Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: data block waits
Check the system that runs Oracle (UNIX, NT, etc.) and see if there is any
symptom of CPU, Disks, memory Contentions.
What is the hardware, OS, CPUs (how many)?
Regards
Waleed
-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
Sent: Wednesday, August 30, 2000 9:42 AM
To: Multiple recipients of list ORACLE-L
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
> 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
> also send the HELP command for other information (like subscribing).
>
-- 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 mayReceived on Wed Aug 30 2000 - 11:22:27 CDT