Oracle PDB的初始化参数

Question

如何在不执行"将会话更改为PDB"的情况下查询Oracle PDB的所有初始化参数？有什么办法吗？

Answer 1

在v$system_parameter视图中使用con_id列

SQL>SELECT name,
value
FROM v$system_parameter
WHERE con_id=
(SELECT con_id
FROM v$pdbs
WHERE name='TESTPDB');

NAME                                               VALUE
-------------------------------------------------- ------------------------------
cpu_min_count                                      12
sga_min_size                                       0
shared_pool_size                                   0
resource_manager_plan                              SCHEDULER[0x4D18]:DEFAULT_MAIN
TENANCE_PLAN

db_performance_profile
sga_target                                         0
db_cache_size                                      0
undo_tablespace                                    UNDOTBS1
tde_configuration
private_temp_table_prefix                          ORA$PTT_
unified_audit_systemlog                            FALSE
parallel_servers_target                            192
common_user_prefix
multishard_query_data_consistency                  strong
multishard_query_partial_results                   not allowed