The allocated file size in KB. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
The free space available in the data file in KB. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
The number of blocks used as auto-extension increment. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Instance ID of the instance to which the temp file belongs. This column has a NULL value for temp files that belong to shared tablespaces. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
Indicates whether the data file is auto-extensible.
The lost write protection status of the file.
The maximum file size in KB. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
The filename (including the path) of the data file or temp file.
The online status of the file.
Type of tablespace this file belongs to. If it's for a shared tablespace, for a local temporary tablespace for RIM (read-only) instances, or for local temporary tablespace for all instance types.
The status of the file. INVALID status is used when the file number is not in use, for example, a file in a tablespace that was removed.
The percentage of used space out of the total allocated space in the file. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
The percentage of used space out of the maximum available space in the file. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
The total space used in the data file in KB. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
The size of the file available for user data in KB. The actual size of the file minus the USER_BYTES value is used to store file-related metadata. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.
The details of a data file.