In a CDB, views used by LogMiner to show information about LogMiner sessions running in the system contain an additional column named
CON_ID. This column identifies the container ID associated with the session for which information is being displayed. When you query the view from a pluggable database (PDB), only information associated with the database is displayed. The following views are affected by this new behavior:
To support CDBs, the
V$LOGMNR_CONTENTS view has several other new columns in addition to
CON_ID. See "The V$LOGMNR_CONTENTS View in a CDB".
The following DBA views have analogous CDB views whose names begin with CDB.
|DBA View||CDB_ View|
The DBA views show only information related to sessions defined in the container in which they are queried.
The CDB views contain an additional
CON_ID column which identifies the container whose data a given row represents. When CDB views are queried from the root, they can be used to see information about all containers.