Static Data Dictionary Views

Static data dictionary views change only when a change is made to the data dictionary (for example, when a new table is created or when a user is granted new privileges).

The static data dictionary views are grouped into three categories:

• ALL_ views: Contains data that is accessible to the current user

• DBA_ views: Contains data about the entire database

• USER_ views: Contains data that is owned by the current user

The columns of the ALL_, DBA_, and USER_ views are nearly identical. Therefore, the column descriptions and data types are described once, at their first occurrence alphabetically, and are listed without full descriptions at the other occurrences.

These views return 0 rows. The column names and the column descriptions are not documented for these views:

• SYS.ALL_COL_PRIVS

• SYS.DBA_COL_PRIVS

• SYS.SESSION_ROLES

• SYS.USER_COL_PRIVS

Table 1-3 shows the static data dictionary views.

Table 1-3 Static data dictionary views

Name	Description
SYS.ALL_ARGUMENTS SYS.DBA_ARGUMENTS SYS.USER_ARGUMENTS	Contains data about the arguments of stored procedures and functions
SYS.ALL_DEPENDENCIES SYS.DBA_DEPENDENCIES SYS.USER_DEPENDENCIES	Contains data about the dependencies between procedures, packages, functions, and package bodies
SYS.ALL_DIRECTORIES SYS.DBA_DIRECTORIES	Contains data about directories There is no SYS.USER_DIRECTORIES view.
SYS.ALL_ERRORS SYS.DBA_ERRORS SYS.USER_ERRORS	Contains data about errors on the stored objects
SYS.ALL_IDENTIFIERS SYS.DBA_IDENTIFIERS SYS.USER_IDENTIFIERS	Contains data about the identifiers in the stored objects
SYS.ALL_OBJECTS SYS.DBA_OBJECTS SYS.USER_OBJECTS	Contains data about the objects that are stored in the database
SYS.DBA_OBJECT_SIZE SYS.USER_OBJECT_SIZE	Contains data about the size (in bytes) of PL/SQL objects There is no SYS.ALL_OBJECT_SIZE view.
SYS.ALL_PLSQL_OBJECT_SETTINGS SYS.DBA_PLSQL_OBJECT_SETTINGS SYS.USER_PLSQL_OBJECT_SETTINGS	Contains data about the compiler settings for PL/SQL objects
SYS.ALL_PROCEDURES SYS.DBA_PROCEDURES SYS.USER_PROCEDURES	Contains data about PL/SQL procedures and functions
SYS.DBA_PROFILES	Contains data about profiles and the limits for each of the profiles. There is neither a SYS.ALL_PROFILES nor a SYS.USER_PROFILES system view.
SYS.ALL_SOURCE SYS.DBA_SOURCE SYS.USER_SOURCE	Contains data about the text source of the stored PL/SQL objects
SYS.ALL_STORED_SETTINGS SYS.DBA_STORED_SETTINGS SYS.USER_STORED_SETTINGS	Contains data about persistent parameter settings for stored PL/SQL units
SYS.ALL_SYNONYMS SYS.DBA_SYNONYMS SYS.USER_SYNONYMS	Contains data about synonyms
SYS.DBA_SYS_PRIVS SYS.USER_SYS_PRIVS	Contains data about system privileges There is no SYS.ALL_SYS_PRIVS view.
SYS.ALL_TABLES SYS.DBA_TABLES SYS.USER_TABLES	Contains data about the tables in the database
SYS.ALL_TAB_PRIVS SYS.DBA_TAB_PRIVS SYS.USER_TAB_PRIVS	Contains data about table privileges
SYS.ALL_TAB_SIZES SYS.DBA_TAB_SIZES SYS.USER_TAB_SIZES	Contains data about the size of tables
SYS.ALL_USERS SYS.DBA_USERS SYS.USER_USERS	Contains data about database users
SYS.ALL_VIEWS SYS.DBA_VIEWS SYS.USER_VIEWS	Contains data about the views in the database
SYS.USER_PASSWORD_LIMITS	Contains data about the password profile parameters for the user who is currently connected to the database.