Databases Reference
In-Depth Information
DBA_VIEWS
This view shows all the views in the database. There are the corresponding
ALL_VIEWS
and
USER_VIEWS
, that show, respectively, the views which the current user can access and the
views the current user owns.
Fields
The most relevant view fields are as follows:
F
OWNER
: The owner of the view
F
VIEW_NAME
: The name of the view
F
TEXT
: The text of the view
DBA_WAITERS
This view shows all the sessions waiting for a lock. It correlates a blocked transaction to
the blocking one.
Fields
The most relevant view fields are as follows:
F
WAITING_SESSION
: The ID of the waiting session
F
HOLDING_SESSION
: The ID of the session holding the lock
F
LOCK_TYPE
: The type of lock
F
MODE_HELD
: The locking mode held
F
MODE_REQUESTED
: The locking mode requested
See also
F
The
DBA_BLOCKERS
,
V$LOCK
, and
V$LOCKED_OBJECT
sections in this appendix
INDEX_STATS
This view collects information from index statistics (after an
ANALYZE
INDEX
).
