Databases Reference
In-Depth Information
F
LOGGING
: This indicates whether changes to the table are logged or not (
YES
/
NO
)
F
NUM_ROWS
: The number of rows in the table
F
BLOCKS
: The number of used database blocks in the table
F
EMPTY_BLOCKS
: The number of empty database blocks in the table
F
AVG_SPACE
: The average free space in bytes for allocated data blocks
F
CHAIN_CNT
: The number of chained rows in the table
F
AVG_ROW_LEN
: The average length of a row in the table
F
AVG_SPACE_FREELIST_BLOCKS
: The average free space of all blocks
on a freelist
F
NUM_FREELIST_BLOCKS
: The number of blocks in a freelist
F
SAMPLE_SIZE
: The sample size used when analyzing the table
F
GLOBAL_STATS
: For partitioned tables, this indicates whether the statistics
were made on all the partitions (
YES
) or estimated (
NO
)
F
USER_STATS
: This indicates whether the statistics were entered
by the user (
YES
/
NO
)
F
LAST_ANALYZED
: The date on which the table was last analyzed
DBA_TEMP_FILES
This view shows all temporary files in the database.
Fields
The most relevant view fields are as follows:
F
FILE_ID
: A unique ID associated to the file
F
FILE_NAME
: The name of the temporary file
F
TABLESPACE_NAME
: The name of the tablespace to which the file belongs
F
BYTES
: The size in bytes
F
BLOCKS
: The size in database blocks
See also
F
The
DBA_EXTENTS
,
FILE$
,
V$DATAFILE
,
V$LOGFILE
,
DBA_DATA_FILES
,
and
V$CONTROLFILE
sections in this appendix