oracle12c process,ORACLE 12C new critical background process is LREG(2)

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.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值