Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: buffer busy waits on C_USER#

Re: buffer busy waits on C_USER#

From: Terry Sutton <terrysutton_at_usa.net>
Date: Tue, 7 Dec 2004 08:25:53 -0800
Message-ID: <012301c4dc7a$24ed0350$6501a8c0@TerrySutton>


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

--Terry

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US