7.219 V$FILESPACE_USAGE
V$FILESPACE_USAGE
summarizes space allocation information of each data file and temp file.
Column | Datatype | Description |
---|---|---|
|
|
ID of the tablespace to which the file belongs |
|
|
Relative file number of the file |
|
|
Total allocated space in the file |
|
|
Current file size |
|
|
Maximum file size |
|
|
SCN base of the last change to the file |
|
|
SCN wrap of the last change to the file |
|
|
The 8–byte representation of the SCN at which the last change happened to the file |
|
|
Flags for file attributes |
|
|
The ID of the container to which the data pertains. Possible values include:
|