Databases Reference
In-Depth Information
DBA_TABLESPACES
This is a dynamic performance view equivalent to the
SYS.TS$
table containing
information on all tablespaces; the only difference is that
DBA_TABLESPACES
doesn't
list dropped tablespaces.
Fields
The most relevant view fields are as follows:
F
TABLESPACE_NAME
: The name of the tablespace
F
BLOCK_SIZE
: The database block size used in the tablespace
F
STATUS
: This can be
ONLINE
,
OFFLINE
, or
READ
ONLY
F
CONTENTS
: This can be
UNDO
,
PERMANENT
, or
TEMPORARY
F
LOGGING
: This can be
LOGGING
or
NOLOGGING
F
EXTENT_MANAGEMENT
: This can be
DICTIONARY
for dictionary managed or
LOCAL
for locally managed tablespaces
F
ALLOCATION_TYPE
: This can be
SYSTEM
,
USER
, or
UNIFORM
DBA_TAB_HISTOGRAMS
This view describes histograms on all the tables and views generated when collecting statistics
using the
ANALYZE
statement or
DBMS_STATS
package. There are the equivalent views
ALL_TAB_HISTOGRAMS
and
USER_TAB_HISTOGRAMS
; the first contains information on all the
objects accessible by the current user, the last on the current user objects in the database.
Fields
The most relevant view fields are as follows:
F
OWNER
: The owner of the table
F
TABLE_NAME
: The name of the table
F
COLUMN_NAME
: The name of the column
F
ENDPOINT_NUMBER
: The histogram bucket number
F
ENDPOINT_VALUE
: The normalized endpoint value for the bucket
F
ENDPOINT_ACTUAL_VALUE
: The actual endpoint value (not normalized)
for the bucket