Viewing the currently executing SQL in Oracle
Sometimes if you are having a performance problem you might want to know what SQL statements are being run - you
can trawl through these to work out what is causing the problem. The v$sql table can be used to view all queries that are being run.
[Read More]