Hi,
I'm using Toad For Oracle and I have found - what I think is - a way to see the longest running operations made recently in our database.
The tab is called longops (found in the Session Browser ). Here Toad gives me a list of
long running operations. In the listing (which I can sort by time taken) I see quite a few full table scans together
with the time taken for each scan.
My first question is - can I trust Toad on this?
The items in the list looks something like:
FULL TABLE SCAN ON <table name> 40 sec. 2012-04-12 12:00:00 56000 out of 56000 blocks done
My second question is - what SQL can I use to generate this output?
In Toad - I need to click on a session (user) and then I get the statistics for that session (user).
I would like to get the statistics for all the recent sessions (users).
/best regards, Håkan