Introduce LREG process any informations,but have problem for follow:
what cause use of LREG instead of PMON process to register instance to oracle net?
use command dump listener register detail informations, for example:
SYS@em12c> alter system set events=’immediate trace name listener_registration level 3′;
System altered.
——————————
Start Registration Information
——————————
Last update: 542781289 (27 seconds ago)
Flag: 0x4, 0x0
State: succ=1, wait=0, fail=0
CDB: root pdb 1 last pdb 254 open max pdb 3
Listeners:
0 – (ADDRESS=(PROTOCOL=TCP)(HOST=em12c.oracle.com)(PORT=1521)) pdb 1
state=1, err=0
nse[0]=0, nse[1]=0, nte[0]=0, nte[1]=0, nte[2]=0
ncre=0
endp=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=em12c.oracle.com)(PORT=1521)))
flg=0x80000000 nse=0
Instance: em12c (PDB 1 flag 0x1 state 1)
flg=0x0, upd=0xa
info=(INF=(HOST=em12c)(REGION=)(DB_NAME=orcl)(VINST_NAME=))
node load=30, max=20480
inst load=17, max=472
Instance: em12c (PDB 2 flag 0x1 state 1)
flg=0x0, upd=0xa
info=(INF=(HOST=em12c)(REGION=)(DB_NAME=orcl)(VINST_NAME=))
node load=30, max=20480
inst load=17, max=472
Instance: em12c (PDB 3 flag 0x1 state 1)
flg=0x0, upd=0xa
info=(INF=(HOST=em12c)(REGION=)(DB_NAME=orcl)(VINST_NAME=))
node load=30, max=20480
inst load=17, max=472
Services:
0 – em12cXDB.oracle.com
flg=0x105, upd=0x0, pdb=1
goodnes=0, delta=0
1 – orcl.oracle.com
flg=0x104, upd=0x6, pdb=0
goodnes=0, delta=1
2 – em12cXDB.oracle.com
flg=0x105, upd=0x6, pdb=0
goodnes=0, delta=1
3 – orcl2.oracle.com
flg=0x104, upd=0x6, pdb=0
goodnes=0, delta=1
Handlers:
0 – Dedicated
flg=0x80002002, upd=0x2
services=orcl.oracle.com,
orcl2.oracle.com
hdlr load=62, max=299
Dispatcher Handlers:
0 – D000(1)
addr=(ADDRESS=(PROTOCOL=tcp)(HOST=em12c.oracle.com)(PORT=39998))
inf=DISPATCHER
flg=0x1004, upd=0x0
services=em12cXDB.oracle.com
hdlr load=0, max=1022
CMON Handlers:
CMON Handlers for Listener Networks:
Listen Endpoints:
0 – (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=em12c.oracle.com)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/orcl/xdb_wallet))(Presentation=HTTP)(Sessi
on=RAW))
flg=0x80000000, nse=0, lsnr=, lflg=0x73
pre=HTTP, sta=0
—————————-
End Registration Information
—————————-
if there are 100+ services and listeners, then is a possibility that the PMON process might spend more time on service registration to listeners due to the number of services and listeners.
But, in version 12c, this possibility is eliminated as the LREG parameter performs service registration and PMON is freed from listener registration.
So, The pmon will be better preformance when resets the status of the active transaction table and so on .
references:
oracle support.
oracle org document.
export oracle rac 12c.