I've got a cust
that is showing some signs that one would
think is having a
horrible problem on I/O...
I suspect it is the
"error" of having a **HUGE** value
in db_block_buffers
and it's constantly crunching memory
trying to figure
out which ones to free up. It's only
256 meg, but
depending on load, it may be too much. SGA
is 687
meg.
While I've got
hundreds of SQL, I'm not sure I have one
to diagnose buffer
utilization. It's also version 8.1.7
and I could
probably do some tweaking of buffers.
It's Oracle CRM
with a lot of customization and I'm also
finding some SQL
that's getting a bit ugly under there.
Maks.
