Message-Id: <10604.115841@fatcity.com>
From: "Ruth Gramolini" <rgramolini@tax.state.vt.us>
Date: Wed, 30 Aug 2000 08:37:28 -0400
Subject: Re: data block waits

Steve, and everyone else,

Well, that's not it.  Buffer Busy Waits is near the bottem. SQL*Net Message
from client is at the top, followed by Slave Wait and CPU used by this
session.

Any other ideas?  I will be a hero if I get a solution.
Ruth

----- Original Message -----
From: Steve Adams <steve.adams@ixora.com.au>
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sent: Wednesday, August 30, 2000 9:17 AM
Subject: RE: data block waits


> Hi Ruth,
>
> Try running the system_times.sql script from the Ixora web site. If
'buffer busy
> waits' is near the top and represents a significant proportion of the
total
> times, then you may have correctly identified the problem.
>
> @   Regards,
> @   Steve Adams
> @   http://www.ixora.com.au/
> @   http://www.christianity.net.au/
> @
> @   Going to OpenWorld?
> @   Catch the Ixora performance tuning seminar too!
> @   See http://www.ixora.com.au/seminars/ for details.
>
>
> -----Original Message-----
> Sent: Wednesday, 30 August 2000 22:35
> To: Multiple recipients of list ORACLE-L
>
>
> Dear Listers,
>
> When I query v$waitstat I get a large number for the class data block  and
> my database is running very slowly.  Are these two things related and is
> there anything I can do?
>
> As always, thank you for any light you can shed.
>
> Ruth B. Gramolini
> ORACLE & DB2  DBA
> VT Dept. of Taxes
> ph# 802.828.5708
> fax# 802.828..3754
> rgramolini@tax.state.vt.us
>
> --
> Author: Ruth Gramolini
>   INET: rgramolini@tax.state.vt.us
>
> 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@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).
>
> --
> Author: Steve Adams
>   INET: steve.adams@ixora.com.au
>
> 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@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