Shulou(Shulou.com)06/01 Report--

-DBA-

DBA_2PC_NEIGHBORS contains information about pending transactions entering and exiting the connection.

DBA_2PC_PENDING contains information about distributed transactions waiting to be recovered.

DBA_ALL_TABLES displays descriptions of all tables (object tables and relational tables) in the database.

DBA_ANALYZE_OBJECTS lists the analysis objects.

DBA_ASSOCIATIONS lists user-defined statistics.

DBA_AUDIT_EXISTS lists the audit trail entries generated by AUDIT NOT EXISTS (no audit) and AUDIT EXISTS (existing audit).

DBA_AUDIT_OBJECT contains audit trail records for all objects in the system.

DBA_AUDIT_SESSION lists all trial tracking records for CONNECT (connected) and DISCONNECT (disconnected).

DBA_AUDIT_STATEMENT lists audit trail records for GRANT (authorization), REVOKE (cancellation), AUDIT (audit), NOAUDIT (no audit), and ALTER SYSTEM (change system) statements.

DBA_AUDIT_TRAIL lists all audit trail entries.

DBA_BLOCKERS lists all sessions in which everyone is waiting for a lock held by a session, but not themselves waiting for a lock.

DBA_CATALOG lists all database tables, views, synonyms, and sequences.

DBA_CLU_COLUMNS lists the mapping of table columns to cluster columns.

DBA_CLUSTER_HASH_EXPRESSIONS lists the hash functions for all clusters.

DBA_CLUSTERS contains descriptions of all families in the database.

DBA_COL_COMMENS lists annotations for all table and view columns.

DBA_COL_PRIVS lists all permissions granted to columns in the database.

DBA_COLL_TYPES displays all named collection types in the database, such as VARRAY (arrays), nested tables, object tables, and so on

DBA_CONS_COLUMNS contains information about accessible columns in the constraint definition

DBA_CONSTRAINTS contains constraint definitions on all tables.

DBA_CONTEXT lists information for all contextual namespaces.

DBA_DATA_FILES contains information about database files

DBA_DB_LINKS lists all database links in the database.

DBA_DDL_LOCKS lists all DDL locks held by the database, as well as all pending requests for a DDL lock.

DBA_DEPENDENCIES lists dependencies between objects. Dependencies on views created without any database links are also available.

DBA_DIM_ATTRIBUTES represents the relationship between dimensional and functionally dependent columns. The table in which the dimension column is located must match the table in which the dependent column is located.

DBA_DIM_CHILD_OF represents the hierarchical relationship of 1 between a pair of dimensional levels in a dimension.

DBA_DIM_HIERARCHIES represents a hierarchy of dimensions.

DBA_DIM_JOIN_KEY represents the join between two dimensional tables. This join is usually specified between a parent dimension column and a child column.

DBA_DIM_LEVEL_KEY represents a dimensional column. The location of the columns in a level is specified by KEY_POSITION.

DBA_DIM_LEVELS represents a dimension. All columns at a dimension level must come from the same relationship.

DBA_DIMENSIONS represents a dimensional object.

DBA_DIRECTORIES provides information about all directory objects in the database.

DBA_DML_LOCKS lists all DML locks held in the database and all outstanding requests for one DML lock.

DBA_ERRORS lists the current errors for all objects stored in the database.

DBA_EXP_FILES contains a description of the exported file.

DBA_EXP_OBJECTS lists objects that are exported incrementally.

DBA_EXP_VERSION contains the version number of the last exported session.

DBA_EXTENTS lists the areas in the database that make up all segments.

DBA_FREE_SPACE lists the free partitions in all tablespaces.

DBA_FREE_SPACE_COALESCED contains statistics for merged spaces in tablespaces.

DBA_IND_COLUMNS contains descriptions of the columns that make up the index in all tables and clusters.

DBA_IND_EXPRESSIONS lists expressions of functional indexes in all tables and clusters.

DBA_IND_PARTITIONS is each index partition, describing partition-level partition information, partition storage parameters, and various partition statistics determined by ANALYZE.

