Home » RDBMS Server » Server Utilities » How to calculate percentage completion while running SQL LOADER through shell script (Oracle, 10.1.0.2.0, Sun OS)
How to calculate percentage completion while running SQL LOADER through shell script [message #313898] Tue, 15 April 2008 01:48 Go to next message
srinihours
Messages: 1
Registered: April 2008
Location: india
Junior Member

Hello All,

Sorry to bother you for a solution to my query. I am running sql loader program and would like to calculate percentage completion of the same

suppose i am loading a data file containing 10 million records into a table "x" in a db "y", i need to know out of 10 million records how many have been loaded in db.

If the processed record is 2 million then i would say 20% of loading the data is complete..

I want a shell script to faciliate the same. Thanks a lot in advance !!

Cheers......Srini
Re: How to calculate percentage completion while running SQL LOADER through shell script [message #313985 is a reply to message #313898] Tue, 15 April 2008 06:59 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Look at sqlldr's output. Look for:

"Commit point reached - logical record count 999"
Previous Topic: sqlloader with nologging mode
Next Topic: EXP dump file and WinRAR/Winzip
Goto Forum:
  


Current Time: Wed Dec 07 06:44:30 CST 2016

Total time taken to generate the page: 0.10479 seconds