DB Time Performance Tuning: Theory and Practice

Maclean Liu(刘相兵

一份介绍DB TIME 和ASH Average Active Sessions很好的文档，包含了一些ASH 相关的脚本
Agenda•DB Time and Average Active Sessions•Time Model•Active Session History (ASH)•Performance Tuning•EM Diagnostic and Tuning Packs•Data VisualizationOracle tuning methods: a history•Prehistoric (v5)•Debug code•Dark Ages (v6)•Counters/Ratios•BSTAT/ESTAT•SQL*Trace•Renaissance (v7/v8)•Introduction of Wait Event instrumentation•Move from counters to timers•STATSPACK•Modernity (v10)•DB Time Tuning – Tuning using fundamental notion of time spent in database•Multiple scoping levels•Always on, non-intrusive•Built into infrastructure: instrumentation, ASH, AWR, ADDM, EMDB Time and Average Active Sessions
beresniewicz_01.pdf (1.14 MB, 下载次数: 23, 售价: 5 金钱)

2011-12-16 22:22 上传

点击文件名下载附件
售价: 5 金钱  [记录]