This book focuses on several Oracle hot topics such as database startup and shutdown, function and parameter files, data dictionary, memory management, Buffer Cache and Shared Pool principles, redo, rollback and undo, wait events, performance diagnosis and SQL optimization. Starting from basic knowledge, we conduct in-depth research on related technologies, combined with performance adjustment and rich diagnostic cases, and strive to present Oracle knowledge to readers in a comprehensive, systematic and in-depth manner.
This book gives a large number of examples taken from actual work sites. In the process of analyzing the examples, both depth and breadth are taken into consideration. Not only the phenomena, causes and related principles of the actual problems are explained in a simple and easy-to-understand manner, but more importantly, a series of ideas and solutions to the problems are provided based on the actual application environment. The method, including detailed operating steps, is highly practical and operable and meets the needs of readers for practical applications.
Expand