RE: Oracle Session commands

  • From: "Terrian, Thomas J DLA CTR TRANSACTION SERVICES" <Tom.Terrian.ctr@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 6 Dec 2011 09:50:26 -0500

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?

 

 

            


--
//www.freelists.org/webpage/oracle-l


Other related posts: