buffer busy waits on C

From: BN <bnsarma_at_gmail.com>
Date: Tue, 7 Dec 2004 09:17:26 -0500
Message-ID: <61292a9d04120706171b8676d2@mail.gmail.com>

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 Received on Tue Dec 07 2004 - 08:15:47 CST

buffer busy waits on C_USER#