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.

regards, John.