DBA_IND_SUBPARTITIONS describes the partition information at the partition level, the storage parameters of the subpartition and the various partition statistics determined by the ANALYZE for each index subpartition owned by the current user.

DBA_INDEXES contains descriptions of all indexes in the database.

DBA_INDEXTYPE_OPERATORS lists all operators supported by the index type.

DBA_INDEXTYPES lists all index types.

DBA_JOBS lists all jobs in the database.

DBA_JOBS_RUNNING lists all jobs currently running in the database.

DBA_LIBRARIES lists all the libraries in the database.

The DBA_LOB_PARTITIONS displays the user-accessible LOB contained in the table.

DBA_LOB_SUBPARTITIONS displays partition-level properties in the LOB data subpartition.

DBA_LOBS displays the LOB. Exe contained in all tables.

DBA_LOCK_INTERNAL contains one line of information for each held lock or simple lock, and one line of information for each undecided request for the lock or simple lock.

DBA_LOCKS lists all locks or simple locks held in the database, and all outstanding requests for a lock or simple lock.

DBA_METHOD_PARAMS contains a description of the method parameters of the type in the database.

DBA_METHOD_RESULTS contains descriptions of the results of all types of methods in the database.

DBA_MVIEW_AGGREGATES represents the grouping function (aggregation method) that appears in the SELECT list of aggregated instantiated views.

DBA_MVIEW_ANALYSIS represents an instantiated view that potentially supports query rewriting and has additional information that can be used for application analysis. This view includes any instantiated view that references a remote table or includes non-static values such as SYSDATE or USER.

DBA_MVIEW_DETAIL_RELATIONS stands for named detail relationships, which are either referenced in an instantiated view's FROM list or directly through a view in the FORM list. In this table, the embedded view in the instantiated view is not represented.

DBA_MVIEW_JOINS represents the join between two columns in the WHERE clause of an instantiated view.

DBA_MVIEW_KEYS stands for named detail relationships, which are either referenced in an instantiated view's FROM list or directly through a view in the FORM list. In this table, the embedded view in the instantiated view is not represented.

DBA_NESTED_TABLES displays descriptions of the nested tables contained in all tables.

DBA_OBJ_AUDIT_OPTS lists the audit options for all objects owned by a user.

DBA_OBJECT_SIZE lists the size of various PL/SQL objects in bytes.

DBA_OBJECT_TABLES displays descriptions of all object tables in the database.

DBA_OBJECTS lists all the objects in the database.

DBA_OPANCILLARY lists additional information for operator connections.

DBA_OPARGUMENTS lists parameter information for operator connections.

DBA_OPBINDINGS lists operator connections.

DBA_OPERATORS lists operators.

DBA_OUTLINE_HINTS lists the set of prompts that make up the profile.

DBA_OUTLINES lists information about the profile.

DBA_PART_COL_STATISTICS contains column statistics and histogram information for all table partitions.

DBA_PART_HISTOGRAMS contains histogram data (the endpoint of each histogram) for histograms on all table partitions.

DBA_PART_INDEXES lists the object-level partition information for all partitioned indexes.

DBA_PART_KEY_COLUMNS describes the partition key columns for all partition objects.

DBA_PART_LOBS describes the table-level information of the partition LOB, including the default properties of the LOB data partition.

DBA_PART_TABLES lists the object-level partition information for all partition tables.

DBA_PARTIAL_DROP_TABS describes partially deleted tables.

DBA_PENDING_TRANSACTIONS provides information about outstanding transactions (due to a failure or no commit or rollback by the coordinator).

DBA_POLICIES lists policies.

DBA_PRIV_AUDIT_OPTS describes the current system permissions that are audited by the system and by the user.

DBA_PROFILES displays all startup files and their restrictions

DBA_QUEUE_SCHEDULES describes the current scheme for disseminating information.

DBA_QUEUE_TABLES describes the names and types of queues in all queue lists established in the database.

DBA_QUEUE describes the operational characteristics of each queue in the database.

DBA_RCHILD lists all subgroups in any refresh group.

