Maclean Liu(刘相兵 发表于 2011-12-16 22:22:01

DB Time Performance Tuning: Theory and Practice

一份介绍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

zhuqibs 发表于 2011-12-27 22:37:42

应该不错，有机会看看啊

zhuqibs 发表于 2012-2-11 23:09:31

今天仔细看了看该文，不错，值得推荐

hello_jacky 发表于 2013-6-27 14:00:23

看介绍很不错 仔细研究一下

clot09 发表于 2013-7-30 18:24:23

最近在搞调优，学习学习

zengkefu 发表于 2015-4-27 16:15:59

DB Time Performance Tuning: Theory and Practice

zengkefu 发表于 2015-4-27 16:16:16

DB Time Performance Tuning: Theory and Practice

zengkefu 发表于 2015-4-27 16:16:41

没钱多项一下
页: [1]
查看完整版本: DB Time Performance Tuning: Theory and Practice