Skip to Content
avatar image
Former Member

Most allocated extents in any segment

Dear All,

We have SAP ECC 6.0 in Unix 5.3 environment & Oracle 10.2.0.2.0.

From last two days i am getting some error & warning in our ECC Production system. i am checking through ST04.

Error are,

1. Most allocated extents in any segment

2. Database health check -Last brconnect -f check run

3. Database administration - Critical tablespace

4. DBA operations- Last operation failed & Last succ. operation too old

Please guide me.

Regards,

Aasmi.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 31, 2009 at 01:13 PM

    A simple google and you would have found your answer..

    Most allocated extents in any segment

    Cause: The number of allocated extents any segment has exceeded the configured threshold. Having few allocated extents per segment was significant when Oracleu2019s maximum MAX_EXTENTS value was relatively low based on Oracleu2019s block size. MAX_EXTENTS can now have a value of "unlimited," eliminating this concern. Having many extents should not cause problems, assuming none of the segments in this tablespace have PCTINCREASE set to non-zero and that the NEXT storage parameter settings for all segments in this tablespace are either all the same or multiples of one another.

    Action: If you prefer segments with fewer allocated extents, you can use SAPDBA to reorganize the object.

    The Oracle forum would have been the best place for your question.

    Regards,

    Nelis

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 31, 2009 at 04:44 PM

    Hi,

    As you are using oracle 10.2.0.2.0 you do not need to worry about this. Your tablespaces must be locally managed in this version. If you want to reduce the extents then you may reorgnize the table online by BRTOOLS.

    Hope this helps.

    Manoj

    Add comment
    10|10000 characters needed characters exceeded