DBA_REFRESH lists all refresh groups.

DBA_REFRESH_CHILDREN lists all objects in the refresh group.

DBA_REFS describes the REF column and REF attribute in the object type column of all tables in the database.

DBA_REGISTERED_SNAPSHOT_GROUPS lists all snapshot registration groups for the site.

DBA_REGISTERED_SNAPSHOT retrieves information about remote snapshots of the local table.

DBA_REPCAT_REFRESH_TEMPLATES is used with Advanced Replication (Advanced replication).

DBA_REPCAT_TEMPLATES_PARMS is used with Advanced Replication (Advanced replication).

DBA_REPCAT_TEMPLATES_SITES is used with Advanced Replication (Advanced replication).

DBA_REPCAT_USER_AUTHORIZATIONS is used with Advanced Replication (Advanced replication).

DBA_REPCAT_USER_PARM_VALUES is used with Advanced Replication (Advanced replication).

DBA_REPCATLOG is used with Advanced Replication (Advanced replication).

DBA_REPCOLUMN is used with Advanced Replication (Advanced replication).

DBA_REPCOLUMN_GROUP is used with Advanced Replication (Advanced replication).

DBA_REPCONFLICT is used with Advanced Replication (Advanced replication).

DBA_REPDDL is used with Advanced Replication (Advanced replication).

DBA_REPGENERATED is used with Advanced Replication (Advanced replication).

DBA_REPGENOBJECTS is used with Advanced Replication (Advanced replication).

DBA_REPGROUP is used with Advanced Replication (Advanced replication).

DBA_REPGROUPED_COLUMN is used with Advanced Replication (Advanced replication).

DBA_REPKEY_COLUMNS is used with Advanced Replication (Advanced replication).

DBA_REPOBJECT is used with Advanced Replication (Advanced replication).

DBA_REPPARAMETER_COLUMN is used with Advanced Replication (Advanced replication).

DBA_REPPRIORITY is used with Advanced Replication (Advanced replication).

DBA_REPPRIORITY_GROUP is used with Advanced Replication (Advanced replication).

DBA_REPPROP is used with Advanced Replication (Advanced replication).

DBA_REPPESOL_STATS_CONTROL is used with Advanced Replication (Advanced replication).

DBA_REPRESOLUTION is used with Advanced Replication (Advanced replication).

DBA_REPRESOLUTION_METHOD is used with Advanced Replication (Advanced replication).

DBA_REPSITES is used with Advanced Replication (Advanced replication).

DBA_RGROUP lists all refresh groups.

DBA_ROLE_PRIIVS lists the roles granted to users and roles

DBA_ROLES lists all roles that exist in the database

DBA_ROLLBACK_SEGS contains a description of the rollback segment

DBA_RSRC_CONSUMER_GROUP_PRIVS lists all authorized resource consumption groups, users, and roles.

DBA_RSRC_CONSUMER_GROUPS lists all resource consumption groups that exist in the database.

DBA_RSRC_MANAGER_SYSTEM_PRIVS lists all users and roles that have been granted system permissions that belong to the resource administrator.

DBA_RSRC_PLAN_DIRECTIVES lists instructions for all resource plans that exist in the database.

DBA_RSRC_PLANS lists all resource plans that exist in the database.

DBA_RULESETS lists rule set information.

DBA_SEGMENTS contains storage information for all database segments at the allocation level.

DBA_SEOUENCES contains descriptions of all sequences in the database.

DBA_SNAPSHOT_LOG_FILTER_COLS lists all filter columns recorded on the snapshot log (excluding contention columns)

DBA_SNAPSHOT_LOGS lists all snapshot logs in the database.

DBA_SNAPSHOT_REFRESH_TIMES lists the number of snapshot refreshes.

DBA_SNAPSHOTS lists all snapshots in the database.

DBA_SOURCE contains the source of all stored objects in the database.

The DBA_STMT_AUDIT_OPTS contains information describing the current system audit options that pass the system and are audited by the user.

DBA_SUBPART_COL_STATISTICS lists the column statistics and histogram information for the table subpartition.

