Home » RDBMS Server » Performance Tuning » Inserts to table very slow (solaris, 10g)
Inserts to table very slow [message #383245] Tue, 27 January 2009 23:08 Go to next message
TRaj
Messages: 82
Registered: September 2006
Member

Experts,

I have a table of 9 columns with 4.6 million of records currently. one primary key col, 1 normal index col and a composite index of 2 cols.

Query is performing faster, where as, dml statements are very slow and it takes minutes to complete.

Pls advise as what are the various options that I can do to make dml statements also to perform well.

Thanks.
Re: Inserts to table very slow [message #383246 is a reply to message #383245] Tue, 27 January 2009 23:15 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
>Pls advise as what are the various options that I can do to make dml statements also to perform well.

http://www.orafaq.com/forum/t/84315/74940/
which have you tried & what were the results

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.

Use SQLTRACE & TKPROF to see where time is being spent.

Re: Inserts to table very slow [message #383820 is a reply to message #383245] Fri, 30 January 2009 06:55 Go to previous messageGo to next message
wqqzlm
Messages: 1
Registered: January 2009
Location: china
Junior Member

hi
delete index
Re: Inserts to table very slow [message #383835 is a reply to message #383820] Fri, 30 January 2009 09:25 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
The idea presumably being that that waythe Queries will run as fast as the DML?

Q1) Do all DML statements run slowly, or is it just inserts or Updates or Deletes?
Q2) Are there any triggers on the table
Re: Inserts to table very slow [message #383867 is a reply to message #383835] Fri, 30 January 2009 16:34 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
JRowbottom wrote on Sat, 31 January 2009 02:25
The idea presumably being that that waythe Queries will run as fast as the DML?

./fa/449/0/ Laughing ./fa/5665/0/ ./fa/5666/0/
ROFLMAO
Re: Inserts to table very slow [message #386392 is a reply to message #383245] Sat, 14 February 2009 06:16 Go to previous message
telang_rajiv
Messages: 1
Registered: February 2009
Junior Member
Dear
I think there is so many updation or deletion in the given table due to these activitis the index entries get fragmented. so firstly rebulid your index and try to insert. it will work.
raj
Previous Topic: Performance
Next Topic: how to change clustering factor
Goto Forum:
  


Current Time: Sat Dec 03 14:16:24 CST 2016

Total time taken to generate the page: 0.06907 seconds