Get data file usage summary for a specific tablespace
get
/database/storage/tablespaces/{tablespace_name}/datafiles_usage
Returns GV$DATAFILE and DBA_DATA_FILES records for a specific tablespace. 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 data file usage.
Root Schema : DatabaseTablespaceDatafilesUsageItem
Type:
object
Title:
DatabaseTablespaceDatafilesUsageItem
Using GV$DATAFILE and DBA_FREE_SPACE data this object represents the usage of a data file in the database.
Show Source
Nested Schema : Item6
Type:
object
Title:
Show Source
Item6
-
autoextend(optional):
string
Indicates whether the file is autoextensible (YES) or not (NO).
-
file_name(optional):
string
Name of the database file.
-
status(optional):
string
File status.
-
tablespace(optional):
string
Name of the tablespace.
-
total_space(optional):
integer(int32)
Total size of the files (in bytes).
-
used_space(optional):
integer(int32)
Total used space (in bytes).
-
used_space_pct(optional):
number(double)
:Percentage of how much space is used.