One more detail: "buffer busy waits" is not an indication of competition
for a block on disk. It indicates competition for a block IN MEMORY.
More memory won't help, faster disks won't help. The cure is to make the
competing processes not compete.
The problem is usually a result of applications t
> CLASS COUNT TIME
> -- -- --
> data block 131525173 225446798
> will not
> -- using bind variables instead of literals
> -- seperating tables and indexes to diferent tabelspace
>
> solve my problem ?
No and no. You have
Hi Ganesh,
First of all the problem here is "Buffer busy waits "
When you have determined the "Buffer busy waits" is one of the top wait
events
causing problems then
1. You could query v$waitstat to see the breakdown of waits according to
'class'
2. You could query x$KCBFWAIT to find the
Fro my clarity ..
What does the extent size has to do with segment header contention.
And about index rebuilds.. Why do u say that this will cause a Problem
for the waits he is Experencing.
Hope to get some clarity on this... Thanks
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 4
Hi,
Your major problems with buffer busy waits are in the
Data blocks class: (1), undo block(2), segment header (3)
For Data block Class:
Solution:
1. Reduce no of rows by changing pctfree/pctused
2. check when the last time your indexes were re-built and
rebuild them often (inde
oraora oraora£¬
hi, i think use bind variable will give better performance, but it has nothing to
do with the buffer busy wait.Using bind variable will solve the repeated parse and
thus reduce library latch free wait.
And seperate table and index won't help either. There is a greate
Hi Kavitha,
querying v$waitstat gives me the o/p below.
CLASS COUNT TIME
-- -- --
data block 131525173 225446798
sort block 0 0
save undo block 0 0
segment header 4968
oing against a set of same blocks (hot blocks)
Thanks,
Kavi
oraora oraora wrote:
> Guys,
>
> " Buffer busy waits are 10.96% of non-idle waits "
>
> TOAD gives this alarm often. what does it mean ? which view will
> give me the wait statistics ?
>
> " it o
RACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 8:48 AM
> Guys,
>
> " Buffer busy waits are 10.96% of non-idle waits "
>
> TOAD gives this alarm often. what does it mean ? which view will
> give me the wait statistics ?
>
> " it occurs when a se
Guys,
" Buffer busy waits are 10.96% of non-idle waits "
TOAD gives this alarm often. what does it mean ? which view will
give me the wait statistics ?
" it occurs when a session cannot access a block because it is in
use by another session. The two most common causes are
in
10 matches
Mail list logo