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_at_ixora.com.au> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_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_at_tax.state.vt.us
>
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_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_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).
>
> --
> Author: Steve Adams
> INET: steve.adams_at_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_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
Received on Wed Aug 30 2000 - 07:37:28 CDT