DBA_SUBPART_HISTOGRAMS lists the actual data (the endpoint of each histogram) of the histogram in the table subpartition.

DBA_SUBPART_KEY_COLUMNS lists sub-partition key columns for tables (and local indexes on the table) that are partitioned with the Composite Range (composite permutation) or HASH method.

DBA_SYNONYMS lists all synonyms in the database

DBA_SYS_PRIVS lists the system permissions granted to users and roles.

DBA_TAB_COL_STATISTICS column statistics and histogram information contained in the DBA_TAB_COLUMNS view.

DBA_ TAB_COLUMNS contains information about the description columns of all tables, views, and clusters.

DBA_TAB_COMMENTS contains comments for all tables and views in the database.

DBA_TAB_HISTOGRAMS lists the histograms of all the columns in the table.

DBA_TAB_PARTITIONS partitions each table, describing its partition-level partition information, partition storage parameters, and various partition statistics determined by ANALYZE.

DBA_TAB_PRIVS lists all the authorizations granted to objects in the database.

DBA_TAB_SUBPARTITIONS partitions the children of each table, describing its name, the name of the table, and the partition it belongs to, as well as its storage properties.

DBA_TABLES contains descriptions of all relational tables in the database.

DBA_TABLESPACES contains descriptions of all tablespaces

DBA_TEMP_FILES contains information about temporary files in the database.

DBA_TRIGGER_COLS lists the use of columns in all triggers.

DBA_TRIGGERS lists all triggers in the database.

DBA_TS_QUOTAS lists the tablespace limits for all users.

DBA_TYPE_ATTRS displays the properties of the type in the database.

DBA_TYPE_METHODS describes all types of methods in the database.

DBA_TYPES displays all the abstract data types in the database.

DBA_UNUSED_COL_TABS contains a description of all tables with unused columns.

DBA_UPDATABLE_COLUMNS contains a description of the columns that can be updated by the database administrator in a connection view.

DBA_USERS lists the information for all users in the database.

DBA_USTATS contains information about the current user.

DBA_VARRAYS lists the text of the views that the user can access.

DBA_VIEWS contains the text of all views in the database.

DBA_WAITERS lists all sessions that are waiting for a lock and lists the sessions that are preventing them from acquiring the lock.

-$

V$ACCESS displays the objects in the currently locked database and the sessions that are accessing them.

V$ACTIVE_INSTANCES establishes a mapping from the instance name to the instance number for all instances that appear in the currently installed database

V$AQ describes the statistics of the queues in the current database.

V$ARCHIVE contains the information in the redo log files required for archiving. Each line provides the information needed by a thread. This information is also available in V$LOG. Oracle recommends that you use V$LOG.

V$ARCHIVE_DEST describes all archive log destination files for the current instance and their current values, patterns, and status.

V$ARCHIVED_LOG displays archive log information in the control file, including the archive log name. After the joint redo log file is successfully archived or cleared (if the log is cleared, the name column will be NULL), an archive log record is inserted. If this log is archived twice, there will be two archived log records with the same THREAD#,SEQUENCE#,FIRST_CHANG# value, but with different names. When an archive log is restored from a backup set or a copy, an archive log record is also inserted.

V$ARCHIVE_PROCESSES provides an instance with information about the state of different ARCH processes.

V$BACKUP displays the backup status of all online data files.

V$BACKUP_ASYNC_IO displays information about the backup set from the control file. After the backup set completes successfully, a backup set record will be inserted.

V$BACKUP_CORRUPTION displays information about corruption in data file backups from the control file. Note that corruption in control files and archive log backup files cannot be tolerated

V$BACKUP_DATAFILE displays information about backup data files and backup control files from the control file.

V$BACKUP_DEVICE displays information about supporting backup devices. If a device type does not support named devices, a row with the device type and NULL device name will be returned for that device type. If a device type supports named devices, a row is returned for each available device of that type. The special device type DISK is not returned through this view because it is always available.

V$BACKUP_PIECE displays information about the backup block from the control file. Each backup set consists of one more backup block.

