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.

GigsGigsCloud:$16/月KVM-1GB/30GB/1TB/1.6T高防/洛杉矶CN2 GIA+AS9929

GigsGigsCloud是一家成立于2015年老牌国外主机商,提供VPS主机和独立服务器租用,数据中心包括美国洛杉矶、中国香港、新加坡、马来西亚和日本等。商家VPS主机基于KVM架构,绝大部分系列产品中国访问速度不错,比如洛杉矶机房有CN2 GIA、AS9929及高防线路等。目前Los Angeles - SimpleCloud with Premium China DDOS Protectio...

Cloudxtiny:£1.5/月,KVM-512MB/100GB/英国机房

Cloudxtiny是一家来自英国的主机商,提供VPS和独立服务器租用,在英国肯特自营数据中心,自己的硬件和网络(AS207059)。商家VPS主机基于KVM架构,开设在英国肯特机房,为了庆祝2021年欧洲杯决赛英格兰对意大利,商家为全场VPS主机提供50%的折扣直到7月31日,优惠后最低套餐每月1.5英镑起。我们对这场比赛有点偏见,但希望这是一场史诗般的决赛!下面列出几款主机套餐配置信息。CPU...

virmach:3.23美元用6个月,10G硬盘/VirMach1核6个月Virmach

virmach这是第二波出这种一次性周期的VPS了,只需要缴费1一次即可,用完即抛,也不允许你在后面续费。本次促销的是美国西海岸的圣何塞和美国东海岸的水牛城,周期为6个月,过后VPS会被自动且是强制性取消。需要临时玩玩的,又不想多花钱的用户,可以考虑下!官方网站:https://www.virmach.comTemporary Length Service Specials圣何塞VPS-一次性6个...

oracle10g为你推荐
kaixin.com开心网。www.kaixin.com是什么时间出来的。曹谷兰曹谷兰事件 有吧友知道吗mole.61.com谁知道摩尔庄园的网址啊www.niuav.com在那能找到免费高清电影网站呢 ?www.mywife.ccmywife哪部最经典www.kknnn.com求有颜色的网站!要免费的杨丽晓博客杨丽晓是怎么 出道的baqizi.cc曹操跟甄洛是什么关系555sss.com拜求:http://www.jjj555.com/这个网站是用的什么程序彪言彪语很多的话:( )言( )语 豪迈雄壮:( )言( )语 含有讽刺意味的风凉话:( )言( )语
域名转让 免费cn域名注册 太原域名注册 什么是二级域名 亚洲大于500m webhostingpad 512m mobaxterm 天猫双十一抢红包 中国智能物流骨干网 阿里云浏览器 亚马逊香港官网 1美金 流媒体加速 免费mysql数据库 美国独立日 空间登录首页 lick 秒杀品 photobucket 更多