realising a "progressbar" for a long working package

From: Norbert Winkler <norbert.winkler1_at_gmx.de>
Date: Tue, 10 Feb 2009 12:58:36 +0100
Message-ID: <g8k4ixhgq6g4.1m4kgolxj2fdz$.dlg_at_40tude.net>



Hi,

I've a package that generates some table records with some random chooses (2-5%).
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 9.2.0.8.0 64Bit
Received on Tue Feb 10 2009 - 05:58:36 CST

Original text of this message