Database Administration (MOSC)

MOSC Banner

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).

https://docs.oracle.com/en/database/oracle/oracle-database/23/refrn/DBA_SUPPLEMENTAL_LOGGING.html#GUID-6C561CEE-E5D0-4F61-B5C2-87A722DFBE26

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