Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what are the common data dictionaries in Oracle". In daily operation, I believe many people have doubts about what problems there are in Oracle common data dictionaries. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubts about "what are the common data dictionaries in Oracle?" Next, please follow the editor to study!

Classification of a data dictionary

1. Static data dictionary table 2. Static data dictionary view 3 dynamic data dictionary table 4 dynamic data dictionary view

2. Use of data dictionaries

1. The use of static data dictionary tables

Static data dictionary tables can only be maintained by ORACLE.

two。 Use of static data dictionary view *

Usually, users can get all the database information they need by querying the static data dictionary view.

Oracle static data dictionary classification

Name prefix meaning

User_ contains information about all the schema objects owned by the current database user

All_ contains information about all schema objects that can be accessed by the current database user

Dba_ contains all the database object information, and only users with the DBA role can access these views

For example:

Select * from dba_tables

Select * from all_tables

Select * from user_tables

Note: dba_ must start with sys users, while non-sys users need to be prefixed with sys.

Here are some common view families, all of which have a view of DBA_ ALL_ USER_

Col_privs contains the column permission information of the table, including the grantee, grantee, permission name and other information.

Extents stores allocation information, including data segment name, table space name and partition number, partition size

Indexes index information includes table information such as index type, uniqueness, index function, etc.

Ind_columns index column information includes information such as how the columns on the index are sorted

Object object information, including object name, type, creation time, etc.

Segment information for segments tables and indexes, including tablespaces, storage settings, etc.

Sequences sequence information includes sequence name, cyclicity, maximum value and other information.

Source source code information for all stored procedures, functions, and packages except triggers

Synonyms synonym information includes information such as referenced objects

Sys_privs system permission information includes the grantee of the system permission name

Column information for tab_columns tables and views, including data types of columns

Tab_privs permission information

Tables table information includes the table space to which the table belongs, storage parameters, the number of data rows and other information.

Triggers trigger information includes trigger type, event. Information such as trigger body

Users user information. Includes user temporary and default table space types

Views View Information

Take a look at the permissions view

View of system permissions owned by the role_sys_privs role

Object permissions owned by the role_tab_privs role

Roles owned by user_role _ privs user

The role of the permissions owned by the user_sys_privs user

About table object permissions assigned by user_tab_privs_mads user

Permissions on table objects owned by user_tab_privs_recd users

Object permissions on columns assigned by the user_col_privs_mads user

Object permissions on columns that the user_col_privs_recd user has

3. Dynamic performance tables are tables that are created after the database instance is started. Dynamic performance tables are all data SYS users; used to store database performance-related information in the process of running. View through the following view

Select name from v_$fixed_table

4. Use of dynamic performance views

Only sys users and users with the DBA role can access it.

V$ parameter v$sga v$session v$process v$instance v$version v$option can be accessed when the database is started to the state of NOMOUNT

We can also access v$log v$logfiel v$datafile v$controlfile v$ database v$thread v$datafile_header when the database starts to the state of mount

When the database is fully started. Access to v_$fixed_table

V$access contains the database objects that are currently locked and the sessions that are accessing them

V$archive contains the information in the redo log file required for archiving

V $archived_log contains archive log information obtained from the control file.

V$archive_processes contains the status information of an instance-related arch process

V $backup contains backup status information for online data files

V$backup_async_io includes information about backup sets obtained from control files

V $backup_corruption contains information obtained from the control file about corruption in the backup of the data file.

V $backup_datafile contains information about backup data files and backup control files obtained from control files

V $backup_device contains information that supports backup devices

V$backup_piece contains information about backup blocks obtained from the control file

V$backup_redolog contains information about the archive log of the backup set obtained from the control file

V$backup_set contains information about backup sets obtained from control files

V$bgprocess contains database background process information

V $buffer_pool contains information about all available buffer pools in the current instance

V $buffer_pool_statistics contains statistics for all available buffer pools in the current instance

V $cache contains header information for each block in the SGA of the current instance

V$context contains property information for the current conversation.

V$controlfile contains control file information

V $controlfile_record_section contains information about the record section of the control file

V $copy_curruption contains information about corrupted copies of data files obtained from the control inquiry.

V$database contains database information obtained from the control file

V$datafile contains data file information obtained from the control file

V$datafile_copy includes information about copies of data files obtained from control files

V$datafile_header contains data file header information

V $db_object_cache contains database object information cached in the library cache

V$db_pipes contains pipe information in the current database

V$deleted_object contains information about deleted archive logs, copies of data files, and backup blocks obtained from control files

V $dispatcher_rate contains information about scheduling process rate statistics

V $dispatche contains information about the scheduling process

V $DLM_ALL_LOCKS contains all current locks

V $DLM_CONVERT_LOCAL contains information about the time consumed by the local lock conversion operation

V $EVENT_NAME contains information about waiting time

V $fixed_table contains information about all available dynamic performance views and dynamic performance tables

V $sysstat contains performance statistics for the current instance

V$ instance contains the details of the current instance

V$sga contains information about the main components of the SGA area

V$ sgainfo contains detailed messages for the SGA zone

V $parameter contains initialization parameter information

V$ sversion contains Oracle version information

V $option contains option information for installed Oraclette components

V$session contains all current session information

V$process contains all the process information of the current system

V$ bgprocess contains information about all background processes in the database

V $database contains the current database information

V $controlfile contains all the control file information of the current database

V $datafile contains information about all the data files in the current database

V $dbfile contains numbering information for all data files

V $logfile contains all the redo log file information of the current database

V $log contains the current database redo log file information

V$ log_history contains historical information about the switching of redo log files

V $thread contains information about the current database thread

V $lock contains lock information

V $locked_object contains information about locked database objects

V $rollname contains fallback information that is currently online

V $rollstat contains statistics for all current fallback segments

V $tablespace contains all the tablespace information of the current database

V $tempfile contains information about temporary data files in the current database.

At this point, the study of "what are the common data dictionaries of Oracle" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.