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

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 Received on Tue Feb 27 2007 - 02:19:37 CST