Data Pump monitoring in a tight loop
- From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 23 Mar 2010 15:32:49 -0500 (CDT)
Hey all,
I'm still investigating using Data Pump and I keep coming across examples
like this:
http://www.oracle.com/technology/oramag/oracle/05-mar/o25tuning.html
In "Code Listing 2" on the above page, there is a tight WHILE...LOOP with no
sleeps/waits.
Won't that chow heavily on a CPU while it's running? Or is there an
implicit sleep/wait somewhere like the DBMS_DATAPUMP.get_status procedure?
TIA!
Rich
p.s. The code linked above appears to come from the Data Pump API example
in the Oracle Database Utilities manual (10gR1 for me).
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Data Pump monitoring in a tight loop - Rich Jesse
