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: See underlying recursive SYS statements in SGA ??

Re: See underlying recursive SYS statements in SGA ??

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Wed, 08 Sep 2004 00:24:00 +0200
Message-ID: <i7dsj0lgnii3cf7l96mjlsgl85m8c4tqpu@4ax.com> 





On 7 Sep 2004 07:15:46 -0700, spendius_at_muchomail.com (Spendius) wrote:



>I'm rephrasing my last question: do you think it's possible

>to view what are the SELECTs implicitly performed by Oracle 

>itself (on all SYS.*$ stuffs etc.) for a session otherwise 

>than through a trace/tkprof of this session ?

>

>Thanks.

>Spendius




Just check out v$open_cursor



--
Sybrand Bakker, Senior Oracle DBA


Received on Tue Sep 07 2004 - 17:24:00 CDT












Original text of this message













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