Segments - Most Extents

 

Use these reports to view the segments with the most extents, sorted by tablespace, tablespace group, database, computer, computer group, and network wide.

Type

Use these reports to...

What's in these reports?

By Tablespace

View the segments with the most extents sorted by tablespace

  • Number Extents

  • Group Creator (By group clauses only)

  • Group Name (By group clauses only)

  • Segment Creator

  • Segment Name

  • Computer

  • Instance

  • Database

  • Partition

  • Segment Type

  • Parent Type

  • Parent Creator

  • Parent Name

  • Total Size

  • Empty Used Space

  • Freelist Blocks

  • Freelist Groups

  • Initial Extent

  • Next Extent

  • Minimum Extents

  • Maximum Extents

  • Percent Increase

By Tablespace Group

View the segments with the most extents sorted by tablespace group

By Database

View the segments with the most extents sorted by Database

By Computer

View the segments with the most extents sorted by computer

By Computer Group

View the segments with the most extents sorted by computer group

Network Wide

View the segments with the most extents network wide