Small tricks of the large Oracle 11G and 12C. Mikheichev V.V.

The book sets out many years of experience with Oracle. All versions from Oracle 10G to Oracle 12C Release 2 are considered, as well as new opportunities that appeared in Oracle 11G and Oracle 12C. The material set forth in the book is systematized and is the result of solving the problems that arose during the operation of Oracle both software developers and database administrators. Numerous examples and diagnostic requests built on Oracle representations are given.

during the operation of Oracle, a number of problems were revealed:

• Ineffective implementation of SQL queries;
• Ineffective indices and hints;
• The use and configuration of parallelization processes;
• Creation of tables using large (LOB) objects;
• blocking, their classification, cause of the occurrence and methods of warning and monitoring.