OraFAQ Forum: Performance Tuning » Inserts to table very slow

Home » RDBMS Server » Performance Tuning » Inserts to table very slow (solaris, 10g)

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

Inserts to table very slow [message #383245]

Tue, 27 January 2009 23:08

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.

Report message to a moderator

Re: Inserts to table very slow [message #383246 is a reply to message #383245]

Tue, 27 January 2009 23:15

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Inserts to table very slow [message #383820 is a reply to message #383245]

Fri, 30 January 2009 06:55

wqqzlm
Messages: 1
Registered: January 2009
Location: china

Junior Member

hi
delete index

Report message to a moderator

Re: Inserts to table very slow [message #383835 is a reply to message #383820]

Fri, 30 January 2009 09:25

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

Report message to a moderator

Re: Inserts to table very slow [message #383867 is a reply to message #383835]

Fri, 30 January 2009 16:34

rleishman
Messages: 3728
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?

ROFLMAO

Report message to a moderator

Re: Inserts to table very slow [message #386392 is a reply to message #383245]

Sat, 14 February 2009 06:16

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

Report message to a moderator

Previous Topic:	Performance
Next Topic:	how to change clustering factor

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 18:30:45 CST 2024