Thursday, 6 August 2015

Important DBA Tables in Oralce Apps

Table of Contents

ALL_ALL_TABLES : Description of all object and relational tables accessible to the user

ALL_APPLY : Details about each apply process that dequeues from the queue visible to the current user

ALL_APPLY_CONFLICT_COLUMNS : Details about conflict resolution on tables visible to the current user

ALL_APPLY_DML_HANDLERS : Details about the dml handler on tables visible to the current user

ALL_APPLY_ERROR : Error transactions that were generated after dequeuing from the queue visible to the current user

ALL_APPLY_KEY_COLUMNS : Alternative key columns for a STREAMS table visible to the current user

ALL_APPLY_PARAMETERS : Details about parameters of each apply process that dequeues from the queue visible to the current user

ALL_APPLY_PROGRESS : Information about the progress made by the apply process that dequeues from the queue visible to the current user

ALL_ARGUMENTS : Arguments in object accessible to the user

ALL_ASSOCIATIONS : All associations available to the user



ALL_AUDIT_POLICIES : All fine grained auditing policies in the database

ALL_BASE_TABLE_MVIEWS : All materialized views with log(s) in the database that the user can see

ALL_CAPTURE : Details about each capture process that stores the captured changes in a queue visible to the current user

ALL_CAPTURE_PARAMETERS : Details about parameters for each capture process that stores the captured changes in a queue visible to the current user

ALL_CAPTURE_PREPARED_DATABASE : Is the local database prepared for instantiation?

ALL_CAPTURE_PREPARED_SCHEMAS : All user schemas at the local database that are prepared for instantiation

ALL_CAPTURE_PREPARED_TABLES : All tables visible to the current user that are prepared for instantiation

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

ALL_CLUSTERS : Description of clusters accessible to the user

ALL_CLUSTER_HASH_EXPRESSIONS : Hash functions for all accessible clusters



ALL_COLL_TYPES : Description of named collection types accessible to the user

ALL_COL_COMMENTS : Comments on columns of accessible tables and views

ALL_COL_PRIVS : Grants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee

ALL_COL_PRIVS_MADE : Grants on columns for which the user is owner or grantor

ALL_COL_PRIVS_RECD : Grants on columns for which the user, PUBLIC or enabled role is the grantee

ALL_CONSTRAINTS : Constraint definitions on accessible tables

ALL_CONS_COLUMNS : Information about accessible columns in constraint definitions

ALL_CONS_OBJ_COLUMNS : List of types an object column or attribute is constrained to in the tables accessible to the user

ALL_CONTEXT : Description of all active context namespaces under the current session

ALL_DB_LINKS : Database links accessible to the user



ALL_DEF_AUDIT_OPTS : Auditing options for newly created objects

ALL_DEPENDENCIES : Dependencies to and from objects accessible to the user

ALL_DIMENSIONS : Description of the dimension objects accessible to the DBA

ALL_DIM_ATTRIBUTES : Representation of the relationship between a dimension level and a functionally dependent column

ALL_DIM_CHILD_OF : Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension

ALL_DIM_HIERARCHIES : Representation of a dimension hierarchy

ALL_DIM_JOIN_KEY : Representation of a join between two dimension tables.

ALL_DIM_LEVELS : Description of dimension levels visible to DBA

ALL_DIM_LEVEL_KEY : Representations of columns of a dimension level

ALL_DIRECTORIES : Description of all directories accessible to the user



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

ALL_EVALUATION_CONTEXTS : rule evaluation contexts seen by user

ALL_EVALUATION_CONTEXT_TABLES : tables in all rule evaluation contexts seen by the user

ALL_EVALUATION_CONTEXT_VARS : variables in all rule evaluation contexts seen by the user

ALL_EXTERNAL_LOCATIONS : Description of the external tables locations accessible to the user

ALL_EXTERNAL_TABLES : Description of the external tables accessible to the user

ALL_HISTOGRAMS : Synonym for ALL_TAB_HISTOGRAMS

ALL_INDEXES : Descriptions of indexes on tables accessible to the user

ALL_INDEXTYPES : All indextypes available to the user

ALL_INDEXTYPE_COMMENTS : Comments for user-defined indextypes



ALL_INDEXTYPE_OPERATORS : All operators available to the user

ALL_IND_COLUMNS : COLUMNs comprising INDEXes on accessible TABLES

ALL_IND_EXPRESSIONS : FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES

ALL_IND_PARTITIONS :

ALL_IND_SUBPARTITIONS :

ALL_INTERNAL_TRIGGERS : Description of the internal triggers on the tables accessible to the user

ALL_JAVA_ARGUMENTS : argument information of stored java class accessible to the user

ALL_JAVA_CLASSES : class level information of stored java class accessible to the user

ALL_JAVA_DERIVATIONS : this view maps java source objects and their derived java class objects and java resource objects for the java class accessible to user

ALL_JAVA_FIELDS : field information of stored java class accessible to user



ALL_JAVA_IMPLEMENTS : interfaces implemented by the stored java class accessible to the user

ALL_JAVA_INNERS : list of inner classes refered by the stored java class accessible to user

ALL_JAVA_LAYOUTS : class layout information about stored java class accessible to the user

ALL_JAVA_METHODS : method information of stored java class accessible to user

ALL_JAVA_NCOMPS : ncomp related information of all java classes

ALL_JAVA_RESOLVERS : resolver of java class owned by user

ALL_JAVA_THROWS : list of exceptions thrown from a method of a class accessible to user

ALL_JOBS : Synonym for USER_JOBS

ALL_JOIN_IND_COLUMNS : Join Index columns comprising the join conditions

ALL_LIBRARIES : Description of libraries accessible to the user



ALL_LOBS : Description of LOBs contained in tables accessible to the user

ALL_LOB_PARTITIONS :

ALL_LOB_SUBPARTITIONS :

ALL_LOB_TEMPLATES :

ALL_LOG_GROUPS : Log group definitions on accessible tables

ALL_LOG_GROUP_COLUMNS : Information about columns in log group definitions

ALL_METHOD_PARAMS : Description of method parameters of types accessible to the user

ALL_METHOD_RESULTS : Description of method results of types accessible to the user

ALL_MVIEWS : All materialized views in the database

ALL_MVIEW_AGGREGATES : Description of the materialized view aggregates accessible to the user



ALL_MVIEW_ANALYSIS : Description of the materialized views accessible to the user

ALL_MVIEW_DETAIL_RELATIONS : Description of the materialized view detail tables accessible to the user

ALL_MVIEW_JOINS : Description of a join between two columns in the WHERE clause of a materialized view accessible to the user

ALL_MVIEW_KEYS : Description of the columns that appear in the GROUP BY list of a materialized view accessible to the user

ALL_MVIEW_LOGS : All materialized view logs in the database that the user can see

ALL_MVIEW_REFRESH_TIMES : Materialized views and their last refresh times for each master table that the user can look at

ALL_NESTED_TABLES : Description of nested tables 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_OBJ_COLATTRS : Description of object columns and attributes contained in the tables accessible to the user



ALL_OPANCILLARY : All ancillary operators available to the user

ALL_OPARGUMENTS : All arguments of the operators available to the user

ALL_OPBINDINGS : All binding functions for operators available to the user

ALL_OPERATORS : All operators available to the user

ALL_OPERATOR_COMMENTS : Comments for user-defined operators

ALL_OUTLINES : Synonym for USER_OUTLINES

ALL_OUTLINE_HINTS : Synonym for USER_OUTLINE_HINTS

ALL_PARTIAL_DROP_TABS : All tables with patially dropped columns accessible to the user

ALL_PART_COL_STATISTICS :

ALL_PART_HISTOGRAMS :



ALL_PART_INDEXES :

ALL_PART_KEY_COLUMNS :

ALL_PART_LOBS :

ALL_PART_TABLES :

ALL_PENDING_CONV_TABLES : All tables accessible to the user which are not upgraded to the latest type version

ALL_POLICIES : All policies for objects if the user has system privileges or owns the objects

ALL_POLICY_CONTEXTS : All policy driving context defined for all synonyms, tables, or views accessable to the user

ALL_POLICY_GROUPS : All policy groups defined for any synonym, table or view accessable to the user

ALL_PROBE_OBJECTS :

ALL_PROCEDURES : Description of all procedures available to the user



ALL_PROPAGATION : Streams propagation seen by the user

ALL_PUBLISHED_COLUMNS :

ALL_QUEUES : All queues accessible to the user

ALL_QUEUE_PUBLISHERS :

ALL_QUEUE_TABLES : All queue tables accessible to the user

ALL_REFRESH : All the refresh groups that the user can touch

ALL_REFRESH_CHILDREN : All the objects in refresh groups, where the user can touch the group

ALL_REFRESH_DEPENDENCIES : Description of the detail tables that materialized views depend on for refresh

ALL_REFS : Description of REF columns contained in tables accessible to the user

ALL_REGISTERED_MVIEWS : Remote materialized views of local tables that the user can see



ALL_REGISTERED_SNAPSHOTS : Remote snapshots of local tables that the user can see

ALL_REGISTRY_BANNERS :

ALL_REPAUDIT_ATTRIBUTE : Information about attributes automatically maintained for replication

ALL_REPAUDIT_COLUMN : Information about columns in all shadow tables for replicated tables which are accessible to the user

ALL_REPCAT :

ALL_REPCATLOG : Information about asynchronous administration requests

ALL_REPCAT_REFRESH_TEMPLATES :

ALL_REPCAT_TEMPLATE_OBJECTS :

ALL_REPCAT_TEMPLATE_PARMS :

ALL_REPCAT_TEMPLATE_SITES :



ALL_REPCAT_USER_AUTHORIZATIONS :

ALL_REPCAT_USER_PARM_VALUES :

ALL_REPCOLUMN : Replicated top-level columns (table) sorted alphabetically in ascending order

ALL_REPCOLUMN_GROUP : All column groups of replicated tables which are accessible to the user

ALL_REPCONFLICT : All conflicts with available resolutions for user's replicated tables

ALL_REPDDL : Arguments that do not fit in a single repcat log record

ALL_REPFLAVORS : Flavors defined for replicated object groups

ALL_REPFLAVOR_COLUMNS : Replicated columns in flavors

ALL_REPFLAVOR_OBJECTS : Replicated objects in flavors

ALL_REPGENERATED : Objects generated to support replication



ALL_REPGENOBJECTS : Objects generated to support replication

ALL_REPGROUP : Information about replicated object groups

ALL_REPGROUPED_COLUMN : Columns in the all column groups of replicated tables which are accessible to the user

ALL_REPGROUP_PRIVILEGES : Information about users who are registered for object group privileges

ALL_REPKEY_COLUMNS : Primary columns for a table using column-level replication

ALL_REPOBJECT : Information about replicated objects

ALL_REPPARAMETER_COLUMN : All columns used for resolving conflicts in replicated tables which are accessible to the user

ALL_REPPRIORITY : Values and their corresponding priorities in all priority groups which are accessible to the user

ALL_REPPRIORITY_GROUP : Information about all priority groups which are accessible to the user

ALL_REPPROP : Propagation information about replicated objects



ALL_REPRESOLUTION : Description of all conflict resolutions for replicated tables which are accessible to the user

ALL_REPRESOLUTION_METHOD : All conflict resolution methods accessible to the user

ALL_REPRESOLUTION_STATISTICS : Statistics for conflict resolutions for replicated tables which are accessible to the user

ALL_REPRESOL_STATS_CONTROL : Information about statistics collection for conflict resolutions for replicated tables which are accessible to the user

ALL_REPSCHEMA : N-way replication information

ALL_REPSITES : N-way replication information

ALL_RULES : Rules seen by the user

ALL_RULESETS : Rulesets seen by the user: maintained for backward compatibility

ALL_RULE_SETS : Rule sets seen by the user

ALL_RULE_SET_RULES : Rules in all rule sets seen by the user



ALL_SECONDARY_OBJECTS : All secondary objects for domain indexes

ALL_SEQUENCES : Description of SEQUENCEs accessible to the user

