ORACLE data dictionary and view

When the ORACLE database SYSTEM is started, the data dictionary is always available and resides in the SYSTEM tablespace. A data dictionary contains a gallery. In many cases, each Gallery has three views that contain class information and are prefixed with USER, ALL, and DBA. L a USER-prefixed view in the USER mode. L if the prefix is ALL

When the ORACLE database SYSTEM is started, the data dictionary is always available and resides in the SYSTEM tablespace. A data dictionary contains a gallery. In many cases, each Gallery has three views that contain class information and are prefixed with USER, ALL, and DBA. L a USER-prefixed view in the USER mode. L if the prefix is ALL

When the ORACLE database SYSTEM is started, the data dictionary is always available and resides in the SYSTEM tablespace. A data dictionary contains a gallery. In many cases, each Gallery has three views that contain similar information and are prefixed with USER, ALL, and DBA.

L a USER-prefixed view in the USER mode.

L a view prefixed with ALL is an extended user view (an accessible view ).

L a view prefixed with DBA is a view of DBA (a view accessible to all users ).

In ORACLE, a set of virtual tables are maintained to record the activity of the current database. These tables are called dynamic performance tables. Dynamic Performance tables are not real tables, and many users cannot directly access them. DBAs can query these tables, create views, and grant access to views to other users.

ORACLE data dictionary and view

