Get temporary file usage summary for a specific tablespace
get
/database/storage/tablespaces/{tablespace_name}/tempfiles_usage
Returns records from GV$TEMPFILE and DBA_TEMP_FILES for a specific tablespace. 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
Summary information of all temporary files used by the tablespace.
Root Schema : DatabaseTablespaceDatafilesUsageItem
Type:
object
Using GV$DATAFILE and DBA_FREE_SPACE data this object represents the usage of a data file in the database.
Show Source
Nested Schema : items
Type:
Show Source
object
-
autoextend: string
Indicates whether the file is autoextensible (YES) or not (NO).
-
file_name: string
Name of the database file.
-
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.