Performance tuning methodology was not found by accident , it came with a lot of effort with each release and evolved over time. The availability of fast timers on most platforms, instrumenting of wait events in the kernel, and introduction of Time concept for operations all made this possbile.
Also, BSTAT/ESTAT: V6 :
DB Time is time spent in Database calls.
It is possible that Total DB time can be more than Wall clock time, since there could be many processes running at the same time in a multi-cpu environment
Anjo Kolk et others pioneered YAPP: Yet Another Perf. Profiling Methodology
Total Response time = Total Service Time + Total Wait Time
Provide bullet points of the included scope from your written proposal. Be sure to discuss any out of scope items that are in the written proposal.
If they have the written proposal already, be sure to make a footnote of what page in the written handout this relates to.
Why is ASH significant? Well, because it is a concept similar to airline blackbox for database. ASH provides a very fine gained history of activity which not only makes automatic performance diagnostic – I will talk about this piece in just a few minutes from now – more accurate but also allows users to go back in time and figure out what was going on then.
EM GC Support for 9i – The core performance analysis methodology (click on the big stuff) is cheaply reproduced for 9i using middle-tier ASH emulation. It helps prepare DBA for 10g as well as offer superior tuning capabilities.
Database Diagnostic Pack Introduction
- Part of the database management pack family
- Diagnostic, Tuning, Configuration Management and Change Management, Provisioning and Data Masking Packs
- Provides unique functionalities
- Industry’s first performance self-diagnosing engine
- Lightweight, Automatic, Out-of-box performance data warehouse
- Guided problem resolution
- Introduces a new, easy to use performance tuning methodology
- Not just another tool
- Core functionality built right into the database server
- Makes it most efficient, integrated and accurate
© 2010, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.
相关文章 | Related posts:
- Interpreting HANGANALYZE trace files to diagnose hanging and performance problems
- Troubleshooting JVM Performance Problems
- Checklist for Performance Problems with Parallel Execution
- PeopleSoft Enterprise Performance on Oracle 10g Database
- Oracle Database 11g: Server Manageability Student Guide
- No Time for Downtime Patching Database using Oracle Enterprise Manager
- Performance Tuning Guide for Siebel CRM Application on Oracle
- SQL*Net PERFORMANCE TUNING UTILIZING UNDERLYING NETWORK PROTOCOL
- Oracle AIX Performance and Tuning
- Oracle Advanced Compression:Throw Away Half of Your Disks and Run Your Database Faster
最新评论