Re: buffer busy waits on C_USER#

How much time is spent on these waits? Are they slowing down your system? Are they affecting users?

--Terry

• Original Message ----- From: "BN" <bnsarma_at_gmail.com> To: <oracle-l_at_freelists.org> Sent: Tuesday, December 07, 2004 6:17 AM Subject: buffer busy waits on C_USER#

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 07 2004 - 10:55:59 CST