View Graph name	Description
ALL_CATALOG	All tables, views, and sequences accessible to users
ALL_COL_COMMENTS	Annotations for user-accessible tables and view Columns
ALL_COL_PRIVS	Authorize the user or the PUBLIC account on the column
ALL_COL_PRIVS_MADE	Authorize on the column. The user is the holder or creator.
ALL_COL_PRIVS_RECD	Authorize the user or the PUBLIC account on the column
ALL_CONSTRAINTS	Definition of constraints on an accessable table
ALL_CONS_COLUMN	Information about the columns that can be accessed in the constraint Definition
ALL_DB_LINKS	Database chains accessible to users
ALL_DBF_AUDIT_OPTS	When an object is created, the default Object audit selection applied
ALL_DEPENDENCIES	Subordination between accessible objects
ALL_ERROES	Current error on the user-accessible object
ALL_INDEXES	Description of indexes on user-accessible tables
ALL_IND_COLUMNS	Index columns on accessible tables
ALL_OBJECTS	Accessible objects
ALL_SEQUENCES	User-accessible sequence description
ALL_SNAPSHOTS	All snapshots that can be accessed by users
ALL_SOURCE	All stored object text source programs that users can access
ALL_SYNONYM	All synonyms accessible to users
ALL_TABLES	Description of accessible tables
ALL_TAB_COLUMNS	Accessible tables, views, and clustered Columns
ALL_TAB_COMMENTS	Comments on tables or views that can be accessed by users.
ALL_TAB_PRIVS	Authorization on the object. The user or PUBLIC is granted
ALL_TAB_PRIVS_MADE	Authorization on objects or user authorization
ALL_TAB_PRIVS_RECD	Authorization on the object. The user or PUBLIC is the authorized person.
ALL_TRIGGERS	User-accessible triggers
ALL_TRIGGER_COLS	Displays the use of columns in the table held by the user and in the triggers held by the user, or the use of columns on all triggers when the user has the create any trigger privilege
ALL_USERS	Information about databases as all users
ALL_VIEW	View Text accessible to users
AUDIT_ACTIONS	Audit Trail action type code description table
CAT	It is a synonym for USER_CATALOG.
CHAINED_ROWS	Default Value of the analyze chained rows command
CLU	It is a synonym for USER_CLUSTERS.
COLS	It is a synonym for USER_TAB_COLUMNS.
COLUMN_PRIVILEGES	In column authorization, the user is its Authorizer, the authorized person, the holder or the PUBLIC
DBA_2PC_NEIGHBORS	Information about hanging transaction Inbound and Outbound Connections
DBA_2PC_PENDING	Information about fractional transactions that fail during the PREPARED State
DBA_AUDIT_EXISTS	AUDIT Trail records created by the audit exists command
DBA_AUDIT_OBJECT	Audit Trail records of all objects in the system
DBA_AUDIT_SESSION	All audit trail records involving CONNECT and DISCONNECT IN THE SYSTEM
DBA_AUDIT_STATEMENT	All AUDIT records in the SYSTEM involving GRANT, REVOKE, AUDIT, NOAUDIT, and alter system statements
DBA_AUDIT_TRAIL	Set of all audit records in the system
DBA_BLOCKERS	As a session set, they have a blocking that other sessions are waiting for, and they are not waiting for blocking.
DBA_CATALAOG	For all database tables, views, synonyms, and Sequences
DBA_CLUSTERS	Description of all aggregation in the database
DBA_CLU_CLOUMNS	Ing of columns to clustering Columns
DBA_COL_COMMENTS	Comment on columns of all tables and views
DBA_COL_PRIVS	All permissions on Database Columns
DBA_CONSTRAINTS	Constraint definitions on all tables in the database
DBA_CONS_CLOUMNS	Information about all columns in the constraint Definition
DBA_DATA_FILES	Information about data files
DBA _ DB_LINKS	All data links in the database
DBA _ DDL_LOCKS	All DDL blocking and uncompleted DML blocking requests in the database
DBA _ DEPENDENCIES	Subordination between all objects
DBA_DML_LOCKS	The currently held DDL blocking and all unfinished DML blocking requests in the database
DBA_ERRORS	Current error on all storage objects in the database
DBA_EXP_FILES	Output file description
DBA_EXP_OBJECTS	Existing incremental output object
DBA_EXP_VERSION	Version of the final output session
DBA_EXTENTS	Range of all segments in the database
DBA_FREE_SPACE	Unused ranges in all tablespaces
DBA_INDEXES	Description of all indexes in the database
DBA_IND_COLUMN	Index columns on all tables and aggregation
DBA_LOCKS	All blocking held in the database and uncompleted request blocking (including DML and DDL blocking)
DBA_OBJECT	All aggregates, database chains, indexes, packages, packages, sequences, synonyms, tables, and views defined in the database
DBA_OBJECT_SIZE	All PL/SQL objects in the database
DBA_OBJ_AUDIT_OPTS	Select Audit for all tables and views
DBA_PRIV_AUDIT_OPTS	Privileged audit Selection
DBA_PROFILES	Resource restrictions assigned to each Environment File
DBA_ROLES	All roles in the database
DBA_ROLE_PRIVS	Description of roles authorized to users or roles
DBA_ROLLBACK_SEGS	Rollback segment description
DBA_SEGMENTS	Storage allocated to all database segments
DBA_SEQUENCES	Description of all sequences in the database
DBA_SNAPSHOTS	All snapshots in the database
DBA_SNAPSHOTS_LOGS	All snapshot logs in the database
DBA_SOURCE	Store the source text of all objects in the database
DBA_SYNONYMS	All synonyms in the database
DBA_STMT_AUDIT_OPTS	Select for the current system audit
DBA_SYS_PRIVS	System privileges authorized to users or roles
DBA_TABLES	Description of all tables in the database
DBA_TABLESSPACES	Description of all tablespaces in the database
DBA_TAB_CLOUMNS	Columns in all tables, views, and aggregation
DBA_TAB_COMMENTS	Comments on all tables and views in the database
DBA_TAB_PRIVS	All authorization on objects in the database
DBA_TRIGGERS	Description of all triggers in the database
DBA_TRIGGERS_COLS	Display usage of columns defined by the user or in triggers on any user table
DBA_TS_QUOTAS	Table Space share for all users
DBA_USERS	Information about all database users
DBA_VIEWS	Text of all views in the database
DBA_WAITERS	All sessions awaiting blockout and sessions holding the lock
DICT	It is a synonym for DICTIONARY.
DICTIONARY	Description of database dictionary tables and views
DICT_COLUMNS	Description of columns in database dictionary tables and views
EXCEPTIONS	Information that violates integrity constraints
GLOBAL_NMAE	Global name of the current database
IND	It is a synonym for usermetadata indexes.
INDEX_STATE	Store information about the vaildate index Command
OBJ	It is a synonym for USER _ OBJECT.
RESOURCE_COST	Cost per Resource
ROLE_ROLE_PRIVS	Role information authorized to other roles
ROLE_SYS_PRIVS	Information on system privileges authorized to a role
ROLE_TAB_PRVS	Information on table privileges authorized to a role
SEQ	It is a synonym for USER_SEQUENCES.
SEESSIONS_PORIVS	Permissions currently available to users
SESSION_ROLES	The user has enabled the role.
SYN	It is a synonym for USER_SYNONYMS.
SYSTEM_PRILEGE_MAP	Is a description of the system privileged code.
TABLE_PRIVILEGES	Authorization on objects
TABLE_PRIVILEGE_MAP	Description table for accessing privileged code
TABS	It is a synonym for USER_TABLES.
USER_AUDIT_OBJECT	Audit Trail records involving objects
USER_AUDIT_SESSION	All audit trail records involving connection or connection Deletion
USER_AUDIT_STATEMENT	AUDIT Trail items for GRANT, REVOKE, AUDIT, NOAUDIT, and all system statements issued by the user
USER_AUDIT_TRAIL	User-related audit trail items
USER_CATALOG	Tables, views, synonyms, and sequences held by users
USER_CLUSTERS	Description of the aggregation held by the user
USER_CLU_CLOUMNS	Ing of user columns to clustering
USER_COL_COMMENTS	Comment on the column of a user's table or view
USER_COL_PRIVS	Authorization on the column. The user is the holder, Authorizer, or grantee.
USER_COL_PRIVS_MADE	Authorize all columns of objects held by the user
USER_COL_PRIVS_RECD	This user is authorized on the column of the Authorized Person
USER_CONSTRAINT	Constraint definitions on user tables
USER_CONS_COLUMNS	Column information in the constraint definition held by the user
USER_DB_LINKS	Database chain held by the user
USER_DEPENDENCIES	Subordination between user objects
USER_ERRORS	Current error on the user's storage object
User_extrcnt	Range of user object segments
USER_FREE_SPACE	Unused ranges in user-accessible tablespaces
USRE_INDEXES	User's own index description
USER_IND_CLOUMNS	User-indexed or user-table columns
USER_OBJECTS	Objects held by users
USER_OBJECT_SIZE	User's PL/SQL object
USER_OBJ_AUDIT_OPTS	Select tables and audits for users
USER_RESOURCE_LIMITS	Resource limit for the current user
USER_ROLE_PRIVS	Role granted by privilege
USER_SEGMENT	Storage Allocation of database segments belonging to user objects
USER_SEQUENCE	Description of user's sequence
USER_SNAPSHOTS	Snapshots that can be viewed by users
USER_SNAPSHOT_LOGS	User-supported snapshot logs
USER_SOURCE	Source Text of all objects stored by the user
USER_SYNONYM	User Synonym
USER_SYS_PRIVS	System privileges granted to users
USER_TABLES	Description of table owned by users
USER_TABLESPACES	Description of the stored tablespace
USER_TAB_COLUMNSS	User tables, views, and clustered Columns
USER_TAB_COMMENTS	Comments on tables and views held by users
USER_TAB_PRIVS	User authorization for the authorizer, holder or object of the Authorized Person
USRE_TAB_PRIVS_MADE	All privileges of objects held by the user
USER_TAB_PRIVS_RECD	The user authorizes the object of the authorized person.
USER_TRIGGRS	Description of user triggers
USER_TRIGGRS_COLS	Usage of columns held by users or in triggers on user tables
USER_TS_QUOTAS	User shares in tablespaces
USER_USERS	Information about the current user
USER_VIEWS	Text of the view held by the user