Using Standard Database Commands and Tools

This section describes the commands and tools that are either included with a database product or are part of the operating system.

UNIX Commands

UNIX commands and tools, such as ps and pstat, can be used to check on some of the important database processes. The database listeners and names servers are examples of some of these critical database processes. Listing 8-1 shows an example of using ps to find the Oracle processes on the system. Note that Oracle appends the database instance name to the end of the process names associated with each instance.

The who command can be used to list the UNIX users logged in to the system. This gives you an idea of who is using the system, but doesn't necessarily ...

Get UNIX® Fault Management: A Guide for System Administration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.