buffer busy waits PUZZLES

From: The Human Fly <sjaffarhussain_at_gmail.com>
Date: Tue, 10 May 2005 15:41:06 +0300
Message-ID: <97b7fd2f05051005419e40b7b@mail.gmail.com>

Hello List,

First of all, I am not using TABLESPACES with ASSM feature. I saw a lot of buffer busy waits on couple of tables which being used for heavy inserts. I have increased the freelist of those 5 online tables from 1(default) to 5, as I have 5 CPU on the server. I was expecting 'buffer busy waits' to be reduced on these segments, but, to my surprise, what I have seen is a drastic increments in the value for these segment, buffer busy waits. Is increasing freelist wont help in this manner?

--=20
Best Regards,
Jaffar, OCP DBA
Banque Saudi Fransi
Saudi Arabia

---------------------------------------------------------------------------=

---

"It is your atittude, not your aptitude that determins your altitude."

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 10 2005 - 08:45:46 CDT