Hi,
I have a noticed the following behavior...
when the DB is clean and fresh... our DB handles a very high rate of inserts (~1200 per second), butwith time, when the datafile (think thats the reason but might be any other thing... maybe indexes?) increases - the rate is going down. Right now the rate of inserts per second is around 500 per second (around 40% from the starting rate).
Does anyone has any idea why is that happen? How can I solve that problem?
Thanks,
Ori Raz