Oracle database 12c release 2 performance tuning tips and techniques
By: Richard J. Niemiec
Published: 2017
Language: eng
Number of pages: 1085
ISBN-13: 9781259589683
Subjects: Relational databases; Oracle (Computer file)
Description: This book details the latest monitoring, troubleshooting, and optimization methods. Find out how to identify and fix bottlenecks on premises and in the cloud, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered in this Oracle Press guide.
Notes: Includes bibliographical references and index.
Table of contents: title: Introduction to Oracle database 12c R1 & R2 new features (DBA and Developer); title: Basic index principles (beginner developer and beginner DBA); title: Pluggable databases, disk implementation methodology, and ASM (DBA); title: turning the database with initialization parameters (DBA); title: Tuning with enterprise manager cloud control (DBA and developer); title: Using EXPLAIN, TRACE, and SQL plan management (Developer and DBA); title: Basic hint syntax (Developer and DBA); title: Query tuning (Developer and beginner DBA); title: Table joins and other advanced tuning (Advanced DBA and Developer); title: Using PL/SQL to enhance performance (Developer and DBA); title: Oracle cloud, exadata, tuning RAC, and using parallel features; title: The V$ tables (Developer and DBA); title: The X$ tables and internals topcs (Advanced DBA); title: Using statspack and the AWR report to tune waits, latches, and mutexes; title: Performing a quick system review (DBA); title: Monitor the system using unix utilities (DBA) Key initialization parameters (DBA) The V$ views (Developer and DBA); title: The X$ tables (DBA).