Databases Reference
In-Depth Information
F
INDEX_TYPE
: The type of the index; can be
NORMAL
,
BITMAP
,
FUNCTION-BASED
NORMAL
,
FUNCTION-BASED
BITMAP
, or
DOMAIN
F
TABLE_TYPE
: The type of the indexed object (
TABLE
or
CLUSTER
)
F
UNIQUENESS
: Whether the index is
UNIQUE
or
NONUNIQUE
F
COMPRESSION
: If the index is compressed then the value is
ENABLED
, else
DISABLED
F
PREFIX_LENGTH
: The number of columns in the compressed prefix of the key
F
LEAF_BLOCKS
: The number of leaf blocks in the index
DBA_SQL_PLAN_BASELINES
Displays information about the SQL Plan baselines created for a specific SQL statement.
Fields
The most relevant view fields are as follows:
F
SQL_HANDLE
: A unique identifier
F
SQL_TEXT
: The un-normalized SQL text
F
PLAN_NAME
: A unique plan identifier
F
ENABLED
: This indicates whether the plan baseline is enabled (
YES
/
NO
)
F
ACCEPTED
: This indicates if the plan baseline is accepted (
YES
/
NO
)
F
FIXED
: This indicates if the plan baseline is fixed (
YES
/
NO
)
F
EXECUTIONS
: The number of executions at the time the plan baseline was created
DBA_TABLES
This view lists all the tables in the database. There are the corresponding
ALL_TABLES
and
USER_TABLES
, showing, respectively, the tables which the current user can access and the
tables the current user owns.
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
TABLESPACE_NAME
: The name of the tablespace in which the table is stored
F
STATUS
: This can be
VALID
or
UNUSABLE