Can DBA_SUPPLEMENTAL_LOGGING be used in any instance context ( cdb/pdb/standalone?)
Oracle Database 12c, 19c +
CAN the DBA_SUPPLEMENTAL_LOGGING be relied upon to correctly provide the supplemental logging settings for the current connection context in all of CDB/PDB or standalone oracle instances ?
With this being a 'DBA_' view, is the security context included under the 'select any dictionary role' ?
In Oracle 12c, a new view was added to provide details on the supplemental logging settings at the database level. Containerized/ Multi-tenant databases allowed enabling additional supplemental logging at separate PDB levels rather than entire database (CDB and all mounted PDBs).