Database Tuning (MOSC)

MOSC Banner

Performace issue due to very high DML

edited May 27, 2010 3:42AM in Database Tuning (MOSC) 8 commentsAnswered
Hi All, I have a procedure that inserts around 150 million rows in a two hour period. I have two indexes on the table which is partitioned on range [business_date]. I end up getting very high buffer busy waits, free buffer waits on the two partitioned indexes during the two hour period. At present I am using ASSM and the disk is on a Raid 5. As a part of the improvement process I have increased the sequence CACHE size used in the table. I am also planning to replace the current range with range-hash partition. I am also planning to create a new tablespace where segment space management is manual and have multiple freelists/inittrans for the table as well as for the index. I am also looking to add couple of DB writers and am also increasing the the db_buffer_cache based of the cache advice. I cannot use reverse key as that would be a big code change for us. I am planning to find

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center