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 -> Re: show session parameter

Re: show session parameter

From: <sybrandb_at_hccnet.nl>
Date: Tue, 28 Aug 2007 00:37:34 +0200
Message-ID: <qek6d31n3tqm3b1r3kpfduubmdjjai7vof@4ax.com> 





On Mon, 27 Aug 2007 13:38:21 -0000, eliot06 <p.hirth_at_gmail.com> wrote:



>to eeing what optimizer is used ? whit the session scott.




Ever heard of v$sql_plan? 


Also there is an Oracle provided stored procedure (would need to
search for it) allowing you to retrieve a parameter value from a
session, just as you can retrieve event settings from a session.
You don't need access at all.


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Mon Aug 27 2007 - 17:37:34 CDT












Original text of this message













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