realising a "progressbar" for a long working package
Date: Tue, 10 Feb 2009 12:58:36 +0100
I've a package that generates some table records with some random chooses
But the steps to generates the random sample need a little bit time. I've tried to optimize it by using all indexes (by separtating it in more steps with several new tables) and so far I think I couln't improve it in speed.
Now I would like it that my application reports me the step it is working on.
1. The simplest way - but brute force - seems me to start the package work in a separated thread, and use a timer to start count-queries about the filled tables, a commit after each step wouldn't be a problem. 2. Or I split the work in more procedures that I call step by step in my application. But the the logic goes to the application. 3. To use a package report-variable isn't possible (I think) because my threads need different sessions.
Any suggestions are welcome!
-- Norbert Oracle9i Enterprise Edition Release 184.108.40.206.0 64BitReceived on Tue Feb 10 2009 - 05:58:36 CST