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
