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.
This enhancement request is currently already in planning stages and will be included in a future release (post 4.5) of Spotlight on Oracle.