Portable DBA Oracle

by Robert G. Freeman

Overview

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

The ultimate field guide for every Oracle DBA’s laptop bag. Don’t go onsite without it!


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.

Product Details

ISBN-13:	9780072229806
Publisher:	McGraw Hill LLC
Publication date:	11/01/2004
Series:	Server Technologies and Tools Series
Pages:	598
Product dimensions:	7.30(w) x 9.00(h) x 1.25(d)

About the Author

Robert Freeman has been an Oracle DBA for almost 15 years. He currently lives in Chicago, where he works for TUSC as a management consultant. Robert presents at Oracle-related user groups such as IOUG-A and the UKOUG on a regular basis. He is the author of three other best-selling Oracle Press titles, Oracle Database 10g New Features, Oracle 9i RMAN Backup & Recovery, and Oracle9i New Features. Robert is the father of five teenagers, husband of a wife who is incredible, and the owner of a moody cat. In his spare time he works on getting his third-degree black belt in tae kwon do and sits at the edge of local runways with a sign that says "Will DBA for blocks of flight time."

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