Oracle redo log performance degradation when inserting
- by Aldarund
I have a oracle 11g database. I'm testing in for inserts. The database running in noarchive mode. I have 3 redo log configured, each 2gb.
I'm trying to insert data into test table. At begin it goes fine with 15k ins/second. I make a commit after 200 inserts.
But after about 1.3m inserted records it become really slow, about 1-2k ins/second. As i noticed in resource explorer at this point we have filled all redo logs and so the inserts from this points work slow.
So my question is why it become so slow when it fills redo logs, even if i commit each 200 records. And how this situation can be fixed ( except the turning off logging completely at inserts)