Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Tuning Pack

This pack includes these applications:

Expert

Helps with the initial configuration of an Oracle database and makes recommendations for modifications to the database to improve performance. Expert also generates scripts to implement these recommendations.

Index Tuning Wizard

Generates suggestions concerning tables that could use additional indexes and the scripts for implementing those recommendations.

SQL Analyze

Analyzes and compares optimization plans for SQL statements, as well as helps to improve the performance with hints.

Tablespace Map and Analysis

Displays information about tablespaces and an analysis that can detect potential space management problems.

Reorg Wizard

Can reorganize specific schema objects or tablespaces or repair migrated rows. This application is new as a standalone application with Oracle9i.

Outline Management

Helps to manage stored outlines. This application is new as a standalone application with Oracle9i.

Outline Editor

Allows easy editing of stored outlines. This application is new as a standalone application with Oracle9i.

Auto Analyze

Automatically maintains the statistics for an Oracle8i database. This application was not offered as of Oracle9i.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page