Oracle Database 11g performance tuning recipes a problem-solution approach
Performance problems are rarely "problems" per se. They are more often "crises" during which you’re pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won’t have the time for a leisurely perusal of the manu...
| Autor principal: | |
|---|---|
| Otros Autores: | , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
[New York?] :
Apress
c2011.
|
| Edición: | 1st ed. 2011. |
| Colección: | Expert's voice in Oracle.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628178806719 |
Tabla de Contenidos:
- Title Page; Copyright Page; Dedication Page; Contents at a Glance; Table of Contents; About the Authors; About the Technical Reviewer; Acknowledgments; Personal Acknowledgments; CHAPTER 1 Optimizing Table Performance; 1-1. Building a Database That Maximizes Performance; Problem; Solution; How It Works; 1-2. Creating Tablespaces to Maximize Performance; Problem; Solution; How It Works; 1-3. Matching Table Types to Business Requirements; Problem; Solution; How It Works; 1-4. Choosing Table Features for Performance; Problem; Solution; How It Works
- 1-5. Avoiding Extent Allocation Delays When Creating TablesProblem; Solution; How It Works; 1-6. Maximizing Data Loading Speeds; Problem; Solution; How It Works; 1-7. Efficiently Removing Table Data; Problem; Solution; How It Works; 1-8. Displaying Automated Segment Advisor Advice; Problem; Solution; How It Works; 1-9. Manually Generating Segment Advisor Advice; Problem; Solution; How It Works; 1-10. Automatically E-mailing Segment Advisor Output; Problem; Solution; How It Works; 1-11. Rebuilding Rows Spanning Multiple Blocks; Problem; Solution; How It Works; 1-12. Freeing Unused Table Space
- ProblemSolution; How It Works; 1-13. Compressing Data for Direct Path Loading; Problem; Solution; How It Works; 1-14. Compressing Data for All DML; Problem; Solution; How It Works; 1-15. Compressing Data at the Column Level; Problem; Solution; How It Works; 1-16. Monitoring Table Usage; Problem; Solution; How It Works; CHAPTER 2 Choosing and Optimizing Indexes; 2-1. Understanding B-tree Indexes; Problem; Solution; Scenario 1: All Data Lies in the Index Blocks; Scenario 2: All Information Is Not Contained in the Index; Scenario 3: Only the Table Blocks Are Accessed; How It Works
- 2-2. Deciding Which Columns to IndexProblem; Solution; How It Works; 2-3. Creating a Primary Key Index; Problem; Solution; How It Works; Create Index and Constraint Separately; Create Constraint Inline; Create Constraint Out of Line; 2-4. Creating a Unique Index; Problem; Solution; How It Works; Use CREATE TABLE; Create Index First, Then Add Constraint; Creating Only a Unique Index; 2-5. Indexing Foreign Key Columns; Problem; Solution; How It Works; 2-6. Deciding When to Use a Concatenated Index; Problem; Solution; How It Works; 2-7. Reducing Index Size Through Compression; Problem; Solution
- How It Works2-8. Implementing a Function-Based Index; Problem; Solution; How It Works; 2-9. Indexing a Virtual Column; Problem; Solution; How It Works; 2-10. Avoiding Concentrated I/O for Index; Problem; Solution; How It Works; 2-11. Adding an Index Without Impacting Existing Applications; Problem; Solution; How It Works; 2-12. Creating a Bitmap Index in Support of a Star Schema; Problem; Solution; How It Works; 2-13. Creating a Bitmap Join Index; Problem; Solution; How It Works; 2-14. Creating an Index-Organized Table; Problem; Solution; How It Works; 2-15. Monitoring Index Usage; Problem
- Solution
