Re: buffer busy waits PUZZLES

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Tue, 17 May 2005 21:41:49 +0200
Message-ID: <c2213f68050517124129fb1430@mail.gmail.com>

As it was mentioned already, you probably don't have this problem. If you have around 50 tps, chances are that you perform much more logical IOs than few thousands "buffer busy waits".

You can have a look at v$system_event to see whether "buffer busy waits" is significant. Better yet to identify the sessions that have performance problem and check v$session_event or even better do 10046 trace. If you do not see buffer busy waits in top waits for the instance and do not have performance issues for specific sessions/transactions than you you've got CTD ("Compulsive Tuning Disorder") speaking Carry's language.

2005/5/10, The Human Fly <sjaffarhussain_at_gmail.com>:
> Gopal,

>=20

> Actually, I was digging at v$segment_statistic level. The following
> query has been used,

>=20

> select object_name,statistic_name,value from v$segment_statistics
> where statistic_name like '%buffer busy%'
> and value > 100
> order by value desc

>=20

> and the output is

>=20


> OBJECT_NAME                    STATISTIC_NAME                      VALUE

> ------------------------------ ------------------------------ ----------

> C_INTIMATION                   buffer busy waits                    8032

> CIS_AUDIT_TRAILH               buffer busy waits                    3739

> TRANSACTION_LOG                buffer busy waits                    2185

> FM_AUDIT_FORM                  buffer busy waits                    2032

> C_CUSTOMER                     buffer busy waits                    1768

> FM_OLTP_LOG                    buffer busy waits                    1476

> RB_RESTRAINTS                  buffer busy waits                     730

> RB_TRAN_HIST                   buffer busy waits                     653

> FM_ERROR_LOG                   buffer busy waits                     532

>=20

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

Received on Tue May 17 2005 - 15:46:28 CDT