Buffer cache hit very low...!!!
- From: Chirag DBA <chiragdba@xxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>, askdba@xxxxxxxxxxxxx
- Date: Tue, 13 Sep 2005 14:53:36 -0400
Hi Team,
My OEM shows buffer cache hit ratio as 28% and library cache as 99%.
Another query shows different results for buffer cache.
SQL> SELECT NAME,100-PHYSICAL_READS/(DB_BLOCK_GETS + CONSISTENT_GETS) FROM
V$BUFFER_POOL_STATISTICS;
NAME 100-PHYSICAL_READS/(DB_BLOCK_GETS+CONSISTENT_GETS)
-------------------- --------------------------------------------------
DEFAULT 99.9072457
SQL> show sga
Total System Global Area 252273320 bytes
Fixed Size 434856 bytes
Variable Size 150994944 bytes
Database Buffers 100663296 bytes
Redo Buffers 180224 bytes
And my db_block_buffers show value as 0.
but it should be the value of database buffers / db_block_size .
SQL> show parameter db_block
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
db_block_buffers integer 0
db_block_checking boolean FALSE
db_block_checksum boolean TRUE
db_block_size integer 8192
Is really my buffer cache hits very low?
Regards - Chirag
- Follow-Ups:
- Re: Buffer cache hit very low...!!!
- From: David Sharples
- Re: Buffer cache hit very low...!!!
- From: Jared Still
- Re: Buffer cache hit very low...!!!
- From: Lou Fangxin
Other related posts:
- » Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » RE: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » RE: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- Re: Buffer cache hit very low...!!!
- From: David Sharples
- Re: Buffer cache hit very low...!!!
- From: Jared Still
- Re: Buffer cache hit very low...!!!
- From: Lou Fangxin