Re: How to reset after Alter Session

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Thu, 23 Jan 2003 17:07:38 GMT
Message-ID: <ujVX9.2140$SZ.79@newssvr19.news.prodigy.com>

Stephan Born wrote:
> 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

If you are correct in your assumption (to me, it sounds like you are), the OP might want to look at the following:

http://www.oracleadvice.com/Tips/dbms_system.htm

If you have enough privileges, you can use DBMS_SYSTEM.READ_EV to determine the current state of SQL_TRACE (event 10046). Received on Thu Jan 23 2003 - 11:07:38 CST