Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL Question : How to understand which statement Oracle is executing
look at v$open_cursor from a second session.
You will need to get the sid for the first session
by something like
select sid, program from v$session
where type = 'USER' and schemaname = '<your schema>'
Hth,
Sybrand Bakker, Oracle DBA
Dogan Cibiceli wrote in message <375DB1F8.60D590EB_at_gwl.com>...
>Hi,
> This is rather a simple question. I have an anoymous pl/sql block and
>it is processing some temp tables. During its execution it seems, it
>stops at some point for some reason because I see no updates to the temp
>table. How can I understand where it is at during execution ? any bright
>ideas, any internal tables I can look at ? Thanks in adv.
>
>D
>
Received on Wed Jun 09 1999 - 00:04:20 CDT
![]() |
![]() |