buffer busy waits on C_USER#

From: BN <bnsarma@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Tue, 7 Dec 2004 09:17:26 -0500

Greetings,

Oracle 8174 on HP UX

I notice BBW with 220 on c_user# during busy times, any suggestions

 7 file#                    1 block#                  54 id           
    220 buffer busy waits
    240 file#                    1 block#                  54 id      
         220 buffer busy waits
    219 file#                    1 block#                  54 id      
         220 buffer busy waits
    272 file#                    1 block#                  54 id      
         220 buffer busy waits
     16 file#                    1 block#                  54 id      
         220 buffer busy waits
     49 file#                    1 block#                  54 id      
         220 buffer busy waits
    203 file#                    1 block#                  54 id      
         220 buffer busy waits

Enter value for absolute_file_number: 1
old   3:         WHERE  file_id = &absolute_file_number
new   3:         WHERE  file_id = 1
Enter value for block_number: 54
old   4:         AND    &block_number BETWEEN block_id AND block_id + blocks -1
new   4:         AND    54 BETWEEN block_id AND block_id + blocks -1

OWNER        SEGMENT_NAME                   SEGMENT_TYPE
------------ ------------------------------ ---------------
SYS          C_USER#                        CLUSTER


Regards & Thanks
BN

-- 
Regards & Thanks
BN
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: buffer busy waits on C_USER#
From: Jared Still

Re: buffer busy waits on C_USER#
From: Terry Sutton

buffer busy waits on C_USER#

Other related posts: