OraFAQ Forum: Performance Tuning » slow while inserting

Home » RDBMS Server » Performance Tuning » slow while inserting (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

slow while inserting [message #659171]

Sun, 08 January 2017 12:43

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.

Report message to a moderator

Re: slow while inserting [message #659172 is a reply to message #659171]

Sun, 08 January 2017 12:50

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

Report message to a moderator

Re: slow while inserting [message #659173 is a reply to message #659171]

Sun, 08 January 2017 12:54

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: slow while inserting [message #659176 is a reply to message #659173]

Sun, 08 January 2017 22:43

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.

Report message to a moderator

Re: slow while inserting [message #659177 is a reply to message #659176]

Mon, 09 January 2017 00:50

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 17:50:30 CST 2025