In OEM 2.1 diagnostics pack, I recall in TOPSESSIONS you could see a list of a users previous SQL statements and do explain plans on them. In the 9i version all I seem to be able to see is the current statement.
Is it possible in either TOPSESSIONS or basic SQL to see such a history.
I only care about connected sessions, and I would like to see an order history of their statements not even going too far back, a few minutes at most.
06-18-2002, 06:45 PM
Since you are using 9i and OEM you can use LogMiner Viewer to get this information.
Configure LogMiner with either redo logs or online data dictionary support, and use the GUI to get this info.