Some views of the Oracle database

1. Previously, SQL was used without deep learning of the underlying knowledge of the database, especially in terms of how it processes and how locks and underlying data are stored.

2. Gradually in the development of the database requirements are slowly high

For example: temporary table-----bi inside, stored procedure inside

Materialized trying to----bi inside like

The use of db-link in development

Locking mechanism of 3.oracle:

　　　　

View of 4.oracle:

Database operation of the metadata record, the individual in the development and multidimensional analysis is a bit similar, is the metadata, because of the existence of these, is more flexible.

v$**** The purpose of these views is to view some of the database's underlying information to facilitate tuning.

Some views of the Oracle database