real time information about progress of pl/sql script
561854Aug 15 2008 — edited Aug 19 2008We 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