Identify the Source of the Problem		back | 1 2 3 4 5 | next
To find out who is hitting the system so hard, I start up TopSessions and look at the user-resource usage on the system. I sort based on I/O activity to find the culprit. A developer is inserting data into the database and causing significant redo-log activity. A double-click on the user shows me the actual SQL that has been executed.