Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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!!!!
Ahmad
Oracle Database Consultant
OCS (12c GG), OCE (11gR2 RAC)
OCP (11gR2/10gR2/9iR2), OCA (9i R2)
Oracle Ride!!
Reference–: www.oracle.com
