Catalog Views / Data Dictionary Views
The data dictionary views, also known as catalog views, let you monitor the state of the database in real time:
- The USER, ALL, and DBA views show information about schema objects that are accessible to you, at different levels of privilege.
- The V$ views show performance-related information.
- The _PRIVS views show privilege information for different combinations of users, roles, and objects.
Shortcuts to View Names
If you know the name of the view you want, select its abbreviation. Otherwise, scroll down to see the entire list.
List of Data Dictionary Views (A-Z)
| DBA_RSRC_CONSUMER_GROUP_PRIVS: Syntax |
| DBA_RSRC_MANAGER_SYSTEM_PRIVS: Syntax |
| USER_RSRC_CONSUMER_GROUP_PRIVS: Syntax |
| USER_RSRC_MANAGER_SYSTEM_PRIVS: Syntax |
