RE: data block waits

Ruth,

We had a similar problem and it turned out that the freelists for a table needed to be increased. If you have a table that has a lot of inserting you may need to increase the freelists for that table. I'm not sure what is the easiest way to find the table that needs its freelist parameter increased. We spent a bunch of time trying to track it down by looking at I/O against all the tables and then narrowing it down to the few most likely ones. Once you find the table(s), the only way I know to increase the freelists is to rebuild that table (we did an export, rebuild and import). If I remember correctly, the freelists should be set to the number of concurrent inserts against that table.

Hope that helps!

Bob VanderMey
Oracle DBA
Works.com
847 573-2687
bvandermey_at_works.com
565 Lakeview Parkway, Suite 250
Vernon Hills, IL 60061
http://www.works.com

-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us] Sent: Wednesday, August 30, 2000 8: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

• Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, August 30, 2000 9:17 AM

> 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 may