Re: dbms_system and string parameters

Oxnard wrote:
>
> "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".

probably better to throw a trace on their session on the fly rather than playing with stats level

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------