Home » RDBMS Server » Performance Tuning » slow while inserting (10g)
slow while inserting [message #659171] Sun, 08 January 2017 12:43 Go to next message
arifmd1705
Messages: 37
Registered: May 2016
Location: uae
Member
Hello experts,

The insert statement is very slow while I am trying to insert around 1000 records into a table which is very huge, is there a way
to find out what exactly the problem is like for slow running queries we can use explain plan.
Please advise.

Re: slow while inserting [message #659172 is a reply to message #659171] Sun, 08 January 2017 12:50 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
we need a few more details.
http://www.orafaq.com/forum/mv/msg/84315/433888/#msg_433888
Please refer to URL above & be sure to provide the details requested:
1) ddl for all tables & indexes
2) EXPLAIN PLAN
3) output from SQL_TRACE & tkprof
Re: slow while inserting [message #659173 is a reply to message #659171] Sun, 08 January 2017 12:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Insert performances don't depend on table size (unless you query it during insert and have no matching indexes).

Avoid to insert from a PL/SQL or program loop, and avoiding committing each row.
From this you should think that you have to post the code.

Re: slow while inserting [message #659176 is a reply to message #659173] Sun, 08 January 2017 22:43 Go to previous messageGo to next message
arifmd1705
Messages: 37
Registered: May 2016
Location: uae
Member
thanks michael, you are right actually i am trying to insert it using pl/sql procedure . It is like ole link where i am trying to read row by row from excel and while uploading i am validating certain conditions.
Re: slow while inserting [message #659177 is a reply to message #659176] Mon, 09 January 2017 00:50 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So the performances issue is an application one not the INSERT itself.

Previous Topic: db file sequential read causing Performance Issues
Next Topic: Need your help to optimize the Query
Goto Forum:
  


Current Time: Thu Mar 28 18:32:29 CDT 2024