Re: How to query a session's active initialization parameters from other session?

On Mar 1, 4:43 pm, DA Morgan <damor..._at_psoug.org> wrote:
> Charles Hooper wrote:
> > It seems like there is a very easy way to get the values of individual
> > session specific parameters for other sessions using DBMS_ functions -
> > I had trouble locating the specific function.
>
> What you are looking for is:
>
> dbms_utility.get_parameter_value
>
> demo at:http://www.psoug.org/reference/dbms_utility.html
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

While looking through "Optimizing Oracle Performance" today for some other task, I think that I found the utility that I was trying to remember:
  DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION
  DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION The above allows one session to change the initialization parameters that are in effect for another session.

I was originally thinking of the group of functions DBMS_SYSTEM.GET_ENV, DBMS_SYSTEM.READ_ENV, and DBMS_SYSTEM.SET_ENV - as well as expecting to see a DBMS_SYSTEM.GET_INT_PARAM_IN_SESSION or DBMS_SYSTEM.READ_INT_PARAM_IN_SESSION in the functions list for DBMS_SYSTEM. However, it looks like there is no GET_INT or READ_INT functions in DBMS_SYSTEM.

The V$SES_OPTIMIZER_ENV view is easier to use, so I guess that it does not matter much.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Thu Mar 01 2007 - 16:21:59 CST