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
————————————————
How can the SYS session change the hash_area_size of HR session?
Hi Sadiq
Please refer to following post :
http://oracleinaction.com/change-parameter-value-another-session/
Regards
Anju Garg