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:
V$LOGMNR_DICTIONARY_LOAD
V$LOGMNR_LATCH
V$LOGMNR_PROCESS
V$LOGMNR_SESSION
V$LOGMNR_STATS
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.