Re: buffer busy waits on C_USER#
- From: Jared Still <jkstill@xxxxxxxxx>
- To: bnsarma@xxxxxxxxx
- Date: Tue, 7 Dec 2004 06:30:18 -0800
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
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
