Unix for Oracle DBAs Pocket Reference

Chapter 1. Unix for Oracle DBAs Pocket Reference

Introduction

The Unix for Oracle DBAs Pocket Reference is a quick reference describing the Unix commands most often used by Oracle database administrators. It’s the result of my 20 years of accumulating Unix tips and techniques. For each of the commands included in this book, I’ve provided the basic syntax and a short, illustrative example. This guide also contains many short Unix scripts that should save you dozens of hours of manual effort.

I’ve organized the commands and examples in this book into the following major topic areas:

Understanding Unix

Gives you a little bit of the history of Unix and tells you some things that you need to know regarding case sensitivity, safety, and shells.

Building Unix Commands

Describes the process of creating complex Unix commands for Oracle.

Unix Server Environment

Describes the commands that make Unix easier for DBAs.

Process Management

Describes the basic Unix commands you use to display and manage server processes.

Server Values

Shows you how to display relevant server values in Unix.

Memory and CPU Management

Shows the main commands used to display information about memory segments, swap space, and semaphores used by an Oracle database. Also covers commands used to monitor CPU utilization.

Semaphore Management

Shows you how to monitor semaphore usage by your Oracle server and how to remove semaphore sets for an instance that has crashed.

System Log Messages

Shows you how to view operating-system log ...