OBCP 学习，如何查看隐藏配置项参数_resource_limit_max_session_num

培训中心
#1

image

OBCP 学习，如何查看隐藏配置项参数_resource_limit_max_session_num，通过如下查询为空
obclient(SYS@ob_oracle)[SYS]> show parameters like ‘resource%’;
Empty set (0.010 sec)

obclient(SYS@ob_oracle)[SYS]> show parameters like ‘_resource_limit_max_session_num’;
Empty set (0.015 sec)

obclient(SYS@ob_oracle)[SYS]> show variables like ‘_resource_limit_max_session_num’;
Empty set (0.004 sec)

2 个赞
#2

隐藏参数这样查看不了，得再SYS租户查看gv$ob_parameters

#3

– 查看变量
select
b.tenant_name,
a.tenant_id,
tenant_type,
name,
value,
info,
scope
from
CDB_OB_SYS_VARIABLES a,
DBA_OB_TENANTS b
where
a.tenant_id = b.tenant_id
and name like ‘%_nlj_batching_enabled%’
and tenant_type not in (‘SYS’,‘META’);

– 查看配置项
select
b.tenant_name,
a.tenant_id,
tenant_type,
name,
value,
SECTION,EDIT_LEVEL
from
GV$OB_PARAMETERS a,
DBA_OB_TENANTS b
where
a.TENANT_ID = b.TENANT_ID
and a.name like ‘%_resource_limit_max_session_num%’
and tenant_type not in (‘SYS’,‘META’);

1 个赞
#4

学习了

#5

感谢大佬