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

The beginning of v$

V$database database information

V$datafile data file information

V$controlfile control file information

V$logfile redo log information

V$instance database instance information

V$log log group information

V$loghist log history information

V$sga database SGA information

V$parameter initialization parameter information

V$process database server process information

V$bgprocess database background process information

V$controlfile_record_section controls the information recorded in each part of the file

V$thread thread information

Information recorded in the header of the v$datafile_header data file

V$archived_log archive log information

Setting information of v$archive_dest archive log

DML DDL result information of v$logmnr_contents archive log analysis

Dictionary file information for v$logmnr_dictionary log analysis

Log list information for v$logmnr_logs log analysis

V$tablespace tablespace information

V$tempfile temporary file information

IUnip 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

Resources and related information accessed by sql statements currently queried by v$sqlarea

V$sql and v$sqlarea have basically the same relevant information.

V$sysstat database system status information

The beginning of all_

Information of all users in the all_users database

Information about all objects in the all_objects database

All default audit settings information for all_def_audit_opts

All the table object information of all_tables

Information about all database object indexes in all_indexes

The beginning of session_

Role information for session_roles session

Permission information for session_privs session

The beginning of index_

Setting up and storing information of index_stats index

Pseudo table

Pseudo-list information of dual system

The beginning of dba_

Dba_users database user information

Dba_segments segment information

Dba_extents datazone information

Dba_objects database object information

Dba_tablespaces database tablespace information

Dba_data_files data File Settings Information

Dba_temp_files temporary data file information

Dba_rollback_segs rollback segment information

Dba_ts_quotas user tablespace quota information

Dba_free_space database free space information

Dba_profiles database user resource limit information

System permission information of dba_sys_privs user

Object permission information for dba_tab_privs users

Column object permission information for dba_col_privs users

Role information for dba_role_privs users

Dba_audit_trail audit trail record information

Dba_stmt_audit_opts Audit Settings Information

Dba_audit_object object audit result information

Dba_audit_session session audit result information

Index information for dba_indexes user mode

The beginning of user_

User_objects user object Information

All resource object information for user_source database users

Table segment information of user_segments user

Table object information for user_tables users

Table column information for user_tab_columns users

Two other common examples involved in this are as follows:

1. Query which table a field belongs to in oracle

Sql code

Select table_name,owner from dba_tab_columns t where t.COLUMN_NAME like upper ('% username%')

2. Query the number of columns of a table in oracle

Sql code

Select count (*) from user_tab_columns where table_name= upper ('sys_operate')

Note: the function upper is used in both examples because the table name has to be capitalized here, otherwise the result is not correct.

Object constraint information for user_constraints users

System permission information of the current user of user_sys_privs

Object permission information for the current user of user_tab_privs

Table column permission information for the current user of user_col_privs

Role permission information of the current user in user_role_privs

Index information of user_indexes user

Table column information corresponding to the index of the user_ind_columns user

Table column information corresponding to the constraints of user_cons_columns users

All cluster information of user_clusters users

Content information contained in the cluster of user_clu_columns users

Information about user_cluster_hash_expressions hash clusters

The 9 most important dynamic performance views of oracle

V$session + v$session_wait (functions are integrated in 10g, make do with one.)

V$process

V$sql

V$sqltext

V$bh (rather x$bh)

V$lock

V$latch_children

V$sysstat

V$system_event

Several sets of important performance views by component

Over view of System

V$sysstat, v$system_event, v$parameter

The current situation of a session

V$process, v$session, v$session_wait, v$session_event, v$sesstat

The situation of SQL

V$sql, v$sqlarea, v$SQL_PLAN, V$SQL_PLAN_STATISTICS, v$sqltext_with_newlines

Latch / lock / ENQUEUE

V$latch, v$latch_children, v$latch_holder, v$lock, V$ENQUEUE_STAT, V$ENQUEUE_LOCK

IO

V$segstat, v$filestat, v$tempstat, v$datafile, v$tempfile

Shared pool / Library cache

V$Librarycache, v$rowcache, x$ksmsp

A few advice is also good.

V$db_cache_advice, v$PGA_TARGET_ADVICE, v$SHARED_POOL_ADVICE

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.