Commonly used Oracle tables

ALL_ARGUMENTS
Arguments in object accessible to the user

ALL_CATALOG
All tables, views, synonyms, sequences accessible to the user

ALL_COL_COMMENTS
Comments on columns of accessible tables and views

ALL_CONSTRAINTS
Constraint definitions on accessible tables

ALL_CONS_COLUMNS
Information about accessible columns in constraint definitions

ALL_DB_LINKS
Database links accessible to the user

ALL_ERRORS
Current errors on stored objects that user is allowed to create

ALL_INDEXES
Descriptions of indexes on tables accessible to the user

ALL_IND_COLUMNS
COLUMNs comprising INDEXes on accessible TABLES

ALL_LOBS
Description of LOBs contained in tables accessible to the user

ALL_OBJECTS
Objects accessible to the user

ALL_OBJECT_TABLES
Description of all object tables accessible to the user

ALL_SEQUENCES
Description of SEQUENCEs accessible to the user

ALL_SNAPSHOTS
Snapshots the user can access

ALL_SOURCE
Current source on stored objects that user is allowed to create

ALL_SYNONYMS
All synonyms accessible to the user

ALL_TABLES
Description of relational tables accessible to the user

ALL_TAB_COLUMNS
Columns of user's tables, views and clusters

ALL_TAB_COL_STATISTICS
Columns of user's tables, views and clusters

ALL_TAB_COMMENTS
Comments on tables and views accessible to the user

ALL_TRIGGERS
Triggers accessible to the current user

ALL_TRIGGER_COLS
Column usage in user's triggers or in triggers on user's tables

ALL_TYPES
Description of types accessible to the user

ALL_UPDATABLE_COLUMNS
Description of all updatable columns

ALL_USERS
Information about all users of the database

ALL_VIEWS
Description of views accessible to the user

DATABASE_COMPATIBLE_LEVEL
Database compatible parameter set via init.ora

DBA_DB_LINKS
All database links in the database

DBA_ERRORS
Current errors on all stored objects in the database

DBA_OBJECTS
All objects in the database

DBA_ROLES
All Roles which exist in the database

DBA_ROLE_PRIVS
Roles granted to users and roles

DBA_SOURCE
Source of all stored objects in the database

DBA_TABLESPACES
Description of all tablespaces

DBA_TAB_PRIVS
All grants on objects in the database

DBA_TRIGGERS
All triggers in the database

DBA_TS_QUOTAS
Tablespace quotas for all users

DBA_USERS
Information about all users of the database

DBA_VIEWS
Description of all views in the database

DICTIONARY
Description of data dictionary tables and views

DICT_COLUMNS
Description of columns in data dictionary tables and views

GLOBAL_NAME
global database name

NLS_DATABASE_PARAMETERS
Permanent NLS parameters of the database

NLS_INSTANCE_PARAMETERS
NLS parameters of the instance

NLS_SESSION_PARAMETERS
NLS parameters of the user session

PRODUCT_COMPONENT_VERSION
version and status information for component products

ROLE_TAB_PRIVS
Table privileges granted to roles

SESSION_PRIVS
Privileges which the user currently has set

SESSION_ROLES
Roles which the user currently has enabled.

SYSTEM_PRIVILEGE_MAP
Description table for privilege type codes. Maps privilege type numbers to type names

TABLE_PRIVILEGES
Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee

TABLE_PRIVILEGE_MAP
Description table for privilege (auditing option) type codes. Maps privilege (auditing option) type numbers to type names