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

This article will explain in detail how the common tables and views of oracle DBA are, and the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

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

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 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

So much for sharing about oracle DBA common tables and views. I hope the above content can be of some help and learn more knowledge. If you think the article is good, you can share it for more people to see.

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.