Static Data Dictionary Views

== Audit Trail
ALL_DEF_AUDIT_OPTS: Lists the default auditing options in effect for new objects
AUDIT_ACTIONS: Lists the audit codes and descriptions
DBA_AUDIT_EXISTS: Info generated by AUDIT EXISTS and AUDIT NOEXISTS
DBA_AUDIT_OBJECT: Audit trail info for object auditing
DBA_AUDIT_SESSION: Audit trail info for all connects and disconnects from the instance
DBA_AUDIT_STATEMENT: Audit trail info for all audited statements
DBA_AUDIT_TRAIL: All audit trail entries. All other views are subsets of this
DBA_OBJ_AUDIT_OPTS: Lists all object auditing options in effect
DBA_PRIV_AUDIT_OPTS: Lists all system privilege options in effect
DBA_STMT_AUDIT_OPTS: Lists all statement auditing options in effect
STMT_AUDIT_OPTION_MAP: Lists the valid SQL statements that can be specified for system privilege auditing
SYSTEM_PRIVILEGE_MAP: Lists the valid system privileges that can be specified for system privilege auditing
TABLE_PRIVILEGE_MAP: Lists the valid object audit options that can be specified for schema object auditing

== Constraints
DBA_CONS_COLUMNS: Shows which columns are affected by each constraint
DBA_CONSTRAINTS: Lists all constraints defined in the db

== Dictionary
DBA_CATALOG: Lists all tables, views, sequences, and synonyms in the db
DBA_DEPENDENCIES: Lists dependencies between db objects
DBA_OBJECTS: Lists all objects in the db
DICT_COLUMNS: Lists all columns defined in the data dictionary views
DICTIONARY: Lists all data dictionary views

== Exports
DBA_EXP_FILES: Desc of export files
DBA_EXP_VERSION: Ver number of the last export session
DBA_EXP_OBJECTS: Objects that have been exported

== Indexes
DBA_IND_COLUMNS: Lists all indexed columns
DBA_INDEXES: Lists all indexes
INDEX_HISTOGRAM: Contains info about the distribution of index keys within the table
INDEX_STATS: Contains info about the structure of an index

== Jobs
DBA_JOBS: Lists all jobs defined
DBA_JOBS_RUNNING: Lists all currently running jobs

== Locks
DBA_BLOCKERS: Lists all sessions holding locks for whose release others are waiting
DBA_DDL_LOCKS: Lists all existing DDL locks
DBA_DML_LOCKS: Lists all existing DML locks
DBA_KGLLOCK: Lists all KGL (library cache) locks in the db
DBA_LOCK_INTERNAL: Contains internal info for each lock defined in DBA_LOCKS
DBA_LOCKS: Lists all locks held or requested in the db
DBA_WAITERS: Lists all sessions that are waiting on a lock held by another session
DBMS_LOCK_ALLOCATED: Shows which locks the current user has allocated

== Distributed
DBA_2PC_NEIGHBORS: Info about commit point for distributed trans listed in DBA_2PC_PENDING
DBA_2PC_PENDING: Info about distributed trans requiring recovery
DBA_DB_LINKS: All db links
GLOBAL_NAME: Shows value of global name
TRUSTED SERVERS: Specifies which servers have been identified as trusted

== PL/SQL
ALL_ARGUMENTS: Lists all valid arguments for stored procedures and functions
DBA_ERRORS: Shows all errors from compiling objects
DBA_LIBRARIES: Lists the external libraries that can be called from PL/SQL packages, procedures, and functions
DBA_OBJECT_SIZE: Shows the size of the compiled code for each PL/SQL package, procedure, function, and trigger
DBA_SOURCE: Source of all stored objects in db
DBA_TRIGGERS: All triggers in db

== Replication
DBA_SNAPSHOTS: All snapshots in db
DBA_JOBS_RUNNING: All running jobs
DBA_REFRESH_CHILDREN: All objects in the refresh
DBA_RGROUP: All refresh groups
DBA_RCHILD: All children in any refresh group
DBA_REFRESH: All refresh groups
DBA_SNAPSHOT_LOGS: All snapshot logs in db

== Security
DBA_COL_PRIVS: All grants on columns in the db
DBA_PROFILES: Display all profiles and their limits
DBA_ROLE_PRIVS: Roles granted to users & roles
DBA_ROLES: All roles in the db
DBA_SYS_PRIVS: System privs granted to users
DBA_TAB_PRIVS: All grants on objects in db
DBA_USERS: Info about all users of the db

== Server Management
NLS_DATABASE_PARAMETERS: Shows NLS parameters in db
NLS_INSTANCE_PARAMETERS: Shows NLS parameters at the instance level
NLS_SESSION_PARAMETERS: Show NLS parameters at the session level
PRODUCT_COMPONENT_VERSION: Shows current release level of all installed Oracle options
SM$VERSION: Shows version level packaged for Server Manger to use

== Storage
DBA_DATA_FILES: Lists all data files in use by the db
DBA_EXTENTS: Lists every allocated extent for every segment
DBA_FREE_SPACE: Lists every free extent
DBA_FREE_SPACE_COALESCED: Lists every extent that is at the start of a block of free extents
DBA_ROLLBACK_SEGS: Lists all rollback segments
DBA_SEGMENTS: Lists all segments
DBA_TABLESPACES: Lists all tablespaces
DBA_TS_QUOTAS: Shows quota and used storage by user

== Synonyms & Sequences
DBA_SYNONYMS: All synonyms in db
DBA_VIEWS: Text of all views in db
DBA_SEQUENCES: Desc of all sequences

== Tables, Clusters, & Views
DBA_ALL_TABLES: Lists all object and relational tables
DBA_CLU_COLUMNS: Lists all cluster keys
DBA_CLUSTERS: Desc of all clusters in db
DBA_COL_COMMENTS: Comments on all table and view columns
DBA_TAB_COL_STATISTICS: Info about analyzed columns
DBA_TAB_COLUMNS: Shows all table and view columns
DBA_TAB_COMMENTS: Shows all comments on tables and views
DBA_TABLES: Shows all relational tables
DBA_UPDATABLE_COLUMNS: Lists columns in views with joins that can be updated
DBA_VIEWS: Shows all views