Description:

This handy, affordable reference is ideal for on-the-job DBAs in need of quick access to administrative commands, error resolutions, and best practices. Covering the most commonly used Oracle database versions, the book contains invaluable tables so problems can be diagnosed quickly and includes examples and syntax diagrams for each command.

 

Table of Contents:

1 DBA Cheat Sheet

2 Database Creation and Management

3 Rollback/Undo Segments, Control Files, and Redo Logs

4 Tablespaces

5 Tables

6 Indexes

7 Views

8 Clusters

9 Sequences and Synonyms

10 Users, Profiles, Roles, and Grants

11 Miscellaneous Administrative Features

12 The Optimizer

13 Miscellaneous Commands

14 Built-in Functions

15 DML Commands

A Initialization Parameters

B Data Dictionary Views

C Oracle SQL Syntax