processoracle10g
oracle10g 时间:2021-04-02 阅读:(
)
TUNINGTHELARGEPOOLTUNINGTHELARGEPOOLFORFORRMANRMANSUCCESSFULCUSTOMBR/DR/BCMODELSNYOUGMEETING,DECEMBER2008ANTHONYDNORIEGAANTHONYDNORIEGAanthony.
noriega@adnmis.
comanthony.
noriega@adnmis.
comADNRADNR&&DDwww.
adnmis.
comwww.
adnmis.
comSpeakerQualificationsSpeakerQualificationsIndependentConsultant,ADNSpeakeratNYOUGmeetings24yearsofITexperience18yearsofOracleexperience,13asaDBARMANexperiencewithOracle8i,9i,10g,and11g,since1999.
BSSystemsEngineering,UniversidaddelNorte,1987.
MSComputerScience,NJIT,1993PhDCIScandidate,NJIT,1997MBAMIS,MontclairStateUniversity,2006CollegeMathProfessorandformerHSMathTeacherPrincipal.
ObjectivesProvideaconciseapproachtotunetheLargePoolforRMANAnalyzeandcompareOraclerecommendationsandcustomsettingsPresentarobustapproachtooptimizeRMANtimeandstoragespaceDeriveaseriesoftechnicalargumentsandusefulrulestoattainaBR/BC/DRoptimizationmethodology.
LargePool:MemoryStructuresJavaPoolBufferCacheRedoBufferSharedPoolStreamsPoolLargePoolOtherServerProcessServerProcessBackgroundProcessPGAServerProcessBackgroundProcessPGAPGAPGAPGASGALargePoolPurposesSessionmemoryforthesharedserverandtheOracleXAinterface(usedwheretransactionsinteractwithmorethanonedatabase)I/OserverprocessesOracleDatabasebackupandrestoreoperationsUsedbybackupprocessfordiskI/Obuffers.
RMANReliabilityBasedonexperimentalgatheringRMANtasksaremorereliablewithaLargepoolsizedwithOraclerecommendedsettings.
RMANtaskstendtoimproveperformancewithhigherLargePoolsettings.
ProductionEnvironmentLinux4-nodeRACs,9iand10gSANarchitectureusingSymantec(Veritas)NetbackupMPP(LinuxIntel64-bit8/16dual-coreprocessorRHLinuxservers).
OracleRACandDataGuardinplace(MAA).
Incrementalbackuplevel0mostly.
BlockChangeTracking(Oracle10g/11g)Oracle-RecommendedSettingsAccordingtoOracleCorporation,therecommendedsettingfortheLargePoolSizeis16M.
So,yourinit.
oraparametershouldread:LARGE_POOL_SIZE=16Mfast_start_mttr_target=900CustomSettingsSomeofthecustomsettingsare;Third-Party(VeritasNetbackupincludingbothRACdatabasesandStandaloneDatabases)LARGEPOOLSIZERELIABILITYPERFORMANCE4MBestDecreased8MBetterAverage16MAverageImprovedHigh-ValueExpectedBetter*e.
g.
,32M-180M,180M-2G+CustomSettingsWithASMandFileSystemDatabasesLARGEPOOLSIZERELIABILITYPERFORMANCE4MImprovedDecreased8MBetterAverage16MAverageImprovedHigh-ValueExpectedBetter*e.
g.
,32M-180M,180M-2G+SharedSegmentandLPSizeAnalogyrelatingLargePoolandSharedsegmentsizesLARGEPOOLSIZESHAREDSEGMENTUSED4M8M16MHigh-Value**e.
g.
,32M-180M,180M-2G+StorageSpaceandTimeStorageSpaceandTimeStorageSpaceandTimeBackupSizeandDuration4M8M16M2G+RelatingtheLargepoolsizeandbackupsizeanddurationSizet0DurationDurationSizeRMANCompatibilityTableOracleByVersionVERSIONLARGEPOOLREMARKSOracle8iNON/AOracle9iYESDynamicParameter,BRdiskbuffers,ParallelExecutionMessageBuffer,NoLRU,Optional.
Defaultsto0.
ksfqxcreinternalsharedmemoryallocationerrorOracle10gYESLike9i.
EnhancedforSharedServerOracle11gYESBettersatisfiedsegmentrequeststhanusingsharedpool.
Fasterparallelqueryexecution.
AutomaticMemoryManagement.
OracleByVersionVERSIONLARGEPOOLREMARKSOracle9iYESDynamicParameter,BRdiskbuffers,ParallelExecutionMessageBuffer,NoLRU,Optional.
Defaultsto0.
ksfqxcreinternalsharedmemoryallocationerrorOraclerecommendedsetting:8M300KBtoatleast2GB(actualmaximumisoperatingsystem-specific)AboutOracle9iLargePoolSELECTPOOL,NAME,SUM(BYTES)FROMV$SGASTATWHEREPOOLLIKE'%pool%'GROUPBYROLLUP(POOL,NAME);POOLNAMESUM(BYTES)largepoolPXmsgpool38092812largepoolfreememory299988largepool38392800….
….
OracleByVersionVERSIONREMARKSOracle10gDynamicParameter,BRdiskbuffers(Oracleallocatesbuffersthatareafewhundredkilobytes)Parallelquery,ParallelExecutionMessageBufferNoLRUandnoagingoutofpoolOptional.
SpecifiedLARGE_POOL_SIZEvalueaminimumvalueforthememorypool(allocationheap).
300KBtoatleast2GB(actualmaximumisoperatingsystem-specific)OracleByVersionVERSIONREMARKSOracle11gDynamicParameter,BRdiskbuffers(Oracleallocatesbuffersthatareafewhundredkilobytes)Parallelquery,ParallelExecutionMessageBufferNoLRUandnoagingoutofpoolOptional.
Defaultsto0.
MinimumValue300K.
30Mrecommendedforabout100sessions(sharedserver,about200-300k/session).
ForeffectivesortusageofLP,setsort_area_sizeandsort_area_retained_simetosamevalue.
PracticalinAutomaticMemoryManagement.
Oracle11gDynamicSizingV$MEMORY_CURRENT_RESIZE_OPS:currentmemoryresizeoperations(bothautomaticandmanual)inprogress.
V$MEMORY_DYNAMIC_COMPONENTS:currentsizesofalldynamicallytunedmemorycomponents,includingSGAandPGA.
V$MEMORY_RESIZE_OPS:last800completedmemoryresizeoperations(bothautomaticandmanual),nocurrentoperations.
V$MEMORY_TARGET_ADVICE:tuningadvicefortheMEMORY_TARGETinitializationparameter.
V$SGA_CURRENT_RESIZE_OPS:currentSGAresizeoperationsinprogress,i.
e.
,agroworashrinkofadynamicSGAcomponent.
V$SGA_RESIZE_OPS:last800completedSGAresizeoperations.
Nocurrentoperations.
V$SGA_DYNAMIC_COMPONENTS:dynamiccomponentsinSGA,summaryofallcompletedSGAresizeoperationssincestartup.
V$SGA_DYNAMIC_FREE_MEMORY:amountofSGAmemoryavailableforfuturedynamicSGAresizeoperations.
SampleRMANShellRMANBackupshellforOracleInstancesStudied(WithoutaRecoveryCatalog)BackupSizeandDurationRMANBackupDurationforOracleInstancesStudied(WithaRecoveryCatalog)BackupSizeDurationLineChartSampleShellRMANBackupshellforOracleInstancesStudied(WithaRecoveryCatalog)BackupSizeandDurationRMANBackupDurationforOracleInstancesStudied(WithaRecoveryCatalog)ASimpleRMANRegressionModelRMANConfigurationSessionLongOperationsBusinessConsiderationsOverallPreparednessforanyRMANprocess.
DisasterRecovery(DR)BusinessContinuity(BC)BackupandRecovery(BR)SDLCQualityAssuranceBackupsetapproachArchivedreologbackuppolicyRetentionpolicystrategy.
ConcludingRemarksTheLargePoolSizeSettingcouldaffectBR/DR/BCProcesses,involvingbothreliabilityandperformance.
LargePoolSizeisafactorwhenCorrelatingdatabasesize/backupsizeandduration.
Thelargepoolsizeisdirectlyproportionaltothebackupsizeandinverselyproportionaltothebackupduration.
BGPTO是一家成立于2017年的国人主机商,从商家背景上是国内的K总和有其他投资者共同创办的商家,主营是独立服务器业务。数据中心包括美国洛杉矶Cera、新加坡、日本大阪和香港数据中心的服务器。商家对所销售服务器产品拥有自主硬件和IP资源,支持Linux和Windows。这个月,有看到商家BGPTO日本和新加坡机房独服正进行优惠促销,折扣最低65折。第一、商家机房优惠券码这次商家的活动机房是新加坡...
在之前的一些文章中有提到HostYun商家的信息,这个商家源头是比较老的,这两年有更换新的品牌域名。在陆续的有新增机房,价格上还是走的低价格路线,所以平时的折扣力度已经是比较低的。在前面我也有介绍到提供九折优惠,这个品牌商家就是走的低价量大为主。中秋节即将到,商家也有推出稍微更低的88折。全场88折优惠码:moon88这里,整理部分HostYun商家的套餐。所有的价格目前都是原价,我们需要用折扣码...
如何低价香港服务器购买?想要做一个个人博客,想用香港服务器,避免繁琐备案,性能不需要多高,只是记录一些日常而已,也没啥视频之类的东西,想问问各位大佬有没有低价的香港服务器推荐?香港距大陆近,相比美国服务器最大的优势在于延迟低,ping值低,但是带宽紧张,普遍都是1M,一般戏称其为“毛细血管”。同时价格普遍高,优质稳定的一般价格不菲。大厂云梯队阿里云、腾讯云两家都有香港服务器,要注意的是尽量不要选择...
oracle10g为你推荐
杰景新特谁给我一个李尔王中的葛罗斯特这个人物的分析?急 ....先谢谢了www.niuav.com在那能找到免费高清电影网站呢 ?www.baitu.com谁有免费的动漫网站?avtt4.comCOM1/COM3/COM4是什么意思??/javbibinobibi的中文意思是?www.22zizi.com乐乐电影天堂 http://www.leleooo.com 这个网站怎么样?baqizi.cc和空姐一起的日子电视剧在线观看 和空姐一起的日子全集在线观看baqizi.cc孔融弑母是真的吗?hao.rising.cn电脑每次开机的时候,都会弹出“http://hao.rising.cn/?b=34” 但是这个时175qq.com查询QQ登录地址
免费网站域名注册 免费域名注册网站 唯品秀 pw域名 外贸主机 cpanel主机 国外bt softbank官网 免费名片模板 香港新世界电讯 天猫双十一抢红包 搜狗12306抢票助手 建站代码 河南服务器 域名转向 申请个人网站 ftp教程 北京双线 免费全能主机 免费mysql数据库 更多