These views are used to monitor real time database statistics from Oracle and are called dynamic performance tables.
Database administrators can query and create views on the tables and grant access to those views to other users.
These views are called fixed views because they cannot be altered or removed by the database administrator, SYS owns the dynamic performance tables.
By default, they are available only to the user SYS and to users granted SELECT ANY TABLE system privilege, such as SYSTEM. Their names all begin with V_$. Views are created on these tables, and then public synonyms are created for the views. The synonym names begin with v$.
V$SGAINFO -displays size information about the SGA, including the sizes of different SGA components, the granule size, and free memory.
NAME VARCHAR2(32) Name of the SGA statistic
BYTES NUMBER Size of the statistic (in bytes)
RESIZEABLE VARCHAR2(3) Indicates whether the statistic
is resizeable (YES) or not (NO)
V$OPEN_CURSOR -Cursors opened by sessions on the instance -we can monitor the number of cursors opened by different sessions.
V$SESSION -Sessions currently connected to the instance. -Use V$SESSION to find the SQL statements being executed by the sessions holding the lock and waiting for the lock.
V$LOCK -Locks currently held/requested on the instance. -You should examine this view if you find sessions waiting for the wait event enqueue.
V$SEGSTAT -High-efficiency view for real-time monitoring of segment-level statistics.
V$SESSION_EVENT -Session-level summary of all the waits for current sessions.
V$SQL_PLAN -Execution plan for cursors that were recently executed.
V$SQLAREA -This view keeps track of all the shared cursors present in the shared pool of SGA, It has one row for every SQL statement present in the shared pool.
V$SGA - It lists statistics on shared SQL areas without the GROUP BY clause and contains one row for each child of the original SQL text entered. Statistics displayed in V$SQL are normally updated at the end of query execution. However, for long running queries, they are updated every 5 seconds. This makes it easy to see the impact of long running SQL statements while they are still in progress.
V$DB_OBJECT_CACHE -This view provides object level statistics for objects in the library cache (shared pool).
V$PROCESS -This view contains information about all Oracle processes running on the system. It is used to relate the Oracle or operating system process ID of the server process to the database session.
PID: Oracle process ID of the process
SPID: Operating system process ID of the process
V$SQLTEXT -This view contains the complete SQL text for the SQL statements in the shared pool.
V$SYSSTAT -The data in this view is used for monitoring system performance. Derived statistics, such as the buffer cache hit ratio and soft parse ratio.
V$DBFILES -informanation on datafiles
V$controlfile -tell u the path name of control files.
V$PGASTAT -Statistics on allocation and use of work area memory can be viewed in the following dynamic performance views.
Database administrators can query and create views on the tables and grant access to those views to other users.
These views are called fixed views because they cannot be altered or removed by the database administrator, SYS owns the dynamic performance tables.
By default, they are available only to the user SYS and to users granted SELECT ANY TABLE system privilege, such as SYSTEM. Their names all begin with V_$. Views are created on these tables, and then public synonyms are created for the views. The synonym names begin with v$.
V$SGAINFO -displays size information about the SGA, including the sizes of different SGA components, the granule size, and free memory.
NAME VARCHAR2(32) Name of the SGA statistic
BYTES NUMBER Size of the statistic (in bytes)
RESIZEABLE VARCHAR2(3) Indicates whether the statistic
is resizeable (YES) or not (NO)
V$OPEN_CURSOR -Cursors opened by sessions on the instance -we can monitor the number of cursors opened by different sessions.
V$SESSION -Sessions currently connected to the instance. -Use V$SESSION to find the SQL statements being executed by the sessions holding the lock and waiting for the lock.
V$LOCK -Locks currently held/requested on the instance. -You should examine this view if you find sessions waiting for the wait event enqueue.
V$SEGSTAT -High-efficiency view for real-time monitoring of segment-level statistics.
V$SESSION_EVENT -Session-level summary of all the waits for current sessions.
V$SQL_PLAN -Execution plan for cursors that were recently executed.
V$SQLAREA -This view keeps track of all the shared cursors present in the shared pool of SGA, It has one row for every SQL statement present in the shared pool.
V$SGA - It lists statistics on shared SQL areas without the GROUP BY clause and contains one row for each child of the original SQL text entered. Statistics displayed in V$SQL are normally updated at the end of query execution. However, for long running queries, they are updated every 5 seconds. This makes it easy to see the impact of long running SQL statements while they are still in progress.
V$DB_OBJECT_CACHE -This view provides object level statistics for objects in the library cache (shared pool).
V$PROCESS -This view contains information about all Oracle processes running on the system. It is used to relate the Oracle or operating system process ID of the server process to the database session.
PID: Oracle process ID of the process
SPID: Operating system process ID of the process
V$SQLTEXT -This view contains the complete SQL text for the SQL statements in the shared pool.
V$SYSSTAT -The data in this view is used for monitoring system performance. Derived statistics, such as the buffer cache hit ratio and soft parse ratio.
V$DBFILES -informanation on datafiles
V$controlfile -tell u the path name of control files.
V$PGASTAT -Statistics on allocation and use of work area memory can be viewed in the following dynamic performance views.
Comments
Post a Comment