Segment Usage
Click the [Analysis] > [Usage Analysis] > [Segment Usage] menu in the global navigation bar to open the Segment Usage screen.
Overview
The users can select the date the users want to view. The Segment Usage list for the selected period shows a simple overview of usage increases and decreases.
Segment Usage
This screen shows the changes in size for each segment name during the specified period.
The following is a description of the items provided in the Segment Usage screen.
Earlier Time
Previous time
Later Time
Subsequent time
Earlier Size
Size at the previous time
Later size
Size at a later point in time
Increment
The amount by which the size has increased or decreased from the previous point in time to the later point in time
Tablespace Name
Tablespace name
Owner
Owner of the object
Segment Name
Segment Name
Segment Type
Segment type
Partition Name
Partition Name
Earlier Extents
Number of Extents at an Earlier Point in Time
Later Extents
Number of Extents at a later point in time
Earlier Blocks
Blocks at an earlier point in time
Later Blocks
Blocks at later points in time
Segment Usage Header
The Segment Usage Header provides a feature that allows the users to select filters for data retrieval
The users can sort by the desired column using the drop-down box to the right of Order by.
Use the drop-down menu to the right to set the number of top items the users want to view.
Segment Info
When the users click on specific data in Segment Usage, the users can view detailed changes in the size of the segment by date. At the same time, the users can quickly grasp the size changes at a glance using the graph on the right.
The following is a description of the items provided in the Segment Info screen.
Log Time
Collection time
Partition Count
Number of partitions
Size
Size
Blocks
Number of blocks
Last updated