Re: SQL TRACING FOR A PARTICULAR SESSION.

On 1 Mar 2004 01:50:25 -0800, maulana1_at_hotmail.com (Jaffery) wrote:

>Hi,
>
>I like to say that, I wanted to enable SQL Tracing for a particular
>session implicitly, when it connects to database.
>Is that possible?

Yes, in 8i and higher, by means of an after logon trigger

>When a session connects to database, its information will be stored in
>a table “Session_Tracing (id, text)”.

This is not possible. Why would it? You have a trace file and that should be sufficient.

> And when the session log off, its information will be deleted from
>the table “Session_Tracing”.

So the whole operation is pretty useless

>How should we do that?
>
>
>Any ideas will be great.
>
>Jaffery

--
Sybrand Bakker, Senior Oracle DBA