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.

ParkInHost - 俄罗斯VPS主机 抗投诉 55折,月付2.75欧元起

ParkInHost主机商是首次介绍到的主机商,这个商家是2013年的印度主机商,隶属于印度DiggDigital公司,主营业务有俄罗斯、荷兰、德国等机房的抗投诉虚拟主机、VPS主机和独立服务器。也看到商家的数据中心还有中国香港和美国、法国等,不过香港机房肯定不是直连的。根据曾经对于抗投诉外贸主机的了解,虽然ParkInHost以无视DMCA的抗投诉VPS和抗投诉服务器,但是,我们还是要做好数据备...

选择Vultr VPS主机不支持支付宝付款的解决方案

在刚才更新Vultr 新年福利文章的时候突然想到前几天有网友问到自己有在Vultr 注册账户的时候无法用支付宝付款的问题,当时有帮助他给予解决,这里正好顺带一并介绍整理出来。毕竟对于来说,虽然使用的服务器不多,但是至少是见过世面的,大大小小商家的一些特性特征还是比较清楚的。在这篇文章中,和大家分享如果我们有在Vultr新注册账户或者充值购买云服务器的时候,不支持支付宝付款的原因。毕竟我们是知道的,...

注册做什么96%可以干啥,常用的7个常用的国内国外域名注册服务商_云服务器可以干什么

日前,国内知名主机服务商阿里云与国外资深服务器面板Plesk强强联合,推出 阿里云域名注册与备案、服务器ECS购买与登录使用 前言云服务器(Elastic  只需要确定cpu内存与带宽基本上就可以了,对于新手用户来说,我们在购买阿里云服务申请服务器与域名许多云服务商的云服务器配置是弹性的 三周学会小程序第三讲:服务 不过这个国外服务器有点慢,可以考虑国内的ngrokcc。 ngrokcc...

oracle10g为你推荐
sherylsandberg这个文章什么意思 给个翻译好吗 谢谢了商标注册流程及费用商标注册流程及费用?haokandianyingwang谁有好看电影网站啊、要无毒播放速度快的、在线等haokandianyingwang有什么好看的电影网站haokandianyingwang谁给个好看的电影网站看看。www.zjs.com.cn怎么查询我的平安信用卡寄送情况www.baitu.com谁有免费的动漫网站?www.ijinshan.com在电脑看港台电视台那个网站最好而又不用钱速度又快ww.66bobo.comfq55点com是什么网站888300.com请问GXG客服电话号码是多少?
双线服务器租用 国内免备案主机 stablehost 密码泄露 免费网站申请 太原联通测速平台 百兆独享 admit的用法 双11秒杀 web服务器安全 阿里dns 买空间网 免备案cdn加速 中国电信宽带测速 googlevoice web服务器 windowsserverr2 windowsserver2012 建站行业 俄勒冈州 更多