Skip to main content

All Dictionary View Tables:


All Dictionary View Tables:


TABLE_NAME COMMENTS
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_ENQUEUE Details about the apply enqueue action for user accessible rules where the destination queue exists and is visible to the user
ALL_APPLY_ERROR Error transactions that were generated after dequeuing from the queue visible to the current user
ALL_APPLY_EXECUTE Details about the apply execute action for all rules visible to the 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_APPLY_TABLE_COLUMNS Details about the columns of destination table object visible to the 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_AUDIT_POLICY_COLUMNS All fine grained auditing policy columns in the database
ALL_AWS Analytic Workspaces accessible to the user
ALL_AW_AC Active Catalog Analytic Workspaces accessible to the user
ALL_AW_AC_10G
ALL_AW_OBJ Objects in Analytic Workspaces accessible to the user
ALL_AW_PROP Object properties in Analytic Workspaces accessible to the user
ALL_AW_PROP_NAME Analytic Workspace property names accessible to the user
ALL_AW_PS Pagespaces in Analytic Workspaces accessible to the user
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_EXTRA_ATTRIBUTES Extra attributes for a capture process that is 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_DEQUEUE_QUEUES All queues 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_ENCRYPTED_COLUMNS Encryption information on all accessible columns
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_FILE_GROUPS Details about file groups
ALL_FILE_GROUP_EXPORT_INFO Details about export information of file group versions
ALL_FILE_GROUP_FILES Details about file group files
ALL_FILE_GROUP_TABLES Details about the tables in the file group repository
ALL_FILE_GROUP_TABLESPACES Details about the transportable tablespaces in the file group repository
ALL_FILE_GROUP_VERSIONS Details about file group versions
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_ARRAYTYPES All array types specified by the indextype
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_STATISTICS Optimizer statistics for all indexes on tables accessible to the user
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_COMMENTS Comments on 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_NESTED_TABLE_COLS Columns of nested tables
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_OLAP_ALTER_SESSION Synonym for V$OLAP_ALTER_SESSION
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_PLSQL_OBJECT_SETTINGS Compiler settings of stored objects accessible to the user
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 Functions/procedures/packages/types/triggers available to the user
ALL_PROPAGATION Streams propagation seen by the user
ALL_PUBLISHED_COLUMNS Source columns available for Change Data Capture
ALL_QUEUES All queues accessible to the user
ALL_QUEUE_PUBLISHERS
ALL_QUEUE_SUBSCRIBERS All queue subscribers accessible to user
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_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_REWRITE_EQUIVALENCES Description of all rewrite equivalence accessible to the user
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_SCHEDULER_CHAINS All scheduler chains in the database visible to current user
ALL_SCHEDULER_CHAIN_RULES All rules from scheduler chains visible to the current user
ALL_SCHEDULER_CHAIN_STEPS All steps of scheduler chains visible to the current user
ALL_SCHEDULER_GLOBAL_ATTRIBUTE All scheduler global attributes
ALL_SCHEDULER_JOBS All scheduler jobs visible to the user
ALL_SCHEDULER_JOB_ARGS All arguments with set values of all scheduler jobs in the database
ALL_SCHEDULER_JOB_CLASSES All scheduler classes visible to the user
ALL_SCHEDULER_JOB_LOG Logged information for all scheduler jobs
ALL_SCHEDULER_JOB_RUN_DETAILS The details of a job run
ALL_SCHEDULER_PROGRAMS All scheduler programs visible to the user
ALL_SCHEDULER_PROGRAM_ARGS All arguments of all scheduler programs visible to the user
ALL_SCHEDULER_RUNNING_CHAINS All job steps of running job chains visible to the user
ALL_SCHEDULER_SCHEDULES All schedules in the database
ALL_SCHEDULER_WINDOWS All scheduler windows in the database
ALL_SCHEDULER_WINDOW_DETAILS The details of a window
ALL_SCHEDULER_WINDOW_GROUPS All scheduler window groups in the database
ALL_SCHEDULER_WINDOW_LOG Logged information for all scheduler windows
ALL_SCHEDULER_WINGROUP_MEMBERS Members of all scheduler window groups in the database
ALL_SECONDARY_OBJECTS All secondary objects for domain indexes
ALL_SEC_RELEVANT_COLS Security Relevant columns of all VPD policies for tables or views which the user has access
ALL_SEQUENCES Description of SEQUENCEs accessible to the user
ALL_SERVICES
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 Source tables available for Change Data Capture
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_SQLSET
ALL_SQLSET_BINDS
ALL_SQLSET_PLANS
ALL_SQLSET_REFERENCES
ALL_SQLSET_STATEMENTS
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_MESSAGE_CONSUMERS Streams messaging consumers visible to the current user
ALL_STREAMS_MESSAGE_RULES Rules for Streams messaging visible to the current user
ALL_STREAMS_NEWLY_SUPPORTED List of tables that are newly supported by Streams
ALL_STREAMS_RULES Rules used by streams processes
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_STREAMS_TRANSFORM_FUNCTION Rules-based transform functions used by Streams
ALL_STREAMS_UNSUPPORTED List of all the tables that are not supported by Streams in this release
ALL_SUBPARTITION_TEMPLATES
ALL_SUBPART_COL_STATISTICS
ALL_SUBPART_HISTOGRAMS
ALL_SUBPART_KEY_COLUMNS
ALL_SUBSCRIBED_COLUMNS Change Data Capture subscribed columns
ALL_SUBSCRIBED_TABLES Change Data Capture subscribed tables
ALL_SUBSCRIPTIONS Change Data Capture subscriptions
ALL_SUMDELTA Direct path load entries accessible to the user
ALL_SUMMARIES Description of the summaries accessible to the user
ALL_SYNONYMS All synonyms for base objects accessible to the user and session
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_STATISTICS Optimizer statistics for all tables accessible to the user
ALL_TAB_STATS_HISTORY History of table statistics modifications
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_WARNING_SETTINGS Warnings ettings for objects accessible to the user
ALL_WORKSPACES
ALL_XML_INDEXES Description of the all XMLType indexes that the user has privileges on
ALL_XML_SCHEMAS Description of all XML Schemas that user has privilege to reference
ALL_XML_SCHEMAS2 Dummy version of ALL_XML_SCHEMAS that does not have an XMLTYPE column
ALL_XML_TABLES Description of the all XMLType tables that the user has privileges on
ALL_XML_TAB_COLS Description of the all XMLType tables that the user has privileges on
ALL_XML_VIEWS Description of the all XMLType views that the user has privileges on
ALL_XML_VIEW_COLS Description of the all XMLType views that the user has privileges on
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_ADVISOR_ACTIONS
DBA_ADVISOR_COMMANDS
DBA_ADVISOR_DEFINITIONS
DBA_ADVISOR_DEF_PARAMETERS
DBA_ADVISOR_DIRECTIVES
DBA_ADVISOR_FINDINGS
DBA_ADVISOR_JOURNAL
DBA_ADVISOR_LOG
DBA_ADVISOR_OBJECTS
DBA_ADVISOR_OBJECT_TYPES
DBA_ADVISOR_PARAMETERS
DBA_ADVISOR_PARAMETERS_PROJ
DBA_ADVISOR_RATIONALE
DBA_ADVISOR_RECOMMENDATIONS
DBA_ADVISOR_SQLA_REC_SUM
DBA_ADVISOR_SQLA_WK_MAP
DBA_ADVISOR_SQLA_WK_STMTS
DBA_ADVISOR_SQLW_COLVOL
DBA_ADVISOR_SQLW_JOURNAL
DBA_ADVISOR_SQLW_PARAMETERS
DBA_ADVISOR_SQLW_STMTS
DBA_ADVISOR_SQLW_SUM
DBA_ADVISOR_SQLW_TABLES
DBA_ADVISOR_SQLW_TABVOL
DBA_ADVISOR_SQLW_TEMPLATES
DBA_ADVISOR_TASKS
DBA_ADVISOR_TEMPLATES
DBA_ADVISOR_USAGE
DBA_ALERT_ARGUMENTS Message Id and arguments of outstanding alerts
DBA_ALERT_HISTORY Description on alert history
DBA_ALL_TABLES Description of all object and relational tables in the database
DBA_ANALYZE_OBJECTS
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_ENQUEUE Details about the apply enqueue action
DBA_APPLY_ERROR Error transactions
DBA_APPLY_EXECUTE Details about the apply execute action
DBA_APPLY_INSTANTIATED_GLOBAL Details about database instantiated
DBA_APPLY_INSTANTIATED_OBJECTS Details about objects instantiated
DBA_APPLY_INSTANTIATED_SCHEMAS Details about schemas instantiated
DBA_APPLY_KEY_COLUMNS alternative key columns for a table for STREAMS
DBA_APPLY_OBJECT_DEPENDENCIES Synonym for _DBA_APPLY_OBJECT_CONSTRAINTS
DBA_APPLY_PARAMETERS All parameters for apply process
DBA_APPLY_PROGRESS Information about the progress made by apply process
DBA_APPLY_SPILL_TXN Streams apply spilled transactions info
DBA_APPLY_TABLE_COLUMNS Details about the destination table columns
DBA_APPLY_VALUE_DEPENDENCIES Synonym for _DBA_APPLY_CONSTRAINT_COLUMNS
DBA_AQ_AGENTS
DBA_AQ_AGENT_PRIVS
DBA_ARGUMENTS All arguments for objects in the database
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 Fine grained auditing policies in the database
DBA_AUDIT_POLICY_COLUMNS All fine grained auditing policy columns 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_OBJ Objects in Analytic Workspaces in the database
DBA_AW_PROP Object properties in 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_EXTRA_ATTRIBUTES Extra attributes for a 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_CHANGE_NOTIFICATION_REGS Description of the registrations for change notification
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_COMMON_AUDIT_TRAIL Combined Standard and Fine Grained audit trail entries
DBA_CONNECT_ROLE_GRANTEES Information regarding which users are granted CONNECT
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_CPU_USAGE_STATISTICS Database CPU Usage Statistics
DBA_DATAPUMP_JOBS Datapump jobs
DBA_DATAPUMP_SESSIONS Datapump sessions attached to a job
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_ENABLED_AGGREGATIONS Information about enabled on-demand statistic aggregation
DBA_ENABLED_TRACES Information about enabled SQL traces
DBA_ENCRYPTED_COLUMNS Encryption information on columns in the database
DBA_EPG_DAD_AUTHORIZATION DADs authorized to use different user's privileges
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_EXPORT_OBJECTS Export INCLUDE and EXCLUDE object type names
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_FEATURE_USAGE_STATISTICS Database Feature Usage Statistics
DBA_FGA_AUDIT_TRAIL All fine grained audit event logs
DBA_FILE_GROUPS Details about file groups
DBA_FILE_GROUP_EXPORT_INFO Details about export information of file group versions
DBA_FILE_GROUP_FILES Details about file group files
DBA_FILE_GROUP_TABLES Details about the tables in the file group repository
DBA_FILE_GROUP_TABLESPACES Details about the transportable tablespaces in the file group repository
DBA_FILE_GROUP_VERSIONS Details about file group versions
DBA_FREE_SPACE Free extents in all tablespaces
DBA_FREE_SPACE_COALESCED Statistics on Coalesced Space in Tablespaces
DBA_GLOBAL_CONTEXT Description of all context information accessible globally
DBA_HIGH_WATER_MARK_STATISTICS Database High Water Mark Statistics
DBA_HISTOGRAMS Synonym for DBA_TAB_HISTOGRAMS
DBA_HIST_ACTIVE_SESS_HISTORY Active Session Historical Statistics Information
DBA_HIST_BASELINE Baseline Metadata Information
DBA_HIST_BG_EVENT_SUMMARY Summary of Background Event Historical Statistics Information
DBA_HIST_BUFFERED_QUEUES STREAMS Buffered Queues Historical Statistics Information
DBA_HIST_BUFFERED_SUBSCRIBERS STREAMS Buffered Queue Subscribers Historical Statistics Information
DBA_HIST_BUFFER_POOL_STAT Buffer Pool Historical Statistics Information
DBA_HIST_COMP_IOSTAT I/O stats aggregated on component level
DBA_HIST_CR_BLOCK_SERVER Consistent Read Block Server Historical Statistics
DBA_HIST_CURRENT_BLOCK_SERVER Current Block Server Historical Statistics
DBA_HIST_DATABASE_INSTANCE Database Instance Information
DBA_HIST_DATAFILE Names of Datafiles
DBA_HIST_DB_CACHE_ADVICE DB Cache Advice History Information
DBA_HIST_DLM_MISC Distributed Lock Manager Miscellaneous Historical Statistics Information
DBA_HIST_ENQUEUE_STAT Enqueue Historical Statistics Information
DBA_HIST_EVENT_NAME Event Names
DBA_HIST_FILEMETRIC_HISTORY File Metrics History
DBA_HIST_FILESTATXS Datafile Historical Statistics Information
DBA_HIST_INSTANCE_RECOVERY Instance Recovery Historical Statistics Information
DBA_HIST_INST_CACHE_TRANSFER Instance Cache Transfer Historical Statistics
DBA_HIST_JAVA_POOL_ADVICE Java Pool Advice History
DBA_HIST_LATCH Latch Historical Statistics Information
DBA_HIST_LATCH_CHILDREN Latch Children Historical Statistics Information
DBA_HIST_LATCH_MISSES_SUMMARY Latch Misses Summary Historical Statistics Information
DBA_HIST_LATCH_NAME Latch Names
DBA_HIST_LATCH_PARENT Latch Parent Historical Historical Statistics Information
DBA_HIST_LIBRARYCACHE Library Cache Historical Statistics Information
DBA_HIST_LOG Log Historical Statistics Information
DBA_HIST_METRIC_NAME Segment Names
DBA_HIST_MTTR_TARGET_ADVICE Mean-Time-To-Recover Target Advice History
DBA_HIST_OPTIMIZER_ENV Optimizer Environment Information
DBA_HIST_OSSTAT Operating System Historical Statistics Information
DBA_HIST_OSSTAT_NAME Operating System Statistic Names
DBA_HIST_PARAMETER Parameter Historical Statistics Information
DBA_HIST_PARAMETER_NAME Parameter Names
DBA_HIST_PGASTAT PGA Historical Statistics Information
DBA_HIST_PGA_TARGET_ADVICE PGA Target Advice History
DBA_HIST_PROCESS_MEM_SUMMARY Process Memory Historical Summary Information
DBA_HIST_RESOURCE_LIMIT Resource Limit Historical Statistics Information
DBA_HIST_ROWCACHE_SUMMARY Row Cache Historical Statistics Information Summary
DBA_HIST_RULE_SET Rule sets historical statistics information
DBA_HIST_SEG_STAT  Historical Statistics Information
DBA_HIST_SEG_STAT_OBJ Segment Names
DBA_HIST_SERVICE_NAME Service Names
DBA_HIST_SERVICE_STAT Historical Service Statistics
DBA_HIST_SERVICE_WAIT_CLASS Historical Service Wait Class Statistics
DBA_HIST_SESSMETRIC_HISTORY System Metrics History
DBA_HIST_SESS_TIME_STATS CPU and I/O time for interesting (STREAMS) sessions
DBA_HIST_SGA SGA Historical Statistics Information
DBA_HIST_SGASTAT SGA Pool Historical Statistics Information
DBA_HIST_SGA_TARGET_ADVICE SGA Target Advice History
DBA_HIST_SHARED_POOL_ADVICE Shared Pool Advice History
DBA_HIST_SNAPSHOT Snapshot Information
DBA_HIST_SNAP_ERROR Snapshot Error Information
DBA_HIST_SQLBIND SQL Bind Information
DBA_HIST_SQLSTAT SQL Historical Statistics Information
DBA_HIST_SQLTEXT SQL Text
DBA_HIST_SQL_BIND_METADATA SQL Bind Metadata Information
DBA_HIST_SQL_PLAN SQL Plan Information
DBA_HIST_SQL_SUMMARY Summary of SQL Statistics
DBA_HIST_SQL_WORKAREA_HSTGRM SQL Workarea Histogram History
DBA_HIST_STAT_NAME Statistic Names
DBA_HIST_STREAMS_APPLY_SUM STREAMS Apply Historical Statistics Information
DBA_HIST_STREAMS_CAPTURE STREAMS Capture Historical Statistics Information
DBA_HIST_STREAMS_POOL_ADVICE Streams Pool Advice History
DBA_HIST_SYSMETRIC_HISTORY System Metrics History
DBA_HIST_SYSMETRIC_SUMMARY System Metrics History
DBA_HIST_SYSSTAT System Historical Statistics Information
DBA_HIST_SYSTEM_EVENT System Event Historical Statistics Information
DBA_HIST_SYS_TIME_MODEL System Time Model Historical Statistics Information
DBA_HIST_TABLESPACE_STAT Tablespace Historical Statistics Information
DBA_HIST_TBSPC_SPACE_USAGE Tablespace Usage Historical Statistics Information
DBA_HIST_TEMPFILE Names of Temporary Datafiles
DBA_HIST_TEMPSTATXS Temporary Datafile Historical Statistics Information
DBA_HIST_THREAD Thread Historical Statistics Information
DBA_HIST_UNDOSTAT Undo Historical Statistics Information
DBA_HIST_WAITCLASSMET_HISTORY Wait Class Metric History
DBA_HIST_WAITSTAT Wait Historical Statistics Information
DBA_HIST_WR_CONTROL Workload Repository Control Information
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_ARRAYTYPES All array types specified by the indextype
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_STATISTICS Optimizer statistics for all indexes in the database
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_LOGMNR_LOG
DBA_LOGMNR_PURGED_LOG
DBA_LOGMNR_SESSION
DBA_LOGSTDBY_EVENTS Information on why logical standby events
DBA_LOGSTDBY_HISTORY Information on processed, active, and pending log streams
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_COMMENTS Comments on all materialized views in the database
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_NESTED_TABLE_COLS Columns of nested 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 with atleast one option set
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_OPTSTAT_OPERATIONS History of statistics operations performed
DBA_OUTLINES Stored outlines
DBA_OUTLINE_HINTS Hints stored in outlines
DBA_OUTSTANDING_ALERTS Description of all outstanding alerts
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_PLSQL_OBJECT_SETTINGS Compiler settings of all objects in the database
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 the dba functions/procedures/packages/types/triggers
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 Source columns available for Change Data Capture
DBA_QUEUES All database queues
DBA_QUEUE_PUBLISHERS
DBA_QUEUE_SCHEDULES
DBA_QUEUE_SUBSCRIBERS queue subscribers in the database
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_RECOVERABLE_SCRIPT Details about recoverable operations
DBA_RECOVERABLE_SCRIPT_BLOCKS Details about the recoverable script blocks
DBA_RECOVERABLE_SCRIPT_ERRORS Details showing errors during script execution
DBA_RECOVERABLE_SCRIPT_PARAMS Details about the recoverable operation parameters
DBA_RECYCLEBIN Description of the Recyclebin view accessible to the user
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_ARCHIVED_LOG Details about the registered log files
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_REGISTRY_HISTORY
DBA_REGISTRY_LOG
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_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_RESOURCE_INCARNATIONS Resource incarnations that are running or eligible for HA status notification
DBA_RESUMABLE Resumable session information in the system
DBA_REWRITE_EQUIVALENCES Description of rewrite equivalence accessible to DBA
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_GROUP_MAPPINGS all the consumer group mappings
DBA_RSRC_MANAGER_SYSTEM_PRIVS system privileges for the resource manager
DBA_RSRC_MAPPING_PRIORITY the consumer group mapping attribute priorities
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_SCHEDULER_CHAINS All scheduler chains in the database
DBA_SCHEDULER_CHAIN_RULES All rules from scheduler chains in the database
DBA_SCHEDULER_CHAIN_STEPS All steps of scheduler chains in the database
DBA_SCHEDULER_GLOBAL_ATTRIBUTE All scheduler global attributes
DBA_SCHEDULER_JOBS All scheduler jobs in the database
DBA_SCHEDULER_JOB_ARGS All arguments with set values of all scheduler jobs in the database
DBA_SCHEDULER_JOB_CLASSES All scheduler classes in the database
DBA_SCHEDULER_JOB_LOG Logged information for all scheduler jobs
DBA_SCHEDULER_JOB_RUN_DETAILS The details of a job run
DBA_SCHEDULER_PROGRAMS All scheduler programs in the database
DBA_SCHEDULER_PROGRAM_ARGS All arguments of all scheduler programs in the database
DBA_SCHEDULER_RUNNING_CHAINS All steps of all running chains in the database
DBA_SCHEDULER_SCHEDULES All schedules in the database
DBA_SCHEDULER_WINDOWS All scheduler windows in the database
DBA_SCHEDULER_WINDOW_DETAILS The details of a window
DBA_SCHEDULER_WINDOW_GROUPS All scheduler window groups in the database
DBA_SCHEDULER_WINDOW_LOG Logged information for all scheduler windows
DBA_SCHEDULER_WINGROUP_MEMBERS Members of all scheduler window groups in the database
DBA_SECONDARY_OBJECTS All secondary objects for domain indexes
DBA_SEC_RELEVANT_COLS Security Relevant columns of all VPD policies in the database
DBA_SEGMENTS Storage allocated for all database segments
DBA_SEGMENTS_OLD Storage allocated for all database segments
DBA_SEQUENCES Description of all SEQUENCEs in the database
DBA_SERVER_REGISTRY
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 Source tables available for Change Data Capture
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_SQLSET
DBA_SQLSET_BINDS
DBA_SQLSET_DEFINITIONS Synonym for DBA_SQLSET
DBA_SQLSET_PLANS
DBA_SQLSET_REFERENCES
DBA_SQLSET_STATEMENTS
DBA_SQLTUNE_BINDS
DBA_SQLTUNE_PLANS
DBA_SQLTUNE_RATIONALE_PLAN
DBA_SQLTUNE_STATISTICS
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_ADD_COLUMN Add column transformations
DBA_STREAMS_ADMINISTRATOR Users granted the privileges to be a streams administrator
DBA_STREAMS_DELETE_COLUMN Delete column transformations
DBA_STREAMS_GLOBAL_RULES Global rules created by streams administrative APIs
DBA_STREAMS_MESSAGE_CONSUMERS Streams messaging consumers
DBA_STREAMS_MESSAGE_RULES Rules for Streams messaging
DBA_STREAMS_NEWLY_SUPPORTED List of tables that are newly supported by Streams
DBA_STREAMS_RENAME_COLUMN Rename column transformations
DBA_STREAMS_RENAME_SCHEMA Rename schema transformations
DBA_STREAMS_RENAME_TABLE Rename table transformations
DBA_STREAMS_RULES Rules used by Streams processes
DBA_STREAMS_SCHEMA_RULES Schema rules created by streams administrative APIs
DBA_STREAMS_TABLE_RULES Table rules created by streams administrative APIs
DBA_STREAMS_TRANSFORMATIONS Transformations defined on rules
DBA_STREAMS_TRANSFORM_FUNCTION Rules-based transform functions used by Streams
DBA_STREAMS_UNSUPPORTED List of all the tables that are not supported by Streams in this release
DBA_SUBPARTITION_TEMPLATES
DBA_SUBPART_COL_STATISTICS
DBA_SUBPART_HISTOGRAMS
DBA_SUBPART_KEY_COLUMNS
DBA_SUBSCRIBED_COLUMNS Change Data Capture subscribed columns
DBA_SUBSCRIBED_TABLES Change Data Capture subscribed tables
DBA_SUBSCRIPTIONS Change Data Capture subscriptions
DBA_SUMMARIES Description of the summaries accessible to dba
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_TABLESPACE_GROUPS Description of all tablespace groups
DBA_TABLESPACE_USAGE_METRICS Description of all tablespace space usage metrics
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_STATISTICS Optimizer statistics for all tables in the database
DBA_TAB_STATS_HISTORY History of table statistics modifications
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_THRESHOLDS Desription of all thresholds
DBA_TRANSFORMATIONS
DBA_TRIGGERS All triggers in the database
DBA_TRIGGER_COLS Column usage in all triggers
DBA_TSM_DESTINATION Transparent session migration source session statistics
DBA_TSM_HISTORY Transparent session migration statistics
DBA_TSM_SOURCE Transparent session migration source session statistics
DBA_TS_QUOTAS Tablespace quotas for all users
DBA_TUNE_MVIEW Catalog View to show the result after executing TUNE_MVIEW() API
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_WARNING_SETTINGS warning settings for all objects
DBA_WORKSPACES
DBA_WORKSPACE_SESSIONS
DBA_XML_INDEXES Description of all XML indexes in the database
DBA_XML_SCHEMAS Description of all the XML Schemas registered
DBA_XML_TABLES Description of all XML tables in the database
DBA_XML_TAB_COLS Description of all XML tables in the database
DBA_XML_VIEWS Description of all XML views in the database
DBA_XML_VIEW_COLS Description of all XML views in the database
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_SERVICES Synonym for GV_$ACTIVE_SERVICES
GV$ACTIVE_SESSION_HISTORY Synonym for GV_$ACTIVE_SESSION_HISTORY
GV$ACTIVE_SESS_POOL_MTH Synonym for GV_$ACTIVE_SESS_POOL_MTH
GV$ADVISOR_PROGRESS Synonym for GV_$ADVISOR_PROGRESS
GV$ALERT_TYPES Synonym for GV_$ALERT_TYPES
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$ASM_ALIAS Synonym for GV_$ASM_ALIAS
GV$ASM_CLIENT Synonym for GV_$ASM_CLIENT
GV$ASM_DISK Synonym for GV_$ASM_DISK
GV$ASM_DISKGROUP Synonym for GV_$ASM_DISKGROUP
GV$ASM_DISKGROUP_STAT Synonym for GV_$ASM_DISKGROUP_STAT
GV$ASM_DISK_STAT Synonym for GV_$ASM_DISK_STAT
GV$ASM_FILE Synonym for GV_$ASM_FILE
GV$ASM_OPERATION Synonym for GV_$ASM_OPERATION
GV$ASM_TEMPLATE Synonym for GV_$ASM_TEMPLATE
GV$AW_AGGREGATE_OP Synonym for GV_$AW_AGGREGATE_OP
GV$AW_ALLOCATE_OP Synonym for GV_$AW_ALLOCATE_OP
GV$AW_CALC Synonym for GV_$AW_CALC
GV$AW_LONGOPS Synonym for GV_$AW_LONGOPS
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$BLOCKING_QUIESCE Synonym for GV_$BLOCKING_QUIESCE
GV$BSP Synonym for GV_$BSP
GV$BUFFERED_PUBLISHERS Synonym for GV_$BUFFERED_PUBLISHERS
GV$BUFFERED_QUEUES Synonym for GV_$BUFFERED_QUEUES
GV$BUFFERED_SUBSCRIBERS Synonym for GV_$BUFFERED_SUBSCRIBERS
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$CLIENT_STATS Synonym for GV_$CLIENT_STATS
GV$CLUSTER_INTERCONNECTS Synonym for GV_$CLUSTER_INTERCONNECTS
GV$CONFIGURED_INTERCONNECTS Synonym for GV_$CONFIGURED_INTERCONNECTS
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$CURRENT_BLOCK_SERVER Synonym for GV_$CURRENT_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_CONFIG Synonym for GV_$DATAGUARD_CONFIG
GV$DATAGUARD_STATUS Synonym for GV_$DATAGUARD_STATUS
GV$DATAPUMP_JOB Synonym for GV_$DATAPUMP_JOB
GV$DATAPUMP_SESSION Synonym for GV_$DATAPUMP_SESSION
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_CONFIG Synonym for GV_$DISPATCHER_CONFIG
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$ENQUEUE_STATISTICS Synonym for GV_$ENQUEUE_STATISTICS
GV$EVENTMETRIC Synonym for GV_$EVENTMETRIC
GV$EVENT_HISTOGRAM Synonym for GV_$EVENT_HISTOGRAM
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$FILEMETRIC Synonym for GV_$FILEMETRIC
GV$FILEMETRIC_HISTORY Synonym for GV_$FILEMETRIC_HISTORY
GV$FILESPACE_USAGE Synonym for GV_$FILESPACE_USAGE
GV$FILESTAT Synonym for GV_$FILESTAT
GV$FILE_CACHE_TRANSFER Synonym for GV_$FILE_CACHE_TRANSFER
GV$FILE_HISTOGRAM Synonym for GV_$FILE_HISTOGRAM
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$FLASHBACK_DATABASE_LOG Synonym for GV_$FLASHBACK_DATABASE_LOG
GV$FLASHBACK_DATABASE_LOGFILE Synonym for GV_$FLASHBACK_DATABASE_LOGFILE
GV$FLASHBACK_DATABASE_STAT Synonym for GV_$FLASHBACK_DATABASE_STAT
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_CACHE_TRANSFER Synonym for GV_$INSTANCE_CACHE_TRANSFER
GV$INSTANCE_LOG_GROUP Synonym for GV_$INSTANCE_LOG_GROUP
GV$INSTANCE_RECOVERY Synonym for GV_$INSTANCE_RECOVERY
GV$JAVAPOOL Synonym for GV_$JAVAPOOL
GV$JAVA_LIBRARY_CACHE_MEMORY Synonym for GV_$JAVA_LIBRARY_CACHE_MEMORY
GV$JAVA_POOL_ADVICE Synonym for GV_$JAVA_POOL_ADVICE
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$LOCK_TYPE Synonym for GV_$LOCK_TYPE
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_DICTIONARY_LOAD Synonym for GV_$LOGMNR_DICTIONARY_LOAD
GV$LOGMNR_LATCH Synonym for GV_$LOGMNR_LATCH
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_PROCESS Synonym for GV_$LOGSTDBY_PROCESS
GV$LOGSTDBY_PROGRESS Synonym for GV_$LOGSTDBY_PROGRESS
GV$LOGSTDBY_STATE Synonym for GV_$LOGSTDBY_STATE
GV$LOGSTDBY_STATS Synonym for GV_$LOGSTDBY_STATS
GV$LOGSTDBY_TRANSACTION Synonym for GV_$LOGSTDBY_TRANSACTION
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$METRIC Synonym for GV_$METRIC
GV$METRICGROUP Synonym for GV_$METRICGROUP
GV$METRICNAME Synonym for GV_$METRICNAME
GV$METRIC_HISTORY Synonym for GV_$METRIC_HISTORY
GV$MTTR_TARGET_ADVICE Synonym for GV_$MTTR_TARGET_ADVICE
GV$MUTEX_SLEEP Synonym for GV_$MUTEX_SLEEP
GV$MUTEX_SLEEP_HISTORY Synonym for GV_$MUTEX_SLEEP_HISTORY
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$OSSTAT Synonym for GV_$OSSTAT
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$PARAMETER_VALID_VALUES Synonym for GV_$PARAMETER_VALID_VALUES
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$PROCESS_MEMORY Synonym for GV_$PROCESS_MEMORY
GV$PROCESS_MEMORY_DETAIL Synonym for GV_$PROCESS_MEMORY_DETAIL
GV$PROCESS_MEMORY_DETAIL_PROG Synonym for GV_$PROCESS_MEMORY_DETAIL_PROG
GV$PROPAGATION_RECEIVER Synonym for GV_$PROPAGATION_RECEIVER
GV$PROPAGATION_SENDER Synonym for GV_$PROPAGATION_SENDER
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_BUFFER_ADVICE Synonym for GV_$PX_BUFFER_ADVICE
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$RESTORE_POINT Synonym for GV_$RESTORE_POINT
GV$RESUMABLE Synonym for GV_$RESUMABLE
GV$RFS_THREAD Synonym for GV_$RFS_THREAD
GV$RMAN_CONFIGURATION Synonym for GV_$RMAN_CONFIGURATION
GV$RMAN_OUTPUT Synonym for GV_$RMAN_OUTPUT
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_CONS_GROUP_HISTORY Synonym for GV_$RSRC_CONS_GROUP_HISTORY
GV$RSRC_PLAN Synonym for GV_$RSRC_PLAN
GV$RSRC_PLAN_CPU_MTH Synonym for GV_$RSRC_PLAN_CPU_MTH
GV$RSRC_PLAN_HISTORY Synonym for GV_$RSRC_PLAN_HISTORY
GV$RSRC_SESSION_INFO Synonym for GV_$RSRC_SESSION_INFO
GV$RULE Synonym for GV_$RULE
GV$RULE_SET Synonym for GV_$RULE_SET
GV$RULE_SET_AGGREGATE_STATS Synonym for GV_$RULE_SET_AGGREGATE_STATS
GV$SCHEDULER_RUNNING_JOBS Synonym for GV_$SCHEDULER_RUNNING_JOBS
GV$SEGMENT_STATISTICS Synonym for GV_$SEGMENT_STATISTICS
GV$SEGSTAT Synonym for GV_$SEGSTAT
GV$SEGSTAT_NAME Synonym for GV_$SEGSTAT_NAME
GV$SERVICEMETRIC Synonym for GV_$SERVICEMETRIC
GV$SERVICEMETRIC_HISTORY Synonym for GV_$SERVICEMETRIC_HISTORY
GV$SERVICES Synonym for GV_$SERVICES
GV$SERVICE_EVENT Synonym for GV_$SERVICE_EVENT
GV$SERVICE_STATS Synonym for GV_$SERVICE_STATS
GV$SERVICE_WAIT_CLASS Synonym for GV_$SERVICE_WAIT_CLASS
GV$SERV_MOD_ACT_STATS Synonym for GV_$SERV_MOD_ACT_STATS
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$SESSION_WAIT_CLASS Synonym for GV_$SESSION_WAIT_CLASS
GV$SESSION_WAIT_HISTORY Synonym for GV_$SESSION_WAIT_HISTORY
GV$SESSMETRIC Synonym for GV_$SESSMETRIC
GV$SESSTAT Synonym for GV_$SESSTAT
GV$SESS_IO Synonym for GV_$SESS_IO
GV$SESS_TIME_MODEL Synonym for GV_$SESS_TIME_MODEL
GV$SES_OPTIMIZER_ENV Synonym for GV_$SES_OPTIMIZER_ENV
GV$SGA Synonym for GV_$SGA
GV$SGAINFO Synonym for GV_$SGAINFO
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$SGA_TARGET_ADVICE Synonym for GV_$SGA_TARGET_ADVICE
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$SQLAREA_PLAN_HASH Synonym for GV_$SQLAREA_PLAN_HASH
GV$SQLSTATS Synonym for GV_$SQLSTATS
GV$SQLTEXT Synonym for GV_$SQLTEXT
GV$SQLTEXT_WITH_NEWLINES Synonym for GV_$SQLTEXT_WITH_NEWLINES
GV$SQL_BIND_CAPTURE Synonym for GV_$SQL_BIND_CAPTURE
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_JOIN_FILTER Synonym for GV_$SQL_JOIN_FILTER
GV$SQL_OPTIMIZER_ENV Synonym for GV_$SQL_OPTIMIZER_ENV
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_APPLY_SNAPSHOT Synonym for GV_$STANDBY_APPLY_SNAPSHOT
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$STREAMS_POOL_ADVICE Synonym for GV_$STREAMS_POOL_ADVICE
GV$STREAMS_TRANSACTION Synonym for GV_$STREAMS_TRANSACTION
GV$SUBCACHE Synonym for GV_$SUBCACHE
GV$SYSAUX_OCCUPANTS Synonym for GV_$SYSAUX_OCCUPANTS
GV$SYSMETRIC Synonym for GV_$SYSMETRIC
GV$SYSMETRIC_HISTORY Synonym for GV_$SYSMETRIC_HISTORY
GV$SYSMETRIC_SUMMARY Synonym for GV_$SYSMETRIC_SUMMARY
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$SYSTEM_WAIT_CLASS Synonym for GV_$SYSTEM_WAIT_CLASS
GV$SYS_OPTIMIZER_ENV Synonym for GV_$SYS_OPTIMIZER_ENV
GV$SYS_TIME_MODEL Synonym for GV_$SYS_TIME_MODEL
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_HISTOGRAM Synonym for GV_$TEMP_HISTOGRAM
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$THRESHOLD_TYPES Synonym for GV_$THRESHOLD_TYPES
GV$TIMER Synonym for GV_$TIMER
GV$TIMEZONE_FILE Synonym for GV_$TIMEZONE_FILE
GV$TIMEZONE_NAMES Synonym for GV_$TIMEZONE_NAMES
GV$TRANSACTION Synonym for GV_$TRANSACTION
GV$TRANSACTION_ENQUEUE Synonym for GV_$TRANSACTION_ENQUEUE
GV$TSM_SESSIONS Synonym for GV_$TSM_SESSIONS
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$WAITCLASSMETRIC Synonym for GV_$WAITCLASSMETRIC
GV$WAITCLASSMETRIC_HISTORY Synonym for GV_$WAITCLASSMETRIC_HISTORY
GV$WAITSTAT Synonym for GV_$WAITSTAT
GV$WALLET Synonym for GV_$WALLET
GV$XML_AUDIT_TRAIL Synonym for GV_$XML_AUDIT_TRAIL
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
RECYCLEBIN Synonym for USER_RECYCLEBIN
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_ADVISOR_ACTIONS
USER_ADVISOR_DIRECTIVES
USER_ADVISOR_FINDINGS
USER_ADVISOR_JOURNAL
USER_ADVISOR_LOG
USER_ADVISOR_OBJECTS
USER_ADVISOR_PARAMETERS
USER_ADVISOR_RATIONALE
USER_ADVISOR_RECOMMENDATIONS
USER_ADVISOR_SQLA_REC_SUM
USER_ADVISOR_SQLA_WK_MAP
USER_ADVISOR_SQLA_WK_STMTS
USER_ADVISOR_SQLW_COLVOL
USER_ADVISOR_SQLW_JOURNAL
USER_ADVISOR_SQLW_PARAMETERS
USER_ADVISOR_SQLW_STMTS
USER_ADVISOR_SQLW_SUM
USER_ADVISOR_SQLW_TABLES
USER_ADVISOR_SQLW_TABVOL
USER_ADVISOR_SQLW_TEMPLATES
USER_ADVISOR_TASKS
USER_ADVISOR_TEMPLATES
USER_ALL_TABLES Description of all object and relational tables owned by the user's
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_POLICY_COLUMNS Users fine grained auditing policy columns in the database
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_OBJ Objects in Analytic Workspaces owned by the user
USER_AW_PROP Object properties in 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_CHANGE_NOTIFICATION_REGS change notification registrations for current 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_DATAPUMP_JOBS Datapump jobs for current 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_ENCRYPTED_COLUMNS Encryption information on columns of tables owned by the user
USER_EPG_DAD_AUTHORIZATION DADs authorized to use the user's privileges
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_FILE_GROUPS Details about file groups
USER_FILE_GROUP_EXPORT_INFO Details about export information of file group versions
USER_FILE_GROUP_FILES Details about file group files
USER_FILE_GROUP_TABLES Details about the tables in the file group repository
USER_FILE_GROUP_TABLESPACES Details about the transportable tablespaces in the file group repository
USER_FILE_GROUP_VERSIONS Details about file group versions
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_ARRAYTYPES All array types specified by the indextype
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_STATISTICS Optimizer statistics for user's own indexes
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_COMMENTS Comments on materialized views owned 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_NESTED_TABLE_COLS Columns of nested 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 with atleast one option set
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_PLSQL_OBJECT_SETTINGS Compiler settings of stored objects owned by the user
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 user functions/procedures/packages/types/triggers
USER_PROXIES Description of connections the user is allowed to proxy
USER_PUBLISHED_COLUMNS Source columns available for Change Data Capture
USER_QUEUES All queues owned by the user
USER_QUEUE_PUBLISHERS
USER_QUEUE_SCHEDULES
USER_QUEUE_SUBSCRIBERS queue subscribers under a user'schema
USER_QUEUE_TABLES All queue tables created by the user
USER_RECYCLEBIN User view of his recyclebin
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_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_REWRITE_EQUIVALENCES Description of all rewrite equivalence owned by the 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_SCHEDULER_CHAINS All scheduler chains owned by the current user
USER_SCHEDULER_CHAIN_RULES All rules from scheduler chains owned by the current user
USER_SCHEDULER_CHAIN_STEPS All steps of scheduler chains owned by the current user
USER_SCHEDULER_JOBS All scheduler jobs in the database
USER_SCHEDULER_JOB_ARGS All arguments with set values of all scheduler jobs in the database
USER_SCHEDULER_JOB_LOG Logged information for all scheduler jobs
USER_SCHEDULER_JOB_RUN_DETAILS The details of a job run
USER_SCHEDULER_PROGRAMS Scheduler programs owned by the current user
USER_SCHEDULER_PROGRAM_ARGS All arguments of all scheduler programs in the database
USER_SCHEDULER_RUNNING_CHAINS All steps of chains being run by jobs owned by the current user
USER_SCHEDULER_SCHEDULES Schedules belonging to the current user
USER_SECONDARY_OBJECTS All secondary objects for domain indexes
USER_SEC_RELEVANT_COLS Security Relevant columns of VPD policies for tables or views owned by the user
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 Source tables available for Change Data Capture
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_SQLSET
USER_SQLSET_BINDS
USER_SQLSET_DEFINITIONS Synonym for USER_SQLSET
USER_SQLSET_PLANS
USER_SQLSET_REFERENCES
USER_SQLSET_STATEMENTS
USER_SQLTUNE_BINDS
USER_SQLTUNE_PLANS
USER_SQLTUNE_RATIONALE_PLAN
USER_SQLTUNE_STATISTICS
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 Change Data Capture subscribed columns
USER_SUBSCRIBED_TABLES Change Data Capture subscribed tables
USER_SUBSCRIPTIONS Change Data Capture subscriptions
USER_SUMMARIES Description of the summaries created by the user
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_STATISTICS Optimizer statistics of the user's own tables
USER_TAB_STATS_HISTORY History of table statistics modifications
USER_TAB_SUBPARTITIONS
USER_TRANSFORMATIONS
USER_TRIGGERS Triggers owned by the user
USER_TRIGGER_COLS Column usage in user's triggers
USER_TS
USER_TS_QUOTAS Tablespace quotas for the user
USER_TUNE_MVIEW tune_mview catalog view owned by 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_WARNING_SETTINGS Warning Parameter settings for objects owned by the user
USER_WORKSPACES
USER_XML_COLUMN_NAMES
USER_XML_INDEXES Description of the user's own XMLType indexes
USER_XML_SCHEMAS Description of XML Schemas registered by the user
USER_XML_TABLES Description of the user's own XMLType tables
USER_XML_TAB_COLS Description of the user's own XMLType tables
USER_XML_VIEWS Description of the user's own XMLType views
USER_XML_VIEW_COLS Description of the user's own XMLType views
V$ACCESS Synonym for V_$ACCESS
V$ACTIVE_INSTANCES Synonym for V_$ACTIVE_INSTANCES
V$ACTIVE_SERVICES Synonym for V_$ACTIVE_SERVICES
V$ACTIVE_SESSION_HISTORY Synonym for V_$ACTIVE_SESSION_HISTORY
V$ACTIVE_SESS_POOL_MTH Synonym for V_$ACTIVE_SESS_POOL_MTH
V$ADVISOR_PROGRESS Synonym for V_$ADVISOR_PROGRESS
V$ALERT_TYPES Synonym for V_$ALERT_TYPES
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$ASM_ALIAS Synonym for V_$ASM_ALIAS
V$ASM_CLIENT Synonym for V_$ASM_CLIENT
V$ASM_DISK Synonym for V_$ASM_DISK
V$ASM_DISKGROUP Synonym for V_$ASM_DISKGROUP
V$ASM_DISKGROUP_STAT Synonym for V_$ASM_DISKGROUP_STAT
V$ASM_DISK_STAT Synonym for V_$ASM_DISK_STAT
V$ASM_FILE Synonym for V_$ASM_FILE
V$ASM_OPERATION Synonym for V_$ASM_OPERATION
V$ASM_TEMPLATE Synonym for V_$ASM_TEMPLATE
V$AW_AGGREGATE_OP Synonym for V_$AW_AGGREGATE_OP
V$AW_ALLOCATE_OP Synonym for V_$AW_ALLOCATE_OP
V$AW_CALC Synonym for V_$AW_CALC
V$AW_LONGOPS Synonym for V_$AW_LONGOPS
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_ARCHIVELOG_DETAILS Synonym for V_$BACKUP_ARCHIVELOG_DETAILS
V$BACKUP_ARCHIVELOG_SUMMARY Synonym for V_$BACKUP_ARCHIVELOG_SUMMARY
V$BACKUP_ASYNC_IO Synonym for V_$BACKUP_ASYNC_IO
V$BACKUP_CONTROLFILE_DETAILS Synonym for V_$BACKUP_CONTROLFILE_DETAILS
V$BACKUP_CONTROLFILE_SUMMARY Synonym for V_$BACKUP_CONTROLFILE_SUMMARY
V$BACKUP_COPY_DETAILS Synonym for V_$BACKUP_COPY_DETAILS
V$BACKUP_COPY_SUMMARY Synonym for V_$BACKUP_COPY_SUMMARY
V$BACKUP_CORRUPTION Synonym for V_$BACKUP_CORRUPTION
V$BACKUP_DATAFILE Synonym for V_$BACKUP_DATAFILE
V$BACKUP_DATAFILE_DETAILS Synonym for V_$BACKUP_DATAFILE_DETAILS
V$BACKUP_DATAFILE_SUMMARY Synonym for V_$BACKUP_DATAFILE_SUMMARY
V$BACKUP_DEVICE Synonym for V_$BACKUP_DEVICE
V$BACKUP_FILES Synonym for V_$BACKUP_FILES
V$BACKUP_PIECE Synonym for V_$BACKUP_PIECE
V$BACKUP_PIECE_DETAILS Synonym for V_$BACKUP_PIECE_DETAILS
V$BACKUP_REDOLOG Synonym for V_$BACKUP_REDOLOG
V$BACKUP_SET Synonym for V_$BACKUP_SET
V$BACKUP_SET_DETAILS Synonym for V_$BACKUP_SET_DETAILS
V$BACKUP_SET_SUMMARY Synonym for V_$BACKUP_SET_SUMMARY
V$BACKUP_SPFILE Synonym for V_$BACKUP_SPFILE
V$BACKUP_SPFILE_DETAILS Synonym for V_$BACKUP_SPFILE_DETAILS
V$BACKUP_SPFILE_SUMMARY Synonym for V_$BACKUP_SPFILE_SUMMARY
V$BACKUP_SYNC_IO Synonym for V_$BACKUP_SYNC_IO
V$BGPROCESS Synonym for V_$BGPROCESS
V$BH Synonym for V_$BH
V$BLOCKING_QUIESCE Synonym for V_$BLOCKING_QUIESCE
V$BLOCK_CHANGE_TRACKING Synonym for V_$BLOCK_CHANGE_TRACKING
V$BSP Synonym for V_$BSP
V$BUFFERED_PUBLISHERS Synonym for V_$BUFFERED_PUBLISHERS
V$BUFFERED_QUEUES Synonym for V_$BUFFERED_QUEUES
V$BUFFERED_SUBSCRIBERS Synonym for V_$BUFFERED_SUBSCRIBERS
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$CLIENT_STATS Synonym for V_$CLIENT_STATS
V$CLUSTER_INTERCONNECTS Synonym for V_$CLUSTER_INTERCONNECTS
V$CONFIGURED_INTERCONNECTS Synonym for V_$CONFIGURED_INTERCONNECTS
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$CURRENT_BLOCK_SERVER Synonym for V_$CURRENT_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_CONFIG Synonym for V_$DATAGUARD_CONFIG
V$DATAGUARD_STATS Synonym for V_$DATAGUARD_STATS
V$DATAGUARD_STATUS Synonym for V_$DATAGUARD_STATUS
V$DATAPUMP_JOB Synonym for V_$DATAPUMP_JOB
V$DATAPUMP_SESSION Synonym for V_$DATAPUMP_SESSION
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$DB_TRANSPORTABLE_PLATFORM Synonym for V_$DB_TRANSPORTABLE_PLATFORM
V$DELETED_OBJECT Synonym for V_$DELETED_OBJECT
V$DISPATCHER Synonym for V_$DISPATCHER
V$DISPATCHER_CONFIG Synonym for V_$DISPATCHER_CONFIG
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$ENQUEUE_STATISTICS Synonym for V_$ENQUEUE_STATISTICS
V$EVENTMETRIC Synonym for V_$EVENTMETRIC
V$EVENT_HISTOGRAM Synonym for V_$EVENT_HISTOGRAM
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$FILEMETRIC Synonym for V_$FILEMETRIC
V$FILEMETRIC_HISTORY Synonym for V_$FILEMETRIC_HISTORY
V$FILESPACE_USAGE Synonym for V_$FILESPACE_USAGE
V$FILESTAT Synonym for V_$FILESTAT
V$FILE_CACHE_TRANSFER Synonym for V_$FILE_CACHE_TRANSFER
V$FILE_HISTOGRAM Synonym for V_$FILE_HISTOGRAM
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$FLASHBACK_DATABASE_LOG Synonym for V_$FLASHBACK_DATABASE_LOG
V$FLASHBACK_DATABASE_LOGFILE Synonym for V_$FLASHBACK_DATABASE_LOGFILE
V$FLASHBACK_DATABASE_STAT Synonym for V_$FLASHBACK_DATABASE_STAT
V$FLASH_RECOVERY_AREA_USAGE Synonym for V_$FLASH_RECOVERY_AREA_USAGE
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_CACHE_TRANSFER Synonym for V_$INSTANCE_CACHE_TRANSFER
V$INSTANCE_LOG_GROUP Synonym for V_$INSTANCE_LOG_GROUP
V$INSTANCE_RECOVERY Synonym for V_$INSTANCE_RECOVERY
V$JAVAPOOL Synonym for V_$JAVAPOOL
V$JAVA_LIBRARY_CACHE_MEMORY Synonym for V_$JAVA_LIBRARY_CACHE_MEMORY
V$JAVA_POOL_ADVICE Synonym for V_$JAVA_POOL_ADVICE
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$LOCK_TYPE Synonym for V_$LOCK_TYPE
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_DICTIONARY_LOAD Synonym for V_$LOGMNR_DICTIONARY_LOAD
V$LOGMNR_LATCH Synonym for V_$LOGMNR_LATCH
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_PROCESS Synonym for V_$LOGSTDBY_PROCESS
V$LOGSTDBY_PROGRESS Synonym for V_$LOGSTDBY_PROGRESS
V$LOGSTDBY_STATE Synonym for V_$LOGSTDBY_STATE
V$LOGSTDBY_STATS Synonym for V_$LOGSTDBY_STATS
V$LOGSTDBY_TRANSACTION Synonym for V_$LOGSTDBY_TRANSACTION
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$METRIC Synonym for V_$METRIC
V$METRICGROUP Synonym for V_$METRICGROUP
V$METRICNAME Synonym for V_$METRICNAME
V$METRIC_HISTORY Synonym for V_$METRIC_HISTORY
V$MTTR_TARGET_ADVICE Synonym for V_$MTTR_TARGET_ADVICE
V$MUTEX_SLEEP Synonym for V_$MUTEX_SLEEP
V$MUTEX_SLEEP_HISTORY Synonym for V_$MUTEX_SLEEP_HISTORY
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$OSSTAT Synonym for V_$OSSTAT
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$PARAMETER_VALID_VALUES Synonym for V_$PARAMETER_VALID_VALUES
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$PROCESS_MEMORY Synonym for V_$PROCESS_MEMORY
V$PROCESS_MEMORY_DETAIL Synonym for V_$PROCESS_MEMORY_DETAIL
V$PROCESS_MEMORY_DETAIL_PROG Synonym for V_$PROCESS_MEMORY_DETAIL_PROG
V$PROPAGATION_RECEIVER Synonym for V_$PROPAGATION_RECEIVER
V$PROPAGATION_SENDER Synonym for V_$PROPAGATION_SENDER
V$PROXY_ARCHIVEDLOG Synonym for V_$PROXY_ARCHIVEDLOG
V$PROXY_ARCHIVELOG_DETAILS Synonym for V_$PROXY_ARCHIVELOG_DETAILS
V$PROXY_ARCHIVELOG_SUMMARY Synonym for V_$PROXY_ARCHIVELOG_SUMMARY
V$PROXY_COPY_DETAILS Synonym for V_$PROXY_COPY_DETAILS
V$PROXY_COPY_SUMMARY Synonym for V_$PROXY_COPY_SUMMARY
V$PROXY_DATAFILE Synonym for V_$PROXY_DATAFILE
V$PWFILE_USERS Synonym for V_$PWFILE_USERS
V$PX_BUFFER_ADVICE Synonym for V_$PX_BUFFER_ADVICE
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_DEST Synonym for V_$RECOVERY_FILE_DEST
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$RESTORE_POINT Synonym for V_$RESTORE_POINT
V$RESUMABLE Synonym for V_$RESUMABLE
V$RFS_THREAD Synonym for V_$RFS_THREAD
V$RMAN_BACKUP_JOB_DETAILS Synonym for V_$RMAN_BACKUP_JOB_DETAILS
V$RMAN_BACKUP_SUBJOB_DETAILS Synonym for V_$RMAN_BACKUP_SUBJOB_DETAILS
V$RMAN_BACKUP_TYPE Synonym for V_$RMAN_BACKUP_TYPE
V$RMAN_CONFIGURATION Synonym for V_$RMAN_CONFIGURATION
V$RMAN_OUTPUT Synonym for V_$RMAN_OUTPUT
V$RMAN_STATUS Synonym for V_$RMAN_STATUS
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_CONS_GROUP_HISTORY Synonym for V_$RSRC_CONS_GROUP_HISTORY
V$RSRC_PLAN Synonym for V_$RSRC_PLAN
V$RSRC_PLAN_CPU_MTH Synonym for V_$RSRC_PLAN_CPU_MTH
V$RSRC_PLAN_HISTORY Synonym for V_$RSRC_PLAN_HISTORY
V$RSRC_SESSION_INFO Synonym for V_$RSRC_SESSION_INFO
V$RULE Synonym for V_$RULE
V$RULE_SET Synonym for V_$RULE_SET
V$RULE_SET_AGGREGATE_STATS Synonym for V_$RULE_SET_AGGREGATE_STATS
V$SCHEDULER_RUNNING_JOBS Synonym for V_$SCHEDULER_RUNNING_JOBS
V$SEGMENT_STATISTICS Synonym for V_$SEGMENT_STATISTICS
V$SEGSTAT Synonym for V_$SEGSTAT
V$SEGSTAT_NAME Synonym for V_$SEGSTAT_NAME
V$SERVICEMETRIC Synonym for V_$SERVICEMETRIC
V$SERVICEMETRIC_HISTORY Synonym for V_$SERVICEMETRIC_HISTORY
V$SERVICES Synonym for V_$SERVICES
V$SERVICE_EVENT Synonym for V_$SERVICE_EVENT
V$SERVICE_STATS Synonym for V_$SERVICE_STATS
V$SERVICE_WAIT_CLASS Synonym for V_$SERVICE_WAIT_CLASS
V$SERV_MOD_ACT_STATS Synonym for V_$SERV_MOD_ACT_STATS
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_FIX_CONTROL Synonym for V_$SESSION_FIX_CONTROL
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$SESSION_WAIT_CLASS Synonym for V_$SESSION_WAIT_CLASS
V$SESSION_WAIT_HISTORY Synonym for V_$SESSION_WAIT_HISTORY
V$SESSMETRIC Synonym for V_$SESSMETRIC
V$SESSTAT Synonym for V_$SESSTAT
V$SESS_IO Synonym for V_$SESS_IO
V$SESS_TIME_MODEL Synonym for V_$SESS_TIME_MODEL
V$SES_OPTIMIZER_ENV Synonym for V_$SES_OPTIMIZER_ENV
V$SGA Synonym for V_$SGA
V$SGAINFO Synonym for V_$SGAINFO
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$SGA_TARGET_ADVICE Synonym for V_$SGA_TARGET_ADVICE
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$SQLAREA_PLAN_HASH Synonym for V_$SQLAREA_PLAN_HASH
V$SQLSTATS Synonym for V_$SQLSTATS
V$SQLTEXT Synonym for V_$SQLTEXT
V$SQLTEXT_WITH_NEWLINES Synonym for V_$SQLTEXT_WITH_NEWLINES
V$SQL_BIND_CAPTURE Synonym for V_$SQL_BIND_CAPTURE
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_JOIN_FILTER Synonym for V_$SQL_JOIN_FILTER
V$SQL_OPTIMIZER_ENV Synonym for V_$SQL_OPTIMIZER_ENV
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_APPLY_SNAPSHOT Synonym for V_$STANDBY_APPLY_SNAPSHOT
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$STREAMS_POOL_ADVICE Synonym for V_$STREAMS_POOL_ADVICE
V$STREAMS_TRANSACTION Synonym for V_$STREAMS_TRANSACTION
V$SUBCACHE Synonym for V_$SUBCACHE
V$SYSAUX_OCCUPANTS Synonym for V_$SYSAUX_OCCUPANTS
V$SYSMETRIC Synonym for V_$SYSMETRIC
V$SYSMETRIC_HISTORY Synonym for V_$SYSMETRIC_HISTORY
V$SYSMETRIC_SUMMARY Synonym for V_$SYSMETRIC_SUMMARY
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_FIX_CONTROL Synonym for V_$SYSTEM_FIX_CONTROL
V$SYSTEM_PARAMETER Synonym for V_$SYSTEM_PARAMETER
V$SYSTEM_PARAMETER2 Synonym for V_$SYSTEM_PARAMETER2
V$SYSTEM_WAIT_CLASS Synonym for V_$SYSTEM_WAIT_CLASS
V$SYS_OPTIMIZER_ENV Synonym for V_$SYS_OPTIMIZER_ENV
V$SYS_TIME_MODEL Synonym for V_$SYS_TIME_MODEL
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$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_HISTOGRAM Synonym for V_$TEMP_HISTOGRAM
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$THRESHOLD_TYPES Synonym for V_$THRESHOLD_TYPES
V$TIMER Synonym for V_$TIMER
V$TIMEZONE_FILE Synonym for V_$TIMEZONE_FILE
V$TIMEZONE_NAMES Synonym for V_$TIMEZONE_NAMES
V$TRANSACTION Synonym for V_$TRANSACTION
V$TRANSACTION_ENQUEUE Synonym for V_$TRANSACTION_ENQUEUE
V$TRANSPORTABLE_PLATFORM Synonym for V_$TRANSPORTABLE_PLATFORM
V$TSM_SESSIONS Synonym for V_$TSM_SESSIONS
V$TYPE_SIZE Synonym for V_$TYPE_SIZE
V$UNDOSTAT Synonym for V_$UNDOSTAT
V$UNUSABLE_BACKUPFILE_DETAILS Synonym for V_$UNUSABLE_BACKUPFILE_DETAILS
V$VERSION Synonym for V_$VERSION
V$VPD_POLICY Synonym for V_$VPD_POLICY
V$WAITCLASSMETRIC Synonym for V_$WAITCLASSMETRIC
V$WAITCLASSMETRIC_HISTORY Synonym for V_$WAITCLASSMETRIC_HISTORY
V$WAITSTAT Synonym for V_$WAITSTAT
V$WALLET Synonym for V_$WALLET
V$XML_AUDIT_TRAIL Synonym for V_$XML_AUDIT_TRAIL
V$_LOCK Synonym for V_$_LOCK

