Re: SQL TRACING FOR A PARTICULAR SESSION.

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?
> 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”.
> How should we do that?
>
>
> Any ideas will be great.
>
> Jaffery

Easy done with a AFTER LOGON trigger.

Information about them at tahiti.oracle.com and a simple demo at: http://www.psoug.org/reference/system_trigger.html

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)