Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle技术资料 › DB Time Performance Tuning: Theory and Practice

2135 积分	502 好友	184 主题

发消息

DB Time Performance Tuning: Theory and Practice

1^#

发表于 2011-12-16 22:22:01 | 查看: 6612| 回复: 7

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

分享0

下载专业ORACLE数据库恢复工具PRM-DUL For Oracle http://www.parnassusdata.com/zh-hans/emergency-services

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线： 13764045638 QQ: 47079569

收藏0 回复只看该作者道具举报