Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Display access plan during runtime
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 DBAReceived on Tue Apr 03 2007 - 06:43:11 CDT
![]() |
![]() |