FIND VALUES OF ANOTHER SESSION’S PARAMETERS

   In this post, I will demonstrate how to find out the values of various initialization parameters in another session.

– Start two sessions – as SYS and HR

– Find out SID of HR session from SYS session

SYS> select sid, username from v$session where username='HR';

SID USERNAME
———- ——————————
54 HR

– Find out the current value of parameter hash_area_size for HR’s session

SYS> select name, value 
            from  V$SES_OPTIMIZER_ENV 
            where sid=54 
               and name='hash_area_size';

NAME                                     VALUE
—————————————- ————————-
hash_area_size                           100000

– Change the value of parameter hash_area_size in HR’s session

HR>  alter session set hash_area_size=131072;

– Check that the current new value of parameter hash_area_size for HR’s session is displayed

SYS> select name, value 
            from  V$SES_OPTIMIZER_ENV 
            where sid=54 
               and name='hash_area_size';

NAME                                     VALUE
—————————————- ————————-
hash_area_size                           131072


I hope this information was useful. Your comments and suggestions are always welcome.

References:

http://dioncho.wordpress.com/2009/07/18/spying-on-the-other-session/

———————————————————————————————————–

Related links:

Home

Database Index 

Change Parameter Value In Another Session


                                     ————————————————



2 thoughts on “FIND VALUES OF ANOTHER SESSION’S PARAMETERS

Your comments and suggestions are welcome!