Hi Steve,
My script was doing the same as your
buffer_busy_waits.sql script.
Sorry for the laited reply but I'm leaving the client
this week and I had a lot of things to wrapped up.
Rgs.
- Steve Adams <steve.adams_at_ixora.com.au> a écrit : >
Hi Stephane,
>
> It shows buffer busy waits on buffers containing
> blocks from those
> datafiles.
> Make sure that your script offsets the file number
> by one when doing the
> join to V$DATAFILE.
> Have a look at my buffer_busy_waits.sql script for
> an example.
> Also, for buffer busy waits against rollback segment
> header blocks,
> my enough_rollback_segments.sql script makes a
> helpful distinction
> between read waits and write waits
> that might help you to work out what's going on
> there.
>
> You may want to post the output of both scripts back
> to the list?
>
> Regards,
> Steve Adams
> http://www.ixora.com.au/
> http://www.oreilly.com/catalog/orinternals/
> http://www.christianity.net.au/
>
>
> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On
> Behalf Of paquette
> stephane
> Sent: Tuesday, 1 August 2000 4:00
> To: Multiple recipients of list ORACLE-L
> Subject: Question on x$kcbfwait
>
>
> Hi,
>
> I'm trying to understand x$kcbfwait.
> I can't find a reference of this table in any V$
> views.
>
> I have a script that linked x$kcbfwait to
> v$datafile.
> It seems to show waits on datafiles but I do not
> quite
> understand what's going on. The datafiles having the
> more waits are the ones containing the rollback
> segments.
>
>
>
> =====
> Stephane Paquette
> DBA Oracle
> stephane_paquette_at_yahoo.com
> spaquette_at_houra.fr
> (33) 01 53 93 06 50
>
> __________________________________________________
> Do You Yahoo!?
> Kick off your party with Yahoo! Invites.
> http://invites.yahoo.com/
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Received on Wed Aug 16 2000 - 03:53:34 CDT
