Allocated oracle,Most allocated extents in any segment

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