Database - RAC/Scalability (MOSC)

MOSC Banner

CDB and PDB sharing the same Undo

edited Jan 2, 2020 2:25AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered ✓

Hello Team,

We are on oracle 12c R2  RAC with 2 nodes on Redhat 7.4 as the OS.

We noticed that CDB and PDB on instance 1 are sharing the same tablespace. however on Instance 2 CDB and PDB are sharing separate UNDO.

The parameter Local_undo_enabled is set to true on both instances.

SQL>SQL> select * from database_properties where property_name='LOCAL_UNDO_ENABLED';PROPERTY_NAME             PROPERTY_VALUE            DESCRIPTION------------------------- ------------------------- -----------------------------------LOCAL_UNDO_ENABLED        TRUE                      true if local undo is enabledSQL>

Node 1

SQL>  alter session set container=cdb$root;Session altered.SQL> select inst_id,con_id,name,value from gv$parameter where name='undo_tablespace' order by 1;   INST_ID     CON_ID NAME                                                                             VALUE---------- ---------- -------------------------------------------------------------------------------- ------------------------------         1          1 undo_tablespace                                                                  UNDOTBS1         2          1 undo_tablespace                                                                  UNDOTBS2SQL>SQL> alter session set container=PDB1;Session altered.SQL> select inst_id,con_id,name,value from gv$parameter where name='undo_tablespace' order by 1;   INST_ID     CON_ID NAME                                                                             VALUE---------- ---------- -------------------------------------------------------------------------------- ------------------------------         1          3 undo_tablespace                                                                  UNDOTBS1         2          3 undo_tablespace                                                                  UNDO_2SQL>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center