Display and filter on new 9i/10g columns (elapsed time, cpu time, cluster time, etc) (27388)

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.

WORKAROUND:

None

STATUS:

This enhancement request is currently already in planning stages and will be included in a future release (post 4.5) of Spotlight on Oracle.