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

spiritusz2000_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
>

I'm not sure that you can. These values are stored in the sessions *private* memory, not the SGA.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com