Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Session parameter value of another session

Session parameter value of another session

From: Pratap <pratap_fin_at_rediffmail.com>
Date: 21 Dec 2004 07:37:34 -0800
Message-ID: <830861d2.0412210737.36b61071@posting.google.com> 





Hi,



In session 1 I did -



alter session set sort_area_size=100;


I fired some long running query in session 1.



Now from session 2 can I find out what value of sort_area_size has
been set for session 1? Using v$sql is one way. Is there any another
way of finding this out?



Regards,



Pratap
Received on Tue Dec 21 2004 - 09:37:34 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US