Stephan Born <stephan.born_at_bNrOaSiPnAfMorce.com> wrote in message news:<dc8o0b.h01.ln_at_gatekeeper.solutions.beusen.de>...
> DA Morgan schrieb:
> > Sam wrote:
> >
> >>After I run ALTER SESSION.. such as
> >>
> >>ALTER SESSION SET SQL_TRACE = FALSE
> >>
> >>How do I set the session varible back to original state?
> >>
> >>Help?
> >
> > Is this a serious question?
> >
> > ALTER SESSION SET SQL_TRACE = TRUE
>
> I think the original poster wanted to know how to get the original
> state, change this with
>
> ALTER SESSION SET SQL_TRACE = FALSE
>
> and after doing his work change it back to the original state with
> something like
>
> ALTER SESSION SET SQL_TRACE = <original state>
>
> This could be necessary when the original state can be one of both TRUE
> or FALSE. Unfortunately, I do not know how to get the original state.
> But I am interested in this, too.
>
> Regards, Stephan Born
> --
> ---------------------------------------------------------------
> Dipl.-Inf. (FH) Stephan Born | BRAIN FORCE SOFTWARE GmbH
> | Landsberger Allee 366
> eMail: delete the capital letters | 12681 Berlin
> eMail: entferne die Grossbuchstaben | Germany
> ---------------------------------------------------------------
> PGP-Key verfügbar | PGP-Key available
> ---------------------------------------------------------------
i think you can use the DBMS_SYSTEM.READ_EV procedure (event 10046).
but you need to grant permissions on this pkg to the user who wants to
find out for his session ..
Received on Thu Jan 23 2003 - 11:22:44 CST
