database hangs on free buffer waits
i'm experiencing major performance problems on my application.
i have 2 db's on the same HP-UX machine, each one has an SGA of
about 2.3GB, the machine has 6 CPUs and 6GB ram.
oracle version - 18.104.22.168 64bit.
i have a very insert-intensive application (about 2000 rows/s).
my redo logs & rbs are placed on raw partitions, the rest of the
db files are on vxfs fs.
after i start the application, the load on the database is huge,
but no stress in the storage machine (Va7400) nor the host's cpu.
after about 10-15 minutes, i start recieveing "free buffer waits"
on my application threads, and basically, it hangs forever.
had anyone ever encountered these waits?
please share your experience.
of course, main parameters:
Are you sure you have 256000 database buffers? I think there is typo.
With 256000 buffers, and block size of 8K, your database buffer size will be very very big.
OCP DBA (8,8i,9i)
"Let's document it and call it a feature."
no, no error at all.
both databases buffer cache are the size of 2GB.
i know it's large, but the application is REALLY write-intensive.
Click Here to Expand Forum to Full Width