Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL TRACING FOR A PARTICULAR SESSION.
"lfree" <windows-free_at_163.com:s/windows/linux/> wrote in message news:<c1v1ke$p60$1_at_news.yaako.com>...
> I don't know how to do?
> but I like SQL Monitor !
> download from http://www.toadsoft.com/downld.html
>
> > I like to say that, I wanted to enable SQL Tracing for a particular
> > session implicitly, when it connects to database.
> > Is that possible?
> > When a session connects to database, its information will be stored in
> > a table “Session_Tracing (id, text)”.
> > And when the session log off, its information will be deleted from
> > the table “Session_Tracing”.
Check the supplied package DBMS_SUPPORT. It should be exactly what you need Received on Mon Mar 01 2004 - 10:20:04 CST