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

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 01 Mar 2007 14:23:50 -0800
Message-ID: <1172787828.44750@bubbleator.drizzle.com>

Maxim Demenko wrote:
> DA Morgan schrieb:

>> Charles Hooper wrote:
>>> On Feb 27, 3:19 am, spiritusz2..._at_yahoo.com wrote:
>>>> Hi All,
>>>>
>>>> Do you have any idea how to query a session's active initialization
>>>> parameters from other session?
>>>> For example, someone has changed the db_file_multiblock_read_count
>>>> parameter with an alter session statement.
>>>> How can I query its new value from other session?
>>>>
>>>> Thanks in advance,
>>>> Zoltan
>>>
>>> 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, OP wanted to know the parameter in *other* session.
> IMHO, the answer given by Charles fits perfectly.
>
> Best regards
>
> Maxim

I was responding to Charles not the OP.

What Charles wrote was "I had trouble locating the specific function" and I believe this what he was trying to remember.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Mar 01 2007 - 16:23:50 CST