V$BACKUP_REDOLOG displays information about the archived logs in the backup set from the control file. Note that online redo log files cannot be backed up directly. They must first be stored on disk and then backed up. An archive log backup set can contain one or more archive logs.

V$BACKUP_SET displays information about the backup set from the control file. After the backup set completes successfully, a backup set record is inserted.

V$BACKUP_SYNC_IO displays information about the backup set from the control file. After the backup set completes successfully, a backup set record is inserted.

V$BGPROCESS describes the background process.

V$BH this is a parallel server view. This view gives the status and number of probes for each buffer in the global area of the system.

V$BUFFER_POOL displays information about all available buffer pools for this instance. This "set number" belongs to the number of LRU simple lock sets.

V$BUFFER_POOL_STATISTICS displays information about all available buffer pools for this instance. This "set number" belongs to the number of LRU simple lock sets.

V$CACHE this is a parallel server view. This view contains header information for each block in the SGA of the current instance, which is associated with a particular database object.

V$CACHE_LOCK this is a view of a parallel server. Except for different identifiers for special platform lock managers

V$CACHE_LOCK is very similar to V$CACHE. This information may be useful if this special platform lock manager provides tools for monitoring PCM lock operations that are currently taking place.

The V$CIRCUIT contains information about the virtual circuit, which is all the connections the user makes to the database through the scheduler and the server.

V$CLASS_PING shows the number of blocks being explored in each block class. Use this view to compare different types of block competition.

V$COMPATIBILITY shows the characteristics in use of the database instance, which may prevent system performance from degrading to previous versions. This is a SGA version of this information, which cannot reflect the characteristics of some other instances used and may contain temporary incompatibilities (such as UNDO segments), but this will no longer exist after the database is completely shut down.

V$COMPATSEG lists permanent features in use in the database that will prevent the database from going back to earlier versions.

V$CONTEXT lists the settings properties for the current conversation.

V$CONTROLFILE lists the name of the control file.

V$CONTROLFILE_RECORD_SECTION displays information about the recording section of the control file.

V$COPY_CORRUPTION displays information about controlling the corruption of the copy of the data file in the file.

V$DATABASE contains database information in the control file.

V$DATAFILE contains information about the database files in the control file.

V$DATAFILE_COPY displays information about the copy of the data file in the control file.

V$DATAFILE_HEADER displays the data file information of the data file header.

V$DBFILE lists all the data files in the constituent database. This view is reserved for historical compatibility, and we recommend using V$DATAFILE instead.

V$DBLINK describes all database links opened by a session that publishes queries to V$DBLINK (using IN_TRANSACTION=YES links). These database links must be committed or rolled back before closing.

V$DB_OBJECT_CACHE displays database objects that are cached in the library cache. These objects include tables, indexes, clusters, synonym definitions, PL/SQL procedures and packages, and triggers.

V$DB_PIPES displays the pipes in the current database.

V$DELETED_OBJECT displays information about deleted archive logs, copies of data files, and backup blocks in the control file. The sole purpose of this view is to optimize the resynchronization operation of the recovery directory. When an archive log, a copy of a data file, or a backup block is deleted, the corresponding record is marked for deletion.

V$DISPATCHER provides information about the scheduling process.

V $DISPATCHER_RATE provides rate statistics for scheduling processes.

V$DLM_ALL_LOCKS this is a parallel server view. V$DLM_ALL_LOCKS lists all current lock information, which is known by the lock manager to block or block other objects.

V$DLM_CONVERT_LOCAL displays the time consumed by the local lock conversion operation.

V$DLM_CONVERT_REMOTE shows the time consumed by the remote lock conversion operation.

V$DLM_LOCKS this is a parallel server view. V$DLM_ALL_LOCKS lists all current lock information, which is known by the lock manager to block or block other objects.

V$DLM_MISC displays multiple DLM statistics.

V$DLM_RESS this is a view of a parallel server that displays information about all resources known to the current lock manager.

V$ENABLEDPRIVS displays the permissions granted. These permissions can be found in the SYS.SYSTEM_PRIVILEGES_MAP table.

