[Home] [Help]
[Dependency Information]
VIEW: SYS.DBA_FREE_SPACE
Object Details
Object Name: | DBA_FREE_SPACE |
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Free extents in all tablespaces
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
TABLESPACE_NAME |
VARCHAR2 |
(30) |
|
Name of the tablespace containing the extent |
FILE_ID |
NUMBER |
|
|
ID 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 number of the file containing the extent |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT TABLESPACE_NAME
, FILE_ID
, BLOCK_ID
, BYTES
, BLOCKS
, RELATIVE_FNO
FROM SYS.DBA_FREE_SPACE;
Dependencies
[top of page]
SYS.DBA_FREE_SPACE references the following:
-
SYS
-
FET$
-
FILE$
-
RECYCLEBIN$
-
TS$
-
UET$
-
-
-
-
SYS.DBA_FREE_SPACE is referenced by following:
-
DBSNMP
-
DBA_FREE_SPACE
-
PUBLIC
-
DBA_FREE_SPACE
-
SYS
-
DBMS_AUDIT_MGMT
- show dependent code
-
DBMS_SPACE
- show dependent code
-
INITJVMAUX
- show dependent code
-
KUPC$QUE_INT
- show dependent code
-
PRVT_ILM
- show dependent code
-
SM$TS_FREE