Re: dbms_system and string parameters

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1130372231.686709_at_yasure...
> Oxnard wrote:
>> ver 9.2.0.5 and AIX
>>
>> using dbms_system it is clear how to set a boolean and an integer
>> parameter in someone else's sessions. What about strings? For example I
>> would like to set statistics_level. It has 3 options all strings. I guess
>> maybe the string is changed to an int at some point. Other than setting
>> it for the db in the init.ora or a logon trigger is there a way to alter
>> someone else's session to set strings?
>
> logon trigger.
>
> www.psoug.org / click on Morgan's Library / click on System triggers
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)

I do use logon triggers, however what if the session is already on? Unfortunately, what often happens to me is I get the call. "My job is running slow. Why is it so long? We donot want to stop it as it has been running for X^Y hours". Received on Thu Oct 27 2005 - 08:43:12 CDT