Home » RDBMS Server » Server Utilities » Monitoring SQL Loader
Monitoring SQL Loader [message #168850] Sun, 23 April 2006 19:04 Go to next message
jgutierrez29
Messages: 1
Registered: February 2006
Location: Mexico
Junior Member
Hey Guys,

I`m loading data using shell that at the same time calls java program that at the same time use the SQL loader.

I`d like to know exactla how can i monitoring the load of data. I know that maybe I can use one query check the insert transaction, but Do you know something about how can i monitoring all SQL loader process?

Report message to a moderator

Re: Monitoring SQL Loader [message #168863 is a reply to message #168850] Sun, 23 April 2006 21:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not sure whether these would help you.
You can just monitor the logfile
or
you can also look into the feedback from sqlldr session that looks like 
SQL*Loader: Release 9.2.0.4.0 - Production on Sun Apr 23 22:17:40 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 64
Commit point reached - logical record count 128

Report message to a moderator

Re: Monitoring SQL Loader [message #168904 is a reply to message #168863] Mon, 24 April 2006 01:58 Go to previous message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps just another suggestion: check also .BAD and .DSC files; their existence will show you that some data didn't get into the Oracle table(s).

Report message to a moderator

Previous Topic: Overwriting tables using impdp in Oracle 10g XE
Next Topic: Import error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jul 04 19:21:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.