Database of learning

Tweet

The learning associated with the ORACLE database performance optimization of knowledge, with the SQL statement optimization, system structure optimization, the host tuning and database design optimization as the starting point, on the query performance, and optimizing the analysis of location optimization problem and related problem solving method. .myelibrary.net The working principle, the SQL statement tuning part focuses on the watch case studies and so on connection mode, data access method and the SQL statement, optimize the management system structure optimization part focuses on SGA components, such as shared_pool and buffer cahce optimization; optimization and tuning in the host key on the CPU, memory and IO.