Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help: contents of db buffer
Well, that script was provided by oracle support on metalink. I certainly
can not write something like that, you need to read a lot of documents in
order to understand what each column means.
"Sybrand Bakker" <postbus_at_sybrandb.demon-verwijderdit.nl> wrote in message
news:kuqsmusc2boo3ev7paonkcmapa21mlibih_at_4ax.com...
> On Thu, 29 Aug 2002 11:11:08 GMT, "charlie s" <cs3526(delete this
> word)@yahoo.com> wrote:
>
> >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
> >
>
>
> Please issue
> describe x$bh
> connected as SYS
> I'm also wondering why you don't use the v$bh view, instead the
> underlying tables which might be and probably will change from release
> to release
>
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Thu Aug 29 2002 - 14:22:04 CDT