oraclefortrueunix性能调优

《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