Databases Reference
In-Depth Information
A
Dynamic Performance
Views
In this topic, we have been presented with many dynamic performance views, used to access
a wide spread of details about an Oracle database, regarding different aspects from the
sessions to the SQL statement executed.
In this appendix, we present a summary of these views, in alphabetical order, which can be
used as a reference. For each view, there is a brief description and a list of the most useful
fields of the view.
ALL_OBJECTS
This view lists all the database objects the current user can access. As for many
ALL_
views,
there are similar
DBA_OBJECTS
and
USER_OBJECTS
views; they have the same fields
but
DBA_OBJECTS
shows all the objects in the database, while
USER_OBJECTS
shows
information only on the objects of the current user.
This view is often joined to other dynamic performance views, for example,
V$LOCKED_OBJECT
,
by
OBJECT_ID
to obtain the object name and owner.
Fields
The most relevant view fields are as follows:
F
OWNER
: The owner of the object
F
OBJECT_NAME
: The name of the object
F
OBJECT_ID
: The unique ID associated to the object in the data dictionary