Re: buffer busy waits on C_USER#

The USER$ and TSQ$ ( tablespace quota ) tables are in the cluster C_USER#.

You haven't provided any other info about the system, so it could be a number of things.

High number of hard parses?

High login activity?

??

You might try dumping that block and see what's in it.

HTH Jared

On Tue, 7 Dec 2004 09:17:26 -0500, BN <bnsarma_at_gmail.com> wrote:
> 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
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l