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

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Thu, 01 Mar 2007 22:59:55 +0100
Message-ID: <45E74CDB.70603@gmail.com>

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 Received on Thu Mar 01 2007 - 15:59:55 CST