Get tablespace space usage history
get
/database/storage/tablespaces/{tablespace_name}/history
Oracle Diagnostic Pack licence is required for this service. Returns DBA_HIST_TBSPC_SPACE_USAGE records where tablespace size has changed. These records are historical tablespace usage statistics. Recent changes in tablespace storage or usage will not appear until a snapshot is created. A client requires SQL Administrator role to invoke this service.
Request
Path Parameters
-
tablespace_name(required): string
Name of the tablespace.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
200 Response
Tablespace space usage history for the specified tablespace.
Root Schema : DatabaseTablespaceHistoryItem
Type:
object
Describes historical tablespace usage statistics.
Show Source
-
con_dbid: integer
The database ID of the PDB for the sampled session.
-
con_id: integer
The ID of the container that CON_DBID identifies.
-
dbid: integer
Database ID for the snapshot.
-
name: string
Tablespace name.
-
prev_tablespace_size: integer
The previous tablespace size (in database blocks).
-
rtime: string
Runtime.
-
snap_id: integer
Unique snapshot ID.
-
tablespace_id: integer
Tablespace ID.
-
tablespace_maxsize: integer
Maximum size of the tablespace (in database blocks).
-
tablespace_size: integer
Tablespace size (in database blocks).
-
tablespace_usedsize: integer
Used size of the tablespace (in database blocks).