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
Path Parameters
-
file_id(required): string
File identifier.
-
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
Usage information about the temporary file.
Root Schema : DatabaseTablespaceDatafileUsageItem
Type:
object
Using GV$DATAFILE and DBA_FREE_SPACE data this object represents the usage of a data file in the database.
Show Source
-
autoextend: string
Indicates whether the file is autoextensible (YES) or not (NO).
-
file_id: integer
File identifier number of the database file.
-
file_name: string
Name of the database file.
-
links: array
links
-
status: string
File status.
-
tablespace: string
Name of the tablespace.
-
total_space: integer
Total size of the files (in bytes).
-
used_space: integer
Total used space (in bytes).
-
used_space_pct: number
:Percentage of how much space is used.