数据库根据参数创建实例之后,后台进程依次启动,注意上面输出中包含了PID信息以及OS ID两个信息,PID代表该进程在数据库内部的标识符编号,而OS ID则代表该进程在操作系统上的进程编号。
我们可以通过oracle中的动态视图v$process,可以把后台进程和操作系统的进程想关联起来:
SQL> select addr,pid,spid,username,program from v$process;
ADDR PID SPID USERNAME PROGRAM
ADDR PID SPID USERNAME PROGRAM
-------- ---------- ------------------------------------------------------------------------ --------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------
393B9444 1 PSEUDO
393B9F1C 2 5989 oracle oracle@localhost.localdomain (PMON)
393BA9F4 3 5991 oracle oracle@localhost.localdomain (VKTM)
393BB4CC 4 5995 oracle oracle@localhost.localdomain (GEN0)
393BBFA4 5 5997 oracle oracle@localhost.localdomain (DIAG)
393BCA7C 6 5999 oracle oracle@localhost.localdomain (DBRM)
393BD554 7 6001 oracle oracle@localhost.localdomain (PSP0)
393BE02C 8 6003 oracle oracle@localhost.localdomain (DIA0)
393BEB04 9 6005 oracle oracle@localhost.localdomain (MMAN)
393BF5DC 10 6007 oracle oracle@localhost.localdomain (DBW0)
393C00B4 11 6009 oracle oracle@localhost.localdomain (LGWR)
393C0B8C 12 6011 oracle oracle@localhost.localdomain (CKPT)
393C1664 13 6013 oracle oracle@localhost.localdomain (SMON)
393C213C 14 6015 oracle oracle@localhost.localdomain (RECO)
393C2C14 15 6017 oracle oracle@localhost.localdomain (MMON)
393C36EC 16 6019 oracle oracle@localhost.localdomain (MMNL)
393C41C4 17 6021 oracle oracle@localhost.localdomain (D000)
393C4C9C 18 6023 oracle oracle@localhost.localdomain (S000)
393C5774 19 6757 oracle oracle@localhost.localdomain (TNS V1-V3)
已选择19行。
分析第二个过程mount: