RE: Oracle Session commands
From: Terrian, Thomas J DLA CTR TRANSACTION SERVICES <Tom.Terrian.ctr_at_dla.mil>
Date: Tue, 6 Dec 2011 09:50:26 -0500
Message-ID: <96FC82DA2FD4354D9A8B8434B6E7003D09773848_at_COL0SGEM20.AD.DLA.MIL>
Oracle 10g.
....
Date: Tue, 6 Dec 2011 09:50:26 -0500
Message-ID: <96FC82DA2FD4354D9A8B8434B6E7003D09773848_at_COL0SGEM20.AD.DLA.MIL>
Oracle 10g.
Is there any view in Oracle that records all of the commands that came from a session? For example, if I have a session that has been open for an hour, I would like to see something like:
SID Time Command 123 8:00 Desc emp; 123 8:10 Select * from emp; 123 8:20 Insert ....into emp;
....
Is there any V$ that I can select from to get this information?
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 06 2011 - 08:50:26 CST