undo tablespace assignment in Oracle RAC changed - CDB/PDB
19c Enterprise Edition - version 19.22 on Linux
Four node RAC.
Recently we ran into the error, snapshot too old.
Important Note: We created larger undo tablespace for the instance 3 and 4 because we run data load with lots of DML compared to instance 1 and 2(mostly read)
- When we moved to 19c, we created four undo tablespace. This showed the same in CDB and PDB. Meaning, undotb_001 TS assigned to inst1,
undotb_002 TS assigned to inst2 and so on.
*** initially same in CDB and PDB
inst# TS_name Size
1 undotb_001 120
2 undotb_002 120
3 undotb_003 200
4 undotb_004 200
2. after I got snapshot too old error, i found the following:
Tagged:
0