Total System Global Area 1543500832 bytes Fixed Size 9135136 bytes Variable Size 452984832 bytes Database Buffers 1073741824 bytes Redo Buffers 7639040 bytes Database mounted. Database opened. SQL> alter pluggable database all open;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO SQL> select sid, serial# from v$session where sid=(select userenv('sid') from dual);
SID SERIAL# ---------- ---------- 1 52344
SQL> alter session set parallel_max_servers=128 container=all SCOPE=BOTH; alter session set parallel_max_servers=128 container=all SCOPE=BOTH * ERROR at line 1: ORA-02096: specified initialization parameter is not modifiable with this option
SQL> select type,sid,id1,id2 from v$lock where type='TX';
no rows selected
SQL> alter system set parallel_max_servers=128 container=all SCOPE=BOTH;
System altered.
SQL> select type,sid,id1,id2 from v$lock where type='TX';
SQL> select sid, serial# from v$session where sid=(select userenv('sid') from dual);
SID SERIAL# ---------- ---------- 1 52344
SQL> select type,sid,id1,id2 from v$lock where type='TX';
no rows selected
SQL> ALTER SYSTEM SET parallel_max_servers=96 SCOPE=both; ALTER SYSTEM SET parallel_max_servers=96 SCOPE=both * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-00060: deadlock detected while waiting for resource
SQL>
From the trace file of ORA-60, self deadlock happened when update pdb_spfile$ recusively.
Deadlock graph: ------------Blocker(s)----------- ------------Waiter(s)------------ Resource Name process session holds waits serial process session holds waits serial TX-000A0005-00002173-00000001-00000000 88 459 X 12153 88 459 X 12153
----- Current SQL Statement for this session (sql_id=2y7cqwmwf43jz) ----- update pdb_spfile$ set value$=:5, comment$=:6, spare2=(decode(bitand(:8,1), 1, :8 - 1, :8)), spare1=(case WHEN spare1 < :7 THEN :7 ELSE spare1 END) where name=:1 and pdb_uid=:2 and db_uniq_name=:3 and sid=:4