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.
大硬盘服务器、存储服务器、Chia矿机。RackNerd,2019年末成立的商家,主要提供各类KVM VPS主机、独立服务器和站群服务器等。当前RackNerd正在促销旗下几款美国大硬盘服务器,位于洛杉矶multacom数据中心,亚洲优化线路,非常适合存储、数据备份等应用场景,双路e5-2640v2,64G内存,56G SSD系统盘,160T SAS数据盘,流量是每月200T,1Gbps带宽,配5...
Hostinger 商家我们可能一些新用户不是太熟悉,因为我们很多新人用户都可能较多的直接从云服务器、独立服务器起步的。而Hostinger商家已经有将近十年的历史的商家,曾经主做低价虚拟主机,也是比较有知名度的,那时候也有接触过,不过一直没有过多的使用。这不这么多年过去,Hostinger商家一直比较稳妥的在运营,最近看到这个商家在改版UI后且产品上也在活动策划比较多。目前Hostinger在进...
酷锐云是一家2019年开业的国人主机商家,商家为企业运营,主要销售主VPS服务器,提供挂机宝和云服务器,机房有美国CERA、中国香港安畅和电信,CERA为CN2 GIA线路,提供单机10G+天机盾防御,提供美国原生IP,支持媒体流解锁,商家的套餐价格非常美丽,CERA机房月付20元起,香港安畅机房10M带宽月付25元,有需要的朋友可以入手试试。酷锐云自开业以来一直有着良好的产品稳定性及服务态度,支...
oracle10g为你推荐
敬汉卿姓名被抢注如果有一定影响力的笔名,被某个产品抢注,能否起诉告其侵权?敬汉卿姓名被抢注12306身份证名字被注册怎么办sonicchatwe chat和微信区别巨星prince去世有几位好莱坞巨星死在2016年比肩工场比肩成局 什么意思51sese.comwww.51xuanh.com这是什么网站是骗人的吗?www.zjs.com.cn中国快递公司排名百度指数词百度指数为0的词 为啥排名没有www.mywife.ccmywife哪部最经典斗城网女追男有多易?喜欢你,可我不知道你喜不喜欢我!!平安夜希望有他陪我过
域名服务 万网域名 台湾服务器租用 查询ip地址 息壤主机 cve-2014-6271 美国主机网 视频存储服务器 godaddy优惠码 payoneer 淘宝双十一2018 云图标 彩虹ip 电子邮件服务器 免费活动 可外链相册 网购分享 沈阳主机托管 中国电信网络测速 英雄联盟台服官网 更多