SQL ScriptSQL Script
DB Block Buffer
Updated : 30-June-1999
Version : 1.1
Description
This script lists the state of all the DB_BLOCK_BUFFERS in the database. This 
script must be run as SYS.
Parameters
None
SQL Source
set serverout on size 1000000
set verify off
select decode(state, 0, 'Free', 
	1, decode(lrba_seq,0,'Available','Being Modified'), 
	2, 'Not Modified', 
	3, 'Being Read',
	'Other') "BLOCK STATUS"
	,count(*) cnt
from sys.x$bh
group by decode(state, 0, 'Free', 
	1, decode(lrba_seq,0,'Available','Being Modified'), 
	2, 'Not Modified', 
	3, 'Being Read',
	'Other') 
/
set verify on
spool off
Return to Index of SQL Scripts 



Home | Company Profile | Services | Contact Us | SQL scripts and tips | Quiz 
Legal 



         

