摘要：
Develop your own scripts.Use the supplied packages for tuning.Schedule periodic performance checking.Take advantage of the Enterprise Manager Event service to track specific situations.Take advantage of the Oracle Enterprise Manager Job service to:Automate the regular execution of administrative tas 阅读全文
摘要：
1、Statspack(强大的分析和性能调优工具)Installation of Statspack using the spcreate.sql scriptCollection of statistics execute statspack.snapAutomatic collection of statistics using the spauto.sql scriptProduce a report using the spreport.sql scriptTo collect timing information,set TIMED_STATISTICS = True2、搭建stat 阅读全文
摘要：
1、What Does the DBA Tune?Performance tuning areasApplication:(Shared with developers)SQL statement performanceChange managementInstance tuning:MermoryDatabase structureInstance configurationOperating system interactions:(Shared with SA)I/OSwapParameters2、Tuning QuestionsWho tunes?Application designe 阅读全文