July 2005
Intermediate to advanced
528 pages
12h 21m
English
Because we'll be talking about the Oracle RDBMS in depth in later sections, we'll simply cover a few of the more important details here. One of the major differences between Oracle running on Windows and Oracle running on UNIX-based platforms is the number of processes that combine to create the actual RDBMS. On Windows there is simply the oracle.exe process, but on UNIX platforms there are multiple processes each responsible for some part of functionality. Using ps we can list these processes:
$ ps -ef | grep oracle oracle 17749 1 0 11:26:13 ? 0:00 ora_pmon_orasidsol oracle 10109 1 0 Sep 18 ? 0:01 /u01/oracle/product/9.2.0/bin/tnslsnr listener920 -inherit oracle 17757 1 0 11:26:16 ? 0:01 ora_smon_orasidsol oracle 17759 1 0 11:26:17 ? 0:00 ora_reco_orasidsol oracle 17751 1 0 11:26:15 ? 0:01 ora_dbw0_orasidsol oracle 17753 1 0 11:26:16 ? 0:01 ora_lgwr_orasidsol oracle 17755 1 0 11:26:16 ? 0:05 ora_ckpt_orasidsol oracle 17762 1 0 11:30:59 ? 1:34 oracleorasidsol (LOCAL=NO)
Each RDBMS process has the name of the database SID appended to it — in this case orasidsol. The following list looks at each process and discusses what each does.
Read now
Unlock full access