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: Display access plan during runtime

Re: Display access plan during runtime

From: sybrandb <sybrandb_at_gmail.com>
Date: 3 Apr 2007 04:43:11 -0700
Message-ID: <1175600591.794640.65590@d57g2000hsg.googlegroups.com> 





On Apr 3, 1:09 pm, joker197cin..._at_gmail.com wrote:


> How can I obtain access plan at runtime during a long procedure?

>

> Any help appreciated.




from 9i onwards: v$sql_plan (you need the address and the hash_value
of the statement, which can be obtained from v$session_longops)


--
Sybrand Bakker
Senior Oracle DBA


Received on Tue Apr 03 2007 - 06:43:11 CDT












Original text of this message













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