OraFAQ Forum: Performance Tuning » dml is very slowly when table have many rows

Home » RDBMS Server » Performance Tuning » dml is very slowly when table have many rows (11.2.0.1.0 Windos XP)

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

dml is very slowly when table have many rows [message #521927]

Sun, 04 September 2011 20:14

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
If a table(have a primary key) is empty(after truncate),the sql of dml(insert,update) is very quickly,but if the table have many rows about 10,000,000 rows, the dml is very slowly,why?

Report message to a moderator

Re: dml is very slowly when table have many rows [message #521928 is a reply to message #521927]

Sun, 04 September 2011 20:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

post SQL_TRACE & EXPLAIN PLAN for both cases.

INSERT /*+ APPEND */ should maintain constant rate regardless of number of existing rows.

Report message to a moderator

Re: dml is very slowly when table have many rows [message #521930 is a reply to message #521927]

Sun, 04 September 2011 23:28

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

Senior Member
Account Moderator

Quote:

why?

Why update 10,000,000 rows is slower then 0 row?

Regards
Michel

[Updated on: Sun, 04 September 2011 23:28]

Report message to a moderator

Re: dml is very slowly when table have many rows [message #521935 is a reply to message #521930]

Mon, 05 September 2011 01:58

andy huang
Messages: 498
Registered: July 2011

Senior Member

hi,
Just only insert, not update.

Report message to a moderator

Re: dml is very slowly when table have many rows [message #521939 is a reply to message #521935]

Mon, 05 September 2011 02:17

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

Senior Member
Account Moderator

Quoting you: "the sql of dml(insert,update) [...] the dml is very slowly".
If you post a question that is not the one you want an answer there is few likelyhood you get an answer to the question you didn't post, isn't it?

Regards
Michel

Report message to a moderator

Re: dml is very slowly when table have many rows [message #521942 is a reply to message #521939]

Mon, 05 September 2011 02:34

andy huang
Messages: 498
Registered: July 2011

Senior Member

hi,
Sorry, I just test insert,not update. note the table is partitioned. when there no any row, it quickly,but when i have many rows about 10,000,000 rows, the insert is very.

Report message to a moderator

Re: dml is very slowly when table have many rows [message #521944 is a reply to message #521942]

Mon, 05 September 2011 02:45

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

Senior Member
Account Moderator

You didn't post any information that allows us to diagnose.

Regards
Michel

Report message to a moderator

Previous Topic:	performance tuning
Next Topic:	Statspack unit information

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 04:06:52 CST 2024