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 13:43:14 -0800
Message-ID: <1172785392.96847@bubbleator.drizzle.com>

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 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 - 15:43:14 CST