oracle pmon负载信息,oracle 跟踪PMON动态注册

[oracle@normal admin]$ ps -ef | grep ora

oracle 1687 1 0 15:21 ? 00:00:00 ora_pmon_normal

[oracle@normal admin]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 26-AUG-2014 16:23:11

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

[oracle@normal ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 26 16:24:10 2014

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> oradebug setospid 1687

Oracle pid: 2, Unix process pid: 1687, image: oracle@normal.localdomain (PMON)

SQL> oradebug event 10257 trace name context forever, level 16;

Statement processed.

SQL> oradebug tracefile_name

/u01/app/oracle/diag/rdbms/normal/normal/trace/normal_pmon_1687.trc

*** 2014-08-26 16:28:16.719

err=-300 lbflgs=0x0 tbtime=0 tntime=0 etime=300 srvs=1 nreqs=0 sreqs=0 asrvs=1

error=-300 etime=300 control=0 integral=0 lasterr=-300 lastetm=300

kmmlrl: status: succ=0, wait=0, fail=1

kmmlrl: listener failure retry: 6001

kmmgdnu: NORMALXDB

goodness=0, delta=1,

flags=0x5:unblocked/not overloaded, update=0x6:G/D/-

kmmgdnu: normal

goodness=0, delta=1,

flags=0x4:unblocked/not overloaded, update=0x6:G/D/-

kmmlrl: nsgr update returned 0

kmmlrl: nsgr register returned 0

*** 2014-08-26 16:28:19.722

err=-300 lbflgs=0x0 tbtime=0 tntime=0 etime=300 srvs=1 nreqs=0 sreqs=0 asrvs=1

error=-300 etime=300 control=0 integral=0 lasterr=-300 lastetm=300

kmmlrl: status: succ=0, wait=0, fail=1

*** 2014-08-26 16:29:16.748

err=-300 lbflgs=0x0 tbtime=0 tntime=0 etime=300 srvs=1 nreqs=0 sreqs=0 asrvs=1

error=-300 etime=300 control=0 integral=0 lasterr=-300 lastetm=300

kmmlrl: status: succ=0, wait=0, fail=1

kmmlrl: listener failure retry: 6002

kmmgdnu: NORMALXDB

goodness=0, delta=1,

flags=0x5:unblocked/not overloaded, update=0x6:G/D/-

kmmgdnu: normal

goodness=0, delta=1,

flags=0x4:unblocked/not overloaded, update=0x6:G/D/-

kmmlrl: node load 15

kmmlrl: nsgr update returned 0

kmmlrl: nsgr register returned 0

*** 2014-08-26 16:29:19.751

err=-300 lbflgs=0x0 tbtime=0 tntime=0 etime=300 srvs=1 nreqs=0 sreqs=0 asrvs=1

error=-300 etime=300 control=0 integral=0 lasterr=-300 lastetm=300

kmmlrl: status: succ=1, wait=0, fail=0

SQL> oradebug event 10257 trace name context off;

Statement processed.

在11g以后还行使用 listener_registration 来跟踪 PMON 的动态注册

alter system set events='immediate trace name listener_registration level 3';

--pmon trace文件相关输出类容：

*** 2014-08-26 16:38:17.289

Start Registration Information

------------------------------

Last update: 429880227 (15 seconds ago)

Flag: 0xc, 0x0

State: succ=0, wait=0, fail=1

Listeners:

0 - (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.137.11)(PORT=1521))

state=4, err=3

nse[0]=12541, nse[1]=12541, nte[0]=0, nte[1]=0, nte[2]=0

ncre=0

endp=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=normal.localdomain)(PORT=1521)))

flg=0x80000000 nse=0

Instance: normal

flg=0x0, upd=0x0

info=(HOST=normal)

node load=2, max=5120

inst load=1, max=247

Services:

0 - normal

flg=0x4, upd=0x6

goodnes=0, delta=1

1 - NORMALXDB

flg=0x5, upd=0x6

goodnes=0, delta=1

Handlers:

0 - Dedicated

flg=0x80002002, upd=0x0

services=normal

hdlr load=28, max=149

Dispatchers:

0 - D000

addr=(ADDRESS=(PROTOCOL=tcp)(HOST=normal.localdomain)(PORT=31696))

inf=DISPATCHER

flg=0x1004, upd=0x0

services=NORMALXDB

hdlr load=0, max=1022

CMON Handlers:

Listen Endpoints:

----------------------------

End Registration Information

----------------------------

--停止跟踪

alter system set events='immediate trace name listener_registration off';

--pmon trace文件相关信息

*** 2014-08-26 17:03:36.407

Start Registration Information

------------------------------

Last update: 430022203 (114 seconds ago)

Flag: 0x4, 0x0

State: succ=1, wait=0, fail=0

Listeners:

0 - (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.137.11)(PORT=1521))

state=1, err=0

nse[0]=0, nse[1]=0, nte[0]=0, nte[1]=0, nte[2]=0

ncre=0

----------------------------

End Registration Information

----------------------------