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

Report message to a moderator

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: 4580
Registered: April 1998
Senior Member
Look at sqlldr's output. Look for:

"Commit point reached - logical record count 999"

Report message to a moderator

Previous Topic: sqlloader with nologging mode
Next Topic: EXP dump file and WinRAR/Winzip
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 06:46:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.