为繁忙的 DBA 精炼 Oracle SQL 调优
Oracle SQL Tuning Distilled For Busy DBA's
- 1. Introduction
- 1. Introduction
- 2. Install And Configure Software
- 1. Install Oracle Linux
- 2. Configure Putty
- 3. Configure Initial Prerequisites
- 4. Install Oracle Software
- 5. Install Oracle Database
- 3. Architecture Basics
- 1. Database Architecture
- 2. SQL Architecture
- 3. Cursors In Shared Pool
- 4. Cache Table
- 4. Practical Understanding Of SQL Execution
- 1. Factors For SQL Tuning
- 2. Considerations Before Tuning
- 3. Understanding Parsing And Caching
- 4. Understanding SQL Differences
- 5. Tools To Generate Execution Plan
- 1. Basic Free Tools
- 2. Enable And Disable Performance Data Collection