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@xxxxxxxxx> 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

Other related posts: