Home » RDBMS Server » Server Utilities » loader utility - slow performance (oracle 9i, forms6i)
loader utility - slow performance [message #648422] Tue, 23 February 2016 05:15 Go to next message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
I am using sql loader for my data loading actually we received data on daily basis from different stations in different text files, every file contains around 14000 records.
There are lot of other checks who applied when data moving from temp tables to live database.
My problem is this operation is smooth running start of the month but after few days it works very slow even it took more than 30 minutes in a single station data.
Please suggest me whats I should do, how to improve its performance?
Re: loader utility - slow performance [message #648429 is a reply to message #648422] Tue, 23 February 2016 05:50 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
Trace the session to see what Oracle is waiting for.
Re: loader utility - slow performance [message #648441 is a reply to message #648429] Tue, 23 February 2016 06:57 Go to previous messageGo to next message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
how to trace? please inform.
Re: loader utility - slow performance [message #648442 is a reply to message #648441] Tue, 23 February 2016 07:00 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
SQL_TRACE.
Re: loader utility - slow performance [message #648839 is a reply to message #648442] Fri, 04 March 2016 07:35 Go to previous message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
You're welcome.
Previous Topic: Import DMP file to new Table
Next Topic: Load a CSV file into a GTT from a PL/SQL procedure
Goto Forum:
  


Current Time: Tue Jul 14 07:14:44 CDT 2020