V$ENQUEUE_LOCK displays all the locks owned by the queued state object. The columns in this view are equivalent to the columns in V$LOCK. For more information, see V$LOCK.

V$EVENT_NAME contains information about waiting events.

V$EXECUTION displays information in parallel execution.

V$FALSE_PING this is a parallel server view. This view shows buffers that may have failed to probe, probing buffers protected by the same lock more than 10 times, such as another buffer that has probed more than 10 times. Buffers identified as obtaining probe failure information can be remapped to the GC_FILES_TO_LOCKS to reduce lock conflicts.

V$FAST_START_SERVERS provides information about all dependent recovery operations that perform parallel transactional recoveries.

V$FAST_START_TRANSACTIONS contains information about the progress of transactions in Oracle recovery.

V$FILE_PING shows the number of blocks probed for each data file. In turn, this information can be used to determine how to access an existing data file, as well as a new mapping from data file blocks to PCM locks.

V$FILESTAT contains information about read / write statistics in the file

V$FIXED_TABLE displays all dynamic performance tables, views, and export tables in the database. Some V$ tables (such as

V$ROLLNAME) refers to the real table and is not listed.

V$FIXED_VIEW_DEFINITION contains definitions of all fixed views (views that start with V$). Care should be taken to

Use this watch. Oracle always wants to maintain the behavior of fixed views from version to version, but the definition of fixed views can be changed without notice. Use these definitions to optimize your query by using index columns in the dynamic performance table.

V$GLOBAL_BLOCKED_LOCKS shows the whole block lock.

V$GLOBAL_TRANSACTION displays information about the currently active global transaction.

V$HS_AGENT identifies the collection of HS agents currently running on a given host, each agent process represented by a line.

V$HS_SESSION identifies the set of HS sessions currently open for an Oracle server.

V$INDEXED_FIXED_COLUMN displays the columns in the indexed dynamic performance table (X$ table). The X$ table can be used without

Change with notice. Using this view is only more efficient in writing queries than fixed views (V$ views).

V$INSTANCE displays the status of the current instance. This V$INSTANCE version is not compatible with earlier V$INSTANCE versions.

V$INSTANCE_RECOVERY is used to monitor the limit mechanism for performing user-specified restore reads.

V$LATCH lists statistics for non-parent easy locks, as well as total statistics for parent easy locks. That is, the statistics of each parent simple lock include the calculated value of each of its child simple locks.

V$LATCHHOLDER contains information about the current holder of the easy lock.

The V$LATCHNAME contains information about the decoded simple lock name displayed in the V$LATCH.

There is an one-to-one correspondence between rows in V$LATCHNAME and rows in V$LATCH.

V$LATCH_CHILDREN contains statistics about child ease of locking. This view includes all the columns in the V$LATCH and a CHILD# column. Note that if the child simple lock LATCH# columns match, then they will have the same parents.

V$LATCH_MISSES contains statistics for failed attempts to obtain a simple lock.

V$LATCH_PARENT contains statistics about parents' simple locks. Columns in V$LATCH_PARENT are equal to columns in V$LATCH.

V$LIBRARYCACHE contains statistics about cache performance and activity.

V$LICENSE contains information about license restrictions.

V$LOADCSTAT contains SQL*Loader statistics compiled during a direct load execution. These statistics apply to the entire load. Since loading data and querying cannot be done at the same time, any SELECT operation on this table will result in "no rows retured" (no row returns)

V$LOADTSTAT contains SQL*Loader statistics compiled during a direct load execution. These statistics apply to the current table. Since loading data and querying cannot be done at the same time, any SELECT operation on this table will result in "no rows retured" (no row returns)

V$LOCK lists the locks currently held by the ORACLE server and pending requests for a lock or simple lock.

V$LOCK_ACTIVITY this is a parallel server view. It shows the DLM lock operation activity of the current instance, with each row corresponding to the type of lock operation.

V$LOCK_ELEMENT this is a parallel server view. Each PCM lock used by the buffered cache is locked in the

