Carry essential Oracle Database administration information and troubleshooting techniques along with you so you can handle a wide variety of tasks on the spot. This handy resource offers fast access to administrative commands, error resolutions, best practices, and more. Written by an Oracle expert and published by Oracle Press, this convenient reference gives you quick solutions in an easy-to-find format. Don't leave your desk without it! Get details on:
Database creation and management Rollback/undo segments, control files, and redo logs Oracle tablespaces and tables Indexes, views, and materialized views Clusters Sequences and synonyms Users, profiles, roles, and grants Types, dimensions, and other Oracle objects Clauses and outlines PL/SQL DML commands
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
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."