I like to get the latest executed statements within my database, along with performance indicators.
As such, I like to know, which SQL statements were most CPU/DISK intensive.
Oracles Enterprise Monitor console shows a whole wealth of information about which SQL queries are taking the max CPU, bottlenecks, top activity in the database, blocking SQLs et al.
For a historical approach, you can use Oracle's AWR reports to pin point areas concerning you.
Here is the SQL to do the job. Open for trial.
Step 1: Determine the installatin IDs & user IDs.
There might be multiple Ids & Installation Ids returned. So it's up to a users' choice on how to use this data in a web interface etc.
You can also use
This would give you top 10 statements by disk read (note - this is cumulative for all executions):
If the statement is still in
I also like to use