Oracle System View

Source: Internet
Author: User
Tags dba file copy log log session id rollback

Summarize Oracle system views and table Daquan:

Dba_ opening .....

Dba_users Database user Information

Dba_segments Table Segment Information

Dba_extents Data Area Information

Dba_objects Database object Information

Dba_tablespaces database table Space information

Dba_data_files Data File setup Information

Dba_temp_files Temporary data file information

Dba_rollback_segs Rollback Segment Information

Dba_ts_quotas User table Space quota information

Dba_free_space Database Free Space information

Dba_profiles Database User Resource limit information

Dba_sys_privs User's system permissions information

Dba_tab_privs the object permission information that the user has

DBA_COL_PRIVS user has Column object permission information

Dba_role_privs The role information that the user has

Dba_audit_trail Audit trail Record information

Dba_stmt_audit_opts Audit Setup Information

Dba_audit_object Object Audit Results information

Dba_audit_session Session Audit Results Information

Dba_indexes index information for user mode

User_ Opening

User_objects User Object Information

User_source all resource object information for a database user

User_segments User's Table segment information

User_tables User's Table object information

User_tab_columns User's Table column information

User_constraints object constraint information for a user

User_sys_privs System permissions information for the current user

User_tab_privs Object permission information for the current user

User_col_privs table column permission information for the current user

User_role_privs role permission information for the current user

User_indexes User's index information

Table column information for the User_ind_columns user's index

Table column information for the USER_CONS_COLUMNS user's constraints

User_clusters all cluster information for the user

User_clu_columns The content information contained in the user's cluster

User_cluster_hash_expressions Hash Cluster information

v$ Opening

V$database Database Information

V$datafile Data File Information

V$controlfile Control File Information

V$logfile Redo Log Information

V$instance DB Instance Information

V$log Log Group Information

V$loghist Log History information

V$SGA Database SGA Information

V$parameter Initialization of parameter information

V$process Database Server process information

V$bgprocess Database Background Process information

V$controlfile_record_section the information of each part of the control file

V$thread Thread Information

V$datafile_header information in the header of the data file

V$archived_log Archive Log Information

V$archive_dest setting information for archived logs

v$logmnr_contents DML DDL result information for archived log analysis

V$logmnr_dictionary dictionary file information for log analysis

V$logmnr_logs log list information for log analysis

V$tablespace Table Space Information

V$tempfile Temporary file information

I/O statistics for v$filestat data files

V$undostat Undo Data Information

V$rollname Online rollback segment Information

V$session Session Information

V$transaction Transaction information

V$rollstat Rollback Segment Statistics

V$pwfile_users Privileged User Information

V$sqlarea Resources and related information that have been accessed by SQL statements that are currently queried

V$sql basic information about the same as V$sqlarea

V$sysstat Database System State information

All_ Opening

All_users information for all users of the database

All_objects information about all objects in the database

All_def_audit_opts All default Audit setup Information

All_tables all Table Object information

All_indexes information for all database object indexes

Session_ Opening

Role information for Session_roles sessions

Permissions information for Session_privs sessions

Index_ Opening

Index_stats setting and storing information for indexes

Pseudo table

Dual system pseudo-list information

Oracle Common Dynamic View Description:

2.1.1 V$lock

Given the lock information, such as the Type field, the user type locks has 3 kinds: tm,tx,ul,system Type locks There are many, common are: Mr,rt,xr,ts and so on. We only care about TM,TX locks.

When TM locks, the Id1 field represents object_id; when the TX lock, Trunc (Id1/power (2,16)) represents the rollback segment number.

2.1.2 V$sqlarea

The SQL stored in the shared pool and some related information, such as the cumulative number of executions (executions), logical reads (buffer_gets), physical reads (disk_reads), and other statistical information.

You can locate a SQL based on address and hash_value. Sql_text Word Gencun The first 1000 characters of this SQL. Finding the entire SQL also needs to go to V$sqltext or v$sqltext_with_newlines.