ALL_SNAPSHOTS : Snapshots the user can access

ALL_SNAPSHOT_LOGS : All snapshot logs in the database that the user can see

ALL_SNAPSHOT_REFRESH_TIMES : Synonym for ALL_MVIEW_REFRESH_TIMES

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

ALL_SOURCE_TABLES :

ALL_SOURCE_TAB_COLUMNS :

ALL_SQLJ_TYPES : Description of types accessible to the user

ALL_SQLJ_TYPE_ATTRS : Description of attributes of types accessible to the user



ALL_SQLJ_TYPE_METHODS : Description of methods of types accessible to the user

ALL_STORED_SETTINGS : Parameter settings for objects accessible to the user

ALL_STREAMS_GLOBAL_RULES : Global rules created on the streams capture/apply/propagation process that interact with the queue visible to the current user

ALL_STREAMS_SCHEMA_RULES : Rules created by streams administrative APIs on all user schemas

ALL_STREAMS_TABLE_RULES : Rules created by streams administrative APIs on tables visible to the current user

ALL_SUBPARTITION_TEMPLATES :

ALL_SUBPART_COL_STATISTICS :

ALL_SUBPART_HISTOGRAMS :

ALL_SUBPART_KEY_COLUMNS :

ALL_SUBSCRIBED_COLUMNS :



ALL_SUBSCRIBED_TABLES :

ALL_SUBSCRIPTIONS :

ALL_SUMDELTA : Direct path load entries accessible to the user

ALL_SUMMARIES : Description of the summaries accessible to the user

ALL_SUMMARY_AGGREGATES :

ALL_SUMMARY_DETAIL_TABLES :

ALL_SUMMARY_JOINS :

ALL_SUMMARY_KEYS :

ALL_SYNONYMS : All synonyms accessible to the user

ALL_TABLES : Description of relational tables accessible to the user



ALL_TAB_COLS : Columns of user's tables, views and clusters

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_TAB_HISTOGRAMS : Histograms on columns of all tables visible to user

ALL_TAB_MODIFICATIONS : Information regarding modifications to tables

ALL_TAB_PARTITIONS :

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

ALL_TAB_PRIVS_MADE : User's grants and grants on user's objects

ALL_TAB_PRIVS_RECD : Grants on objects for which the user, PUBLIC or enabled role is the grantee



ALL_TAB_SUBPARTITIONS :

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_TYPE_ATTRS : Description of attributes of types accessible to the user

ALL_TYPE_METHODS : Description of methods of types accessible to the user

ALL_TYPE_VERSIONS : Description of each type version accessible to the user

ALL_UNUSED_COL_TABS : All tables with unused columns accessible to the user

ALL_UPDATABLE_COLUMNS : Description of all updatable columns

ALL_USERS : Information about all users of the database



ALL_USTATS : All statistics

ALL_VARRAYS : Description of varrays in tables accessible to the user

ALL_VIEWS : Description of views accessible to the user

ALL_WORKSPACES :

AUDIT_ACTIONS : Description table for audit trail action type codes. Maps action type numbers to action type names

CAT : Synonym for USER_CATALOG

CLU : Synonym for USER_CLUSTERS

COLS : Synonym for USER_TAB_COLUMNS

COLUMN_PRIVILEGES : Grants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee

DATABASE_COMPATIBLE_LEVEL : Database compatible parameter set via init.ora



DBA_2PC_NEIGHBORS : information about incoming and outgoing connections for pending transactions

DBA_2PC_PENDING : info about distributed transactions awaiting recovery

DBA_ALL_TABLES : Description of all object and relational tables in the database

DBA_ANALYZE_OBJECTS :

DBA_APPLICATION_ROLES :

DBA_APPLY : Details about the apply process

DBA_APPLY_CONFLICT_COLUMNS : Details about conflict resolution

DBA_APPLY_DML_HANDLERS : Details about the dml handler

DBA_APPLY_ERROR : Error transactions

DBA_APPLY_INSTANTIATED_OBJECTS : Details about objects instantiated



DBA_APPLY_KEY_COLUMNS : alternative key columns for a table for STREAMS

DBA_APPLY_PARAMETERS : All parameters for apply process

DBA_APPLY_PROGRESS : Information about the progress made by apply process

DBA_AQ_AGENTS :

DBA_AQ_AGENT_PRIVS :

DBA_ASSOCIATIONS : All associations

DBA_ATTRIBUTE_TRANSFORMATIONS :

DBA_AUDIT_EXISTS : Lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS

