The Oracle supplied package dbms_sqltune has been available from Oracle for a while now. In Oracle version 11g however this package now has an entirely new ability, the ability to analyze a SQL statement while it is in-flight. This allows you to look at a SQL statement and see how many I/Os and CPU cycles it has used during the execution on a repeating basis. This allows the ability to see where it is in the execution cycle and what might be causing performance issues.
The dbms_sqltune package is available for use through OEM via the SQL Monitoring function. This is available in the database performance monitoring sub-tab of your database target. This function is definitely worth investigating.
No comments:
Post a Comment