Re: buffer busy waits for data block

In article <36C00480.7E11F9C5_at_it-mannesmann.de>,   Torsten Kleinblotekamp <torsten.kleinblotekamp_at_it-mannesmann.de> wrote:
> I think we've got to many buffer busy wait. The database-buffer hitratio
> is still o.k. How can I fix this problem?
>

you did not specify what kind of buffer waits. i have listed some simple solutions for the commonly known buffer wait types.( with all thanks to Oracle Press and the authors)

buffer wait type solution

data block            increase no. of DBWR processes
sort blocks           decrease SORT_AREA_SIZE parameter
segment header        too many full table scans
free list             too many data loading jobs running simultaneously
undo header           not enough rollback segs
undo block            try increasong pctfree of tables beng modified

of course, this is very basic and i don't have any other information like what kind of environment (OLTP/data warehouse..) your DB is in. let us know if you need more help

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Feb 09 1999 - 23:14:46 CST