2.1.3 V$session

V$session is the basic information view that is used to find the user SID or Saddr. However, it also has some columns that change dynamically and can be used to check the user.

2.1.4 V$sesstat

The session ID can be used to get the statistics

2.1.6 v$process

The V$process view contains all the process information that the current system Oracle runs. is often used to establish a connection between the operating system process ID of an Oracle or service process and the database session.

2.1.7 V$transaction

Depending on the session ID, you can find the transaction information that is executing at the current session:

SELECT * from V$transaction where addr in (select Taddr from v$session where Sid=&sid);

2.1.8 V$sort_usage

Temp table space usage, when the temp table space becomes huge, according to SESSION_ADDR can get session ID, according to SQLADDR and Sqlhash can get the SQL that is executing:

2.1.9 V$sysstat

Statistical information for all instance

2.1.10 V$sqltext View

The V$sqltext view includes the full text of the SQL statement in the shared pool, and an SQL statement may be divided into multiple blocks to be saved in multiple records.

2.1.11 v$session_wait View

This is a critical view of looking for performance bottlenecks. It provides any case where the session is currently waiting in the database (if the session is currently not doing anything, it shows its last wait event). When there is a performance problem with the system, this view can be used as a starting point to indicate the direction in which the problem is explored.

In v$session_wait, each SESSION connected to the instance corresponds to a record.

2.1.12 Overview

and permissions, the role-related views are probably the following:

Dba_sys_privs: Querying system permissions owned by a user

User_sys_privs: System permissions owned by the current user

Session_privs: All permissions owned by the current user

Role_sys_privs: System permissions owned by a role

Note: To query this view with SYS user login, otherwise return NULL.

Role_role_privs: Role assigned to the current role

Session_roles: The role that the current user is activating

User_role_privs: The role that the current user is granted

There is also a view of access rights for tables:

Table_privileges

All_tab_privs

Role_tab_privs: Permissions on related tables that a role is given

2.2.4 Examples

1. Querying permissions owned by the current user

Select * from Session_privs;

2. Query the system permissions that a user has been given.

There are many ways to

Select * from User_sys_privs;

Or: SELECT * from Dba_sys_privs where grantee= ' XXX '

(requires current user to have DBA role)

3. Query the role that the current user is granted:

1). Select * from Session_roles ORDER by ROLE

Description: This query returns all roles that the current user has been granted, including nested authorization roles. For example, a DBA role is granted to a user, and the roles that the DBA role has been granted (for example, Exp_full_database and imp_full_database) are also queried.

2). Select * from User_role_privs

4. Querying the system permissions assigned to a role

Select Privilege from Role_sys_privs where role=&role

5. Query the role that the current role is granted

Select granted_role from Role_role_privs where role=&role

Description: Plustrace This role is used to execute SQL AUTO trace, which can be generated by executing $oracle_home/sqlplus/admin/plustrce.sql

