Re: buffer busy waits PUZZLES

From: The Human Fly <sjaffarhussain_at_gmail.com>
Date: Wed, 18 May 2005 09:10:35 +0300
Message-ID: <97b7fd2f05051723103eb1d414@mail.gmail.com>

However, I haven't have buffer busy wait as my tops events nor I see any session execessively waiting for this event. I have already mentioned in my previous replies that I have grabbed these values from v$segment_statistics dynamic view.

The following are today's result for the buffer busy waits.

TRANSACTION_LOG                    211143
FM_AUDIT_FORM                       39906
C_INTIMATION                        37029
CIS_AUDIT_TRAILH                    15001
OUTWARD_CLEARING_CHEQUES             8310
C_CUSTOMER                           5793
FM_OLTP_LOG                          2727
INWARD_CLEARING_CHEQUES              2347
RB_RESTRAINTS                        2239
SYSTEM_PARAMETER_VALUE               1492
RB_TRAN_HIST                         1102

I have increased default freelist 1 to 5 to those tables and now I can clearly see that those tables buffer busy wait event has increased madly. This could be due to heavy access on those tables?

However, I have been reading Cary's book past 1 year and still I enjoying reading it. Thank god, now, I started undertanding the concept behind method R and the true power of 10046 trace for resolving performance issues.

On 5/18/05, Alex Gorbachev <gorbyx_at_gmail.com> wrote:
> My bad...

>=20

> 2005/5/17, Cary Millsap <Cary.Millsap_at_hotsos.com>:
> > Ah! Credit to Gaja and Kirti for that one...
> >=3D20
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > http://www.hotsos.com
> > * Nullius in verba *
> >=3D20
> > Visit www.hotsos.com for curriculum and schedule details...
> >=3D20
> >=3D20
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.o=
rg=3D
> ]
> > On Behalf Of Alex Gorbachev
> > Sent: Tuesday, May 17, 2005 2:42 PM
> > To: sjaffarhussain_at_gmail.com
> > Cc: K Gopalakrishnan; oracle-l_at_freelists.org
> > Subject: Re: buffer busy waits PUZZLES
> >=3D20
> > sessions/transactions than you you've got CTD ("Compulsive Tuning
> > Disorder") speaking Carry's language.

>=20

> --=3D20
> Best regards,
> Alex Gorbachev
> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Best Regards,
Jaffar, OCP DBA
Banque Saudi Fransi
Saudi Arabia

---------------------------------------------------------------------------=

"It is your atittude, not your aptitude that determins your altitude."

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 18 2005 - 02:15:12 CDT