Unix for Oracle DBAs Pocket Reference

Features

• Cover Type: Paperback with 104 pages
• Published by: O'Reilly Media, Inc.
• Edition: 1st Edition February 1, 2001
• Written in: English
• ISBN 10 Number: 0596000669
• ISBN 13 Number: 978-0596000660
• Book Dimensions: 6.8 x 4.2 x 0.5 inches
• Weighs: 3.5 ounces

Product Review
The Unix for Oracle DBAs Pocket Reference has a remarkably tight focus. It's about making Oracle database management systems run optimally under various Unix operating systems, including HP-UX, Sun Solaris, and IBM AIX (there's also some specialized coverage of IRIX and DEC Unix). Author Donald Burleson assumes readers know how to get around the Unix command shell, and that they're quite familiar with Oracle database administration. To put it simply, to get the most out of this book, you should already know what you want to do, and need only to be told concisely how to do it. This book is ideal for people moving from Oracle administration under Windows to the same job under Unix.

As a byproduct of its careful focus, the book is tiny. It almost fits in a shirt pocket, and is about as thick as a standard pencil. A typical entry documents a single command (there are separate entries for different operating systems when commands differ), and includes a bit of text followed by the relevant command and a listing of typical output. Utility scripts with Oracle relevance are listed with minimal comments. This isn't traditional man-page-style Unix documentation, but rather advice on how to accomplish various Oracle goals inside Unix. Most readers will likely turn first to the index to find the entries that they need. --David Wall

Topics covered: Making Oracle database management systems run well under HP-UX, Sun Solaris, IBM AIX, IRIX, and DEC Unix. Ways of looking at and adjusting Oracle's use of processes, memory, processor cycles, files, disk resources, and other aspects of the Unix system. Information is presented in recipes, in type-this-to-do-that format.

Product Description
The Unix for Oracle DBAs Pocket Reference puts within easy reach the commands that Oracle database administrators need most when operating in a Unix environment. If you are an Oracle DBA moving to Unix from another environment such as Windows NT or IBM Mainframe, you know that these commands are far different from those covered in most beginning Unix books. To jump start your learning process, Don Burleson has gathered together in this succinct book the Unix commands he most often uses when managing Oracle databases. You'll be able to reach into your pocket for the answer when you need to know how to:

• Display all Unix components related to Oracle, identify the top CPU consumers on your server, and even kill processes when necessary
• Stack Unix commands into powerful scripts that can perform vital DBA functions
• Monitor Unix filesystems, and automatically manage your trace files, dump files, and archived redo log files
• Use essential server monitoring commands such as top, sar, and vmstat

And there's much more between these covers. If you need to get up to speed with Oracle on Unix, and quickly, this book is for you.

Reader Reviews
This is a very helpful book which provides a basic overview of using Unix running Oracle. Perhaps the best feature of this book is that the author has spent lot of time providing only the most useful and salient Unix scripts for the Oracle DBA. You will not find any unnecessary or redundant information in this book. In fact, I highly recommend all Oracle DBAs to read this book and memorize all its ideas. Here are some of the best tips: 1)Script to kill all Oracle processes. 2)Place a SQL * Plus script in a Unix Shell Wrapper 3)Ensure that only the Oracle user can run a Unix shell script 4)Execute a SQL*Plus Script on all the instances in the enterprise. 5)Automatically delete old trace and audit files 6)Copy TNSnames.ora to all the Unix servers in the enterprise 7)Detect when Oracle is not accepting connections and send alert