Home » RDBMS Server » Performance Tuning » dml is very slowly when table have many rows (11.2.0.1.0 Windos XP)
dml is very slowly when table have many rows [message #521927] Sun, 04 September 2011 20:14 Go to next message
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?
Re: dml is very slowly when table have many rows [message #521928 is a reply to message #521927] Sun, 04 September 2011 20:34 Go to previous messageGo to next message
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.
Re: dml is very slowly when table have many rows [message #521930 is a reply to message #521927] Sun, 04 September 2011 23:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
Just only insert, not update.
Re: dml is very slowly when table have many rows [message #521939 is a reply to message #521935] Mon, 05 September 2011 02:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: dml is very slowly when table have many rows [message #521942 is a reply to message #521939] Mon, 05 September 2011 02:34 Go to previous messageGo to next message
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.
Re: dml is very slowly when table have many rows [message #521944 is a reply to message #521942] Mon, 05 September 2011 02:45 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't post any information that allows us to diagnose.

Regards
Michel
Previous Topic: performance tuning
Next Topic: Statspack unit information
Goto Forum:
  


Current Time: Thu Mar 28 12:57:51 CDT 2024