Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

real time information about progress of pl/sql script

561854Aug 15 2008 — edited Aug 19 2008
We periodically rebuild our DB. The process is divided into about a dozen separate steps implemented as functions in pl/sql. A driver procedure steps through the functions to accomplish the total rebuild.. After completion the script produces a report that shows what it did.

While the script is running changes have not been committed so there is no way to check the DB for changes and figure out what step the script is on. Output from the script is not displayed until it finishes.

So my question: is there is a way to ascertain where the script is in its processing sequence?

On thing the script does is update a progress table with the time each step took. Is it possible to commit only the inserts to this table as they are done and leave everything else to be committed or rolled back when the script finishes?

Thanks for any help or guidance,
-=bill
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 16 2008
Added on Aug 15 2008
12 comments
1,672 views