SQL 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

spool buffer.lst

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