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.
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.
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 oraUID 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:
The user ID that owns the process.
The process ID for the task.
The parent process. If the parent is 1, the process was created by the init ...