When changing a parameter in spfile of a pluggable database, the change is visible in V$spparameter view for PDB con_id (5), but with wrong con_id (0). This is a known bug:
SQL> show con_name
CON_NAME
------------------------------
PDB3
SQL> alter system set ddl_lock_timeout=30 scope=both;
SQL> select con_id, name, value from v$spparameter where name='ddl_lock_timeout' ;
CON_ID
----------
NAME
-----------------------------
VALUE
-----------------------------
0
ddl_lock_timeout
30
Connected to the PDB we check the value of the parameter and the con_id from v$parameter view:
SQL> show parameter ddl_lock_timeout;
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
ddl_lock_timeout integer 30
SQL> select con_id, name, value from v$parameter where name='ddl_lock_timeout';
CON_ID
----------
NAME
----------------------------
VALUE
----------------------------
5
ddl_lock_timeout
30
Bug 16682595 SPFILE / V$SPPARAMETER problems with PDB
SQL> show con_name
CON_NAME
------------------------------
PDB3
SQL> alter system set ddl_lock_timeout=30 scope=both;
SQL> select con_id, name, value from v$spparameter where name='ddl_lock_timeout' ;
CON_ID
----------
NAME
-----------------------------
VALUE
-----------------------------
0
ddl_lock_timeout
30
Connected to the PDB we check the value of the parameter and the con_id from v$parameter view:
SQL> show parameter ddl_lock_timeout;
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
ddl_lock_timeout integer 30
SQL> select con_id, name, value from v$parameter where name='ddl_lock_timeout';
CON_ID
----------
NAME
----------------------------
VALUE
----------------------------
5
ddl_lock_timeout
30
No comments:
Post a Comment