There is an entry in V$LOCK_ELEMENT. The name of the PCM lock corresponding to a lock element is ('BL',indx,class).

V$LOCKED_OBJECT lists all the locks acquired by each transaction in this system.

V$LOCKS_WITH_COLLISIONS this is a parallel server view. Use this view to find locks that protect multi-lock buffers, each of which is forced to read or write at least ten times. Those buffers that are experiencing probe failures are mainly due to being mapped to the same lock.

V$LOG contains log file information in the control file.

V$LOGFILE contains information about redo log files.

V$LOGHIST contains log history information in the control file. This view is reserved for historical compatibility. It is recommended that V$LOG_HISTORY be used instead.

V$LOGMNR_CONTENTS contains log history information.

V$LOGMNR_DICTIONARY contains log history information.

V$LOGMNR_LOGS contains log information.

V$LOGMNR_PARAMETERS contains log information.

V$LOG_HISTORY contains log history information in the control file.

V$MLS_PARAMETERS this is an ORACLE delegate server (Trusted Oracle Server) view that lists the initialization parameters of the delegate server specified by ORACLE. More information can be found in your ORACLE delegation file.

V$MTS contains information about the server that adjusts multithreading.

V$MYSTAT contains statistics for the current session.

V$NLS_PARAMETERS contains the value of the current NLS parameter.

V$NLS_VALID_VALUES lists all valid information for the NLS parameter.

V$OBJECT_DEPENDENCY can decide which object to depend on based on the package, procedure, or cursor currently installed in the shared pool. For example, along with V$SESSIONV and $SQL, it can be used to determine which table is being executed by the user in the SQL statement. For more information, see V$SESSION and V$SQL

V$OBSOLETE_PARAMETER lists stale parameters. As long as there is a value of TRUE, you should check why.

V$OFFLINE_CURSOR displays offline information for data files in control files.

V$OPEN_CURSOR lists the currently open and resolved cursors for each user session.

V$OPTION lists the options for installing with an ORACLE server.

V$PARALLEL_DEGREE_LIMIT_MTH shows all effective ways to limit resource allocation by parallelism.

V$PARAMETER lists information about initialization parameters.

V$PING this is a parallel server view. Except that showing blocks that have been probed at least once is different, the V$PING view is exactly the same as the V$CACHE view, which contains block header information for each block in the SGA of the current instance, which is associated with a specific database object.

V$PQ_SESSTAT lists statistics for parallel query sessions. Note: this view will be used in future releases.

V$PQ_SLAVE lists the statistics of the parallel execution server for each activity on an instance. Note: this view will become obsolete in future releases and will be replaced by a new view called V$PX_PROCESS.

V$PQ_SYSSTAT lists the system statistics for parallel queries. Note: this view will become obsolete in future releases and will be replaced by a new view called V$PX_PROCESS_SYSSTAT.

V$PQ_TQSTAT contains statistics on parallel execution operations. These statistics are edited after the query is completed and are maintained only during the session. It shows the number of rows processed by each parallel running server at each stage of the execution tree. This view can help determine imbalances in a query execution. Note: this view will be called the V$PX_TQSTAT view in a future release.

V$PROCESS contains information about the currently active process. When the LATCHWAIT column shows what easy lock a process is waiting for, the LATCHSPIN column shows what kind of easy lock a process is running around. On multiprocessor machines, the ORACLE process runs around it before waiting for a simple lock.

V$PROXY_ARCHIVEDLOG contains descriptions of archive log backup files with a new feature called Proxy copies. Each line represents backup information for an archive log.

V$PROXY_DATAFILE contains a description of the backup of data files and control files with a new feature called Proxy copy. Each line represents the backup information of a database file.

V$PWFILE_USERS lists the users who are granted SYSDBA and SYSOPER permissions as if they were derived from a password file.

V$PX_PROCESS contains information about sessions that are running parallel operations.

V$PX_PROCESS_SYSSTAT contains information about sessions that are running parallel operations.

V$PX_SESSION contains information about sessions that are running parallel operations.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.