| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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
A copy of this was sent to Dogan Cibiceli <dcib_at_gwl.com>
(if that email address didn't require changing)
On Tue, 08 Jun 1999 18:14:48 -0600, you wrote:
>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
You can instrument your code with calls to dbms_application_info to set upto 3 fields in the v$session table. you can query this from time to time in another session. If you do this and set meaningful values in these columns using that package -- you'll be able to see where you are. for example, I sometimes put calls to dbms_application_info inside of tight loops and such so I can tell i am processing iteration 500 of 1000 or something.
SQL> select text from all_source where name= 'DBMS_APPLICATION_INFO' and type = 'PACKAGE' order by LINE;
will give you a quick overview of this package.
See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/
Current article is "Fine Grained Access Control", added June 8'th
Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA--
 |
 |