Beyond Basics

Onstat and Sysmaster

Number of unused buffers:

select count(*) from sysbufhdr where pagenum = -1;

Buffers by table:

select dbsname,tabname, count(*)

from sysextents se, sysbufhdr sb

where sb.pagenum >= se.start

and sb.pagenum < (se.start + se.size)

and tabname not match 'sys*'

and tabname != 'TBLSpace'

group by 1, 2

order by 1, 2;

onstat -P