I would like to have the ability to filter and sort by the v$sql.cpu_time and v$sql.elapsed_time the same way as currently done for buffer gets and disk reads.
When looking for resource intensive SQL queries, there are a number of current search and report criteria that include buffer gets, disk reads, buffer_gets / execution, disk_reads / executions, etc.
Starting with Oracle9i, the V$SQL table also holds the cumulative CPU and elapsed times associated with each query just like buffer_gets and disk reads. It would be beneficial to identify and report top queries by these two additional attributes.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center