Get tablespace temporary file usage
get
/database/storage/tablespaces/{tablespace_name}/tempfiles/{file_id}/usage
Returns GV$DATAFILE and DBA_TEMP_FILES records for a specific tablespace and file. A client requires SQL Administrator role to invoke this service.
Request
Supported Media Types
- application/json
Path Parameters
-
file_id: string
File identifier.
-
tablespace_name: string
Name of the tablespace.
Response
Supported Media Types
- application/json
200 Response
Usage information about the temporary file.
Root Schema : DatabaseTablespaceDatafileUsageItem
Type:
object
Title:
DatabaseTablespaceDatafileUsageItem
Using GV$DATAFILE and DBA_FREE_SPACE data this object represents the usage of a data file in the database.
Show Source
-
autoextend(optional):
string
Indicates whether the file is autoextensible (YES) or not (NO).
-
file_id(optional):
integer(int32)
File identifier number of the database file.
-
file_name(optional):
string
Name of the database file.
-
links(optional):
array links
-
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.