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.
FREE Two-Day Shipping for Students. Learn more |
Book Description
Special Offers and Product Promotions
- Buy $50 in qualifying physical textbooks, get $5 in Amazon MP3 Credit. Here's how (restrictions apply)
Editorial Reviews
From the Back Cover
YOUR ON-THE-JOB QUICK REFERENCE 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
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:
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."
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
8 of 8 people found the following review helpful:
5.0 out of 5 stars
A true MUST HAVE reference book,
By
This review is from: Portable DBA: Oracle (Paperback)
Like many Oracle DBAs, I have plenty of reference books that are useful. The problem I run into is that some tend to be quite large (i.e. 1000+ pages) and the information I need is contained in one paragragh from this book, one chapter from another and a schema diagram from yet another. I have long searched for one book to take with me to customer sites that contains examples of command usage, diagrams and concise explanations. Enter Robert Freeman's Portable DBA: Oracle.
This book is just what is claims to be: a portable reference for topics such as creating/removing a database, managing undo/rollback segments, building indexes and using the import/export utilities. This is just some of the subject matter covered. There are also appendices containing Oracle syntax, data dictionary views and initialization parameters. Note that this book is not a tutorial and assumes you are knowledgeable in at least the basics of being an Oracle DBA. Having said that, it is full of examples to help jog your memory in how to use a certain command as well as giving you enough infomation so that you can research a command more fully in other reference materials. Lest I forget, Mr. Freeman's writing style is easy to read and instructional without getting too technical. He knows his stuff and knows how to teach as well. At just under 600 pages, you will not be carrying this in your back pocket. But, if you want one DBA reference book to take with you in your travels, this is the one. Highly recommended!!! Dwayne Cox Oracle DBA for over 6 years
1 of 1 people found the following review helpful:
5.0 out of 5 stars
Great book for all DBAs,
By
This review is from: Portable DBA: Oracle (Paperback)
This is a book all DBAs must have! As a DBA for over 5 years, I have been waiting for a book like this to come out for some time and Robert Freeman has hit the mark! This book has all the basic essentials for my day to day job. I don't know how most people, but I have a hard time remembering the exact syntax of all the commands. The DBA Cheat Sheet section has helped me every time. And if I need more information, I just look in the chapters and I always find it.
Another great feature of the book is the error sections. Robert has included the typical errors that you may run into when issuing commands. Then provides possible causes and solutions. It's all right there without having to search Metalink or Oracle's documentation. I highly recommend this book. It has been a welcome member in my book collection and has replaced a number of them.
2 of 3 people found the following review helpful:
1.0 out of 5 stars
Reference Manual Replica,
By
This review is from: Portable DBA: Oracle (Paperback)
I hate being a critic of the Oracle Books but I believe constructive criticism is good for the Oracle Authors and they benefit the Oracle Community in the long run.
This is a good book If you are looking for a mini and heavy Reference Manual instead of the online help or Oracle Documentation CD. For all those who are used to the old Oracle Handbook, this is nothing but a replica of it with a cool name. For all those who want to add a book to the book shelf , it is a piece to add to increase the numbers. But for people who are keen to keep the bookshelf with usable books, this is not the right book. Arif Khan Oracle Consultant, London.
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
First Sentence:
As I mentioned in the introduction, this book is less about learning how to do something and more about actually doing it. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
update global indexes, impacted partitions, table system privilege, resumable space management, alter cluster command, alter database command, automated undo management, user table containing, alter sequence command, full database export, database parameter file, system kill session command, backup control file, manual rollback segments, create cluster command, lock table command, set constraints command, default tablespace type, index system privilege, using backup controlfile, smallfile tablespace, tablespace system privilege, undo tablespace, alter database open, bigfile tablespace Key Phrases - Capitalized Phrases (CAPs): (learn more)
Oracle Error Message Text Description, View Name Description All User, Oracle Data Pump, Step Action, Data Dictionary Information Data, Parameter Description, Table Constraints, None Allows, Oracle Flashback Version Query, Oracle Press, Database Resource Manager, Datatype Name Description Example, Table Column, Value Description, Attribute Description Default Value, Cost Based Optimizer, Database Release, Miscellaneous Administrative Features, Oracle Errors Associated New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
As I mentioned in the introduction, this book is less about learning how to do something and more about actually doing it. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
update global indexes, impacted partitions, table system privilege, resumable space management, alter cluster command, alter database command, automated undo management, user table containing, alter sequence command, full database export, database parameter file, system kill session command, backup control file, manual rollback segments, create cluster command, lock table command, set constraints command, default tablespace type, index system privilege, using backup controlfile, smallfile tablespace, tablespace system privilege, undo tablespace, alter database open, bigfile tablespace Key Phrases - Capitalized Phrases (CAPs): (learn more)
Oracle Error Message Text Description, View Name Description All User, Oracle Data Pump, Step Action, Data Dictionary Information Data, Parameter Description, Table Constraints, None Allows, Oracle Flashback Version Query, Oracle Press, Database Resource Manager, Datatype Name Description Example, Table Column, Value Description, Attribute Description Default Value, Cost Based Optimizer, Database Release, Miscellaneous Administrative Features, Oracle Errors Associated New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Books on Related Topics
(learn more)
|
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
Listmania!
|
|
