Jonathan Lewis Knihy

Provides information on the cost-based optimizer and how it works with statistics in Oracle.

A guide to designing and constructing Oracle databases covers leveraged tablespaces, partitioning, LOBs, autonomous transactions, row-level security, parallel query, parallel server, and Oracle's new analytical functions.

When your database application isn’t running fast enough, troubleshooting is usually your first move. Finding the slow part of an application is often easy, but discovering a solution can prove much more difficult. Troubleshooting Oracle Performance helps by providing a systematic approach to addressing the underlying causes of poor database application performance. Written for developers by an application developer who has learned by doing, this book shows you how to plan for performance as you would for any other application requirement.