📋Steps in this guide1/1

Check undo mode in Multitenant db (oracle 12.2)

-- Local undo mode means that each container has its own undo tablespace for every instance in which it is open. -- Shared undo mode means that there is one active undo tablespace for a single-instance CDB

oracle configurationintermediate

by OracleDba

14 views

Check undo mode in Multitenant db (oracle 12.2)

Code/Command (click line numbers to comment):

1
2
3

-- Local undo mode means that each container has its own undo tablespace for every instance in which it is open.
-- Shared undo mode means that there is one active undo tablespace for a single-instance CDB
select * from database_properties where property_name='LOCAL_UNDO_ENABLED';

Comments (0)

Please to add comments

No comments yet. Be the first to comment!