Comments

Post a Comment

Popular posts from this blog

ORACLE FLASH RECOVERY AREA USAGE QUERY

FINDING ORACLE FLASH RECOVERY AREA USAGE SELECT NAME,        (SPACE_LIMIT / 1024 / 1024 / 1024) SPACE_LIMIT_GB,          ((SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE) / 1024 / 1024 / 1024) AS SPACE_AVAILABLE_GB,        ROUND((SPACE_USED - SPACE_RECLAIMABLE) / SPACE_LIMIT * 100, 1) AS PERCENT_FULL   FROM V$RECOVERY_FILE_DEST;

Shared Pool Tuning: Cursor Tuning (Tuning Open_Cursors, Session_Cached_Cursors, Cursor_Space_For_Time)

Shared Pool Tuning: Cursor Tuning The three most important parameter for shared pool tuning are OPEN_CURSORS , SESSION_CACHED_CURSORS and CURSOR_SPACE_FOR_TIME. But most of the time we see that these two parameters SESSION_CACHED_CURSORS and CURSOR_SPACE_FOR_TIME are ignored or unused . OPEN CURSORS Open cursors take up space in the shared pool, in the library cache. OPEN_CURSORS sets the maximum number of cursors each session can have open, per session. For example, if OPEN_CURSORS is set to 1000, then each session can have up to 1000 cursors open at one time. V$open_cursor shows cached cursors, not currently open cursors, by session. If you’re wondering how many cursors a session has open, don’t look in v$open_cursor. It shows the cursors in the session cursor cache for each session, not cursors that are actually open.  To monitor open cursors, query v$sesstat where name= ’opened cursors current’ . This will give the number of currently opened cursors, by session:

How to delete/remove Management Agent from Oracle Enterprise Manager 12C

  1. Before you deinstall a Management Agent, do the following:     a. Stop the Agent using command from Management Agent home:                 cd /u01/oemcc_latest/core/12.1.0.2.0/bin/                 $ emctl stop agent     b. Wait for the Management Agent to go to the unreachable state in the Cloud Control console.     c. It is mandatory to delete the Management Agent and their monitored targets using any of the following methods: Remove the Agent target manually from the console: 1. Login to 12C Cloud Control 2. Navigate to Setup => Manage Cloud Control => Agents 3. Go to the Home page of the Agent that you want to remove 4. Expand the drop-down menu near the " Agent " 5. Expand the " Target Setup " option 6. Select " Remove Target "            In Cloud Control Release 12.1.0.2, the following dialog box will be displayed if the Agent is still monitoring targets. Click Continue. You can then remove all targets (usin