Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> (no subject)
Can anybody please let me know as to whether you are facing any probs with
dba_waiters,dba_blockers in 8.1.6,we upgraded up on of out m/c from 7.3.4 to
8.1.6,when we query the dba_waiters it hangs and even the dba_blockers
hang,I am not able to why this is happening.
Can somebody please help me out with this
Thanks in advance
arun
From: sean.hull_at_pobox.com
Date: Wed, 21 Jun 2000 15:47:53 -0400 (EDT)
Subject: Re: DB Block Buffers - Too Much ???
On Wed, 21 Jun 2000, Gaja Krishna Vaidyanatha wrote:
> If overallocation is done, and if a significant portion of your
> SGA is getting paged/swapped out, then you will experience a
> system-wide degradation in performance. Goes to prove that
> cache hit ratios by themselves cannot validate that Oracle is
> running and functioning optimally. They are just one of the
Received on Wed Jun 21 2000 - 14:46:24 CDT