Oracle Database 19c New Static Data Dictionary Views

 Static Data Dictionary Views

These are new static data dictionary views which are introduce in Oracle Database Release 19c.

ALL_TRIGGERS_AE

DBA_TRIGGERS_AE

USER_TRIGGERS_AE

DBA_AUTO_INDEX_CONFIG

DBA_AUTO_STAT_EXECUTIONS

DBA_PDB_SNAPSHOTFILE

DBA_RAT_CAPTURE_SCHEMA_INFO

DBA_REGISTRY_BACKPORTS

DBA_SQL_QUARANTINE

 

ALL_TRIGGERS_AE 

1	It describes the triggers on tables accessible to the current user.

DBA_TRIGGERS_AE

1	It describes all triggers in the database.

USER_TRIGGERS_AE

1	IT describes the triggers owned by the current user.

DBA_AUTO_INDEX_CONFIG

1	IT displays the current configuration parameter settings for automatic indexing.

 DBA_AUTO_STAT_EXECUTIONS

1	IT displays information about automatic optimizer statistics collection tasks.

DBA_PDB_SNAPSHOTFILE

1	It displays the files associated with snapshots taken of pluggable databases (PDBs).

DBA_RAT_CAPTURE_SCHEMA_INFO

1	It displays the login schema and current schema that were in effect when SQL statements were recorded in a workload capture.

DBA_REGISTRY_BACKPORTS

1	It displays backported bug fixes that were applied to the database. This view displays only bug fixes that changed the data dictionary of the database.

DBA_SQL_QUARANTINE

1	It displays information about quarantine configurations.

With Best Wishes!!!!