FAQ
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

Search Discussions

  • Jared Still at Dec 7, 2004 at 8:29 am
    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 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
  • Terry Sutton at Dec 7, 2004 at 10:55 am
    How much time is spent on these waits? Are they slowing down your system?
    Are they affecting users?

    --Terry

    Original Message -----
    From: "BN"
    To:
    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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedDec 7, '04 at 8:15a
activeDec 7, '04 at 10:55a
posts3
users3
websiteoracle.com

3 users in discussion

Jared Still: 1 post BN: 1 post Terry Sutton: 1 post

People

Translate

site design / logo © 2022 Grokbase