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