RE: Question on x$kcbfwait

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Tue, 1 Aug 2000 05:40:07 +1000
Message-Id: <10575.113409@fatcity.com>

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).

Received on Mon Jul 31 2000 - 14:40:07 CDT