The actual dynamic performance views are identified by the prefix
V_$. Public synonyms for these views have the prefix
V$. Database administrators and other users should access only the
V$ objects, not the
The dynamic performance views are used by Oracle Enterprise Manager, which is the primary interface for accessing information about system performance. After an instance is started, the
V$ views that read from memory are accessible. Views that read data from disk require that the database be mounted, and some require that the database be open.
V$ views are
CONTAINER_DATA objects. When a user connected to the root queries a V$ view, the query results will depend on the
CONTAINER_DATA attribute for users for the view. The
CONTAINER_DATA clause of the SQL
ALTER USER statement is used to set and modify users'