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.

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-l
Received on Tue Dec 06 2011 - 08:50:26 CST

Original text of this message