Oracle Common dynamic views

1. A dynamic performance view of the database/instance

V$database:d isplays information about the database from the control file.

V$instance:d Isplays The state of the present instance (status of current instance)

V$option:displays Oracle Database Options and features (options and attributes for databases)

: option must be separately licensed (option separate authentication settings)

: Whereas features come with the product and is enabled based on

The product is running (the performance of products is also to be reflected in product operation)

V$parameter:displays information about the initialization parameter that

: is currently in effect for the session. A New Session Inherits

:p Arameter values from the Instance-wide values displayed by the

: V$system_parameter view.

V$backup:d Isplay The backup status of all online datafiles. (Backup of all online data files)

V$px_process_sysstat:contains information about the sessions running parallel execution

(Contains information for parallel execution sessions)

V$process:displays information about the currently active processes (information on the active process)

V$waitstat:displays block contention Statistics.this table is only updated when timed

: Statistics is enabled (shows the statistics of Hot block competition, when the time statistic parameter is started, this table can only be updated)

V$system_event:total waits for an event (total wait time for events)

2. A view of disk files

V$datafile:d atafile information from the control file

V$filestat:d isplays The number of physical reads and writes done and the total number of

: Single-block and Multiblock I/Os done at file level (physical read and write and IO information is displayed at the file levels)

V$log:displays log file information from the control file

V$log_history:log information from the control file

V$dbfile:all datafiles making up the database

V$tempfile:tempfile Information

V$tempstat:file read/write Statistics (file read and write statistics)

V$segment_statistics:segment-level Statistics

View of the 3.contention competition

V$lock:lists the locks currently held by the Oracle database and outstanding requests for

: a lock or latch (lock in use and excessive request to lock)

V$rollname:lists the names of all online rollback segments (information on online rollback segments)

V$rollstat:contains rollback Segment Statistics (statistics of rollback segments)

V$waitstat:block Contention Statistics (block contention statistics)

V$latch:aggregate latch statistics (the sum of the latch statistics)

View of 4.memory

V$buffer_pool_statistics:statistics about all buffer pools available for the instance

Statistics for all available cache Pools:(instance)

V$db_object_cache:database objects Thatare cached inthe library cache (objects cached in library buffers)

V$librarycache:contains statistics about library cache performance and activity

(Statistical information on performance and activity of the library buffers)

V$rowcache:statistics for data dictionary activities (data Dictionary activity Information Statistics)

V$sysstat:system Statistics

V$sgastat:d etailed information on the system global Area (SGA)

5. View of User/session

V$lock:lists the locks currently held by the Oracle database and outstanding requests for

: a lock or latch (lock in use and excessive request to lock)

V$open_cursor:list cursors that each user session currently have opened and Parsed,or cached

(The list of cursors opened by the current session)

V$process:displays information about the currently active processes (information on the active process)

V$transaction:lists the active transaction in the system (list of things that are active on the systems)

V$px_sesstat:parallel Execution (PX), contains information about the sessions running

(Parallel execution Statistics for the session being performed)

V$px_session:parallel Execution (PX), contains information about the sessions running

V$sesstat:user Session Statistics

V$session_event:on waits for an event by a session (conversation wait event)

V$sort_usage: There seems to be no in 11g.

V$sort_segment:displays information about every sort segment in given instance

Displays the information for each rollback segment given in the instance.

V$session_wait:current or last-wait for each session (current or previous wait information)

V$session

V$session_object_cache:object cache statistics for the current user session on the local

: Server (instance)

This article is from the "Xianyunyehe" blog, make sure to keep this source http://228110.blog.51cto.com/218110/1589766

Oracle Common dynamic views