1.
select spid ,program from v$process where program like '%PMON%';
SPID PROGRAM
------------------------ ------------------------------------------------
5421 oracle@netuf20.urow.netfinity.com (PMON)
2.
SQL> select spid ,program from v$process where program like '%PMON%';
SPID PROGRAM
------------------------ ------------------------------------------------
5421 oracle@netuf20.urow.netfinity.com (PMON)
SQL> oradebug setospid 5421;
Oracle pid: 2, Unix process pid: 5421, image: oracle@netuf20.urow.netfinity.com (PMON)
SQL> oradebug event 10257 trace name context forever,level 16;
Statement processed.
SQL> alter system register;
System altered.
SQL> oradebug event 10257 trace name context off;
Statement processed.
SQL> oradebug tracefile_name;
/u01/app/diag/rdbms/kobe/kobe/trace/kobe_pmon_5421.trc
cat /u01/app/diag/rdbms/kobe/kobe/trace/kobe_pmon_5421.trc
kmmlrl: register now
kmmgdnu: kobeXDB
goodness=0, delta=1,
flags=0x5:unblocked/not overloaded, update=0x6:G/D/-
kmmgdnu: kobe
goodness=1, delta=1,
flags=0x4:unblocked/not overloaded, update=0x6:G/D/-
kmmlrl: nsgr update returned 0
kmmlrl: nsgr register returned 0
能看到PMON 自动注册的过程
PMON的自动注册是使用init.ora中service_names和instance_name的值。将他们拼接而成.
主要的信息来自于此：
阅读(2635) | 评论(0) | 转发(0) |
