Oracle 11gR1
V$TEMPFILE displays tempfile information.
| Column | Datatype | Description |
|
|
| Absolute file number |
|
|
| Creation System Change Number (SCN) |
|
|
| Creation time |
|
|
| Tablespace number |
|
|
| Relative file number in the tablespace |
|
|
| Status of the file ( |
|
|
| Enabled for read and/or write |
|
|
| Size of the file in bytes (from the file header) |
|
|
| Size of the file in blocks (from the file header) |
|
|
| Creation size of the file (in bytes) |
|
|
| Block size for the file |
|
|
| Name of the file |
No comments:
Post a Comment