O'Reilly logo

Unix for Oracle DBAs Pocket Reference by Donald K. Burleson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Process Management

This section is designed to provide a basic overview of how you manage Oracle processes in a Unix environment. As you know, an Oracle instance is composed in part of a set of processes such as PMON, SMON, and DBWR. In addition, there are other Unix processes that you need to be aware of and manage. For example, if you are using a dedicated listener (as opposed to the multithreaded server, MTS), then each connected user will have a Unix process.

Tip

Manny DBAs call a standard listener a "dedicated" listener because it spawns a dedicated Unix process that connects to Oracle. The MTS does not create PID for each Oracle connection; instead, it routes the connection through a multithreaded dispatcher.

This section shows you how to find Oracle processes and identify the ones consuming the most CPU resources. You'll also see how options can be added to the ps -ef command to filter and sort the process list output.

Display Unix Processes

The basic process management command is the ps command. It is commonly used to display active processes and their characteristics, and displays the values shown in the following example:

>ps -ef|grep ora

UID    PID   PPID  C  STIME     TTY  TIME  CMD
oracle 13168    1  0  05:33:06   -   3:15  oracleprod
oracle 26164    1  0  12:57:10   -   4:54  oracleprod 
...

The column definitions that you should be aware of are as follows:

UID

The user ID that owns the process.

PID

The process ID for the task.

PPID

The parent process. If the parent is 1, the process was created by the init ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required