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
Supported Media Types
- application/json
Path Parameters
-
tablespace_name: string
Name of the tablespace.
Response
Supported Media Types
- application/json
200 Response
Tablespace space usage history for the specified tablespace.
Root Schema : DatabaseTablespaceHistoryItem
Type:
object
Title:
DatabaseTablespaceHistoryItem
Describes historical tablespace usage statistics.
Show Source
-
con_dbid(optional):
integer(int32)
The database ID of the PDB for the sampled session.
-
con_id(optional):
integer(int32)
The ID of the container that CON_DBID identifies.
-
dbid(optional):
integer(int32)
Database ID for the snapshot.
-
name(optional):
string
Tablespace name.
-
prev_tablespace_size(optional):
integer(int32)
The previous tablespace size (in database blocks).
-
rtime(optional):
string
Runtime.
-
snap_id(optional):
integer(int32)
Unique snapshot ID.
-
tablespace_id(optional):
integer(int32)
Tablespace ID.
-
tablespace_maxsize(optional):
integer(int32)
Maximum size of the tablespace (in database blocks).
-
tablespace_size(optional):
integer(int32)
Tablespace size (in database blocks).
-
tablespace_usedsize(optional):
integer(int32)
Used size of the tablespace (in database blocks).