Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL TRACING FOR A PARTICULAR SESSION.

Re: SQL TRACING FOR A PARTICULAR SESSION.

From: bonminh lam <hansmayer1962_at_hotmail.com>
Date: 1 Mar 2004 08:20:04 -0800
Message-ID: <3c6b1bcf.0403010820.7de93e2f@posting.google.com>


"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 &#8220;Session_Tracing (id, text)&#8221;.
> > And when the session log off, its information will be deleted from
> > the table &#8220;Session_Tracing&#8221;.

Check the supplied package DBMS_SUPPORT. It should be exactly what you need Received on Mon Mar 01 2004 - 10:20:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US