Re: What's in my buffers script
Would this be correct on 9.4?
select dbsname, tabname, count(*) as buffer_count
from sysextents se, sysbufhdr bh
where bh.offset between se.offset and (se.offset + se.size - 1)
group by 1, 2
order by 3 desc, 1, 2
↪ replying to Kristofer Andersson
On Fri, 22 Aug 2003 11:23:58 -0400, Kristofer Andersson wrote:
Almost one clause missing:
> Would this be correct on 9.4?
>
> select dbsname, tabname, count(*) as buffer_count
> from sysextents se, sysbufhdr bh
> where bh.offset between se.offset and (se.offset + se.size - 1) group
and bh.chunk = se.chunk
> by 1, 2
> order by 3 desc, 1, 2
Art S. Kagel