-----------DBA----------------
The dba_2pc_neighbors contains pending transactions entering the connection and exiting the connection information.
The dba_2pc_pending contains information about the distributed transaction awaiting recovery.
Dba_all_tables displays a description 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 listed by AUDIT not EXISTS (non-existent audit) and AUDIT EXISTS (existence
Audit trail entries generated by the
Dba_audit_object contains audit trail records for all objects in the system.
Dba_audit_session Lists all interrogation tracking records for connect (connect) and disconnect (disconnected).
Dba_audit_statement lists audit trail records for Grant (authorization), REVOKE (cancel), audit(Audit), Noaudit (non-audited), and alter system statements.
Dba_audit_trail Lists all the audit trail entries.
Dba_blockers lists all sessions where everyone waits 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 mappings for the table columns to the cluster columns.
Dba_cluster_hash_expressions lists hash (hash) functions for all clusters.
Dba_clusters contains a description of all the 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 information that is included in the constraint definition for accessible columns
The dba_constraints contains the constraint definitions on all tables.
Dba_context lists information for all context namespaces.
Dba_data_files contains information about a database file
Dba_db_links Lists all database links in the database.
Dba_ddl_locks Lists all DDL locks held by the database, and any pending requests for a DDL lock.
Dba_dependencies lists the dependencies between objects. Dependencies on views that are created when there are no database links are also available.
Dba_dim_attributes represents the relationship between a dimension and a column that is functionally dependent. The table in which the dimension column resides must match the table where the dependent column resides.
Dba_dim_child_of represents a hierarchical relationship of 1:n between a pair of dimensions in a dimension.
Dba_dim_hierarchies represents a hierarchy of dimensions.
Dba_dim_join_key represents a connection between two dimension tables. This connection is typically specified between a parent dimension column and a child column.
Dba_dim_level_key represents a column of a dimension. The position of a column in a level is specified by Key_position.
Dba_dim_levels represents a dimension. All columns of a dimension must come from the same relationship.
Dba_dimensions represents a Dimension 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 pending requests to a DML lock.
Dba_errors lists the current errors for all stored objects in the database.
Dba_exp_files contains a description of the export file.
Dba_exp_objects lists the objects that are exported in an incremental manner.
Dba_exp_version contains the version number of the last export session.
Dba_extents lists the extents in the database that make up all the segments.
Dba_free_space lists the free partitions in all table spaces.
The dba_free_space_coalesced contains the statistics for the merged space in the table space.
Dba_ind_columns contains a description of the columns that make up the index in all tables and clusters.
Dba_ind_expressions lists the expressions for functional indexes in all tables and clusters.
Dba_ind_partitions for each index partition, describes partition-level partition information, storage parameters for partitions, and various partition statistics determined by analyze.
Dba_ind_subpartitions for each index sub-partition owned by the current user, it describes the partition information at the partition level, the storage parameters of the sub-partitions, and the various partition statistics determined by the analyze.
Dba_indexes contains a description of all the indexes in the database.
Dba_indextype_operators lists all the operators supported by the index type.
Dba_indextypes Lists all the 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.
Dba_lob_partitions Displays the LOB that is accessible to users who are included in the table.
Dba_lob_subpartitions displays the partition-level attributes in the LOB data sub-partition.
Dba_lobs Displays the lob that is contained in all tables.
The dba_lock_internal contains a single row of information for each held lock or simple lock, and one row of information for each non-determined request for a lock or simple lock.
Dba_locks lists all the locks or simple locks held in the database, and any pending 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 a description of the method results for all types in the database.
Dba_mview_aggregates represents the Grouping function (aggregation method) that appears in the select list of clustered materialized views.
Dba_mview_analysis represents a potentially supported query rewrite and has a materialized view of additional information that can be used for application profiling. This view includes any materialized views that reference remote tables or include non-static values such as Sysdate or user.
Dba_mview_detail_relations represent the naming of detail relationships, either in the From list of a materialized view or directly from a view in the form list. In this table, no inline views are represented in the materialized view.
Dba_mview_joins represents a connection between two columns in the WHERE clause of a materialized view.
Dba_mview_keys represent the naming of detail relationships, either in the From list of a materialized view or directly from a view in the form list. In this table, no inline views are represented in the materialized view.
Dba_nested_tables displays a description of the nested tables contained in all tables.
Dba_obj_audit_opts lists auditing options for all objects owned by a user.
Dba_object_size lists the size of the number of bytes in the various PL/SQL objects.
Dba_object_tables displays a description of all object tables in the database.
Dba_objects lists all objects in the database.
Dba_opancillary lists additional information for operator connections.
Dba_oparguments lists the parameter information for the operator connection.
Dba_opbindings lists operator connections.
Dba_operators lists the operators.
Dba_outline_hints lists the set of hints 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.
The dba_part_histograms contains histogram data for histograms on all table partitions (the endpoints of each histogram).
Dba_part_indexes lists the object-level partitioning information for all partitioned indexes.
Dba_part_key_columns describes the partition key column for all partition objects.
Dba_part_lobs describes the table-level information for a partitioned lob, including the default nature of the LOB data partition.
Dba_part_tables lists the object-level partitioning information for all partitioned tables.
Dba_partial_drop_tabs describes a partially deleted table.
Dba_pending_transactions provides information about incomplete transactions (because of a failure or the coordinator has not committed or rolled back).
Dba_policies lists the policies.
Dba_priv_audit_opts describes the current system permissions that are audited by the system and by the user.
Dba_profiles Show all startup files and their restrictions
Dba_queue_schedules describes the current scenario for propagating information.
Dba_queue_tables describes the names and types of queues in all queue tables that are established in the database.
Dba_queue describes the operational characteristics of each queue in the database.
Dba_rchild lists any child groups in the 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 a remote snapshot of a local table.
Dba_repcat_refresh_templates is used with advanced Replication (Premium replication).
Dba_repcat_templates_parms is used with advanced Replication (Premium replication).
Dba_repcat_templates_sites is used with advanced Replication (Premium replication).
Dba_repcat_user_authorizations is used with advanced Replication (Premium replication).
Dba_repcat_user_parm_values is used with advanced Replication (Premium replication).
Dba_repcatlog is used with advanced Replication (Premium replication).
Dba_repcolumn is used with advanced Replication (Premium replication).
Dba_repcolumn_group is used with advanced Replication (Premium replication).
Dba_repconflict is used with advanced Replication (Premium replication).
DBA_REPDDL is used with advanced Replication (Premium replication).
Dba_repgenerated is used with advanced Replication (Premium replication).
Dba_repgenobjects is used with advanced Replication (Premium replication).
Dba_repgroup is used with advanced Replication (Premium replication).
Dba_repgrouped_column is used with advanced Replication (Premium replication).
Dba_repkey_columns is used with advanced Replication (Premium replication).
Dba_repobject is used with advanced Replication (Premium replication).
Dba_repparameter_column is used with advanced Replication (Premium replication).
Dba_reppriority is used with advanced Replication (Premium replication).
Dba_reppriority_group is used with advanced Replication (Premium replication).
Dba_repprop is used with advanced Replication (Premium replication).
Dba_reppesol_stats_control is used with advanced Replication (Premium replication).
Dba_represolution is used with advanced Replication (Premium replication).
Dba_represolution_method is used with advanced Replication (Premium replication).
Dba_repsites is used with advanced Replication (Premium replication).
Dba_rgroup lists all refresh groups.
Dba_role_priivs list the roles that are granted to users and roles
Dba_roles list 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 the resource consumption groups that exist in the database.
Dba_rsrc_manager_system_privs lists all users who have been granted permissions to the resource administrator system
and roles.
Dba_rsrc_plan_directives lists the 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 a description of all the sequences in the database.
Dba_snapshot_log_filter_cols lists all filtered columns recorded on the snapshot log (excluding PK columns)
Dba_snapshot_logs lists all the snapshot logs in the database.
Dba_snapshot_refresh_times lists the number of snapshot refreshes.
Dba_snapshots lists all the snapshots in the database.
Dba_source contains the source of all the storage objects in the database.
Dba_stmt_audit_opts contains the following information: Describes the system and the user audit of the current
System audit options.
Dba_subpart_col_statistics lists column statistics and histogram information for table sub-partitions.
Dba_subpart_histograms lists the actual data for the histogram in the table sub-partition (the endpoint of each of the histograms).
Dba_subpart_key_columns list partition with composite Range (compound arrangement) or hash method
The sub-partition key column for the table (and the local index on the table).
Dba_synonyms list all synonyms in the database
DBA_SYS_PRIVS lists the system permissions granted to users and roles.
Dba_tab_col_statistics contains column statistics and histogram information in the Dba_tab_columns view.
Dba_ Tab_columns contains information about all tables, views, and the description columns of the cluster.
Dba_tab_comments contains annotations to all tables and views in the database.
Dba_tab_histograms lists the histograms for the columns in all tables.
dba_tab_partitions partitions Each table, describes its partition-level partition information, the partition's storage parameters, and the
Various zonal statistics determined by ANALYZE.
Dba_tab_privs lists the authorizations for all objects granted in the database.
Dba_tab_subpartitions a sub-partition of each table, describing its name, the name of the table, and the partition it belongs to.
and its storage properties.
Dba_tables contains a description of all the relational tables in the database.
Dba_tablespaces contains a description of all table spaces
Dba_temp_files contains information about the database temp file.
Dba_trigger_cols lists the usage of the columns in all triggers.
Dba_triggers lists all the triggers in the database.
Dba_ts_quotas lists the tablespace quotas 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 that have 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 information for all users in the database.
Dba_ustats contains information about the current user.
Dba_varrays lists the text of the view that the user can access.
Dba_views contains text for all views in the database.
Dba_waiters lists all the 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 session in which they are being accessed.
V$active_instances for all instances that appear in the currently installed database, from the instance name to the instance number
Mapping
V$aq describes the statistics of queues in the current database.
V$archive contains the information in the Redo log files required for archiving. Each row provides the information required for a thread. This information is also available in the V$log. Oracle recommends that you use V$log.
V$archive_dest describes all archived log destination files for the current instance and their current values, patterns, and states.
V$archived_log Displays the archive log information in the control file, including the archive log name. After the redo log file is successfully archived or purged (if the log is cleared, the name column will be null), an archive log record is inserted. If this log is archived two times, then there will be two archived log records with the same thread#,sequence#,first_chang# value, but their names are different. When an archive log is recovered from a backup set or a replica, an archive log record is also inserted.
V$archive_processes provides information about the status of different arch processes for an instance.
V$backup Displays the backup status of all online data files.
V$BACKUP_ASYNC_IO Displays the backup set information from the control file. After this backup set has been successfully completed, a
The backup set record is inserted.
V$backup_corruption displays information about the corruption in the data file backup from the control file. Note in the control
File and archive log backup files are not tolerated.
V$backup_datafile displays information about the backup data file and the backup control file from the control file.
V$backup_device displays information about support for backup devices. If a device type does not support a named device, a line with the device type and a null device name will be returned for this device type. If a device type supports a named device, a row is returned for each of the available devices of this type. 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 a more than one backup block group
Yes.
V$backup_redolog displays information about the archive log in the backup set from the control file. Note the redo date of the online
Log files cannot be backed up directly. They must first be stored on disk and then
Backup. An archive log backup set can contain one or more archived logs.
V$backup_set Displays the backup set information from the control file. After the backup set completes successfully, a backup set record is inserted.
V$BACKUP_SYNC_IO Displays the backup set information from the control file. After the backup set completes successfully, a backup
The set record will be inserted.
V$bgprocess describes the background process.
V$bh This is a parallel server view. This view gives the state and number of probes for each buffer in the system global zone.
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 "number of sets"
is 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. In addition to the special Platform lock manager identifiers,
V$cache_lock is very similar to V$cache. This information may be useful if the special Platform Lock manager provides a tool for monitoring the PCM lock operations that are currently occurring.
The v$circuit contains information about virtual circuits, which are all connections to the database by the user through the scheduler and the server.
V$class_ping shows the number of probed blocks in each block class. Use this view to compare block competitions for different classes.
V$compatibility shows the characteristics in use of a DB instance and may prevent system performance from dropping to a previous version. This is a dynamic (SGA) version of this information, it is not possible to reflect the characteristics of other instances used, and may contain temporary incompatibilities (such as undo segments), but this will not exist until the database is completely shut down.
V$COMPATSEG lists the persistent features in database usage that will prevent the database from going back to the earlier version.
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 control file Records section.
V$copy_corruption displays information about the corruption of the data file copy in the control file.
V$database contains the database information in the control file.
V$datafile contains information about the database files in the control file.
V$datafile_copy displays information about a copy of a data file in a control file.
V$datafile_header displays data file information for the header of the data file.
V$dbfile lists all the data files that comprise the database. This view is reserved for historical compatibility, and we recommend using V$datafile instead.
V$dblink describes all the database links that are opened by a session that publishes a query to the V$dblink.
In_transaction=yes link). These database links must be committed or rolled back before they are closed.
V$db_object_cache Displays the 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 pipelines in the current database.
V$deleted_object displays information about the deleted archive log, data file copy, and backup block in the control file. This
The only purpose of the 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 flagged for deletion.
V$dispatcher provides information about the scheduling process.
v$ Dispatcher_rate provides rate statistics for the scheduling process.
V$dlm_all_locks This is a parallel server view. V$dlm_all_locks lists information about all current locks, which are known to lock managers for blocking or blocking other objects ' lock information.
V$dlm_convert_local shows the time spent by the local lock conversion operation.
V$dlm_convert_remote displays the time that is consumed by the remote lock conversion operation.
V$dlm_locks This is a parallel server view. V$dlm_all_locks lists information about all current locks, which are known to lock managers for blocking or blocking other objects ' lock information.
V$DLM_MISC displays a variety of 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 that are granted. These permissions can be found in the Sys.system_privileges_map table.
V$enqueue_lock Displays all locks owned by the queued state object. The columns in this view are equivalent to V$lock
Columns in the. See V$lock for more information.
The v$event_name contains information about the wait event.
V$execution displays information in parallel execution.
V$false_ping This is a parallel server view. This view shows a buffer that could have failed the probe, probing more than 10 times the buffer protected by the same lock, such as a buffer more than 10 times as another probe. Buffers that are identified as obtaining profiling failure information can be remapped to gc_files_to_locks to reduce lock collisions.
V$fast_start_servers provides information about all dependent recovery operations that perform parallel transaction recovery.
V$fast_start_transactions contains information about the progress of transactions in Oracle recovery.
V$file_ping shows the number of blocks that are probed for each data file. In turn, this information can be used to determine the access to an existing data file, as well as to determine the new mapping from the data file block to the PCM lock.
V$filestat contains file information about read/write statistics
V$fixed_table displays all dynamic performance tables, views, and export tables in the database. Some v$ tables, such as
V$rollname) involves a real table, not being listed.
V$fixed_view_definition contains the definition of all fixed views (views beginning with v$). Care should be taken to make
Use this table. Oracle always wants to keep a fixed view from version to version, but the definition of a fixed view can change without notice. Use these definitions to refine your query by using indexed columns in the dynamic performance table.
V$global_blocked_locks Displays the global block lock.
V$global_transaction displays information for the currently active global transaction.
The V$hs_agent identifies a collection of HS agents that are currently running on a given host, with each agent process represented by a single line.
V$hs_session identifies the HS session set that is currently open for an Oracle server.
V$indexed_fixed_column shows the columns in the dynamic performance table that is indexed (x$ table), the x$ table can be
Change in case of notification. Using this view is more efficient than a fixed view (v$ view) for writing queries only.
V$instance Displays the status of the current instance. This v$instance version is incompatible with earlier versions of V$instance.
The v$instance_recovery is used to monitor the throttling mechanism for performing user-specified recovery reads.
V$latch lists statistical tables for non-parental simple locks, as well as total statistics for both parents. That is, the statistics for each parent's simple lock include the calculated value of each of its simple locks.
The V$latchholder contains information about the current simple lock holder.
The v$latchname contains information about the easy-to-unlock name of the simple lock displayed in the V$latch.
The rows in the V$latchname have a corresponding relationship with the rows in the V$latch. One by one.
The V$latch_children contains statistics about the child's simple lock. This view includes all the columns in the V$latch
A child# column. Note If the child simple lock latch# column matches, then they will have the same parent.
The v$latch_misses contains statistics that attempt to obtain a simple lock failure.
V$latch_parent contains statistics on the simple locking of parents. The columns in the v$latch_parent are equal to the columns in the V$latch.
The V$librarycache contains statistics about cache performance and activity.
V$license contains information about the license restrictions.
The v$loadcstat contains the Sql*loader statistics compiled during a direct load execution. These statistics apply to the entire load. Since loading data and queries cannot occur at the same time, any select operation on the table will result in "No Rows retured" (No rows returned)
The v$loadtstat contains the Sql*loader statistics compiled during a direct load execution. These statistics apply to the current table. Since loading data and queries cannot occur at the same time, any select operation on the table will result in "No Rows retured" (No rows returned)
V$lock lists the locks held by the current Oracle server and the pending requests for a lock or a simple lock.
V$lock_activity This is a parallel server view. It shows the DLM lock operation activity for the current instance, each
A row corresponds to the type of the lock operation.
V$lock_element This is a parallel server view. Each buffered cache uses a PCM lock in the
There is an entry in the 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 that are acquired in each of the firms in the system.
V$locks_with_collisions This is a parallel server view. Use this view to find protection for multiple locks
Buffers of locks, each of which are at least mandatory to read or write up to more than 10 times. Those that are experiencing the failure of probing are mainly due to being mapped to the same lock.
V$log contains the log file information in the control file.
V$logfile contains information about the redo log file.
V$loghist contains the log history information in the control file. This view is reserved for historical compatibility. It is recommended to use V$log_history 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 the log history information in the control file.
V$mls_parameters This is a view of the Oracle Delegation server (Trusted Oracle server), which lists the initialization parameters of the Oracle-specified delegation server. More information can be found in your Oracle delegation file.
The V$MTS contains information about the server that regulates multithreading.
V$mystat contains the 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 is able to rely on a package, procedure, or cursor currently installed in a shared pool to determine
An object. For example, together 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 the stale parameters. As long as there is a value of true, you should check why
You.
V$offline_cursor Displays the offline information for the data files in the control file.
V$open_cursor lists the currently open and resolved cursors for each user session.
V$option lists the options installed with the Oracle server.
V$PARALLEL_DEGREE_LIMIT_MTH shows all the effective methods of parallelism limiting resource allocation.
V$parameter lists information about the initialization parameters.
V$ping This is a parallel server view. In addition to displaying only the blocks that have been probed at least once, the v$ping view is exactly the same as the V$cache view, which contains the block header information for each piece in the SGA of the current instance, which is associated with a particular database object.
V$pq_sesstat lists statistics for parallel query sessions. Note: This view will be over in future releases.
V$pq_slave lists the statistics for each activity that executes the server concurrently on an instance. Note: This view will be obsolete in future releases and replaced by a new view called V$px_process.
V$pq_sysstat lists the system statistics for parallel queries. Note: This view will be obsolete in future releases and replaced by a new view called V$px_process_sysstat.
The v$pq_tqstat contains statistics on parallel execution operations. These statistics are edited after the query is completed and remain only for the duration of the session. It shows the number of rows processed by each parallel running server in each stage of the execution tree. This view helps to determine the imbalance in a query execution. Note: This view will be called a V$px_tqstat view in a future release.
V$process contains information about the currently active process. When the latchwait column shows what kind of simple lock a process is waiting for, the Latchspin column shows what simple lock a process is running around. On multiprocessor machines, the Oracle process runs around it before waiting for a simple lock.
The v$proxy_archivedlog contains descriptive information for the archived log backup files with a name
is a new feature of the proxy copy. Each row represents the backup information for an archived log.
The v$proxy_datafile contains descriptive information about the data file and the control file backup, which brings up a file called
is a new feature of the proxy copy. Each row represents the backup information for a database file.
V$pwfile_users lists the users who have been granted Sysdba and Sysoper permissions as if they were from
Derived from the password file.
The v$px_process contains information about the session that is running parallel operations.
The v$px_process_sysstat contains information about the session that is running parallel operations.
The v$px_session contains information about the session that is running parallel operations.

Oracle System View

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.