Expert One-on-One Oracle

1. Front Matter

   Pages i-xviii

   PDF

2. Introduction

   Pages 1-9

3. Setting Up

   Pages 11-18

4. Developing Successful Oracle Applications

   Pages 19-52

5. Architecture

   Pages 53-99

6. Locking and Concurrency

   Pages 101-134

7. Transactions

   Pages 135-155

8. Redo and Rollback

   Pages 157-196

9. Database Tables

   Pages 197-267

10. Indexes

    Pages 269-315

11. Import and Export

    Pages 317-366

12. Data Loading

    Pages 367-428

13. Tuning Strategies and Tools

    Pages 429-503

14. Optimizer Plan Stability

    Pages 505-543

15. Analytic Functions

    Pages 545-592

16. Materialized Views

    Pages 593-626

17. Partitioning

    Pages 627-657

18. Autonomous Transactions

    Pages 659-697

19. Dynamic SQL

    Pages 699-737

20. interMedia

    Pages 739-770

Thomas Kyte has a simple philosophy: You can treat Oracle as a black box and shove data inside of it, or you can learn how Oracle works and exploit it as a powerful computing environment. If you choose the latter, you will see there are few information management problems you cannot solve quickly and elegantly.

Kyte has selected the most important features and techniques to discuss in Expert One-on-One Oracle, which he teaches in a proof-by-example manner. He discusses available features, implementing software using these features, and avoiding potential pitfalls.

• Access
• DEX
• Java
• Microsoft Access
• SQL
• analytic function
• authentication
• concurrency
• control
• database table
• information
• object
• software
• stored procedure
• techniques

Thomas Kyte is vice president of the Core Technologies Group at Oracle Corporation and has been with the company since version 7.0.9 was released in 1993. Kyte, however, has been working with Oracle since version 5.1.5c. At Oracle, Kyte works with the Oracle database, and more specifically, he helps clients who are using the Oracle database and works directly with them specifying and building their systems or rebuilding and tuning them. Prior to working at Oracle, Kyte was a systems integrator who built large-scale, heterogeneous databases and applications for military and government clients.Tom Kyte is the same "Ask Tom" whose column appears in Oracle Magazine, where he answers questions about the Oracle database and tools that developers and database administrators struggle with every day.

Policies and ethics