Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Performance threshold metrics standard for SQL execution statistics

Siva OraSep 23 2011 — edited Sep 23 2011
Let me know if there any standard or accpeted in general the values of Performance threshold metrics SQL Execution statistics.

On OEM Grid 11g, we have Statistics tab for SQL.
There, I looking at "Execution Statistics".

Total Per Execution Per Row
Executions
Elapsed Time (sec)
CPU Time (sec)
Buffer Gets
Disk Reads
Direct Writes
Rows
Fetches

Basically, I want to know if the current SQL is optimized for execution or should I go for SQL Tuning advisor?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 21 2011
Added on Sep 23 2011
#general-database-discussions, #performance
3 comments
301 views