help: contents of db buffer

We are using the following sql to get the contents of db buffer of 8i

select kcbwbpd.bp_name,
o.name,
count(*) BLOCKS
from sys.x$kcbwds kcbwds,
sys.x$kcbwbpd kcbwbpd,
sys.x$bh bh, sys.obj$ o
Where kcbwds.set_id >= kcbwbpd.bp_lo_sid and kcbwds.set_id <= kcbwbpd.bp_hi_sid
and kcbwbpd.bp_size != 0
and bh.indx between start_buf# and end_buf# and o.dataobj# = bh.obj
and bh.state !=0
and o.owner# !=0
and bp_name like upper('%K%')
group by kcbwbpd.bp_name, o.name

but it does not work on 9i
I got the following error,
ERROR at line 10:
ORA-00904: "END_BUF#": invalid identifier

Could somebody help me out?
Thanks Received on Thu Aug 29 2002 - 06:11:08 CDT