Re: buffer busy waits on C_USER#
- From: "Terry Sutton" <terrysutton@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 7 Dec 2004 08:25:53 -0800
How much time is spent on these waits? Are they slowing down your system?
Are they affecting users?
--Terry
----- Original Message -----
From: "BN" <bnsarma@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
