| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
DBA_FREE_SPACE describes the free extents in all tablespaces in the database.
USER_FREE_SPACE describes the free extents in the tablespaces accessible to the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
TABLESPACE_NAME |
VARCHAR2(30) |
Name of the tablespace containing the extent | |
FILE_ID |
NUMBER |
File identifier number of the file containing the extent | |
BLOCK_ID |
NUMBER |
Starting block number of the extent | |
BYTES |
NUMBER |
Size of the extent (in bytes) | |
BLOCKS |
NUMBER |
Size of the extent (in Oracle blocks) | |
RELATIVE_FNO |
NUMBER |
Relative file number of the file containing the extent |
|
 Copyright © 2002, 2003, Oracle Corporation All Rights Reserved. |
|
