欢迎来到天天文库
浏览记录
ID:40566924
大小:174.50 KB
页数:16页
时间:2019-08-04
《oraclefortrueunix性能调优》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、andJanMarkHolzerSeniorMemberofTechnicalStaffTru64UNIXEngineeringGroupjmh@zk3.dec.com星期六,八月28,2021ConfiguringTru64V5.1forOptimalPerformancewithORACLE8.1.7.x/9iOverviewThisisashortwriteuponrecommendedsettingsto/etc/sysconfigtabinaTru645.1environmentrunningORACLE8.1.7.xand/or9iInthe
2、pasttherehavebeenseveralresources/documentsprovidingrecommendationsonhowtosetcertaintunablesin/etc/sysconfigtabbuttherehasalwaysbeenafairamountofconfusionwhichguidelinestofollow.ThisdocumentattemptstogivesomegenericguidelinesonhowtosetsomekeytunablesapplicabletoanORACLEenvironment.Theassumptionistha
3、ttheORACLEversionusedis8.1.7orhigher.Thisisimportantasstarting8.1.7ORACLEisusingAdvFS’sdirectIOcapabilitiestobypassthebuffercache(UBC)partofthefilesystemlayers.16CompaqConfidentialPage162021/8/28DraftDocumentRestrictedDistributionRecommendedPatchesandOperatingSystemVersionsAsofFebruary2002therecomme
4、ndedversionstousefor8.1.7/9iinstallationsare·Tru64andTruClusterV5.1withpatchkitPK4/BL18·OnlyTru64V5.1/PK4willrequiretheinstallationofaseparatepatchforAdvFS,thispatchpreventsaproblemwhereanapplicationusingAdvFSdirectIO(suchasORACLE)orD_SYNCmayre-readstaledataonaCFSclientoThepatchidentifieris:T64V5118
5、-C0091200-12603-Manual-20011220.tar·Tru64andTruClusterV5.1AwithPK1/IPKoTheabovedmentionedpatchisNOTrequiredforsystemsrunning5.1A/IPKKeyTunablesVMSubsystemThefollowingtunablesshouldbemodifiedinthe‘vm’subsystemsectionof/etc/sysconfigtabnew_wire_methodThistunableshouldbesetto‘0’ifSSMmemoryisused(ie.ssm
6、_thresholdisatthisdefaultvalueof8MB).InTru64V5.1there’saninteractionbetweentheAIO(AsynchronousI/O)andpagewiringmechanismwhichmayresultinhighsystemtime.Thisissuecanberesolvedbysettingnew_wire_methodto‘0’.There’renonegativeperformanceimpactsbydisablingthistunable.Toavoidtheinteractionbetweennew_wire_m
7、ethodandssm_thresholdwouldbetousegranularityhintsmemory(gh_regionsorrad_gh_regions)topre-wirememoryforthedatabasetouse.Seethesectionongh_chunksandrad_gh_regionsformoreinformationonGHmemory.Recommended
此文档下载收益归作者所有