Tablespace Usage

Click [Realtime] > [Usage Monitoring] > [Tablespace Usage] in the global navigation bar to open the Tablespace Usage page.

The Tablespace Usage page displays information about tablespace usage.

Current Tablespace Usage

The users can view the tablespace usage and status information for the monitored database. The default collection interval is 1 hour, but the users can use the [Collect] button in the upper-right corner to collect and display real-time information for the specified time.

Item	Description
Tablespace Name	Tablespace name
Status	Current status of the tablespace
Contents	Table Space Types Permanent Undo
Free/Total Size	Table Space Free Space Status
Used/Total Size	Table Space Used Space Status
Extent Management	Extent Management Method
Allocation Type	Extent Allocation Method
Segment Space Management	Segment Space Management Method
Auto Extend On	Whether any of the data files in the table space are in Auto Extend mode

Last 24 hours history

In the Last 24 hours history, the users can view the usage information to date in grid format or check the trend of changes in chart format.

Item	Description
Log Time	Collection time
Free/Total Size	Free space status of tablespace
Used/Total Size	Usage status of tablespace

Segment Size

In Segment Size, the users can view the size of each segment type within the Log Time selected from the Last 24 hours history. The collection unit for this information is 1 hour.

Note

The larger the segment size, the more it is affected by load. Even if the users click the [Collect] button in the upper-right corner of the Tablespace Usage page, this information is not collected and is instead collected every hour on the hour.

Item	Description
Segment Type	Segment type (Table, Index, Undo, etc.)
Owner	Owner account
Segment Name	Segment Name
Partition Name	Partition Name
Used/Total Size	Ratio of space occupied by the segment