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  |
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
|
|
|
|
Goto Forum:
Current Time: Thu Apr 10 17:31:27 CDT 2025
|