DBA_AUDIT_OBJECT : Audit trail records for statements concerning objects, specifically: table, cluster, view, index, sequence, [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace, role, user

DBA_AUDIT_POLICIES : All fine grained auditing policies in the database



DBA_AUDIT_SESSION : All audit trail records concerning CONNECT and DISCONNECT

DBA_AUDIT_STATEMENT : Audit trail records concerning grant, revoke, audit, noaudit and alter system

DBA_AUDIT_TRAIL : All audit trail entries

DBA_AWS : Analytic Workspaces in the database

DBA_AW_PS : Pagespaces in Analytic Workspaces owned by the user

DBA_BASE_TABLE_MVIEWS : All materialized views with log(s) in the database

DBA_BLOCKERS :

DBA_CACHEABLE_NONTABLE_OBJECTS :

DBA_CACHEABLE_OBJECTS :

DBA_CACHEABLE_OBJECTS_BASE :



DBA_CACHEABLE_TABLES :

DBA_CACHEABLE_TABLES_BASE :

DBA_CAPTURE : Details about the capture process

DBA_CAPTURE_PARAMETERS : All parameters for capture process

DBA_CAPTURE_PREPARED_DATABASE : Is the local database prepared for instantiation?

DBA_CAPTURE_PREPARED_SCHEMAS : All schemas at the local database that are prepared for instantiation

DBA_CAPTURE_PREPARED_TABLES : All tables prepared for instantiation

DBA_CATALOG : All database Tables, Views, Synonyms, Sequences

DBA_CLUSTERS : Description of all clusters in the database

DBA_CLUSTER_HASH_EXPRESSIONS : Hash functions for all clusters



DBA_CLU_COLUMNS : Mapping of table columns to cluster columns

DBA_COLL_TYPES : Description of all named collection types in the database

DBA_COL_COMMENTS : Comments on columns of all tables and views

DBA_COL_PRIVS : All grants on columns in the database

DBA_CONSTRAINTS : Constraint definitions on all tables

DBA_CONS_COLUMNS : Information about accessible columns in constraint definitions

DBA_CONS_OBJ_COLUMNS : List of types an object column or attribute is constrained to in all tables in the database

DBA_CONTEXT : Description of all context namespace information

DBA_DATA_FILES : Information about database data files

DBA_DB_LINKS : All database links in the database



DBA_DDL_LOCKS :

DBA_DEPENDENCIES : Dependencies to and from objects

DBA_DIMENSIONS : Description of the dimension objects accessible to the DBA

DBA_DIM_ATTRIBUTES : Representation of the relationship between a dimension level and a functionally dependent column

DBA_DIM_CHILD_OF : Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension

DBA_DIM_HIERARCHIES : Representation of a dimension hierarchy

DBA_DIM_JOIN_KEY : Representation of a join between two dimension tables.

DBA_DIM_LEVELS : Description of dimension levels visible to DBA

DBA_DIM_LEVEL_KEY : Representations of columns of a dimension level

DBA_DIRECTORIES : Description of all directories



DBA_DML_LOCKS :

DBA_DMT_FREE_SPACE : Free extents in all dictionary managed tablespaces

DBA_DMT_USED_EXTENTS : All extents in the dictionary managed tablespaces

DBA_ERRORS : Current errors on all stored objects in the database

DBA_EVALUATION_CONTEXTS : rule evaluation contexts in the database

DBA_EVALUATION_CONTEXT_TABLES : tables in all rule evaluation contexts in the database

DBA_EVALUATION_CONTEXT_VARS : variables in all rule evaluation contexts in the database

DBA_EXP_FILES : Description of export files

DBA_EXP_OBJECTS : Objects that have been incrementally exported

DBA_EXP_VERSION : Version number of the last export session



DBA_EXTENTS : Extents comprising all segments in the database

DBA_EXTERNAL_LOCATIONS : Description of the external tables locations accessible to the DBA

DBA_EXTERNAL_TABLES : Description of the external tables accessible to the DBA

DBA_FGA_AUDIT_TRAIL : All fine grained audit event logs

DBA_FREE_SPACE : Free extents in all tablespaces

DBA_FREE_SPACE_COALESCED : Statistics on Coalesced Space in Tablespaces

DBA_FREE_SPACE_COALESCED_TMP1 :

DBA_FREE_SPACE_COALESCED_TMP2 :

DBA_FREE_SPACE_COALESCED_TMP3 :

DBA_GLOBAL_CONTEXT : Description of all context information accessible globally



DBA_HISTOGRAMS : Synonym for DBA_TAB_HISTOGRAMS

DBA_IAS_CONSTRAINT_EXP :

DBA_IAS_GEN_STMTS :

DBA_IAS_GEN_STMTS_EXP :

DBA_IAS_OBJECTS :

DBA_IAS_OBJECTS_BASE :

DBA_IAS_OBJECTS_EXP :

DBA_IAS_POSTGEN_STMTS :

DBA_IAS_PREGEN_STMTS :

DBA_IAS_SITES :



DBA_IAS_TEMPLATES :

DBA_INDEXES : Description for all indexes in the database

DBA_INDEXTYPES : All indextypes

DBA_INDEXTYPE_COMMENTS : Comments for user-defined indextypes

DBA_INDEXTYPE_OPERATORS : All indextype operators

DBA_IND_COLUMNS : COLUMNs comprising INDEXes on all TABLEs and CLUSTERs

DBA_IND_EXPRESSIONS : FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLUSTERS

DBA_IND_PARTITIONS :

DBA_IND_SUBPARTITIONS :

DBA_INTERNAL_TRIGGERS : Description of the internal triggers on all tables in the database



DBA_JAVA_ARGUMENTS : argument information of all stored java class

DBA_JAVA_CLASSES : class level information of all stored java classes

DBA_JAVA_DERIVATIONS : this view maps java source objects and their derived java class objects and java resource objects for all java classes

DBA_JAVA_FIELDS : field information of all stored java class

DBA_JAVA_IMPLEMENTS : interfaces implemented by the stored java class

DBA_JAVA_INNERS : list of inner classes refered by the stored java class

DBA_JAVA_LAYOUTS : class layout information about stored java class

DBA_JAVA_METHODS : method information of all stored java class

DBA_JAVA_NCOMPS :

DBA_JAVA_POLICY : java security Permissions for all users



DBA_JAVA_RESOLVERS : resolver of java class owned by user

DBA_JAVA_THROWS : list of exceptions thrown from a method of a class owned by user

DBA_JOBS : All jobs in the database

DBA_JOBS_RUNNING : All jobs in the database which are currently running, join v$lock and job$

DBA_JOIN_IND_COLUMNS : Join Index columns comprising the join conditions

DBA_KGLLOCK :

DBA_LIBRARIES : Description of all libraries in the database

DBA_LMT_FREE_SPACE : Free extents in all locally managed tablespaces

DBA_LMT_USED_EXTENTS : All extents in the locally managed tablespaces

DBA_LOBS : Description of LOBs contained in all tables



DBA_LOB_PARTITIONS :

DBA_LOB_SUBPARTITIONS :

DBA_LOB_TEMPLATES :

DBA_LOCK :

DBA_LOCKS : Synonym for DBA_LOCK

DBA_LOCK_INTERNAL :

DBA_LOGSTDBY_EVENTS : Information on why logical standby events

DBA_LOGSTDBY_LOG : List the information about received logs from the primary

DBA_LOGSTDBY_NOT_UNIQUE : List of all the tables with out primary or unique key not null constraints

DBA_LOGSTDBY_PARAMETERS : Miscellaneous options and settings for Logical Standby



DBA_LOGSTDBY_PROGRESS : List the SCN values describing read and apply progress

DBA_LOGSTDBY_SKIP : List the skip settings choosen

DBA_LOGSTDBY_SKIP_TRANSACTION : List the transactions to be skipped

DBA_LOGSTDBY_UNSUPPORTED : List of all the columns that are not supported by Logical Standby

DBA_LOG_GROUPS : Log group definitions on all tables

DBA_LOG_GROUP_COLUMNS : Information about columns in log group definitions

DBA_METHOD_PARAMS : Description of method parameters of all types in the database

DBA_METHOD_RESULTS : Description of method results of all types in the database

DBA_MVIEWS : All materialized views in the database

DBA_MVIEW_AGGREGATES : Description of the materialized view aggregates accessible to dba



DBA_MVIEW_ANALYSIS : Description of the materialized views accessible to dba

DBA_MVIEW_DETAIL_RELATIONS : Description of the materialized view detail tables accessible to dba

DBA_MVIEW_JOINS : Description of a join between two columns in the WHERE clause of a materialized view accessible to dba

DBA_MVIEW_KEYS : Description of the columns that appear in the GROUP BY list of a materialized view accessible to dba

DBA_MVIEW_LOGS : All materialized view logs in the database

DBA_MVIEW_LOG_FILTER_COLS : All filter columns (excluding PK cols) being logged in the materialized view logs

DBA_MVIEW_REFRESH_TIMES : All fast refreshable materialized views and their last refresh times for each master table

DBA_NESTED_TABLES : Description of nested tables contained in all tables

DBA_OBJECTS : All objects in the database

DBA_OBJECT_SIZE : Sizes, in bytes, of various pl/sql objects



DBA_OBJECT_TABLES : Description of all object tables in the database

DBA_OBJ_AUDIT_OPTS : Auditing options for all tables and views

DBA_OBJ_COLATTRS : Description of object columns and attributes contained in all tables in the database

DBA_OPANCILLARY : All ancillary operators

DBA_OPARGUMENTS : All operator arguments

DBA_OPBINDINGS : All operator binding functiosn or methods

DBA_OPERATORS : All operators

DBA_OPERATOR_COMMENTS : Comments for user-defined operators

DBA_OUTLINES : Stored outlines

DBA_OUTLINE_HINTS : Hints stored in outlines



DBA_PARTIAL_DROP_TABS : All tables with partially dropped columns in the database

DBA_PART_COL_STATISTICS :

DBA_PART_HISTOGRAMS :

DBA_PART_INDEXES :

DBA_PART_KEY_COLUMNS :

DBA_PART_LOBS :

DBA_PART_TABLES :

DBA_PENDING_CONV_TABLES : All tables which are not upgraded to the latest type version in the database

DBA_PENDING_TRANSACTIONS : information about unresolved global transactions

DBA_POLICIES : All row level security policies in the database



DBA_POLICY_CONTEXTS : All policy driving context defined for any synonym, table, or view in the database

DBA_POLICY_GROUPS : All policy groups defined for any synonym, table, view in the database

DBA_PRIV_AUDIT_OPTS : Describes current system privileges being audited across the system and by user

DBA_PROCEDURES : Description of all procedures

DBA_PROFILES : Display all profiles and their limits

DBA_PROPAGATION : Streams propagation in the database

DBA_PROXIES : Information about all proxy connections

DBA_PUBLISHED_COLUMNS :

DBA_QUEUES : All database queues

DBA_QUEUE_PUBLISHERS :



DBA_QUEUE_SCHEDULES :

DBA_QUEUE_TABLES : All queue tables created in the database

DBA_RCHILD : All the children in any refresh group. This view is not a join.

DBA_REFRESH : All the refresh groups

DBA_REFRESH_CHILDREN : All the objects in refresh groups

DBA_REFS : Description of REF columns contained in all tables

DBA_REGISTERED_MVIEWS : Remote materialized views of local tables

DBA_REGISTERED_MVIEW_GROUPS : Materialized view repgroup registration information

DBA_REGISTERED_SNAPSHOTS : Remote snapshots of local tables

DBA_REGISTERED_SNAPSHOT_GROUPS : Snapshot repgroup registration information



DBA_REGISTRY :

DBA_REGISTRY_HIERARCHY :

DBA_REPAUDIT_ATTRIBUTE : Information about attributes automatically maintained for replication

DBA_REPAUDIT_COLUMN : Information about columns in all shadow tables for all replicated tables in the database

DBA_REPCAT :

DBA_REPCATLOG : Information about asynchronous administration requests

DBA_REPCAT_EXCEPTIONS : Repcat processing exceptions table.

DBA_REPCAT_REFRESH_TEMPLATES :

DBA_REPCAT_TEMPLATE_OBJECTS :

DBA_REPCAT_TEMPLATE_PARMS :



DBA_REPCAT_TEMPLATE_SITES :

DBA_REPCAT_USER_AUTHORIZATIONS :

DBA_REPCAT_USER_PARM_VALUES :

DBA_REPCOLUMN : Replicated top-level columns (table) sorted alphabetically in ascending order

DBA_REPCOLUMN_GROUP : All column groups of replicated tables in the database

DBA_REPCONFLICT : All conflicts for which users have specified resolutions in the database

DBA_REPDDL : Arguments that do not fit in a single repcat log record

DBA_REPEXTENSIONS : Information about replication extension requests

DBA_REPFLAVORS : Flavors defined for replicated object groups

DBA_REPFLAVOR_COLUMNS : Replicated columns in flavors



DBA_REPFLAVOR_OBJECTS : Replicated objects in flavors

DBA_REPGENERATED : Objects generated to support replication

DBA_REPGENOBJECTS : Objects generated to support replication

DBA_REPGROUP : Information about all replicated object groups

DBA_REPGROUPED_COLUMN : Columns in the all column groups of replicated tables in the database

DBA_REPGROUP_PRIVILEGES : Information about users who are registered for object group privileges

DBA_REPKEY_COLUMNS : Primary columns for a table using column-level replication

DBA_REPOBJECT : Information about replicated objects

DBA_REPPARAMETER_COLUMN : All columns used for resolving conflicts in the database

DBA_REPPRIORITY : Values and their corresponding priorities in all priority groups in the database



DBA_REPPRIORITY_GROUP : Information about all priority groups in the database

DBA_REPPROP : Propagation information about replicated objects

DBA_REPRESOLUTION : Description of all conflict resolutions in the database

DBA_REPRESOLUTION_METHOD : All conflict resolution methods in the database

DBA_REPRESOLUTION_STATISTICS : Statistics for conflict resolutions for all replicated tables in the database

DBA_REPRESOL_STATS_CONTROL : Information about statistics collection for conflict resolutions for all replicated tables in the database

DBA_REPSCHEMA : N-way replication information

DBA_REPSITES : N-way replication information

DBA_REPSITES_NEW : Information about new masters for replication extension

DBA_RESUMABLE : Resumable session information in the system



DBA_RGROUP : All refresh groups. This view is not a join.

DBA_ROLES : All Roles which exist in the database

DBA_ROLE_PRIVS : Roles granted to users and roles

DBA_ROLLBACK_SEGS : Description of rollback segments

DBA_RSRC_CONSUMER_GROUPS : all the resource consumer groups

DBA_RSRC_CONSUMER_GROUP_PRIVS : Switch privileges for consumer groups

DBA_RSRC_MANAGER_SYSTEM_PRIVS : system privileges for the resource manager

DBA_RSRC_PLANS : All the resource plans

DBA_RSRC_PLAN_DIRECTIVES : all the resource plan directives

DBA_RULES : Rules in the databse



DBA_RULESETS : Rulesets in the database: maintained for backward compatibility

DBA_RULE_SETS : Rule sets in the database

DBA_RULE_SET_RULES : Rules in all rule sets in the database

DBA_SECONDARY_OBJECTS : All secondary objects for domain indexes

DBA_SEGMENTS : Storage allocated for all database segments

DBA_SEQUENCES : Description of all SEQUENCEs in the database

DBA_SNAPSHOTS : All snapshots in the database

DBA_SNAPSHOT_LOGS : All snapshot logs in the database

DBA_SNAPSHOT_LOG_FILTER_COLS : Synonym for DBA_MVIEW_LOG_FILTER_COLS

DBA_SNAPSHOT_REFRESH_TIMES : Synonym for DBA_MVIEW_REFRESH_TIMES



DBA_SOURCE : Source of all stored objects in the database

DBA_SOURCE_TABLES :

DBA_SOURCE_TAB_COLUMNS :

DBA_SQLJ_TYPES : Description of all types in the database

DBA_SQLJ_TYPE_ATTRS : Description of attributes of all types in the database

DBA_SQLJ_TYPE_METHODS : Description of methods of all types in the database

DBA_STMT_AUDIT_OPTS : Describes current system auditing options across the system and by user

DBA_STORED_SETTINGS : Parameter settings for all objects

DBA_STREAMS_GLOBAL_RULES : Global rules created by streams administrative APIs

DBA_STREAMS_SCHEMA_RULES : Schema rules created by streams administrative APIs



DBA_STREAMS_TABLE_RULES : Table rules created by streams administrative APIs

DBA_SUBPARTITION_TEMPLATES :

DBA_SUBPART_COL_STATISTICS :

DBA_SUBPART_HISTOGRAMS :

DBA_SUBPART_KEY_COLUMNS :

DBA_SUBSCRIBED_COLUMNS :

DBA_SUBSCRIBED_TABLES :

DBA_SUBSCRIPTIONS :

DBA_SUMMARIES : Description of the summaries accessible to dba

DBA_SUMMARY_AGGREGATES :



DBA_SUMMARY_DETAIL_TABLES :

DBA_SUMMARY_JOINS :

DBA_SUMMARY_KEYS :

DBA_SYNONYMS : All synonyms in the database

DBA_SYS_PRIVS : System privileges granted to users and roles

DBA_TABLES : Description of all relational tables in the database

DBA_TABLESPACES : Description of all tablespaces

DBA_TAB_COLS : Columns of user's tables, views and clusters

DBA_TAB_COLUMNS : Columns of user's tables, views and clusters

DBA_TAB_COL_STATISTICS : Columns of user's tables, views and clusters



DBA_TAB_COMMENTS : Comments on all tables and views in the database

DBA_TAB_HISTOGRAMS : Histograms on columns of all tables

DBA_TAB_MODIFICATIONS : Information regarding modifications to tables

DBA_TAB_PARTITIONS :

DBA_TAB_PRIVS : All grants on objects in the database

DBA_TAB_SUBPARTITIONS :

DBA_TEMPLATE_REFGROUPS : Table for maintaining refresh group information for template.

DBA_TEMPLATE_TARGETS : Internal table for tracking potential target databases for templates.

DBA_TEMP_FILES : Information about database temp files

DBA_TRANSFORMATIONS :



DBA_TRIGGERS : All triggers in the database

DBA_TRIGGER_COLS : Column usage in all triggers

DBA_TS_QUOTAS : Tablespace quotas for all users

DBA_TYPES : Description of all types in the database

DBA_TYPE_ATTRS : Description of attributes of all types in the database

DBA_TYPE_METHODS : Description of methods of all types in the database

DBA_TYPE_VERSIONS : Description of each type version in the database

DBA_UNDO_EXTENTS : Extents comprising all segments in the system managed undo tablespaces

DBA_UNUSED_COL_TABS : All tables with unused columns in the database

DBA_UPDATABLE_COLUMNS : Description of dba updatable columns



DBA_USERS : Information about all users of the database

DBA_USTATS : All statistics collected on either tables or indexes

DBA_VARRAYS : Description of varrays in tables accessible to the user

DBA_VIEWS : Description of all views in the database

DBA_WAITERS :

DBA_WORKSPACES :

DBA_WORKSPACE_SESSIONS :

DBMS_ALERT_INFO :

DBMS_LOCK_ALLOCATED :

DICT : Synonym for DICTIONARY



DICTIONARY : Description of data dictionary tables and views

DICT_COLUMNS : Description of columns in data dictionary tables and views

DUAL :

GLOBAL_NAME : global database name

GV$ACCESS : Synonym for GV_$ACCESS

GV$ACTIVE_INSTANCES : Synonym for GV_$ACTIVE_INSTANCES

GV$ACTIVE_SESS_POOL_MTH : Synonym for GV_$ACTIVE_SESS_POOL_MTH

GV$AQ : Synonym for GV_$AQ

GV$AQ1 : Synonym for GV_$AQ1

GV$ARCHIVE : Synonym for GV_$ARCHIVE



GV$ARCHIVED_LOG : Synonym for GV_$ARCHIVED_LOG

GV$ARCHIVE_DEST : Synonym for GV_$ARCHIVE_DEST

GV$ARCHIVE_DEST_STATUS : Synonym for GV_$ARCHIVE_DEST_STATUS

GV$ARCHIVE_GAP : Synonym for GV_$ARCHIVE_GAP

GV$ARCHIVE_PROCESSES : Synonym for GV_$ARCHIVE_PROCESSES

GV$AW_CALC : Synonym for GV_$AW_CALC

GV$AW_OLAP : Synonym for GV_$AW_OLAP

GV$AW_SESSION_INFO : Synonym for GV_$AW_SESSION_INFO

GV$BACKUP : Synonym for GV_$BACKUP

GV$BACKUP_ASYNC_IO : Synonym for GV_$BACKUP_ASYNC_IO



GV$BACKUP_CORRUPTION : Synonym for GV_$BACKUP_CORRUPTION

GV$BACKUP_DATAFILE : Synonym for GV_$BACKUP_DATAFILE

GV$BACKUP_DEVICE : Synonym for GV_$BACKUP_DEVICE

GV$BACKUP_PIECE : Synonym for GV_$BACKUP_PIECE

GV$BACKUP_REDOLOG : Synonym for GV_$BACKUP_REDOLOG

GV$BACKUP_SET : Synonym for GV_$BACKUP_SET

GV$BACKUP_SPFILE : Synonym for GV_$BACKUP_SPFILE

GV$BACKUP_SYNC_IO : Synonym for GV_$BACKUP_SYNC_IO

GV$BGPROCESS : Synonym for GV_$BGPROCESS

GV$BH : Synonym for GV_$BH



GV$BSP : Synonym for GV_$BSP

GV$BUFFER_POOL : Synonym for GV_$BUFFER_POOL

GV$BUFFER_POOL_STATISTICS : Synonym for GV_$BUFFER_POOL_STATISTICS

GV$CIRCUIT : Synonym for GV_$CIRCUIT

GV$CLASS_CACHE_TRANSFER : Synonym for GV_$CLASS_CACHE_TRANSFER

GV$CLASS_PING : Synonym for GV_$CLASS_PING

GV$COMPATIBILITY : Synonym for GV_$COMPATIBILITY

GV$COMPATSEG : Synonym for GV_$COMPATSEG

GV$CONTEXT : Synonym for GV_$CONTEXT

GV$CONTROLFILE : Synonym for GV_$CONTROLFILE



GV$CONTROLFILE_RECORD_SECTION : Synonym for GV_$CONTROLFILE_RECORD_SECTION

GV$COPY_CORRUPTION : Synonym for GV_$COPY_CORRUPTION

GV$CR_BLOCK_SERVER : Synonym for GV_$CR_BLOCK_SERVER

GV$DATABASE : Synonym for GV_$DATABASE

GV$DATABASE_BLOCK_CORRUPTION : Synonym for GV_$DATABASE_BLOCK_CORRUPTION

GV$DATABASE_INCARNATION : Synonym for GV_$DATABASE_INCARNATION

GV$DATAFILE : Synonym for GV_$DATAFILE

GV$DATAFILE_COPY : Synonym for GV_$DATAFILE_COPY

GV$DATAFILE_HEADER : Synonym for GV_$DATAFILE_HEADER

GV$DATAGUARD_STATUS : Synonym for GV_$DATAGUARD_STATUS



GV$DBFILE : Synonym for GV_$DBFILE

GV$DBLINK : Synonym for GV_$DBLINK

GV$DB_CACHE_ADVICE : Synonym for GV_$DB_CACHE_ADVICE

GV$DB_OBJECT_CACHE : Synonym for GV_$DB_OBJECT_CACHE

GV$DB_PIPES : Synonym for GV_$DB_PIPES

GV$DELETED_OBJECT : Synonym for GV_$DELETED_OBJECT

GV$DISPATCHER : Synonym for GV_$DISPATCHER

GV$DISPATCHER_RATE : Synonym for GV_$DISPATCHER_RATE

GV$DLM_ALL_LOCKS : Synonym for GV_$DLM_ALL_LOCKS

GV$DLM_CONVERT_LOCAL : Synonym for GV_$DLM_CONVERT_LOCAL



GV$DLM_CONVERT_REMOTE : Synonym for GV_$DLM_CONVERT_REMOTE

GV$DLM_LATCH : Synonym for GV_$DLM_LATCH

GV$DLM_LOCKS : Synonym for GV_$DLM_LOCKS

GV$DLM_MISC : Synonym for GV_$DLM_MISC

GV$DLM_RESS : Synonym for GV_$DLM_RESS

GV$DLM_TRAFFIC_CONTROLLER : Synonym for GV_$DLM_TRAFFIC_CONTROLLER

GV$ENABLEDPRIVS : Synonym for GV_$ENABLEDPRIVS

GV$ENQUEUE_LOCK : Synonym for GV_$ENQUEUE_LOCK

GV$ENQUEUE_STAT : Synonym for GV_$ENQUEUE_STAT

GV$EVENT_NAME : Synonym for GV_$EVENT_NAME



GV$EXECUTION : Synonym for GV_$EXECUTION

GV$FAST_START_SERVERS : Synonym for GV_$FAST_START_SERVERS

GV$FAST_START_TRANSACTIONS : Synonym for GV_$FAST_START_TRANSACTIONS

GV$FILESTAT : Synonym for GV_$FILESTAT

GV$FILE_CACHE_TRANSFER : Synonym for GV_$FILE_CACHE_TRANSFER

GV$FILE_PING : Synonym for GV_$FILE_PING

GV$FIXED_TABLE : Synonym for GV_$FIXED_TABLE

GV$FIXED_VIEW_DEFINITION : Synonym for GV_$FIXED_VIEW_DEFINITION

GV$GCSHVMASTER_INFO : Synonym for GV_$GCSHVMASTER_INFO

GV$GCSPFMASTER_INFO : Synonym for GV_$GCSPFMASTER_INFO



GV$GC_ELEMENT : Synonym for GV_$GC_ELEMENT

GV$GC_ELEMENTS_WITH_COLLISIONS : Synonym for GV_$GC_ELEMENTS_W_COLLISIONS

GV$GES_BLOCKING_ENQUEUE : Synonym for GV_$GES_BLOCKING_ENQUEUE

GV$GES_ENQUEUE : Synonym for GV_$GES_ENQUEUE

GV$GLOBALCONTEXT : Synonym for GV_$GLOBALCONTEXT

GV$GLOBAL_BLOCKED_LOCKS : Synonym for GV_$GLOBAL_BLOCKED_LOCKS

GV$GLOBAL_TRANSACTION : Synonym for GV_$GLOBAL_TRANSACTION

GV$HS_AGENT : Synonym for GV_$HS_AGENT

GV$HS_PARAMETER : Synonym for GV_$HS_PARAMETER

GV$HS_SESSION : Synonym for GV_$HS_SESSION



GV$HVMASTER_INFO : Synonym for GV_$HVMASTER_INFO

GV$INDEXED_FIXED_COLUMN : Synonym for GV_$INDEXED_FIXED_COLUMN

GV$INSTANCE : Synonym for GV_$INSTANCE

GV$INSTANCE_RECOVERY : Synonym for GV_$INSTANCE_RECOVERY

GV$LATCH : Synonym for GV_$LATCH

GV$LATCHHOLDER : Synonym for GV_$LATCHHOLDER

GV$LATCHNAME : Synonym for GV_$LATCHNAME

GV$LATCH_CHILDREN : Synonym for GV_$LATCH_CHILDREN

GV$LATCH_MISSES : Synonym for GV_$LATCH_MISSES

GV$LATCH_PARENT : Synonym for GV_$LATCH_PARENT



GV$LIBRARYCACHE : Synonym for GV_$LIBRARYCACHE

GV$LIBRARY_CACHE_MEMORY : Synonym for GV_$LIBRARY_CACHE_MEMORY

GV$LICENSE : Synonym for GV_$LICENSE

GV$LOADISTAT : Synonym for GV_$LOADISTAT

GV$LOADPSTAT : Synonym for GV_$LOADPSTAT

GV$LOCK : Synonym for GV_$LOCK

GV$LOCKED_OBJECT : Synonym for GV_$LOCKED_OBJECT

GV$LOCKS_WITH_COLLISIONS : Synonym for GV_$LOCKS_WITH_COLLISIONS

GV$LOCK_ACTIVITY : Synonym for GV_$LOCK_ACTIVITY

GV$LOCK_ELEMENT : Synonym for GV_$LOCK_ELEMENT



GV$LOG : Synonym for GV_$LOG

GV$LOGFILE : Synonym for GV_$LOGFILE

GV$LOGHIST : Synonym for GV_$LOGHIST

GV$LOGMNR_CALLBACK : Synonym for GV_$LOGMNR_CALLBACK

GV$LOGMNR_CONTENTS : Synonym for GV_$LOGMNR_CONTENTS

GV$LOGMNR_DICTIONARY : Synonym for GV_$LOGMNR_DICTIONARY

GV$LOGMNR_LOGFILE : Synonym for GV_$LOGMNR_LOGFILE

GV$LOGMNR_LOGS : Synonym for GV_$LOGMNR_LOGS

GV$LOGMNR_PARAMETERS : Synonym for GV_$LOGMNR_PARAMETERS

GV$LOGMNR_PROCESS : Synonym for GV_$LOGMNR_PROCESS



GV$LOGMNR_REGION : Synonym for GV_$LOGMNR_REGION

GV$LOGMNR_SESSION : Synonym for GV_$LOGMNR_SESSION

GV$LOGMNR_STATS : Synonym for GV_$LOGMNR_STATS

GV$LOGMNR_TRANSACTION : Synonym for GV_$LOGMNR_TRANSACTION

GV$LOGSTDBY : Synonym for GV_$LOGSTDBY

GV$LOGSTDBY_STATS : Synonym for GV_$LOGSTDBY_STATS

GV$LOG_HISTORY : Synonym for GV_$LOG_HISTORY

GV$MANAGED_STANDBY : Synonym for GV_$MANAGED_STANDBY

GV$MAP_COMP_LIST : Synonym for GV_$MAP_COMP_LIST

GV$MAP_ELEMENT : Synonym for GV_$MAP_ELEMENT



GV$MAP_EXT_ELEMENT : Synonym for GV_$MAP_EXT_ELEMENT

GV$MAP_FILE : Synonym for GV_$MAP_FILE

GV$MAP_FILE_EXTENT : Synonym for GV_$MAP_FILE_EXTENT

GV$MAP_FILE_IO_STACK : Synonym for GV_$MAP_FILE_IO_STACK

GV$MAP_LIBRARY : Synonym for GV_$MAP_LIBRARY

GV$MAP_SUBELEMENT : Synonym for GV_$MAP_SUBELEMENT

GV$MAX_ACTIVE_SESS_TARGET_MTH : Synonym for GV_$MAX_ACTIVE_SESS_TARGET_MTH

GV$MLS_PARAMETERS : Synonym for GV_$MLS_PARAMETERS

GV$MTS : Synonym for GV_$MTS

GV$MTTR_TARGET_ADVICE : Synonym for GV_$MTTR_TARGET_ADVICE



GV$MVREFRESH : Synonym for GV_$MVREFRESH

GV$MYSTAT : Synonym for GV_$MYSTAT

GV$NLS_PARAMETERS : Synonym for GV_$NLS_PARAMETERS

GV$NLS_VALID_VALUES : Synonym for GV_$NLS_VALID_VALUES

GV$OBJECT_DEPENDENCY : Synonym for GV_$OBJECT_DEPENDENCY

GV$OBSOLETE_PARAMETER : Synonym for GV_$OBSOLETE_PARAMETER

GV$OFFLINE_RANGE : Synonym for GV_$OFFLINE_RANGE

GV$OPEN_CURSOR : Synonym for GV_$OPEN_CURSOR

GV$OPTION : Synonym for GV_$OPTION

GV$PARALLEL_DEGREE_LIMIT_MTH : Synonym for GV_$PARALLEL_DEGREE_LIMIT_MTH



GV$PARAMETER : Synonym for GV_$PARAMETER

GV$PARAMETER2 : Synonym for GV_$PARAMETER2

GV$PGASTAT : Synonym for GV_$PGASTAT

GV$PGA_TARGET_ADVICE : Synonym for GV_$PGA_TARGET_ADVICE

GV$PGA_TARGET_ADVICE_HISTOGRAM : Synonym for GV_$PGATARGET_ADVICE_HISTOGRAM

GV$PQ_SESSTAT : Synonym for GV_$PQ_SESSTAT

GV$PQ_SLAVE : Synonym for GV_$PQ_SLAVE

GV$PQ_SYSSTAT : Synonym for GV_$PQ_SYSSTAT

GV$PQ_TQSTAT : Synonym for GV_$PQ_TQSTAT

GV$PROCESS : Synonym for GV_$PROCESS



GV$PROXY_ARCHIVEDLOG : Synonym for GV_$PROXY_ARCHIVEDLOG

GV$PROXY_DATAFILE : Synonym for GV_$PROXY_DATAFILE

GV$PWFILE_USERS : Synonym for GV_$PWFILE_USERS

GV$PX_PROCESS : Synonym for GV_$PX_PROCESS

GV$PX_PROCESS_SYSSTAT : Synonym for GV_$PX_PROCESS_SYSSTAT

GV$PX_SESSION : Synonym for GV_$PX_SESSION

GV$PX_SESSTAT : Synonym for GV_$PX_SESSTAT

GV$QUEUE : Synonym for GV_$QUEUE

GV$QUEUEING_MTH : Synonym for GV_$QUEUEING_MTH

GV$RECOVERY_FILE_STATUS : Synonym for GV_$RECOVERY_FILE_STATUS



GV$RECOVERY_LOG : Synonym for GV_$RECOVERY_LOG

GV$RECOVERY_PROGRESS : Synonym for GV_$RECOVERY_PROGRESS

GV$RECOVERY_STATUS : Synonym for GV_$RECOVERY_STATUS

GV$RECOVER_FILE : Synonym for GV_$RECOVER_FILE

GV$REPLPROP : Synonym for GV_$REPLPROP

GV$REPLQUEUE : Synonym for GV_$REPLQUEUE

GV$REQDIST : Synonym for GV_$REQDIST

GV$RESERVED_WORDS : Synonym for GV_$RESERVED_WORDS

GV$RESOURCE : Synonym for GV_$RESOURCE

GV$RESOURCE_LIMIT : Synonym for GV_$RESOURCE_LIMIT



GV$RESUMABLE : Synonym for GV_$RESUMABLE

GV$RMAN_CONFIGURATION : Synonym for GV_$RMAN_CONFIGURATION

GV$ROLLSTAT : Synonym for GV_$ROLLSTAT

GV$ROWCACHE : Synonym for GV_$ROWCACHE

GV$ROWCACHE_PARENT : Synonym for GV_$ROWCACHE_PARENT

GV$ROWCACHE_SUBORDINATE : Synonym for GV_$ROWCACHE_SUBORDINATE

GV$RSRC_CONSUMER_GROUP : Synonym for GV_$RSRC_CONSUMER_GROUP

GV$RSRC_CONSUMER_GROUP_CPU_MTH : Synonym for GV_$RSRC_CONSUME_GROUP_CPU_MTH

GV$RSRC_PLAN : Synonym for GV_$RSRC_PLAN

GV$RSRC_PLAN_CPU_MTH : Synonym for GV_$RSRC_PLAN_CPU_MTH



GV$SEGMENT_STATISTICS : Synonym for GV_$SEGMENT_STATISTICS

GV$SEGSTAT : Synonym for GV_$SEGSTAT

GV$SEGSTAT_NAME : Synonym for GV_$SEGSTAT_NAME

GV$SESSION : Synonym for GV_$SESSION

GV$SESSION_CONNECT_INFO : Synonym for GV_$SESSION_CONNECT_INFO

GV$SESSION_CURSOR_CACHE : Synonym for GV_$SESSION_CURSOR_CACHE

GV$SESSION_EVENT : Synonym for GV_$SESSION_EVENT

GV$SESSION_LONGOPS : Synonym for GV_$SESSION_LONGOPS

GV$SESSION_OBJECT_CACHE : Synonym for GV_$SESSION_OBJECT_CACHE

GV$SESSION_WAIT : Synonym for GV_$SESSION_WAIT



GV$SESSTAT : Synonym for GV_$SESSTAT

GV$SESS_IO : Synonym for GV_$SESS_IO

GV$SGA : Synonym for GV_$SGA

GV$SGASTAT : Synonym for GV_$SGASTAT

GV$SGA_CURRENT_RESIZE_OPS : Synonym for GV_$SGA_CURRENT_RESIZE_OPS

GV$SGA_DYNAMIC_COMPONENTS : Synonym for GV_$SGA_DYNAMIC_COMPONENTS

GV$SGA_DYNAMIC_FREE_MEMORY : Synonym for GV_$SGA_DYNAMIC_FREE_MEMORY

GV$SGA_RESIZE_OPS : Synonym for GV_$SGA_RESIZE_OPS

GV$SHARED_POOL_ADVICE : Synonym for GV_$SHARED_POOL_ADVICE

GV$SHARED_POOL_RESERVED : Synonym for GV_$SHARED_POOL_RESERVED



GV$SHARED_SERVER : Synonym for GV_$SHARED_SERVER

GV$SHARED_SERVER_MONITOR : Synonym for GV_$SHARED_SERVER_MONITOR

GV$SORT_SEGMENT : Synonym for GV_$SORT_SEGMENT

GV$SORT_USAGE : Synonym for GV_$SORT_USAGE

GV$SPPARAMETER : Synonym for GV_$SPPARAMETER

GV$SQL : Synonym for GV_$SQL

GV$SQLAREA : Synonym for GV_$SQLAREA

GV$SQLTEXT : Synonym for GV_$SQLTEXT

GV$SQLTEXT_WITH_NEWLINES : Synonym for GV_$SQLTEXT_WITH_NEWLINES

GV$SQL_BIND_DATA : Synonym for GV_$SQL_BIND_DATA



GV$SQL_BIND_METADATA : Synonym for GV_$SQL_BIND_METADATA

GV$SQL_CURSOR : Synonym for GV_$SQL_CURSOR

GV$SQL_PLAN : Synonym for GV_$SQL_PLAN

GV$SQL_PLAN_STATISTICS : Synonym for GV_$SQL_PLAN_STATISTICS

GV$SQL_PLAN_STATISTICS_ALL : Synonym for GV_$SQL_PLAN_STATISTICS_ALL

GV$SQL_REDIRECTION : Synonym for GV_$SQL_REDIRECTION

GV$SQL_SHARED_CURSOR : Synonym for GV_$SQL_SHARED_CURSOR

GV$SQL_SHARED_MEMORY : Synonym for GV_$SQL_SHARED_MEMORY

GV$SQL_WORKAREA : Synonym for GV_$SQL_WORKAREA

GV$SQL_WORKAREA_ACTIVE : Synonym for GV_$SQL_WORKAREA_ACTIVE



GV$SQL_WORKAREA_HISTOGRAM : Synonym for GV_$SQL_WORKAREA_HISTOGRAM

GV$STANDBY_LOG : Synonym for GV_$STANDBY_LOG

GV$STATISTICS_LEVEL : Synonym for GV_$STATISTICS_LEVEL

GV$STATNAME : Synonym for GV_$STATNAME

GV$STREAMS_APPLY_COORDINATOR : Synonym for GV_$STREAMS_APPLY_COORDINATOR

GV$STREAMS_APPLY_READER : Synonym for GV_$STREAMS_APPLY_READER

GV$STREAMS_APPLY_SERVER : Synonym for GV_$STREAMS_APPLY_SERVER

GV$STREAMS_CAPTURE : Synonym for GV_$STREAMS_CAPTURE

GV$SUBCACHE : Synonym for GV_$SUBCACHE

GV$SYSSTAT : Synonym for GV_$SYSSTAT



GV$SYSTEM_CURSOR_CACHE : Synonym for GV_$SYSTEM_CURSOR_CACHE

GV$SYSTEM_EVENT : Synonym for GV_$SYSTEM_EVENT

GV$SYSTEM_PARAMETER : Synonym for GV_$SYSTEM_PARAMETER

GV$SYSTEM_PARAMETER2 : Synonym for GV_$SYSTEM_PARAMETER2

GV$TABLESPACE : Synonym for GV_$TABLESPACE

GV$TEMPFILE : Synonym for GV_$TEMPFILE

GV$TEMPORARY_LOBS : Synonym for GV_$TEMPORARY_LOBS

GV$TEMPSEG_USAGE : Synonym for GV_$SORT_USAGE

GV$TEMPSTAT : Synonym for GV_$TEMPSTAT

GV$TEMP_CACHE_TRANSFER : Synonym for GV_$TEMP_CACHE_TRANSFER



GV$TEMP_EXTENT_MAP : Synonym for GV_$TEMP_EXTENT_MAP

GV$TEMP_EXTENT_POOL : Synonym for GV_$TEMP_EXTENT_POOL

GV$TEMP_PING : Synonym for GV_$TEMP_PING

GV$TEMP_SPACE_HEADER : Synonym for GV_$TEMP_SPACE_HEADER

GV$THREAD : Synonym for GV_$THREAD

GV$TIMER : Synonym for GV_$TIMER

GV$TIMEZONE_NAMES : Synonym for GV_$TIMEZONE_NAMES

GV$TRANSACTION : Synonym for GV_$TRANSACTION

GV$TRANSACTION_ENQUEUE : Synonym for GV_$TRANSACTION_ENQUEUE

GV$TYPE_SIZE : Synonym for GV_$TYPE_SIZE



GV$UNDOSTAT : Synonym for GV_$UNDOSTAT

GV$VERSION : Synonym for GV_$VERSION

GV$VPD_POLICY : Synonym for GV_$VPD_POLICY

GV$WAITSTAT : Synonym for GV_$WAITSTAT

GV$_LOCK : Synonym for GV_$_LOCK

IND : Synonym for USER_INDEXES

INDEX_HISTOGRAM : statistics on keys with repeat count

INDEX_STATS : statistics on the b-tree

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

OBJ : Synonym for USER_OBJECTS

RESOURCE_COST : Cost for each resource

ROLE_ROLE_PRIVS : Roles which are granted to roles

ROLE_SYS_PRIVS : System privileges granted to roles

ROLE_TAB_PRIVS : Table privileges granted to roles

SEQ : Synonym for USER_SEQUENCES

SESSION_PRIVS : Privileges which the user currently has set

SESSION_ROLES : Roles which the user currently has enabled.

SM$VERSION : Synonym for SM_$VERSION



SYN : Synonym for USER_SYNONYMS

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

TABS : Synonym for USER_TABLES

USER_ALL_TABLES : Description of all object and relational tables owned by the user's

USER_APPLICATION_ROLES :

USER_AQ_AGENT_PRIVS :

USER_ARGUMENTS : Arguments in object accessible to the user

USER_ASSOCIATIONS : All assocations defined by the user

USER_ATTRIBUTE_TRANSFORMATIONS :

USER_AUDIT_OBJECT : Audit trail records for statements concerning objects, specifically: table, cluster, view, index, sequence, [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace, role, user



USER_AUDIT_POLICIES : All fine grained auditing policies for objects in user schema

USER_AUDIT_SESSION : All audit trail records concerning CONNECT and DISCONNECT

USER_AUDIT_STATEMENT : Audit trail records concerning grant, revoke, audit, noaudit and alter system

USER_AUDIT_TRAIL : Audit trail entries relevant to the user

USER_AWS : Analytic Workspaces owned by the user

USER_AW_PS : Pagespaces in Analytic Workspaces owned by the user

USER_BASE_TABLE_MVIEWS : All materialized views with log(s) owned by the user in the database

USER_CATALOG : Tables, Views, Synonyms and Sequences owned by the user

USER_CLUSTERS : Descriptions of user's own clusters

USER_CLUSTER_HASH_EXPRESSIONS : Hash functions for the user's hash clusters



USER_CLU_COLUMNS : Mapping of table columns to cluster columns

USER_COLL_TYPES : Description of the user's own named collection types

USER_COL_COMMENTS : Comments on columns of user's tables and views

USER_COL_PRIVS : Grants on columns for which the user is the owner, grantor or grantee

USER_COL_PRIVS_MADE : All grants on columns of objects owned by the user

USER_COL_PRIVS_RECD : Grants on columns for which the user is the grantee

USER_CONSTRAINTS : Constraint definitions on user's own tables

USER_CONS_COLUMNS : Information about accessible columns in constraint definitions

USER_CONS_OBJ_COLUMNS : List of types an object column or attribute is constrained to in the tables owned by the user

USER_DB_LINKS : Database links owned by the user



USER_DEPENDENCIES : Dependencies to and from a users objects

USER_DIMENSIONS : Description of the dimension objects accessible to the DBA

USER_DIM_ATTRIBUTES : Representation of the relationship between a dimension level and a functionally dependent column

USER_DIM_CHILD_OF : Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension

USER_DIM_HIERARCHIES : Representation of a dimension hierarchy

USER_DIM_JOIN_KEY : Representation of a join between two dimension tables.

USER_DIM_LEVELS : Description of dimension levels visible to DBA

USER_DIM_LEVEL_KEY : Representations of columns of a dimension level

USER_ERRORS : Current errors on stored objects owned by the user

USER_EVALUATION_CONTEXTS : rule evaluation contexts owned by user



USER_EVALUATION_CONTEXT_TABLES : tables in user rule evaluation contexts

USER_EVALUATION_CONTEXT_VARS : variables in user rule evaluation contexts

USER_EXTENTS : Extents comprising segments owned by the user

USER_EXTERNAL_LOCATIONS : Description of the user's external tables locations

USER_EXTERNAL_TABLES : Description of the user's own external tables

USER_FREE_SPACE : Free extents in tablespaces accessible to the user

USER_HISTOGRAMS : Synonym for USER_TAB_HISTOGRAMS

USER_INDEXES : Description of the user's own indexes

USER_INDEXTYPES : All user indextypes

USER_INDEXTYPE_COMMENTS : Comments for user-defined indextypes



USER_INDEXTYPE_OPERATORS : All user indextype operators

USER_IND_COLUMNS : COLUMNs comprising user's INDEXes and INDEXes on user's TABLES

USER_IND_EXPRESSIONS : Functional index expressions in user's indexes and indexes on user's tables

USER_IND_PARTITIONS :

USER_IND_SUBPARTITIONS :

USER_INTERNAL_TRIGGERS : Description of the internal triggers on the user's own tables

USER_JAVA_ARGUMENTS : argument information of stored java class owned by the user

USER_JAVA_CLASSES : class level information of stored java class owned by the user

USER_JAVA_DERIVATIONS : this view maps java source objects and their derived java class objects and java resource objects for the java class owned by user

USER_JAVA_FIELDS : field information of stored java class owned by the user



USER_JAVA_IMPLEMENTS : interfaces implemented by the stored java class owned by user

USER_JAVA_INNERS : list of inner classes refered by the stored java class owned by user

USER_JAVA_LAYOUTS : class layout information about stored java class owned by the user

USER_JAVA_METHODS : method information of stored java class owned by the user

USER_JAVA_NCOMPS : ncomp related information of java classes owned by user

USER_JAVA_POLICY : java security Permissions for current user

USER_JAVA_RESOLVERS : resolver of java class owned by user

USER_JAVA_THROWS : list of exceptions thrown from a method of a class owned by user

USER_JOBS : All jobs owned by this user

USER_JOIN_IND_COLUMNS : Join Index columns comprising the join conditions



USER_LIBRARIES : Description of the user's own libraries

USER_LOBS : Description of the user's own LOBs contained in the user's own tables

USER_LOB_PARTITIONS :

USER_LOB_SUBPARTITIONS :

USER_LOB_TEMPLATES :

USER_LOG_GROUPS : Log group definitions on user's own tables

USER_LOG_GROUP_COLUMNS : Information about columns in log group definitions

USER_METHOD_PARAMS : Description of method parameters of the user's own types

USER_METHOD_RESULTS : Description of method results of the user's own types

USER_MVIEWS : All materialized views in the database



USER_MVIEW_AGGREGATES : Description of the materialized view aggregates created by the user

USER_MVIEW_ANALYSIS : Description of the materialized views created by the user

USER_MVIEW_DETAIL_RELATIONS : Description of the materialized view detail tables of the materialized views created by the user

USER_MVIEW_JOINS : Description of a join between two columns in the WHERE clause of a materialized view created by the user

USER_MVIEW_KEYS : Description of the columns that appear in the GROUP BY list of a materialized view created by the user

USER_MVIEW_LOGS : All materialized view logs owned by the user

USER_MVIEW_REFRESH_TIMES : Materialized views and their last refresh times for each master table that the user can look at

USER_NESTED_TABLES : Description of nested tables contained in the user's own tables

USER_OBJECTS : Objects owned by the user

USER_OBJECT_SIZE : Sizes, in bytes, of various pl/sql objects



USER_OBJECT_TABLES : Description of the user's own object tables

USER_OBJ_AUDIT_OPTS : Auditing options for user's own tables and views

USER_OBJ_COLATTRS : Description of object columns and attributes contained in tables owned by the user

USER_OPANCILLARY : All ancillary opertors defined by user

USER_OPARGUMENTS : All operator arguments of operators defined by user

USER_OPBINDINGS : All binding functions or methods on operators defined by the user

USER_OPERATORS : All user operators

USER_OPERATOR_COMMENTS : Comments for user-defined operators

USER_OUTLINES : Stored outlines owned by the user

USER_OUTLINE_HINTS : Hints stored in outlines owned by the user



USER_PARTIAL_DROP_TABS : User tables with unused columns

USER_PART_COL_STATISTICS :

USER_PART_HISTOGRAMS :

USER_PART_INDEXES :

USER_PART_KEY_COLUMNS :

USER_PART_LOBS :

USER_PART_TABLES :

USER_PASSWORD_LIMITS : Display password limits of the user

USER_PENDING_CONV_TABLES : All user's tables which are not upgraded to the latest type version

USER_POLICIES : All row level security policies for synonyms, tables, or views owned by the user



USER_POLICY_CONTEXTS : All policy driving context defined for synonyms, tables, or views in current schema

USER_POLICY_GROUPS : All policy groups defined for any synonym, table, or view

USER_PROCEDURES : Description of the users own procedures

USER_PROXIES : Description of connections the user is allowed to proxy

USER_PUBLISHED_COLUMNS :

USER_QUEUES : All queues owned by the user

USER_QUEUE_PUBLISHERS :

USER_QUEUE_SCHEDULES :

USER_QUEUE_TABLES : All queue tables created by the user

USER_REFRESH : All the refresh groups



USER_REFRESH_CHILDREN : All the objects in refresh groups, where the user owns the refresh group

USER_REFS : Description of the user's own REF columns contained in the user's own tables

USER_REGISTERED_MVIEWS : Remote materialized views of local tables currently using logs owned by the user

USER_REGISTERED_SNAPSHOTS : Remote snapshots of local tables currently using logs owned by the user

USER_REGISTRY :

USER_REPAUDIT_ATTRIBUTE : Information about attributes automatically maintained for replication

USER_REPAUDIT_COLUMN : Information about columns in all shadow tables for user's replicated tables

USER_REPCAT :

USER_REPCATLOG : Information about the current user's asynchronous administration requests

USER_REPCAT_REFRESH_TEMPLATES :



USER_REPCAT_TEMPLATE_OBJECTS :

USER_REPCAT_TEMPLATE_PARMS :

USER_REPCAT_TEMPLATE_SITES :

USER_REPCAT_USER_AUTHORIZATION :

USER_REPCAT_USER_PARM_VALUES :

USER_REPCOLUMN : Replicated columns for the current user's table in ascending order

USER_REPCOLUMN_GROUP : All column groups of user's replicated tables

USER_REPCONFLICT :

USER_REPDDL : Arguments that do not fit in a single repcat log record

USER_REPFLAVORS : Flavors current user created for replicated object groups



USER_REPFLAVOR_COLUMNS : Replicated columns from current user's tables in flavors

USER_REPFLAVOR_OBJECTS : Replicated user objects in flavors

USER_REPGENERATED : Objects generated for the current user to support replication

USER_REPGENOBJECTS : Objects generated for the current user to support replication

USER_REPGROUP : Replication information about the current user

USER_REPGROUPED_COLUMN : Columns in the all column groups of user's replicated tables

USER_REPGROUP_PRIVILEGES : Information about users who are registered for object group privileges

USER_REPKEY_COLUMNS : Primary columns for a table using column-level replication

USER_REPOBJECT : Replication information about the current user's objects

USER_REPPARAMETER_COLUMN : All columns used for resolving conflicts in user's replicated tables



USER_REPPRIORITY : Values and their corresponding priorities in user's priority groups

USER_REPPRIORITY_GROUP : Information about user's priority groups

USER_REPPROP : Propagation information about the current user's objects

USER_REPRESOLUTION : Description of all conflict resolutions for user's replicated tables

USER_REPRESOLUTION_METHOD : All conflict resolution methods accessible to the user

USER_REPRESOLUTION_STATISTICS : Statistics for conflict resolutions for user's replicated tables

USER_REPRESOL_STATS_CONTROL : Information about statistics collection for conflict resolutions for user's replicated tables

USER_REPSCHEMA : N-way replication information about the current user

USER_REPSITES : N-way replication information about the current user

USER_RESOURCE_LIMITS : Display resource limit of the user



USER_RESUMABLE : Resumable session information for current user

USER_ROLE_PRIVS : Roles granted to current user

USER_RSRC_CONSUMER_GROUP_PRIVS : Switch privileges for consumer groups for the user

USER_RSRC_MANAGER_SYSTEM_PRIVS : system privileges for the resource manager for the user

USER_RULES : Rules owned by the user

USER_RULESETS : Rulesets owned by the user: maintained for backward compatibility

USER_RULE_SETS : Rule sets owned by the user

USER_RULE_SET_RULES : Rules in user rule sets

USER_SECONDARY_OBJECTS : All secondary objects for domain indexes

USER_SEGMENTS : Storage allocated for all database segments



USER_SEQUENCES : Description of the user's own SEQUENCEs

USER_SNAPSHOTS : Snapshots the user can look at

USER_SNAPSHOT_LOGS : All snapshot logs owned by the user

USER_SNAPSHOT_REFRESH_TIMES : Synonym for USER_MVIEW_REFRESH_TIMES

USER_SOURCE : Source of stored objects accessible to the user

USER_SOURCE_TABLES :

USER_SOURCE_TAB_COLUMNS :

USER_SQLJ_TYPES : Description of the user's own types

USER_SQLJ_TYPE_ATTRS : Description of attributes of the user's own types

USER_SQLJ_TYPE_METHODS : Description of methods of the user's own types



USER_STORED_SETTINGS : Parameter settings for objects owned by the user

USER_SUBPARTITION_TEMPLATES :

USER_SUBPART_COL_STATISTICS :

USER_SUBPART_HISTOGRAMS :

USER_SUBPART_KEY_COLUMNS :

USER_SUBSCRIBED_COLUMNS :

USER_SUBSCRIBED_TABLES :

USER_SUBSCRIPTIONS :

USER_SUMMARIES : Description of the summaries created by the user

USER_SUMMARY_AGGREGATES :



USER_SUMMARY_DETAIL_TABLES :

USER_SUMMARY_JOINS :

USER_SUMMARY_KEYS :

USER_SYNONYMS : The user's private synonyms

USER_SYS_PRIVS : System privileges granted to current user

USER_TABLES : Description of the user's own relational tables

USER_TABLESPACES : Description of accessible tablespaces

USER_TAB_COLS : Columns of user's tables, views and clusters

USER_TAB_COLUMNS : Columns of user's tables, views and clusters

USER_TAB_COL_STATISTICS : Columns of user's tables, views and clusters



USER_TAB_COMMENTS : Comments on the tables and views owned by the user

USER_TAB_HISTOGRAMS : Histograms on columns of user's tables

USER_TAB_MODIFICATIONS : Information regarding modifications to tables

USER_TAB_PARTITIONS :

USER_TAB_PRIVS : Grants on objects for which the user is the owner, grantor or grantee

USER_TAB_PRIVS_MADE : All grants on objects owned by the user

USER_TAB_PRIVS_RECD : Grants on objects for which the user is the grantee

USER_TAB_SUBPARTITIONS :

USER_TRANSFORMATIONS :

USER_TRIGGERS : Triggers owned by the user



USER_TRIGGER_COLS : Column usage in user's triggers

USER_TS_QUOTAS : Tablespace quotas for the user

USER_TYPES : Description of the user's own types

USER_TYPE_ATTRS : Description of attributes of the user's own types

USER_TYPE_METHODS : Description of methods of the user's own types

USER_TYPE_VERSIONS : Description of each version of the user's types

USER_UNUSED_COL_TABS : User tables with unused columns

USER_UPDATABLE_COLUMNS : Description of updatable columns

USER_USERS : Information about the current user

USER_USTATS : All statistics on tables or indexes owned by the user



USER_VARRAYS : Description of varrays contained in the user's own tables

USER_VIEWS : Description of the user's own views

USER_WORKSPACES :

V$ACCESS : Synonym for V_$ACCESS

V$ACTIVE_INSTANCES : Synonym for V_$ACTIVE_INSTANCES

V$ACTIVE_SESS_POOL_MTH : Synonym for V_$ACTIVE_SESS_POOL_MTH

V$AQ : Synonym for V_$AQ

V$AQ1 : Synonym for V_$AQ1

V$ARCHIVE : Synonym for V_$ARCHIVE

V$ARCHIVED_LOG : Synonym for V_$ARCHIVED_LOG



V$ARCHIVE_DEST : Synonym for V_$ARCHIVE_DEST

V$ARCHIVE_DEST_STATUS : Synonym for V_$ARCHIVE_DEST_STATUS

V$ARCHIVE_GAP : Synonym for V_$ARCHIVE_GAP

V$ARCHIVE_PROCESSES : Synonym for V_$ARCHIVE_PROCESSES

V$AW_CALC : Synonym for V_$AW_CALC

V$AW_OLAP : Synonym for V_$AW_OLAP

V$AW_SESSION_INFO : Synonym for V_$AW_SESSION_INFO

V$BACKUP : Synonym for V_$BACKUP

V$BACKUP_ASYNC_IO : Synonym for V_$BACKUP_ASYNC_IO

V$BACKUP_CORRUPTION : Synonym for V_$BACKUP_CORRUPTION



V$BACKUP_DATAFILE : Synonym for V_$BACKUP_DATAFILE

V$BACKUP_DEVICE : Synonym for V_$BACKUP_DEVICE

V$BACKUP_PIECE : Synonym for V_$BACKUP_PIECE

V$BACKUP_REDOLOG : Synonym for V_$BACKUP_REDOLOG

V$BACKUP_SET : Synonym for V_$BACKUP_SET

V$BACKUP_SPFILE : Synonym for V_$BACKUP_SPFILE

V$BACKUP_SYNC_IO : Synonym for V_$BACKUP_SYNC_IO

V$BGPROCESS : Synonym for V_$BGPROCESS

V$BH : Synonym for V_$BH

V$BSP : Synonym for V_$BSP



V$BUFFER_POOL : Synonym for V_$BUFFER_POOL

V$BUFFER_POOL_STATISTICS : Synonym for V_$BUFFER_POOL_STATISTICS

V$CIRCUIT : Synonym for V_$CIRCUIT

V$CLASS_CACHE_TRANSFER : Synonym for V_$CLASS_CACHE_TRANSFER

V$CLASS_PING : Synonym for V_$CLASS_PING

V$COMPATIBILITY : Synonym for V_$COMPATIBILITY

V$COMPATSEG : Synonym for V_$COMPATSEG

V$CONTEXT : Synonym for V_$CONTEXT

V$CONTROLFILE : Synonym for V_$CONTROLFILE

V$CONTROLFILE_RECORD_SECTION : Synonym for V_$CONTROLFILE_RECORD_SECTION



V$COPY_CORRUPTION : Synonym for V_$COPY_CORRUPTION

V$CR_BLOCK_SERVER : Synonym for V_$CR_BLOCK_SERVER

V$DATABASE : Synonym for V_$DATABASE

V$DATABASE_BLOCK_CORRUPTION : Synonym for V_$DATABASE_BLOCK_CORRUPTION

V$DATABASE_INCARNATION : Synonym for V_$DATABASE_INCARNATION

V$DATAFILE : Synonym for V_$DATAFILE

V$DATAFILE_COPY : Synonym for V_$DATAFILE_COPY

V$DATAFILE_HEADER : Synonym for V_$DATAFILE_HEADER

V$DATAGUARD_STATUS : Synonym for V_$DATAGUARD_STATUS

V$DBFILE : Synonym for V_$DBFILE



V$DBLINK : Synonym for V_$DBLINK

V$DB_CACHE_ADVICE : Synonym for V_$DB_CACHE_ADVICE

V$DB_OBJECT_CACHE : Synonym for V_$DB_OBJECT_CACHE

V$DB_PIPES : Synonym for V_$DB_PIPES

V$DELETED_OBJECT : Synonym for V_$DELETED_OBJECT

V$DISPATCHER : Synonym for V_$DISPATCHER

V$DISPATCHER_RATE : Synonym for V_$DISPATCHER_RATE

V$DLM_ALL_LOCKS : Synonym for V_$DLM_ALL_LOCKS

V$DLM_CONVERT_LOCAL : Synonym for V_$DLM_CONVERT_LOCAL

V$DLM_CONVERT_REMOTE : Synonym for V_$DLM_CONVERT_REMOTE



V$DLM_LATCH : Synonym for V_$DLM_LATCH

V$DLM_LOCKS : Synonym for V_$DLM_LOCKS

V$DLM_MISC : Synonym for V_$DLM_MISC

V$DLM_RESS : Synonym for V_$DLM_RESS

V$DLM_TRAFFIC_CONTROLLER : Synonym for V_$DLM_TRAFFIC_CONTROLLER

V$ENABLEDPRIVS : Synonym for V_$ENABLEDPRIVS

V$ENQUEUE_LOCK : Synonym for V_$ENQUEUE_LOCK

V$ENQUEUE_STAT : Synonym for V_$ENQUEUE_STAT

V$EVENT_NAME : Synonym for V_$EVENT_NAME

V$EXECUTION : Synonym for V_$EXECUTION



V$FAST_START_SERVERS : Synonym for V_$FAST_START_SERVERS

V$FAST_START_TRANSACTIONS : Synonym for V_$FAST_START_TRANSACTIONS

V$FILESTAT : Synonym for V_$FILESTAT

V$FILESTATXS : Synonym for V_$FILESTATXS

V$FILE_CACHE_TRANSFER : Synonym for V_$FILE_CACHE_TRANSFER

V$FILE_PING : Synonym for V_$FILE_PING

V$FIXED_TABLE : Synonym for V_$FIXED_TABLE

V$FIXED_VIEW_DEFINITION : Synonym for V_$FIXED_VIEW_DEFINITION

V$GCSHVMASTER_INFO : Synonym for V_$GCSHVMASTER_INFO

V$GCSPFMASTER_INFO : Synonym for V_$GCSPFMASTER_INFO



V$GC_ELEMENT : Synonym for V_$GC_ELEMENT

V$GC_ELEMENTS_WITH_COLLISIONS : Synonym for V_$GC_ELEMENTS_W_COLLISIONS

V$GES_BLOCKING_ENQUEUE : Synonym for V_$GES_BLOCKING_ENQUEUE

V$GES_ENQUEUE : Synonym for V_$GES_ENQUEUE

V$GLOBALCONTEXT : Synonym for V_$GLOBALCONTEXT

V$GLOBAL_BLOCKED_LOCKS : Synonym for V_$GLOBAL_BLOCKED_LOCKS

V$GLOBAL_TRANSACTION : Synonym for V_$GLOBAL_TRANSACTION

V$HS_AGENT : Synonym for V_$HS_AGENT

V$HS_PARAMETER : Synonym for V_$HS_PARAMETER

V$HS_SESSION : Synonym for V_$HS_SESSION



V$HVMASTER_INFO : Synonym for V_$HVMASTER_INFO

V$INDEXED_FIXED_COLUMN : Synonym for V_$INDEXED_FIXED_COLUMN

V$INSTANCE : Synonym for V_$INSTANCE

V$INSTANCE_RECOVERY : Synonym for V_$INSTANCE_RECOVERY

V$LATCH : Synonym for V_$LATCH

V$LATCHHOLDER : Synonym for V_$LATCHHOLDER

V$LATCHNAME : Synonym for V_$LATCHNAME

V$LATCH_CHILDREN : Synonym for V_$LATCH_CHILDREN

V$LATCH_MISSES : Synonym for V_$LATCH_MISSES

V$LATCH_PARENT : Synonym for V_$LATCH_PARENT



V$LIBRARYCACHE : Synonym for V_$LIBRARYCACHE

V$LIBRARY_CACHE_MEMORY : Synonym for V_$LIBRARY_CACHE_MEMORY

V$LICENSE : Synonym for V_$LICENSE

V$LOADISTAT : Synonym for V_$LOADISTAT

V$LOADPSTAT : Synonym for V_$LOADPSTAT

V$LOCK : Synonym for V_$LOCK

V$LOCKED_OBJECT : Synonym for V_$LOCKED_OBJECT

V$LOCKS_WITH_COLLISIONS : Synonym for V_$LOCKS_WITH_COLLISIONS

V$LOCK_ACTIVITY : Synonym for V_$LOCK_ACTIVITY

V$LOCK_ELEMENT : Synonym for V_$LOCK_ELEMENT



V$LOG : Synonym for V_$LOG

V$LOGFILE : Synonym for V_$LOGFILE

V$LOGHIST : Synonym for V_$LOGHIST

V$LOGMNR_CALLBACK : Synonym for V_$LOGMNR_CALLBACK

V$LOGMNR_CONTENTS : Synonym for V_$LOGMNR_CONTENTS

V$LOGMNR_DICTIONARY : Synonym for V_$LOGMNR_DICTIONARY

V$LOGMNR_LOGFILE : Synonym for V_$LOGMNR_LOGFILE

V$LOGMNR_LOGS : Synonym for V_$LOGMNR_LOGS

V$LOGMNR_PARAMETERS : Synonym for V_$LOGMNR_PARAMETERS

V$LOGMNR_PROCESS : Synonym for V_$LOGMNR_PROCESS



V$LOGMNR_REGION : Synonym for V_$LOGMNR_REGION

V$LOGMNR_SESSION : Synonym for V_$LOGMNR_SESSION

V$LOGMNR_STATS : Synonym for V_$LOGMNR_STATS

V$LOGMNR_TRANSACTION : Synonym for V_$LOGMNR_TRANSACTION

V$LOGSTDBY : Synonym for V_$LOGSTDBY

V$LOGSTDBY_STATS : Synonym for V_$LOGSTDBY_STATS

V$LOG_HISTORY : Synonym for V_$LOG_HISTORY

V$MANAGED_STANDBY : Synonym for V_$MANAGED_STANDBY

V$MAP_COMP_LIST : Synonym for V_$MAP_COMP_LIST

V$MAP_ELEMENT : Synonym for V_$MAP_ELEMENT



V$MAP_EXT_ELEMENT : Synonym for V_$MAP_EXT_ELEMENT

V$MAP_FILE : Synonym for V_$MAP_FILE

V$MAP_FILE_EXTENT : Synonym for V_$MAP_FILE_EXTENT

V$MAP_FILE_IO_STACK : Synonym for V_$MAP_FILE_IO_STACK

V$MAP_LIBRARY : Synonym for V_$MAP_LIBRARY

V$MAP_SUBELEMENT : Synonym for V_$MAP_SUBELEMENT

V$MAX_ACTIVE_SESS_TARGET_MTH : Synonym for V_$MAX_ACTIVE_SESS_TARGET_MTH

V$MLS_PARAMETERS : Synonym for V_$MLS_PARAMETERS

V$MTS : Synonym for V_$MTS

V$MTTR_TARGET_ADVICE : Synonym for V_$MTTR_TARGET_ADVICE



V$MVREFRESH : Synonym for V_$MVREFRESH

V$MYSTAT : Synonym for V_$MYSTAT

V$NLS_PARAMETERS : Synonym for V_$NLS_PARAMETERS

V$NLS_VALID_VALUES : Synonym for V_$NLS_VALID_VALUES

V$OBJECT_DEPENDENCY : Synonym for V_$OBJECT_DEPENDENCY

V$OBSOLETE_PARAMETER : Synonym for V_$OBSOLETE_PARAMETER

V$OFFLINE_RANGE : Synonym for V_$OFFLINE_RANGE

V$OPEN_CURSOR : Synonym for V_$OPEN_CURSOR

V$OPTION : Synonym for V_$OPTION

V$PARALLEL_DEGREE_LIMIT_MTH : Synonym for V_$PARALLEL_DEGREE_LIMIT_MTH



V$PARAMETER : Synonym for V_$PARAMETER

V$PARAMETER2 : Synonym for V_$PARAMETER2

V$PGASTAT : Synonym for V_$PGASTAT

V$PGA_TARGET_ADVICE : Synonym for V_$PGA_TARGET_ADVICE

V$PGA_TARGET_ADVICE_HISTOGRAM : Synonym for V_$PGA_TARGET_ADVICE_HISTOGRAM

V$PQ_SESSTAT : Synonym for V_$PQ_SESSTAT

V$PQ_SLAVE : Synonym for V_$PQ_SLAVE

V$PQ_SYSSTAT : Synonym for V_$PQ_SYSSTAT

V$PQ_TQSTAT : Synonym for V_$PQ_TQSTAT

V$PROCESS : Synonym for V_$PROCESS



V$PROXY_ARCHIVEDLOG : Synonym for V_$PROXY_ARCHIVEDLOG

V$PROXY_DATAFILE : Synonym for V_$PROXY_DATAFILE

V$PWFILE_USERS : Synonym for V_$PWFILE_USERS

V$PX_PROCESS : Synonym for V_$PX_PROCESS

V$PX_PROCESS_SYSSTAT : Synonym for V_$PX_PROCESS_SYSSTAT

V$PX_SESSION : Synonym for V_$PX_SESSION

V$PX_SESSTAT : Synonym for V_$PX_SESSTAT

V$QUEUE : Synonym for V_$QUEUE

V$QUEUEING_MTH : Synonym for V_$QUEUEING_MTH

V$RECOVERY_FILE_STATUS : Synonym for V_$RECOVERY_FILE_STATUS



V$RECOVERY_LOG : Synonym for V_$RECOVERY_LOG

V$RECOVERY_PROGRESS : Synonym for V_$RECOVERY_PROGRESS

V$RECOVERY_STATUS : Synonym for V_$RECOVERY_STATUS

V$RECOVER_FILE : Synonym for V_$RECOVER_FILE

V$REPLPROP : Synonym for V_$REPLPROP

V$REPLQUEUE : Synonym for V_$REPLQUEUE

V$REQDIST : Synonym for V_$REQDIST

V$RESERVED_WORDS : Synonym for V_$RESERVED_WORDS

V$RESOURCE : Synonym for V_$RESOURCE

V$RESOURCE_LIMIT : Synonym for V_$RESOURCE_LIMIT



V$RESUMABLE : Synonym for V_$RESUMABLE

V$RMAN_CONFIGURATION : Synonym for V_$RMAN_CONFIGURATION

V$ROLLNAME : Synonym for V_$ROLLNAME

V$ROLLSTAT : Synonym for V_$ROLLSTAT

V$ROWCACHE : Synonym for V_$ROWCACHE

V$ROWCACHE_PARENT : Synonym for V_$ROWCACHE_PARENT

V$ROWCACHE_SUBORDINATE : Synonym for V_$ROWCACHE_SUBORDINATE

V$RSRC_CONSUMER_GROUP : Synonym for V_$RSRC_CONSUMER_GROUP

V$RSRC_CONSUMER_GROUP_CPU_MTH : Synonym for V_$RSRC_CONSUMER_GROUP_CPU_MTH

V$RSRC_PLAN : Synonym for V_$RSRC_PLAN



V$RSRC_PLAN_CPU_MTH : Synonym for V_$RSRC_PLAN_CPU_MTH

V$SEGMENT_STATISTICS : Synonym for V_$SEGMENT_STATISTICS

V$SEGSTAT : Synonym for V_$SEGSTAT

V$SEGSTAT_NAME : Synonym for V_$SEGSTAT_NAME

V$SESSION : Synonym for V_$SESSION

V$SESSION_CONNECT_INFO : Synonym for V_$SESSION_CONNECT_INFO

V$SESSION_CURSOR_CACHE : Synonym for V_$SESSION_CURSOR_CACHE

V$SESSION_EVENT : Synonym for V_$SESSION_EVENT

V$SESSION_LONGOPS : Synonym for V_$SESSION_LONGOPS

V$SESSION_OBJECT_CACHE : Synonym for V_$SESSION_OBJECT_CACHE



V$SESSION_WAIT : Synonym for V_$SESSION_WAIT

V$SESSTAT : Synonym for V_$SESSTAT

V$SESS_IO : Synonym for V_$SESS_IO

V$SGA : Synonym for V_$SGA

V$SGASTAT : Synonym for V_$SGASTAT

V$SGA_CURRENT_RESIZE_OPS : Synonym for V_$SGA_CURRENT_RESIZE_OPS

V$SGA_DYNAMIC_COMPONENTS : Synonym for V_$SGA_DYNAMIC_COMPONENTS

V$SGA_DYNAMIC_FREE_MEMORY : Synonym for V_$SGA_DYNAMIC_FREE_MEMORY

V$SGA_RESIZE_OPS : Synonym for V_$SGA_RESIZE_OPS

V$SHARED_POOL_ADVICE : Synonym for V_$SHARED_POOL_ADVICE



V$SHARED_POOL_RESERVED : Synonym for V_$SHARED_POOL_RESERVED

V$SHARED_SERVER : Synonym for V_$SHARED_SERVER

V$SHARED_SERVER_MONITOR : Synonym for V_$SHARED_SERVER_MONITOR

V$SORT_SEGMENT : Synonym for V_$SORT_SEGMENT

V$SORT_USAGE : Synonym for V_$SORT_USAGE

V$SPPARAMETER : Synonym for V_$SPPARAMETER

V$SQL : Synonym for V_$SQL

V$SQLAREA : Synonym for V_$SQLAREA

V$SQLTEXT : Synonym for V_$SQLTEXT

V$SQLTEXT_WITH_NEWLINES : Synonym for V_$SQLTEXT_WITH_NEWLINES



V$SQLXS : Synonym for V_$SQLXS

V$SQL_BIND_DATA : Synonym for V_$SQL_BIND_DATA

V$SQL_BIND_METADATA : Synonym for V_$SQL_BIND_METADATA

V$SQL_CURSOR : Synonym for V_$SQL_CURSOR

V$SQL_PLAN : Synonym for V_$SQL_PLAN

V$SQL_PLAN_STATISTICS : Synonym for V_$SQL_PLAN_STATISTICS

V$SQL_PLAN_STATISTICS_ALL : Synonym for V_$SQL_PLAN_STATISTICS_ALL

V$SQL_REDIRECTION : Synonym for V_$SQL_REDIRECTION

V$SQL_SHARED_CURSOR : Synonym for V_$SQL_SHARED_CURSOR

V$SQL_SHARED_MEMORY : Synonym for V_$SQL_SHARED_MEMORY



V$SQL_WORKAREA : Synonym for V_$SQL_WORKAREA

V$SQL_WORKAREA_ACTIVE : Synonym for V_$SQL_WORKAREA_ACTIVE

V$SQL_WORKAREA_HISTOGRAM : Synonym for V_$SQL_WORKAREA_HISTOGRAM

V$STANDBY_LOG : Synonym for V_$STANDBY_LOG

V$STATISTICS_LEVEL : Synonym for V_$STATISTICS_LEVEL

V$STATNAME : Synonym for V_$STATNAME

V$STREAMS_APPLY_COORDINATOR : Synonym for V_$STREAMS_APPLY_COORDINATOR

V$STREAMS_APPLY_READER : Synonym for V_$STREAMS_APPLY_READER

V$STREAMS_APPLY_SERVER : Synonym for V_$STREAMS_APPLY_SERVER

V$STREAMS_CAPTURE : Synonym for V_$STREAMS_CAPTURE



V$SUBCACHE : Synonym for V_$SUBCACHE

V$SYSSTAT : Synonym for V_$SYSSTAT

V$SYSTEM_CURSOR_CACHE : Synonym for V_$SYSTEM_CURSOR_CACHE

V$SYSTEM_EVENT : Synonym for V_$SYSTEM_EVENT

V$SYSTEM_PARAMETER : Synonym for V_$SYSTEM_PARAMETER

V$SYSTEM_PARAMETER2 : Synonym for V_$SYSTEM_PARAMETER2

V$TABLESPACE : Synonym for V_$TABLESPACE

V$TEMPFILE : Synonym for V_$TEMPFILE

V$TEMPORARY_LOBS : Synonym for V_$TEMPORARY_LOBS

V$TEMPSEG_USAGE : Synonym for V_$SORT_USAGE


V$TEMPSTAT : Synonym for V_$TEMPSTAT

V$TEMPSTATXS : Synonym for V_$TEMPSTATXS

V$TEMP_CACHE_TRANSFER : Synonym for V_$TEMP_CACHE_TRANSFER

V$TEMP_EXTENT_MAP : Synonym for V_$TEMP_EXTENT_MAP

V$TEMP_EXTENT_POOL : Synonym for V_$TEMP_EXTENT_POOL

V$TEMP_PING : Synonym for V_$TEMP_PING

V$TEMP_SPACE_HEADER : Synonym for V_$TEMP_SPACE_HEADER

V$THREAD : Synonym for V_$THREAD

V$TIMER : Synonym for V_$TIMER

V$TIMEZONE_NAMES : Synonym for V_$TIMEZONE_NAMES



V$TRANSACTION : Synonym for V_$TRANSACTION

V$TRANSACTION_ENQUEUE : Synonym for V_$TRANSACTION_ENQUEUE

V$TYPE_SIZE : Synonym for V_$TYPE_SIZE

V$UNDOSTAT : Synonym for V_$UNDOSTAT

V$VERSION : Synonym for V_$VERSION

V$VPD_POLICY : Synonym for V_$VPD_POLICY

V$WAITSTAT : Synonym for V_$WAITSTAT

V$_LOCK : Synonym for V_$_LOCK

X$KCBFWAIT : Synonym for X_$KCBFWAIT

X$KSLLT : Synonym for X_$KSLLT


X$KSPPI : Synonym for X_$KSPPI

X$KSPPSV : Synonym for X_$KSPPSV

X$KSQST : Synonym for X_$KSQST

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete