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
| It describes the triggers on tables accessible to the current user. |
DBA_TRIGGERS_AE
| It describes all triggers in the database. |
USER_TRIGGERS_AE
| IT describes the triggers owned by the current user. |
DBA_AUTO_INDEX_CONFIG
| IT displays the current configuration parameter settings for automatic indexing. |
DBA_AUTO_STAT_EXECUTIONS
| IT displays information about automatic optimizer statistics collection tasks. |
DBA_PDB_SNAPSHOTFILE
| It displays the files associated with snapshots taken of pluggable databases (PDBs). |
DBA_RAT_CAPTURE_SCHEMA_INFO
| It displays the login schema and current schema that were in effect when SQL statements were recorded in a workload capture. |
DBA_REGISTRY_BACKPORTS
| 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
| It displays information about quarantine configurations. |
With Best Wishes!!!!
No comments:
Post a Comment