Subprogram Overloading

CREATE OR REPLACE PACKAGE my_pkg_overload AS

  PROCEDURE p;

END my_pkg_overload;

CREATE OR REPLACE PACKAGE BODY my_pkg_overload AS

  PROCEDURE p IS

    l_data       NUMBER;

    l_other_data NUMBER;

 

    PROCEDURE p_inner(p_data IN OUT NUMBER) IS

    BEGIN

      l_data := l_data + 1;

      p_data := p_data / 2;

    END;

 

    PROCEDURE p_inner(p_input IN NUMBER, p_data IN OUT NUMBER) IS

    BEGIN

      p_data := p_input + l_data + p_data;

    END;

 

    FUNCTION p_inner(p_data IN NUMBER) RETURN NUMBER IS

      functionresult NUMBER;

    BEGIN

      functionresult := p_data + 1;

      RETURN(functionresult);

    END;

 

  BEGIN

    l_data       := 42;

    l_other_data := 84;

    p_inner(l_other_data);

 

    dbms_output.put_line('l_data = ' || l_data || ', l_other_data = ' ||

                         l_other_data);

 

    l_other_data := p_inner(l_other_data);

    dbms_output.put_line('l_data = ' || l_data || ', l_other_data = ' ||

                         l_other_data);

 

    p_inner(l_data, l_other_data);

    dbms_output.put_line('l_data = ' || l_data || ', l_other_data = ' ||

                         l_other_data);

  END;

END my_pkg_overload;

Output
----------------------------------------
l_data = 43, l_other_data = 42
l_data = 43, l_other_data = 43
l_data = 43, l_other_data = 129

I hope you all have enjoyed reading this article. Comments are welcome....

Nested Procedure in Oracle PL/SQL (procedure within a procedure)

Package my_pkg

-----------------------

CREATE OR REPLACE PACKAGE my_pkg AS

  PROCEDURE p;

END my_pkg;

CREATE OR REPLACE PACKAGE BODY my_pkg AS

  PROCEDURE p IS

    l_data       NUMBER;

    l_other_data NUMBER;

 

    PROCEDURE p_inner(p_data IN OUT NUMBER) IS

    BEGIN

      l_data := l_data + 1;

      p_data := p_data / 2;

    END;

  BEGIN

    l_data       := 42;

    l_other_data := 84;

    p_inner(l_other_data);

    dbms_output.put_line('l_data = ' || l_data || ', l_other_data = ' ||

                         l_other_data);

  END;

END my_pkg;

BEGIN

  -- call the procedure

  my_pkg.p;

END;

Output

------------

l_data = 43, l_other_data = 42

Procedure mytable

-----------------------

CREATE OR REPLACE PROCEDURE mytable(ptable_name IN VARCHAR2,

                                    pemp_name   IN VARCHAR2,

                                    pemp_age    IN NUMBER) IS

  PROCEDURE myvalues(pemp_name IN VARCHAR2, pemp_age IN NUMBER) IS

  BEGIN

    EXECUTE IMMEDIATE 'insert into ' || ptable_name ||

                      ' values(:emp_name, :emp_age)'

      USING pemp_name, pemp_age;

    dbms_output.put_line('Data Inserted');

  END;

BEGIN

  EXECUTE IMMEDIATE 'create table ' || ptable_name ||

                    ' (sname varchar2(20), sage number(4))';

  dbms_output.put_line('Table Ptable_name created');

  myvalues(pemp_name, pemp_age);

END;

BEGIN

  -- Call the procedure

  mytable(ptable_name => :ptable_name,

          pemp_name   => :pemp_name,

          pemp_age    => :pemp_age);

END;

Output

------------------

Table Ptable_name created

Data Inserted

Procedure mytable1

-----------------------

CREATE OR REPLACE PROCEDURE mytable1 IS

  PROCEDURE myvalues IS

  BEGIN

    dbms_output.put_line('Inside');

  END;

BEGIN

  myvalues;

  dbms_output.put_line('Outside');

  EXECUTE IMMEDIATE 'create or replace procedure mytable2 is

   begin

     dbms_output.put_line(' || '''' ||

                    'procedure mytable2 is created and called' || '''' || ');

     end;';

  dbms_output.put_line('procedure mytable2 is created');

  --mytable2;

END;

begin

  -- Call the procedure

  mytable1;

end;

Output

------------------

Inside

Outside

procedure mytable2 is created

I hope you all have enjoyed reading this article. Comments are welcome....

Data Dictionary Views

DBA_ROLES
All Roles which exist in the database

DBA_PROFILES
Display all profiles and their limits

USER_RESOURCE_LIMITS
Display resource limit of the user

USER_PASSWORD_LIMITS
Display password limits of the user

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

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

DBA_CATALOG
All database Tables, Views, Synonyms, Sequences

USER_CLUSTERS
Descriptions of user's own clusters

ALL_CLUSTERS
Description of clusters accessible to the user

DBA_CLUSTERS
Description of all clusters in the database

USER_CLU_COLUMNS
Mapping of table columns to cluster columns

DBA_CLU_COLUMNS
Mapping of table columns to cluster columns

USER_COL_COMMENTS
Comments on columns of user's tables and views

ALL_COL_COMMENTS
Comments on columns of accessible tables and views

DBA_COL_COMMENTS
Comments on columns of all tables and views

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

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

DBA_COL_PRIVS
All grants on columns in the database

USER_COL_PRIVS_MADE
All grants on columns of objects owned by the user

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

USER_COL_PRIVS_RECD
Grants on columns for which the user is the grantee

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

DBA_ENCRYPTED_COLUMNS
Encryption information on columns in the database

ALL_ENCRYPTED_COLUMNS
Encryption information on all accessible columns

USER_ENCRYPTED_COLUMNS
Encryption information on columns of tables owned by the user

USER_DB_LINKS
Database links owned by the user

ALL_DB_LINKS
Database links accessible to the user

DBA_DB_LINKS
All database links in the database

DBA_EXP_OBJECTS
Objects that have been incrementally exported

DBA_EXP_VERSION
Version number of the last export session

DBA_EXP_FILES
Description of export files

USER_INDEXES
Description of the user's own indexes

ALL_INDEXES
Descriptions of indexes on tables accessible to the user

DBA_INDEXES
Description for all indexes in the database

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

ALL_IND_COLUMNS
COLUMNs comprising INDEXes on accessible TABLES

DBA_IND_COLUMNS
COLUMNs comprising INDEXes on all TABLEs and CLUSTERs

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

ALL_IND_EXPRESSIONS
FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES

DBA_IND_EXPRESSIONS
FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLUSTERS

USER_JOIN_IND_COLUMNS
Join Index columns comprising the join conditions

ALL_JOIN_IND_COLUMNS
Join Index columns comprising the join conditions

DBA_JOIN_IND_COLUMNS
Join Index columns comprising the join conditions

USER_OBJECTS
Objects owned by the user

ALL_OBJECTS
Objects accessible to the user

DBA_OBJECTS
All objects in the database

USER_PROCEDURES
Description of the users own procedures

ALL_PROCEDURES
Description of all procedures available to the user

DBA_PROCEDURES
Description of all procedures

ALL_STORED_SETTINGS
Parameter settings for objects accessible to the user

USER_STORED_SETTINGS
Parameter settings for objects owned by the user

DBA_STORED_SETTINGS
Parameter settings for all objects

USER_PLSQL_OBJECT_SETTINGS
Compiler settings of stored objects owned by the user

ALL_PLSQL_OBJECT_SETTINGS
Compiler settings of stored objects accessible to the user

DBA_PLSQL_OBJECT_SETTINGS
Compiler settings of all objects in the database

ALL_ARGUMENTS
Arguments in object accessible to the user

USER_ARGUMENTS
Arguments in object accessible to the user

DBA_RESUMABLE
Resumable session information in the system

USER_RESUMABLE
Resumable session information for current user

DBA_ROLLBACK_SEGS
Description of rollback segments

USER_ROLE_PRIVS
Roles granted to current user

DBA_ROLE_PRIVS
Roles granted to users and roles

USER_SYS_PRIVS
System privileges granted to current user

DBA_SYS_PRIVS
System privileges granted to users and roles

USER_SEQUENCES
Description of the user's own SEQUENCEs

ALL_SEQUENCES
Description of SEQUENCEs accessible to the user

DBA_SEQUENCES
Description of all SEQUENCEs in the database

DBA_SYNONYMS
All synonyms in the database

USER_SYNONYMS
The user's private synonyms

ALL_SYNONYMS
All synonyms for base objects accessible to the user and session

USER_TABLES
Description of the user's own relational tables

USER_OBJECT_TABLES
Description of the user's own object tables

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

ALL_TABLES
Description of relational tables accessible to the user

ALL_OBJECT_TABLES
Description of all object tables accessible to the user

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

DBA_TABLES
Description of all relational tables in the database

DBA_OBJECT_TABLES
Description of all object tables in the database

DBA_ALL_TABLES
Description of all object and relational tables in the database

USER_TAB_COLS
Columns of user's tables, views and clusters

ALL_TAB_COLS
Columns of user's tables, views and clusters

DBA_TAB_COLS
Columns of user's tables, views and clusters

USER_TAB_COLUMNS
Columns of user's tables, views and clusters

ALL_TAB_COLUMNS
Columns of user's tables, views and clusters

DBA_TAB_COLUMNS
Columns of user's tables, views and clusters

USER_NESTED_TABLE_COLS
Columns of nested tables

ALL_NESTED_TABLE_COLS
Columns of nested tables

DBA_NESTED_TABLE_COLS
Columns of nested tables

USER_TAB_COL_STATISTICS
Columns of user's tables, views and clusters

ALL_TAB_COL_STATISTICS
Columns of user's tables, views and clusters

DBA_TAB_COL_STATISTICS
Columns of user's tables, views and clusters

USER_TAB_HISTOGRAMS
Histograms on columns of user's tables

ALL_TAB_HISTOGRAMS
Histograms on columns of all tables visible to user

DBA_TAB_HISTOGRAMS
Histograms on columns of all tables

USER_TAB_COMMENTS
Comments on the tables and views owned by the user

ALL_TAB_COMMENTS
Comments on tables and views accessible to the user

DBA_TAB_COMMENTS
Comments on all tables and views in the database

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

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

DBA_TAB_PRIVS
All grants on objects in the database

USER_TAB_PRIVS_MADE
All grants on objects owned by the user

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

USER_TAB_PRIVS_RECD
Grants on objects for which the user is the grantee

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

USER_USERS
Information about the current user

ALL_USERS
Information about all users of the database

DBA_USERS
Information about all users of the database

USER_PROXIES
Description of connections the user is allowed to proxy

DBA_PROXIES
Information about all proxy connections

USER_VIEWS
Description of the user's own views

ALL_VIEWS
Description of views accessible to the user

DBA_VIEWS
Description of all views in the database

USER_CONSTRAINTS
Constraint definitions on user's own tables

ALL_CONSTRAINTS
Constraint definitions on accessible tables

DBA_CONSTRAINTS
Constraint definitions on all tables

USER_LOG_GROUPS
Log group definitions on user's own tables

ALL_LOG_GROUPS
Log group definitions on accessible tables

DBA_LOG_GROUPS
Log group definitions on all tables

USER_CLUSTER_HASH_EXPRESSIONS
Hash functions for the user's hash clusters

ALL_CLUSTER_HASH_EXPRESSIONS
Hash functions for all accessible clusters

DBA_CLUSTER_HASH_EXPRESSIONS
Hash functions for all clusters

USER_CONS_COLUMNS
Information about accessible columns in constraint definitions

ALL_CONS_COLUMNS
Information about accessible columns in constraint definitions

DBA_CONS_COLUMNS
Information about accessible columns in constraint definitions

USER_LOG_GROUP_COLUMNS
Information about columns in log group definitions

ALL_LOG_GROUP_COLUMNS
Information about columns in log group definitions

DBA_LOG_GROUP_COLUMNS
Information about columns in log group definitions

DBA_2PC_PENDING
info about distributed transactions awaiting recovery

DBA_2PC_NEIGHBORS
information about incoming and outgoing connections for pending transactions

USER_UPDATABLE_COLUMNS
Description of updatable columns

ALL_UPDATABLE_COLUMNS
Description of all updatable columns

DBA_UPDATABLE_COLUMNS
Description of dba updatable columns

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

ALL_LOBS
Description of LOBs contained in tables accessible to the user

DBA_LOBS
Description of LOBs contained in all tables

ALL_DIRECTORIES
Description of all directories accessible to the user

DBA_DIRECTORIES
Description of all directories

USER_LIBRARIES
Description of the user's own libraries

ALL_LIBRARIES
Description of libraries accessible to the user

DBA_LIBRARIES
Description of all libraries in the database

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

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

DBA_REFS
Description of REF columns contained in all tables

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

ALL_NESTED_TABLES
Description of nested tables in tables accessible to the user

DBA_NESTED_TABLES
Description of nested tables contained in all tables

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

ALL_VARRAYS
Description of varrays in tables accessible to the user

DBA_VARRAYS
Description of varrays in tables accessible to the user

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

ALL_OBJ_COLATTRS
Description of object columns and attributes contained in the tables accessible to the use
r

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

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

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

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

ALL_SUMDELTA
Direct path load entries accessible to the user

DBA_OPERATORS
All operators

ALL_OPERATORS
All operators available to the user

USER_OPERATORS
All user operators

DBA_OPBINDINGS
All operator binding functiosn or methods

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

ALL_OPBINDINGS
All binding functions for operators available to the user

DBA_OPANCILLARY
All ancillary operators

USER_OPANCILLARY
All ancillary opertors defined by user

ALL_OPANCILLARY
All ancillary operators available to the user

DBA_OPARGUMENTS
All operator arguments

USER_OPARGUMENTS
All operator arguments of operators defined by user

ALL_OPARGUMENTS
All arguments of the operators available to the user

DBA_OPERATOR_COMMENTS
Comments for user-defined operators

USER_OPERATOR_COMMENTS
Comments for user-defined operators

ALL_OPERATOR_COMMENTS
Comments for user-defined operators

DBA_INDEXTYPES
All indextypes

USER_INDEXTYPES
All user indextypes

ALL_INDEXTYPES
All indextypes available to the user

DBA_INDEXTYPE_COMMENTS
Comments for user-defined indextypes

USER_INDEXTYPE_COMMENTS
Comments for user-defined indextypes

ALL_INDEXTYPE_COMMENTS
Comments for user-defined indextypes

DBA_INDEXTYPE_ARRAYTYPES
All array types specified by the indextype

USER_INDEXTYPE_ARRAYTYPES
All array types specified by the indextype

ALL_INDEXTYPE_ARRAYTYPES
All array types specified by the indextype

DBA_INDEXTYPE_OPERATORS
All indextype operators

USER_INDEXTYPE_OPERATORS
All user indextype operators

ALL_INDEXTYPE_OPERATORS
All operators available to the user

USER_UNUSED_COL_TABS
User tables with unused columns

ALL_UNUSED_COL_TABS
All tables with unused columns accessible to the user

DBA_UNUSED_COL_TABS
All tables with unused columns in the database

USER_PARTIAL_DROP_TABS
User tables with unused columns

ALL_PARTIAL_DROP_TABS
All tables with patially dropped columns accessible to the user

DBA_PARTIAL_DROP_TABS
All tables with partially dropped columns in the database

DBA_ASSOCIATIONS
All associations

USER_ASSOCIATIONS
All assocations defined by the user

ALL_ASSOCIATIONS
All associations available to the user

DBA_USTATS
All statistics collected on either tables or indexes

USER_USTATS
All statistics on tables or indexes owned by the user

ALL_USTATS
All statistics

USER_TAB_MODIFICATIONS
Information regarding modifications to tables

ALL_TAB_MODIFICATIONS
Information regarding modifications to tables

DBA_TAB_MODIFICATIONS
Information regarding modifications to tables

DBA_SECONDARY_OBJECTS
All secondary objects for domain indexes

USER_SECONDARY_OBJECTS
All secondary objects for domain indexes

ALL_SECONDARY_OBJECTS
All secondary objects for domain indexes

ALL_SOURCE_TABLES
Source tables available for Change Data Capture

DBA_SOURCE_TABLES
Source tables available for Change Data Capture

USER_SOURCE_TABLES
Source tables available for Change Data Capture

ALL_PUBLISHED_COLUMNS
Source columns available for Change Data Capture

DBA_PUBLISHED_COLUMNS
Source columns available for Change Data Capture

USER_PUBLISHED_COLUMNS
Source columns available for Change Data Capture

ALL_SUBSCRIPTIONS
Change Data Capture subscriptions

DBA_SUBSCRIPTIONS
Change Data Capture subscriptions

USER_SUBSCRIPTIONS
Change Data Capture subscriptions

ALL_SUBSCRIBED_TABLES
Change Data Capture subscribed tables

DBA_SUBSCRIBED_TABLES
Change Data Capture subscribed tables

USER_SUBSCRIBED_TABLES
Change Data Capture subscribed tables

ALL_SUBSCRIBED_COLUMNS
Change Data Capture subscribed columns

DBA_SUBSCRIBED_COLUMNS
Change Data Capture subscribed columns

USER_SUBSCRIBED_COLUMNS
Change Data Capture subscribed columns

ALL_DEF_AUDIT_OPTS
Auditing options for newly created objects

USER_OBJ_AUDIT_OPTS
Auditing options for user's own tables and views with atleast one option set

DBA_OBJ_AUDIT_OPTS
Auditing options for all tables and views with atleast one option set

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

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

DBA_AUDIT_TRAIL
All audit trail entries

USER_AUDIT_TRAIL
Audit trail entries relevant to the user

DBA_AUDIT_SESSION
All audit trail records concerning CONNECT and DISCONNECT

USER_AUDIT_SESSION
All audit trail records concerning CONNECT and DISCONNECT

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

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

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

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

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

ALL_TAB_STATISTICS
Optimizer statistics for all tables accessible to the user

DBA_TAB_STATISTICS
Optimizer statistics for all tables in the database

USER_TAB_STATISTICS
Optimizer statistics of the user's own tables

ALL_IND_STATISTICS
Optimizer statistics for all indexes on tables accessible to the user

DBA_IND_STATISTICS
Optimizer statistics for all indexes in the database

USER_IND_STATISTICS
Optimizer statistics for user's own indexes

USER_TYPES
Description of the user's own types

ALL_TYPES
Description of types accessible to the user

DBA_TYPES
Description of all types in the database

USER_COLL_TYPES
Description of the user's own named collection types

ALL_COLL_TYPES
Description of named collection types accessible to the user

DBA_COLL_TYPES
Description of all named collection types in the database

USER_TYPE_ATTRS
Description of attributes of the user's own types

ALL_TYPE_ATTRS
Description of attributes of types accessible to the user

DBA_TYPE_ATTRS
Description of attributes of all types in the database

USER_TYPE_METHODS
Description of methods of the user's own types

ALL_TYPE_METHODS
Description of methods of types accessible to the user

DBA_TYPE_METHODS
Description of methods of all types in the database

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

ALL_METHOD_PARAMS
Description of method parameters of types accessible
to the user

DBA_METHOD_PARAMS
Description of method parameters of all types in the database

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

ALL_METHOD_RESULTS
Description of method results of types accessible
to the user

DBA_METHOD_RESULTS
Description of method results of all types in the database

USER_SQLJ_TYPES
Description of the user's own types

ALL_SQLJ_TYPES
Description of types accessible to the user

DBA_SQLJ_TYPES
Description of all types in the database

USER_TYPE_VERSIONS
Description of each version of the user's types

ALL_TYPE_VERSIONS
Description of each type version accessible to the user

DBA_TYPE_VERSIONS
Description of each type version in the database

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

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

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

USER_SQLJ_TYPE_ATTRS
Description of attributes of the user's own types

ALL_SQLJ_TYPE_ATTRS
Description of attributes of types accessible to the user

DBA_SQLJ_TYPE_ATTRS
Description of attributes of all types in the database

USER_SQLJ_TYPE_METHODS
Description of methods of the user's own types

ALL_SQLJ_TYPE_METHODS
Description of methods of types accessible to the user

DBA_SQLJ_TYPE_METHODS
Description of methods of all types in the database

DBA_DIMENSIONS
Description of the dimension objects accessible to the DBA

ALL_DIMENSIONS
Description of the dimension objects accessible to the DBA

USER_DIMENSIONS
Description of the dimension objects accessible to the DBA

DBA_DIM_LEVELS
Description of dimension levels visible to DBA

ALL_DIM_LEVELS
Description of dimension levels visible to DBA

USER_DIM_LEVELS
Description of dimension levels visible to DBA

DBA_DIM_LEVEL_KEY
Representations of columns of a dimension level

ALL_DIM_LEVEL_KEY
Representations of columns of a dimension level

USER_DIM_LEVEL_KEY
Representations of columns of a dimension level

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

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

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

DBA_DIM_HIERARCHIES
Representation of a dimension hierarchy

ALL_DIM_HIERARCHIES
Representation of a dimension hierarchy

USER_DIM_HIERARCHIES
Representation of a dimension hierarchy

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

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

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

DBA_DIM_JOIN_KEY
Representation of a join between two dimension tables.

ALL_DIM_JOIN_KEY
Representation of a join between two dimension tables.

USER_DIM_JOIN_KEY
Representation of a join between two dimension tables.

ALL_SUMMARIES
Description of the summaries accessible to the user

USER_SUMMARIES
Description of the summaries created by the user

DBA_SUMMARIES
Description of the summaries accessible to dba

ALL_MVIEW_ANALYSIS
Description of the materialized views accessible to the user

USER_MVIEW_ANALYSIS
Description of the materialized views created by the user

DBA_MVIEW_ANALYSIS
Description of the materialized views accessible to dba

DBA_MVIEW_AGGREGATES
Description of the materialized view aggregates accessible to dba

USER_MVIEW_AGGREGATES
Description of the materialized view aggregates created by the user

ALL_MVIEW_AGGREGATES
Description of the materialized view aggregates accessible to the user

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

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

DBA_MVIEW_DETAIL_RELATIONS
Description of the materialized view detail tables accessible to dba

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

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

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

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

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

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

DBA_MVIEW_COMMENTS
Comments on all materialized views in the database

ALL_MVIEW_COMMENTS
Comments on materialized views accessible to the user

USER_MVIEW_COMMENTS
Comments on materialized views owned by the user

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

DBA_REWRITE_EQUIVALENCES
Description of rewrite equivalence accessible to DBA

ALL_REWRITE_EQUIVALENCES
Description of all rewrite equivalence accessible to the user

USER_REWRITE_EQUIVALENCES
Description of all rewrite equivalence owned by the user

DBA_TUNE_MVIEW
Catalog View to show the result after executing TUNE_MVIEW() API

USER_TUNE_MVIEW
tune_mview catalog view owned by the user

USER_EXTERNAL_TABLES
Description of the user's own external tables

ALL_EXTERNAL_TABLES
Description of the external tables accessible to the user

DBA_EXTERNAL_TABLES
Description of the external tables accessible to the DBA

USER_EXTERNAL_LOCATIONS
Description of the user's external tables locations

ALL_EXTERNAL_LOCATIONS
Description of the external tables locations accessible to the user

DBA_EXTERNAL_LOCATIONS
Description of the external tables locations accessible to the DBA

USER_RECYCLEBIN
User view of his recyclebin

DBA_RECYCLEBIN
Description of the Recyclebin view accessible to the user

DBA_CONNECT_ROLE_GRANTEES
Information regarding which users are granted CONNECT

USER_ERRORS
Current errors on stored objects owned by the user

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

DBA_ERRORS
Current errors on all stored objects in the database

USER_SOURCE
Source of stored objects accessible to the user

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

DBA_SOURCE
Source of all stored objects in the database

USER_TRIGGERS
Triggers owned by the user

ALL_TRIGGERS
Triggers accessible to the current user

DBA_TRIGGERS
All triggers in the database

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

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

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

USER_TRIGGER_COLS
Column usage in user's triggers

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

DBA_TRIGGER_COLS
Column usage in all triggers

USER_DEPENDENCIES
Dependencies to and from a users objects

ALL_DEPENDENCIES
Dependencies to and from objects accessible to the user

DBA_DEPENDENCIES
Dependencies to and from objects

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

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

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

DBA_JOBS
All jobs in the database

USER_JOBS
All jobs owned by this user

USER_WARNING_SETTINGS
Warning Parameter settings for objects owned by the user

ALL_WARNING_SETTINGS
Warnings ettings for objects accessible to the user

DBA_WARNING_SETTINGS
warning settings for all objects

USER_SEGMENTS
Storage allocated for all database segments

DBA_SEGMENTS
Storage allocated for all database segments

DBA_SEGMENTS_OLD
Storage allocated for all database segments

USER_EXTENTS
Extents comprising segments owned by the user

DBA_EXTENTS
Extents comprising all segments in the database

DBA_UNDO_EXTENTS
Extents comprising all segments in the system managed undo tablespaces

DBA_LMT_USED_EXTENTS
All extents in the locally managed tablespaces

DBA_DMT_USED_EXTENTS
All extents in the dictionary managed tablespaces

USER_FREE_SPACE
Free extents in tablespaces accessible to the user

DBA_FREE_SPACE
Free extents in all tablespaces

DBA_LMT_FREE_SPACE
Free extents in all locally managed tablespaces

DBA_DMT_FREE_SPACE
Free extents in all dictionary managed tablespaces

DBA_FREE_SPACE_COALESCED
Statistics on Coalesced Space in Tablespaces

DBA_DATA_FILES
Information about database data files

USER_TABLESPACES
Description of accessible tablespaces

DBA_TABLESPACES
Description of all tablespaces

DBA_TEMP_FILES
Information about database temp files

DBA_TABLESPACE_GROUPS
Description of all tablespace groups

DBA_TABLESPACE_USAGE_METRICS
Description of all tablespace space usage metrics

USER_TS_QUOTAS
Tablespace quotas for the user

DBA_TS_QUOTAS
Tablespace quotas for all users

ALL_CONTEXT
Description of all active context namespaces under the current session

DBA_CONTEXT
Description of all context namespace information

DBA_GLOBAL_CONTEXT
Description of all context information accessible globally

DBA_OPTSTAT_OPERATIONS
History of statistics operations performed

ALL_TAB_STATS_HISTORY
History of table statistics modifications

DBA_TAB_STATS_HISTORY
History of table statistics modifications

USER_TAB_STATS_HISTORY
History of table statistics modifications

DBA_PENDING_TRANSACTIONS
information about unresolved global transactions

USER_RULE_SETS
Rule sets owned by the user

ALL_RULE_SETS
Rule sets seen by the user

DBA_RULE_SETS
Rule sets in the database

USER_RULESETS
Rulesets owned by the user: maintained for backward compatibility

ALL_RULESETS
Rulesets seen by the user: maintained for backward compatibility

DBA_RULESETS
Rulesets in the database: maintained for backward compatibility

USER_RULES
Rules owned by the user

ALL_RULES
Rules seen by the user

DBA_RULES
Rules in the databse

USER_RULE_SET_RULES
Rules in user rule sets

ALL_RULE_SET_RULES
Rules in all rule sets seen by the user

DBA_RULE_SET_RULES
Rules in all rule sets in the database

USER_EVALUATION_CONTEXTS
rule evaluation contexts owned by user

ALL_EVALUATION_CONTEXTS
rule evaluation contexts seen by user

DBA_EVALUATION_CONTEXTS
rule evaluation contexts in the database

USER_EVALUATION_CONTEXT_TABLES
tables in user rule evaluation contexts

ALL_EVALUATION_CONTEXT_TABLES
tables in all rule evaluation contexts seen by the user

DBA_EVALUATION_CONTEXT_TABLES
tables in all rule evaluation contexts in the database

USER_EVALUATION_CONTEXT_VARS
variables in user rule evaluation contexts

ALL_EVALUATION_CONTEXT_VARS
variables in all rule evaluation contexts seen by the user

DBA_EVALUATION_CONTEXT_VARS
variables in all rule evaluation contexts in the database

DBA_QUEUE_TABLES
All queue tables created in the database

ALL_QUEUE_TABLES
All queue tables accessible to the user

USER_QUEUE_TABLES
All queue tables created by the user

DBA_QUEUES
All database queues

ALL_QUEUES
All queues accessible to the user

ALL_DEQUEUE_QUEUES
All queues accessible to the user

USER_QUEUES
All queues owned by the user

USER_QUEUE_SUBSCRIBERS
queue subscribers under a user'schema

ALL_QUEUE_SUBSCRIBERS
All queue subscribers accessible to user

DBA_QUEUE_SUBSCRIBERS
queue subscribers in the database

DBA_RSRC_PLANS
All the resource plans

DBA_RSRC_CONSUMER_GROUPS
all the resource consumer groups

DBA_RSRC_PLAN_DIRECTIVES
all the resource plan directives

DBA_RSRC_CONSUMER_GROUP_PRIVS
Switch privileges for consumer groups

USER_RSRC_CONSUMER_GROUP_PRIVS
Switch privileges for consumer groups for the user

DBA_RSRC_MANAGER_SYSTEM_PRIVS
system privileges for the resource manager

USER_RSRC_MANAGER_SYSTEM_PRIVS
system privileges for the resource manager for the user

DBA_RSRC_GROUP_MAPPINGS
all the consumer group mappings

DBA_RSRC_MAPPING_PRIORITY
the consumer group mapping attribute priorities

DBA_SNAPSHOTS
All snapshots in the database

ALL_SNAPSHOTS
Snapshots the user can access

USER_SNAPSHOTS
Snapshots the user can look at

DBA_SNAPSHOT_LOGS
All snapshot logs in the database

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

USER_SNAPSHOT_LOGS
All snapshot logs owned by the user

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

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

DBA_REFRESH
All the refresh groups

ALL_REFRESH
All the refresh groups that the user can touch

USER_REFRESH
All the refresh groups

DBA_REFRESH_CHILDREN
All the objects in refresh groups

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

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

DBA_REGISTERED_SNAPSHOTS
Remote snapshots of local tables

ALL_REGISTERED_SNAPSHOTS
Remote snapshots of local tables that the user can see

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

DBA_MVIEWS
All materialized views in the database

ALL_MVIEWS
All materialized views in the database

USER_MVIEWS
All materialized views in the database

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

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

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

DBA_MVIEW_LOGS
All materialized view logs in the database

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

USER_MVIEW_LOGS
All materialized view logs owned by the user

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

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

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

DBA_REGISTERED_MVIEWS
Remote materialized views of local tables

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

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

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

DBA_SCHEDULER_PROGRAMS
All scheduler programs in the database

USER_SCHEDULER_PROGRAMS
Scheduler programs owned by the current user

ALL_SCHEDULER_PROGRAMS
All scheduler programs visible to the user

DBA_SCHEDULER_JOBS
All scheduler jobs in the database

USER_SCHEDULER_JOBS
All scheduler jobs in the database

ALL_SCHEDULER_JOBS
All scheduler jobs visible to the user

DBA_SCHEDULER_JOB_CLASSES
All scheduler classes in the database

ALL_SCHEDULER_JOB_CLASSES
All scheduler classes visible to the user

DBA_SCHEDULER_WINDOWS
All scheduler windows in the database

ALL_SCHEDULER_WINDOWS
All scheduler windows in the database

DBA_SCHEDULER_PROGRAM_ARGS
All arguments of all scheduler programs in the database

USER_SCHEDULER_PROGRAM_ARGS
All arguments of all scheduler programs in the database

ALL_SCHEDULER_PROGRAM_ARGS
All arguments of all scheduler programs visible to the user

DBA_SCHEDULER_JOB_ARGS
All arguments with set values of all scheduler jobs in the database

USER_SCHEDULER_JOB_ARGS
All arguments with set values of all scheduler jobs in the database

ALL_SCHEDULER_JOB_ARGS
All arguments with set values of all scheduler jobs in the database

DBA_SCHEDULER_JOB_LOG
Logged information for all scheduler jobs

DBA_SCHEDULER_JOB_RUN_DETAILS
The details of a job run

USER_SCHEDULER_JOB_LOG
Logged information for all scheduler jobs

USER_SCHEDULER_JOB_RUN_DETAILS
The details of a job run

ALL_SCHEDULER_JOB_LOG
Logged information for all scheduler jobs

ALL_SCHEDULER_JOB_RUN_DETAILS
The details of a job run

DBA_SCHEDULER_WINDOW_LOG
Logged information for all scheduler windows

DBA_SCHEDULER_WINDOW_DETAILS
The details of a window

ALL_SCHEDULER_WINDOW_LOG
Logged information for all scheduler windows

ALL_SCHEDULER_WINDOW_DETAILS
The details of a window

DBA_SCHEDULER_WINDOW_GROUPS
All scheduler window groups in the database

ALL_SCHEDULER_WINDOW_GROUPS
All scheduler window groups in the database

DBA_SCHEDULER_WINGROUP_MEMBERS
Members of all scheduler window groups in the database

ALL_SCHEDULER_WINGROUP_MEMBERS
Members of all scheduler window groups in the database

DBA_SCHEDULER_SCHEDULES
All schedules in the database

USER_SCHEDULER_SCHEDULES
Schedules belonging to the current user

ALL_SCHEDULER_SCHEDULES
All schedules in the database

DBA_SCHEDULER_GLOBAL_ATTRIBUTE
All scheduler global attributes

ALL_SCHEDULER_GLOBAL_ATTRIBUTE
All scheduler global attributes

DBA_SCHEDULER_CHAINS
All scheduler chains in the database

USER_SCHEDULER_CHAINS
All scheduler chains owned by the current user

ALL_SCHEDULER_CHAINS
All scheduler chains in the database visible to current user

DBA_SCHEDULER_CHAIN_RULES
All rules from scheduler chains in the database

USER_SCHEDULER_CHAIN_RULES
All rules from scheduler chains owned by the current user

ALL_SCHEDULER_CHAIN_RULES
All rules from scheduler chains visible to the current user

DBA_SCHEDULER_CHAIN_STEPS
All steps of scheduler chains in the database

USER_SCHEDULER_CHAIN_STEPS
All steps of scheduler chains owned by the current user

ALL_SCHEDULER_CHAIN_STEPS
All steps of scheduler chains visible to the current user

DBA_SCHEDULER_RUNNING_CHAINS
All steps of all running chains in the database

USER_SCHEDULER_RUNNING_CHAINS
All steps of chains being run by jobs owned by the current user

ALL_SCHEDULER_RUNNING_CHAINS
All job steps of running job chains visible to the user

DBA_POLICIES
All row level security policies in the database

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

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

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

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

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

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

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

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

DBA_SEC_RELEVANT_COLS
Security Relevant columns of all VPD policies in the database

ALL_SEC_RELEVANT_COLS
Security Relevant columns of all VPD policies for tables or views which the user has acces
s

USER_SEC_RELEVANT_COLS
Security Relevant columns of VPD policies for tables or views owned by the user

USER_OUTLINES
Stored outlines owned by the user

DBA_OUTLINES
Stored outlines

USER_OUTLINE_HINTS
Hints stored in outlines owned by the user

DBA_OUTLINE_HINTS
Hints stored in outlines

DBA_AUDIT_POLICIES
Fine grained auditing policies in the database

DBA_AUDIT_POLICY_COLUMNS
All fine grained auditing policy columns in the database

ALL_AUDIT_POLICIES
All fine grained auditing policies in the database

ALL_AUDIT_POLICY_COLUMNS
All fine grained auditing policy columns in the database

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

DBA_FGA_AUDIT_TRAIL
All fine grained audit event logs

DBA_COMMON_AUDIT_TRAIL
Combined Standard and Fine Grained audit trail entries

DBA_EXPORT_OBJECTS
Export INCLUDE and EXCLUDE object type names

USER_DATAPUMP_JOBS
Datapump jobs for current user

DBA_DATAPUMP_JOBS
Datapump jobs

DBA_DATAPUMP_SESSIONS
Datapump sessions attached to a job

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

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_LOG
List the information about received logs from the primary

DBA_LOGSTDBY_SKIP_TRANSACTION
List the transactions to be skipped

DBA_LOGSTDBY_SKIP
List the skip settings choosen

DBA_LOGSTDBY_EVENTS
Information on why logical standby events

DBA_LOGSTDBY_HISTORY
Information on processed, active, and pending log streams

DBA_AWS
Analytic Workspaces in the database

USER_AWS
Analytic Workspaces owned by the user

ALL_AWS
Analytic Workspaces accessible to the user

DBA_AW_PS
Pagespaces in Analytic Workspaces owned by the user

USER_AW_PS
Pagespaces in Analytic Workspaces owned by the user

ALL_AW_PS
Pagespaces in Analytic Workspaces accessible to the user

DBA_REGISTERED_SNAPSHOT_GROUPS
Snapshot repgroup registration information

DBA_REGISTERED_MVIEW_GROUPS
Materialized view repgroup registration information

ALL_REPGROUP_PRIVILEGES
Information about users who are registered for object group privileges

DBA_REPGROUP_PRIVILEGES
Information about users who are registered for object group privileges

USER_REPGROUP_PRIVILEGES
Information about users who are registered for object group privileges

USER_REPGROUP
Replication information about the current user

ALL_REPGROUP
Information about replicated object groups

DBA_REPGROUP
Information about all replicated object groups

USER_REPSITES
N-way replication information about the current user

ALL_REPSITES
N-way replication information

DBA_REPSITES
N-way replication information

USER_REPSCHEMA
N-way replication information about the current user

ALL_REPSCHEMA
N-way replication information

DBA_REPSCHEMA
N-way replication information

USER_REPOBJECT
Replication information about the current user's objects

ALL_REPOBJECT
Information about replicated objects

DBA_REPOBJECT
Information about replicated objects

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

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

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

USER_REPPROP
Propagation information about the current user's objects

ALL_REPPROP
Propagation information about replicated objects

DBA_REPPROP
Propagation information about replicated objects

DBA_REPKEY_COLUMNS
Primary columns for a table using column-level replication

USER_REPKEY_COLUMNS
Primary columns for a table using column-level replication

ALL_REPKEY_COLUMNS
Primary columns for a table using column-level replication

USER_REPGENOBJECTS
Objects generated for the current user to support replication

ALL_REPGENOBJECTS
Objects generated to support replication

DBA_REPGENOBJECTS
Objects generated to support replication

USER_REPGENERATED
Objects generated for the current user to support replication

ALL_REPGENERATED
Objects generated to support replication

DBA_REPGENERATED
Objects generated to support replication

USER_REPCATLOG
Information about the current user's asynchronous administration requests

ALL_REPCATLOG
Information about asynchronous administration requests

DBA_REPCATLOG
Information about asynchronous administration requests

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

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

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

DBA_REPPRIORITY_GROUP
Information about all priority groups in the database

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

USER_REPPRIORITY_GROUP
Information about user's priority groups

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

ALL_REPPRIORITY
Values and their corresponding priorities in all priority groups which are accessible to t
he user

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

DBA_REPCOLUMN_GROUP
All column groups of replicated tables in the database

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

USER_REPCOLUMN_GROUP
All column groups of user's replicated tables

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

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

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

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

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

DBA_REPRESOLUTION_METHOD
All conflict resolution methods in the database

ALL_REPRESOLUTION_METHOD
All conflict resolution methods accessible to the user

USER_REPRESOLUTION_METHOD
All conflict resolution methods accessible to the user

DBA_REPRESOLUTION
Description of all conflict resolutions in the database

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

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

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

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

USER_REPRESOLUTION_STATISTICS
Statistics for conflict resolutions for user's replicated tables

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

ALL_REPRESOL_STATS_CONTROL
Information about statistics collection for conflict resolutions for replicated tables whi
ch are accessible to the user

USER_REPRESOL_STATS_CONTROL
Information about statistics collection for conflict resolutions for user's replicated tab
les

DBA_REPPARAMETER_COLUMN
All columns used for resolving conflicts in the database

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

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

DBA_REPAUDIT_ATTRIBUTE
Information about attributes automatically maintained for replication

ALL_REPAUDIT_ATTRIBUTE
Information about attributes automatically maintained for replication

USER_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

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

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

DBA_REPFLAVORS
Flavors defined for replicated object groups

ALL_REPFLAVORS
Flavors defined for replicated object groups

USER_REPFLAVORS
Flavors current user created for replicated object groups

DBA_REPFLAVOR_OBJECTS
Replicated objects in flavors

ALL_REPFLAVOR_OBJECTS
Replicated objects in flavors

USER_REPFLAVOR_OBJECTS
Replicated user objects in flavors

DBA_REPFLAVOR_COLUMNS
Replicated columns in flavors

ALL_REPFLAVOR_COLUMNS
Replicated columns in flavors

USER_REPFLAVOR_COLUMNS
Replicated columns from current user's tables in flavors

DBA_TEMPLATE_REFGROUPS
Table for maintaining refresh group information for template.

DBA_TEMPLATE_TARGETS
Internal table for tracking potential target databases for templates.

DBA_REPCAT_EXCEPTIONS
Repcat processing exceptions table.

DBA_REPEXTENSIONS
Information about replication extension requests

DBA_REPSITES_NEW
Information about new masters for replication extension

DBA_CAPTURE
Details about the capture process

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

DBA_CAPTURE_PARAMETERS
All parameters for capture process

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

DBA_CAPTURE_PREPARED_DATABASE
Is the local database prepared for instantiation?

ALL_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

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

DBA_CAPTURE_PREPARED_TABLES
All tables prepared for instantiation

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

DBA_CAPTURE_EXTRA_ATTRIBUTES
Extra attributes for a capture process

ALL_CAPTURE_EXTRA_ATTRIBUTES
Extra attributes for a capture process that is visible to the current user

DBA_REGISTERED_ARCHIVED_LOG
Details about the registered log files

DBA_APPLY
Details about the apply process

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

DBA_APPLY_PARAMETERS
All parameters for apply process

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

DBA_APPLY_INSTANTIATED_OBJECTS
Details about objects instantiated

DBA_APPLY_INSTANTIATED_SCHEMAS
Details about schemas instantiated

DBA_APPLY_INSTANTIATED_GLOBAL
Details about database instantiated

DBA_APPLY_KEY_COLUMNS
alternative key columns for a table for STREAMS

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

DBA_APPLY_CONFLICT_COLUMNS
Details about conflict resolution

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

DBA_APPLY_TABLE_COLUMNS
Details about the destination table columns

ALL_APPLY_TABLE_COLUMNS
Details about the columns of destination table object visible to the user

DBA_APPLY_DML_HANDLERS
Details about the dml handler

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

DBA_APPLY_PROGRESS
Information about the progress made by apply process

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

DBA_APPLY_ERROR
Error transactions

ALL_APPLY_ERROR
Error transactions that were generated after dequeuing from the queue visible to the curre
nt user

DBA_APPLY_ENQUEUE
Details about the apply enqueue action

ALL_APPLY_ENQUEUE
Details about the apply enqueue action for user accessible rules where the destination que
ue exists and is visible to the user

DBA_APPLY_EXECUTE
Details about the apply execute action

ALL_APPLY_EXECUTE
Details about the apply execute action for all rules visible to the user

DBA_APPLY_SPILL_TXN
Streams apply spilled transactions info

DBA_PROPAGATION
Streams propagation in the database

ALL_PROPAGATION
Streams propagation seen by the user

DBA_FILE_GROUPS
Details about file groups

DBA_FILE_GROUP_VERSIONS
Details about file group versions

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_TABLESPACES
Details about the transportable tablespaces in the file group repository

DBA_FILE_GROUP_TABLES
Details about the tables in the file group repository

ALL_FILE_GROUPS
Details about file groups

ALL_FILE_GROUP_VERSIONS
Details about file group versions

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_TABLESPACES
Details about the transportable tablespaces in the file group repository

ALL_FILE_GROUP_TABLES
Details about the tables in the file group repository

USER_FILE_GROUPS
Details about file groups

USER_FILE_GROUP_VERSIONS
Details about file group versions

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_TABLESPACES
Details about the transportable tablespaces in the file group repository

USER_FILE_GROUP_TABLES
Details about the tables in the file group repository

DBA_STREAMS_MESSAGE_CONSUMERS
Streams messaging consumers

ALL_STREAMS_MESSAGE_CONSUMERS
Streams messaging consumers visible to the current user

DBA_STREAMS_GLOBAL_RULES
Global rules created by streams administrative APIs

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

DBA_STREAMS_SCHEMA_RULES
Schema rules created by streams administrative APIs

ALL_STREAMS_SCHEMA_RULES
Rules created by streams administrative APIs on all user schemas

DBA_STREAMS_TABLE_RULES
Table rules created by streams administrative APIs

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

DBA_STREAMS_MESSAGE_RULES
Rules for Streams messaging

ALL_STREAMS_MESSAGE_RULES
Rules for Streams messaging visible to the current user

DBA_STREAMS_RULES
Rules used by Streams processes

ALL_STREAMS_RULES
Rules used by streams processes

DBA_STREAMS_TRANSFORM_FUNCTION
Rules-based transform functions used by Streams

ALL_STREAMS_TRANSFORM_FUNCTION
Rules-based transform functions used by Streams

DBA_STREAMS_ADMINISTRATOR
Users granted the privileges to be a streams administrator

DBA_STREAMS_UNSUPPORTED
List of all the tables that are not supported by Streams in this release

ALL_STREAMS_UNSUPPORTED
List of all the tables that are not supported by Streams in this release

DBA_STREAMS_NEWLY_SUPPORTED
List of tables that are newly supported by Streams

ALL_STREAMS_NEWLY_SUPPORTED
List of tables that are newly supported by Streams

DBA_STREAMS_TRANSFORMATIONS
Transformations defined on rules

DBA_STREAMS_RENAME_SCHEMA
Rename schema transformations

DBA_STREAMS_RENAME_TABLE
Rename table transformations

DBA_STREAMS_DELETE_COLUMN
Delete column transformations

DBA_STREAMS_RENAME_COLUMN
Rename column transformations

DBA_STREAMS_ADD_COLUMN
Add column transformations

DBA_RECOVERABLE_SCRIPT
Details about recoverable operations

DBA_RECOVERABLE_SCRIPT_PARAMS
Details about the recoverable operation parameters

DBA_RECOVERABLE_SCRIPT_BLOCKS
Details about the recoverable script blocks

DBA_RECOVERABLE_SCRIPT_ERRORS
Details showing errors during script execution

DBA_TSM_SOURCE
Transparent session migration source session statistics

DBA_TSM_DESTINATION
Transparent session migration source session statistics

DBA_TSM_HISTORY
Transparent session migration statistics

DBA_CHANGE_NOTIFICATION_REGS
Description of the registrations for change notification

USER_CHANGE_NOTIFICATION_REGS
change notification registrations for current user

DBA_FEATURE_USAGE_STATISTICS
Database Feature Usage Statistics

DBA_HIGH_WATER_MARK_STATISTICS
Database High Water Mark Statistics

DBA_CPU_USAGE_STATISTICS
Database CPU Usage Statistics

DBA_OUTSTANDING_ALERTS
Description of all outstanding alerts

DBA_ALERT_HISTORY
Description on alert history

DBA_THRESHOLDS
Desription of all thresholds

DBA_ALERT_ARGUMENTS
Message Id and arguments of outstanding alerts

DBA_ENABLED_TRACES
Information about enabled SQL traces

DBA_ENABLED_AGGREGATIONS
Information about enabled on-demand statistic aggregation

DBA_HIST_DATABASE_INSTANCE
Database Instance Information

DBA_HIST_SNAPSHOT
Snapshot Information

DBA_HIST_SNAP_ERROR
Snapshot Error Information

DBA_HIST_BASELINE
Baseline Metadata Information

DBA_HIST_WR_CONTROL
Workload Repository Control Information

DBA_HIST_DATAFILE
Names of Datafiles

DBA_HIST_FILESTATXS
Datafile Historical Statistics Information

DBA_HIST_TEMPFILE
Names of Temporary Datafiles

DBA_HIST_TEMPSTATXS
Temporary Datafile Historical Statistics Information

DBA_HIST_COMP_IOSTAT
I/O stats aggregated on component level

DBA_HIST_SQLSTAT
SQL Historical Statistics Information

DBA_HIST_SQLTEXT
SQL Text

DBA_HIST_SQL_SUMMARY
Summary of SQL Statistics

DBA_HIST_SQL_PLAN
SQL Plan Information

DBA_HIST_SQL_BIND_METADATA
SQL Bind Metadata Information

DBA_HIST_SQLBIND
SQL Bind Information

DBA_HIST_OPTIMIZER_ENV
Optimizer Environment Information

DBA_HIST_EVENT_NAME
Event Names

DBA_HIST_SYSTEM_EVENT
System Event Historical Statistics Information

DBA_HIST_BG_EVENT_SUMMARY
Summary of Background Event Historical Statistics Information

DBA_HIST_WAITSTAT
Wait Historical Statistics Information

DBA_HIST_ENQUEUE_STAT
Enqueue Historical Statistics Information

DBA_HIST_LATCH_NAME
Latch Names

DBA_HIST_LATCH
Latch Historical Statistics Information

DBA_HIST_LATCH_CHILDREN
Latch Children Historical Statistics Information

DBA_HIST_LATCH_PARENT
Latch Parent Historical Historical Statistics Information

DBA_HIST_LATCH_MISSES_SUMMARY
Latch Misses Summary Historical Statistics Information

DBA_HIST_LIBRARYCACHE
Library Cache Historical Statistics Information

DBA_HIST_DB_CACHE_ADVICE
DB Cache Advice History Information

DBA_HIST_BUFFER_POOL_STAT
Buffer Pool Historical Statistics Information

DBA_HIST_ROWCACHE_SUMMARY
Row Cache Historical Statistics Information Summary

DBA_HIST_SGA
SGA Historical Statistics Information

DBA_HIST_SGASTAT
SGA Pool Historical Statistics Information

DBA_HIST_PGASTAT
PGA Historical Statistics Information

DBA_HIST_PROCESS_MEM_SUMMARY
Process Memory Historical Summary Information

DBA_HIST_RESOURCE_LIMIT
Resource Limit Historical Statistics Information

DBA_HIST_SHARED_POOL_ADVICE
Shared Pool Advice History

DBA_HIST_STREAMS_POOL_ADVICE
Streams Pool Advice History

DBA_HIST_SQL_WORKAREA_HSTGRM
SQL Workarea Histogram History

DBA_HIST_PGA_TARGET_ADVICE
PGA Target Advice History

DBA_HIST_SGA_TARGET_ADVICE
SGA Target Advice History

DBA_HIST_INSTANCE_RECOVERY
Instance Recovery Historical Statistics Information

DBA_HIST_JAVA_POOL_ADVICE
Java Pool Advice History

DBA_HIST_THREAD
Thread Historical Statistics Information

DBA_HIST_STAT_NAME
Statistic Names

DBA_HIST_SYSSTAT
System Historical Statistics Information

DBA_HIST_SYS_TIME_MODEL
System Time Model Historical Statistics Information

DBA_HIST_OSSTAT_NAME
Operating System Statistic Names

DBA_HIST_OSSTAT
Operating System Historical Statistics Information

DBA_HIST_PARAMETER_NAME
Parameter Names

DBA_HIST_PARAMETER
Parameter Historical Statistics Information

DBA_HIST_UNDOSTAT
Undo Historical Statistics Information

DBA_HIST_SEG_STAT
 Historical Statistics Information

DBA_HIST_SEG_STAT_OBJ
Segment Names

DBA_HIST_METRIC_NAME
Segment Names

DBA_HIST_SYSMETRIC_HISTORY
System Metrics History

DBA_HIST_SYSMETRIC_SUMMARY
System Metrics History

DBA_HIST_SESSMETRIC_HISTORY
System Metrics History

DBA_HIST_FILEMETRIC_HISTORY
File Metrics History

DBA_HIST_WAITCLASSMET_HISTORY
Wait Class Metric History

DBA_HIST_DLM_MISC
Distributed Lock Manager Miscellaneous Historical Statistics Information

DBA_HIST_CR_BLOCK_SERVER
Consistent Read Block Server Historical Statistics

DBA_HIST_CURRENT_BLOCK_SERVER
Current Block Server Historical Statistics

DBA_HIST_INST_CACHE_TRANSFER
Instance Cache Transfer Historical Statistics

DBA_HIST_ACTIVE_SESS_HISTORY
Active Session Historical Statistics Information

DBA_HIST_TABLESPACE_STAT
Tablespace Historical Statistics Information

DBA_HIST_LOG
Log Historical Statistics Information

DBA_HIST_MTTR_TARGET_ADVICE
Mean-Time-To-Recover Target Advice History

DBA_HIST_TBSPC_SPACE_USAGE
Tablespace Usage Historical Statistics Information

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_SESS_TIME_STATS
CPU and I/O time for interesting (STREAMS) sessions

DBA_HIST_STREAMS_CAPTURE
STREAMS Capture Historical Statistics Information

DBA_HIST_STREAMS_APPLY_SUM
STREAMS Apply 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_RULE_SET
Rule sets historical statistics information

DBA_RESOURCE_INCARNATIONS
Resource incarnations that are running or eligible for HA status notification

DBA_JAVA_POLICY
java security Permissions for all users

USER_JAVA_POLICY
java security Permissions for current user

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

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

DBA_JAVA_CLASSES
class level information of all stored java classes

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

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

DBA_JAVA_LAYOUTS
class layout information about stored java class

USER_JAVA_IMPLEMENTS
interfaces implemented by the stored java class owned by user

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

DBA_JAVA_IMPLEMENTS
interfaces implemented by the stored java class

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

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

DBA_JAVA_INNERS
list of inner classes refered by the stored java class

USER_JAVA_FIELDS
field information of stored java class owned by the user

ALL_JAVA_FIELDS
field information of stored java class accessible to user

DBA_JAVA_FIELDS
field information of all stored java class

USER_JAVA_METHODS
method information of stored java class owned by the user

ALL_JAVA_METHODS
method information of stored java class accessible to user

DBA_JAVA_METHODS
method information of all stored java class

USER_JAVA_ARGUMENTS
argument information of stored java class owned by the user

ALL_JAVA_ARGUMENTS
argument information of stored java class accessible to the user

DBA_JAVA_ARGUMENTS
argument information of all stored java class

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

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

DBA_JAVA_THROWS
list of exceptions thrown from a method of a class owned by 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

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

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

USER_JAVA_RESOLVERS
resolver of java class owned by user

ALL_JAVA_RESOLVERS
resolver of java class owned by user

DBA_JAVA_RESOLVERS
resolver of java class owned by user

USER_JAVA_NCOMPS
ncomp related information of java classes owned by user

ALL_JAVA_NCOMPS
ncomp related information of all java classes

USER_EPG_DAD_AUTHORIZATION
DADs authorized to use the user's privileges

DBA_EPG_DAD_AUTHORIZATION
DADs authorized to use different user's privileges

DBA_XML_TABLES
Description of all XML tables in the database

ALL_XML_TABLES
Description of the all XMLType tables that the user has privileges on

USER_XML_TABLES
Description of the user's own XMLType tables

DBA_XML_TAB_COLS
Description of all XML tables in the database

ALL_XML_TAB_COLS
Description of the all XMLType tables that the user has privileges on

USER_XML_TAB_COLS
Description of the user's own XMLType tables

DBA_XML_VIEWS
Description of all XML views in the database

ALL_XML_VIEWS
Description of the all XMLType views that the user has privileges on

USER_XML_VIEWS
Description of the user's own XMLType views

DBA_XML_VIEW_COLS
Description of all XML views in the database

ALL_XML_VIEW_COLS
Description of the all XMLType views that the user has privileges on

USER_XML_VIEW_COLS
Description of the user's own XMLType views

DBA_XML_SCHEMAS
Description of all the XML Schemas registered

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

USER_XML_SCHEMAS
Description of XML Schemas registered by the user

DBA_XML_INDEXES
Description of all XML indexes in the database

ALL_XML_INDEXES
Description of the all XMLType indexes that the user has privileges on

USER_XML_INDEXES
Description of the user's own XMLType indexes

DBA_AW_PROP
Object properties in Analytic Workspaces in the database

USER_AW_PROP
Object properties in Analytic Workspaces owned by the user

ALL_AW_PROP
Object properties in Analytic Workspaces accessible to the user

DBA_AW_OBJ
Objects in Analytic Workspaces in the database

USER_AW_OBJ
Objects in Analytic Workspaces owned by the user

ALL_AW_OBJ
Objects in Analytic Workspaces accessible to the user

ALL_AW_PROP_NAME
Analytic Workspace property names accessible to the user

ALL_AW_AC
Active Catalog Analytic Workspaces accessible to the user

DBA_LOGMNR_PURGED_LOG


DBA_ADVISOR_SQLW_JOURNAL


ALL_SUBPART_HISTOGRAMS


USER_SQLTUNE_RATIONALE_PLAN


DBA_ADVISOR_RECOMMENDATIONS


DBA_ANALYZE_OBJECTS


USER_ADVISOR_DIRECTIVES


USER_ADVISOR_RECOMMENDATIONS


DBA_PART_HISTOGRAMS


ALL_TAB_SUBPARTITIONS


DBA_PART_LOBS


ALL_SQLSET_REFERENCES


USER_XML_COLUMN_NAMES


DBA_QUEUE_PUBLISHERS


DBA_IAS_GEN_STMTS_EXP


DBA_CACHEABLE_OBJECTS


DBA_ADVISOR_SQLA_REC_SUM


DBA_ADVISOR_SQLA_WK_MAP


DBA_IAS_OBJECTS_BASE


DBA_ADVISOR_SQLW_TEMPLATES


USER_ADVISOR_PARAMETERS


USER_PART_TABLES


USER_PART_COL_STATISTICS


DBA_AQ_AGENTS


DBA_TRANSFORMATIONS


USER_ADVISOR_RATIONALE


USER_ADVISOR_SQLA_REC_SUM


DBA_REGISTRY_HISTORY


DBA_ADVISOR_SQLW_STMTS


USER_SUBPART_KEY_COLUMNS


DBA_ADVISOR_JOURNAL


DBA_ADVISOR_RATIONALE


USER_WORKSPACES


DBA_CACHEABLE_TABLES_BASE


USER_ADVISOR_FINDINGS


DBA_LOCK_INTERNAL


DBA_SERVER_REGISTRY


DBA_ADVISOR_SQLW_TABVOL


USER_SQLSET_STATEMENTS


DBA_REGISTRY_LOG


DBA_SQLTUNE_RATIONALE_PLAN


USER_LOB_PARTITIONS


DBA_IAS_SITES


ALL_SERVICES


DBA_BLOCKERS


DBA_ADVISOR_SQLW_PARAMETERS


USER_SQLSET_REFERENCES


USER_ADVISOR_SQLW_JOURNAL


DBA_ADVISOR_ACTIONS


ALL_PART_HISTOGRAMS


DBA_LOB_PARTITIONS


DBA_ADVISOR_DIRECTIVES


ALL_IND_PARTITIONS


DBA_ATTRIBUTE_TRANSFORMATIONS


USER_ADVISOR_TASKS


DBA_ADVISOR_FINDINGS


DBA_LOB_SUBPARTITIONS


USER_ADVISOR_SQLW_STMTS


ALL_PART_LOBS


DBA_DDL_LOCKS


ALL_SQLSET


DBA_DML_LOCKS


DBA_PART_INDEXES


DBA_IAS_GEN_STMTS


DBA_AQ_AGENT_PRIVS


DBA_ADVISOR_PARAMETERS


USER_ADVISOR_SQLW_SUM


DBA_ADVISOR_SQLW_COLVOL


USER_ADVISOR_SQLW_TEMPLATES


DBA_ADVISOR_DEFINITIONS


USER_ADVISOR_OBJECTS


DBA_CACHEABLE_TABLES


USER_REGISTRY


ALL_REGISTRY_BANNERS


USER_IND_PARTITIONS


DBA_IAS_TEMPLATES


DBA_SQLSET_REFERENCES


DBA_ADVISOR_OBJECTS


USER_TAB_SUBPARTITIONS


DBA_REPCAT


DBA_IAS_PREGEN_STMTS


DBA_PART_KEY_COLUMNS


DBA_SQLTUNE_STATISTICS


USER_TRANSFORMATIONS


DBA_WORKSPACES


DBA_ADVISOR_USAGE


DBA_ADVISOR_TEMPLATES


DBA_SUBPART_HISTOGRAMS


USER_ADVISOR_TEMPLATES


DBA_REGISTRY_HIERARCHY


USER_REPCONFLICT


DBA_KGLLOCK


ALL_PART_KEY_COLUMNS


USER_ADVISOR_SQLA_WK_STMTS


DBA_LOGMNR_SESSION


ALL_LOB_SUBPARTITIONS


DBA_PART_COL_STATISTICS


ALL_SQLSET_BINDS


DBA_LOGMNR_LOG


USER_SQLTUNE_STATISTICS


DBA_REGISTRY


DBA_IAS_OBJECTS


ALL_PART_TABLES


ALL_PART_COL_STATISTICS


ALL_PART_INDEXES


USER_ADVISOR_JOURNAL


USER_LOB_SUBPARTITIONS


DBA_SUBPART_COL_STATISTICS


USER_REPCAT


USER_ADVISOR_SQLW_TABLES


DBA_IAS_POSTGEN_STMTS


DBA_ADVISOR_OBJECT_TYPES


USER_SUBPART_HISTOGRAMS


USER_QUEUE_PUBLISHERS


ALL_WORKSPACES


USER_SQLTUNE_PLANS


USER_LOB_TEMPLATES


USER_PART_LOBS


ALL_TAB_PARTITIONS


DBA_ADVISOR_COMMANDS


DBA_LOB_TEMPLATES


USER_SQLTUNE_BINDS


DBA_ADVISOR_LOG


ALL_SQLSET_PLANS


ALL_REPCAT


DBA_SQLSET


DBA_IND_SUBPARTITIONS


DBA_PART_TABLES


DBA_ADVISOR_DEF_PARAMETERS


ALL_PROBE_OBJECTS


USER_SUBPARTITION_TEMPLATES


DBA_IAS_OBJECTS_EXP


DBA_TAB_PARTITIONS


ALL_SUBPARTITION_TEMPLATES


DBA_SQLSET_BINDS


DBA_SQLTUNE_BINDS


DBA_SQLSET_STATEMENTS


DBA_SUBPARTITION_TEMPLATES


USER_PART_INDEXES


USER_ADVISOR_SQLA_WK_MAP


USER_ADVISOR_ACTIONS


ALL_SUBPART_COL_STATISTICS


DBA_ADVISOR_TASKS


ALL_IND_SUBPARTITIONS


DBA_SQLSET_PLANS


USER_TS


USER_PART_HISTOGRAMS


USER_ATTRIBUTE_TRANSFORMATIONS


USER_SQLSET_PLANS


DBA_IND_PARTITIONS


DBA_IAS_CONSTRAINT_EXP


USER_IND_SUBPARTITIONS


USER_TAB_PARTITIONS


DBA_TAB_SUBPARTITIONS


USER_PART_KEY_COLUMNS


DBA_ADVISOR_SQLW_TABLES


USER_QUEUE_SCHEDULES


USER_SUBPART_COL_STATISTICS


ALL_LOB_PARTITIONS


DBA_SUBPART_KEY_COLUMNS


USER_SQLSET_BINDS


DBA_LOCK


DBA_SQLTUNE_PLANS


ALL_SQLSET_STATEMENTS


DBA_ADVISOR_SQLA_WK_STMTS


USER_ADVISOR_LOG


DBA_WORKSPACE_SESSIONS


DBA_JAVA_NCOMPS


USER_ADVISOR_SQLW_COLVOL


DBA_ADVISOR_SQLW_SUM


ALL_LOB_TEMPLATES


DBA_CACHEABLE_NONTABLE_OBJECTS


DBA_QUEUE_SCHEDULES


USER_AQ_AGENT_PRIVS


ALL_SUBPART_KEY_COLUMNS


ALL_AW_AC_10G


DBA_CACHEABLE_OBJECTS_BASE


USER_ADVISOR_SQLW_PARAMETERS


USER_ADVISOR_SQLW_TABVOL


USER_SQLSET


DBA_WAITERS


DBA_ADVISOR_PARAMETERS_PROJ


ALL_QUEUE_PUBLISHERS


SESSION_PRIVS
Privileges which the user currently has set

SESSION_ROLES
Roles which the user currently has enabled.

ROLE_SYS_PRIVS
System privileges granted to roles

ROLE_TAB_PRIVS
Table privileges granted to roles

ROLE_ROLE_PRIVS
Roles which are granted to roles

RESOURCE_COST
Cost for each resource

DICTIONARY
Description of data dictionary tables and views

DICT_COLUMNS
Description of columns in data dictionary tables and views

INDEX_STATS
statistics on the b-tree

INDEX_HISTOGRAM
statistics on keys with repeat count

NLS_SESSION_PARAMETERS
NLS parameters of the user session

NLS_INSTANCE_PARAMETERS
NLS parameters of the instance

NLS_DATABASE_PARAMETERS
Permanent NLS parameters of the database

DATABASE_COMPATIBLE_LEVEL
Database compatible parameter set via init.ora

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

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

GLOBAL_NAME
global database name

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

DBMS_ALERT_INFO


DBMS_LOCK_ALLOCATED


DUAL


V$MAP_LIBRARY
Synonym for V_$MAP_LIBRARY

V$MAP_FILE
Synonym for V_$MAP_FILE

V$MAP_FILE_EXTENT
Synonym for V_$MAP_FILE_EXTENT

V$MAP_ELEMENT
Synonym for V_$MAP_ELEMENT

V$MAP_EXT_ELEMENT
Synonym for V_$MAP_EXT_ELEMENT

V$MAP_COMP_LIST
Synonym for V_$MAP_COMP_LIST

V$MAP_SUBELEMENT
Synonym for V_$MAP_SUBELEMENT

V$MAP_FILE_IO_STACK
Synonym for V_$MAP_FILE_IO_STACK

V$SQL_REDIRECTION
Synonym for V_$SQL_REDIRECTION

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_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$PGA_TARGET_ADVICE
Synonym for V_$PGA_TARGET_ADVICE

V$PGA_TARGET_ADVICE_HISTOGRAM
Synonym for V_$PGA_TARGET_ADVICE_HISTOGRAM

V$PGASTAT
Synonym for V_$PGASTAT

V$SYS_OPTIMIZER_ENV
Synonym for V_$SYS_OPTIMIZER_ENV

V$SES_OPTIMIZER_ENV
Synonym for V_$SES_OPTIMIZER_ENV

V$SQL_OPTIMIZER_ENV
Synonym for V_$SQL_OPTIMIZER_ENV

V$DLM_MISC
Synonym for V_$DLM_MISC

V$DLM_LATCH
Synonym for V_$DLM_LATCH

V$DLM_CONVERT_LOCAL
Synonym for V_$DLM_CONVERT_LOCAL

V$DLM_CONVERT_REMOTE
Synonym for V_$DLM_CONVERT_REMOTE

V$DLM_ALL_LOCKS
Synonym for V_$DLM_ALL_LOCKS

V$DLM_LOCKS
Synonym for V_$DLM_LOCKS

V$DLM_RESS
Synonym for V_$DLM_RESS

V$HVMASTER_INFO
Synonym for V_$HVMASTER_INFO

V$GCSHVMASTER_INFO
Synonym for V_$GCSHVMASTER_INFO

V$GCSPFMASTER_INFO
Synonym for V_$GCSPFMASTER_INFO

GV$DLM_TRAFFIC_CONTROLLER
Synonym for GV_$DLM_TRAFFIC_CONTROLLER

V$DLM_TRAFFIC_CONTROLLER
Synonym for V_$DLM_TRAFFIC_CONTROLLER

V$GES_ENQUEUE
Synonym for V_$GES_ENQUEUE

V$GES_BLOCKING_ENQUEUE
Synonym for V_$GES_BLOCKING_ENQUEUE

V$GC_ELEMENT
Synonym for V_$GC_ELEMENT

V$CR_BLOCK_SERVER
Synonym for V_$CR_BLOCK_SERVER

V$CURRENT_BLOCK_SERVER
Synonym for V_$CURRENT_BLOCK_SERVER

V$GC_ELEMENTS_WITH_COLLISIONS
Synonym for V_$GC_ELEMENTS_W_COLLISIONS

V$FILE_CACHE_TRANSFER
Synonym for V_$FILE_CACHE_TRANSFER

V$TEMP_CACHE_TRANSFER
Synonym for V_$TEMP_CACHE_TRANSFER

V$CLASS_CACHE_TRANSFER
Synonym for V_$CLASS_CACHE_TRANSFER

V$BH
Synonym for V_$BH

V$LOCK_ELEMENT
Synonym for V_$LOCK_ELEMENT

V$LOCKS_WITH_COLLISIONS
Synonym for V_$LOCKS_WITH_COLLISIONS

V$FILE_PING
Synonym for V_$FILE_PING

V$TEMP_PING
Synonym for V_$TEMP_PING

V$CLASS_PING
Synonym for V_$CLASS_PING

V$INSTANCE_CACHE_TRANSFER
Synonym for V_$INSTANCE_CACHE_TRANSFER

V$BUFFER_POOL
Synonym for V_$BUFFER_POOL

V$BUFFER_POOL_STATISTICS
Synonym for V_$BUFFER_POOL_STATISTICS

V$INSTANCE_RECOVERY
Synonym for V_$INSTANCE_RECOVERY

V$CONTROLFILE
Synonym for V_$CONTROLFILE

V$LOG
Synonym for V_$LOG

V$STANDBY_LOG
Synonym for V_$STANDBY_LOG

V$DATAGUARD_STATUS
Synonym for V_$DATAGUARD_STATUS

V$THREAD
Synonym for V_$THREAD

V$PROCESS
Synonym for V_$PROCESS

V$BGPROCESS
Synonym for V_$BGPROCESS

V$SESSION
Synonym for V_$SESSION

V$LICENSE
Synonym for V_$LICENSE

V$TRANSACTION
Synonym for V_$TRANSACTION

V$BSP
Synonym for V_$BSP

V$FAST_START_SERVERS
Synonym for V_$FAST_START_SERVERS

V$FAST_START_TRANSACTIONS
Synonym for V_$FAST_START_TRANSACTIONS

V$LOCKED_OBJECT
Synonym for V_$LOCKED_OBJECT

V$LATCH
Synonym for V_$LATCH

V$LATCH_CHILDREN
Synonym for V_$LATCH_CHILDREN

V$LATCH_PARENT
Synonym for V_$LATCH_PARENT

V$LATCHNAME
Synonym for V_$LATCHNAME

V$LATCHHOLDER
Synonym for V_$LATCHHOLDER

V$LATCH_MISSES
Synonym for V_$LATCH_MISSES

V$SESSION_LONGOPS
Synonym for V_$SESSION_LONGOPS

V$RESOURCE
Synonym for V_$RESOURCE

V$_LOCK
Synonym for V_$_LOCK

V$LOCK
Synonym for V_$LOCK

V$SESSTAT
Synonym for V_$SESSTAT

V$MYSTAT
Synonym for V_$MYSTAT

V$SUBCACHE
Synonym for V_$SUBCACHE

V$SYSSTAT
Synonym for V_$SYSSTAT

V$STATNAME
Synonym for V_$STATNAME

V$OSSTAT
Synonym for V_$OSSTAT

V$ACCESS
Synonym for V_$ACCESS

V$OBJECT_DEPENDENCY
Synonym for V_$OBJECT_DEPENDENCY

V$DBFILE
Synonym for V_$DBFILE

V$FILESTAT
Synonym for V_$FILESTAT

V$TEMPSTAT
Synonym for V_$TEMPSTAT

V$LOGFILE
Synonym for V_$LOGFILE

V$FLASHBACK_DATABASE_LOGFILE
Synonym for V_$FLASHBACK_DATABASE_LOGFILE

V$FLASHBACK_DATABASE_LOG
Synonym for V_$FLASHBACK_DATABASE_LOG

V$FLASHBACK_DATABASE_STAT
Synonym for V_$FLASHBACK_DATABASE_STAT

V$RESTORE_POINT
Synonym for V_$RESTORE_POINT

V$ROLLNAME
Synonym for V_$ROLLNAME

V$ROLLSTAT
Synonym for V_$ROLLSTAT

V$UNDOSTAT
Synonym for V_$UNDOSTAT

V$SGA
Synonym for V_$SGA

V$CLUSTER_INTERCONNECTS
Synonym for V_$CLUSTER_INTERCONNECTS

V$CONFIGURED_INTERCONNECTS
Synonym for V_$CONFIGURED_INTERCONNECTS

V$PARAMETER
Synonym for V_$PARAMETER

V$PARAMETER2
Synonym for V_$PARAMETER2

V$OBSOLETE_PARAMETER
Synonym for V_$OBSOLETE_PARAMETER

V$SYSTEM_PARAMETER
Synonym for V_$SYSTEM_PARAMETER

V$SYSTEM_PARAMETER2
Synonym for V_$SYSTEM_PARAMETER2

V$SPPARAMETER
Synonym for V_$SPPARAMETER

V$PARAMETER_VALID_VALUES
Synonym for V_$PARAMETER_VALID_VALUES

V$ROWCACHE
Synonym for V_$ROWCACHE

V$ROWCACHE_PARENT
Synonym for V_$ROWCACHE_PARENT

V$ROWCACHE_SUBORDINATE
Synonym for V_$ROWCACHE_SUBORDINATE

V$ENABLEDPRIVS
Synonym for V_$ENABLEDPRIVS

V$NLS_PARAMETERS
Synonym for V_$NLS_PARAMETERS

V$NLS_VALID_VALUES
Synonym for V_$NLS_VALID_VALUES

V$LIBRARYCACHE
Synonym for V_$LIBRARYCACHE

V$TYPE_SIZE
Synonym for V_$TYPE_SIZE

V$ARCHIVE
Synonym for V_$ARCHIVE

V$CIRCUIT
Synonym for V_$CIRCUIT

V$DATABASE
Synonym for V_$DATABASE

V$INSTANCE
Synonym for V_$INSTANCE

V$DISPATCHER
Synonym for V_$DISPATCHER

V$DISPATCHER_CONFIG
Synonym for V_$DISPATCHER_CONFIG

V$DISPATCHER_RATE
Synonym for V_$DISPATCHER_RATE

V$LOGHIST
Synonym for V_$LOGHIST

V$SQLAREA
Synonym for V_$SQLAREA

V$SQLAREA_PLAN_HASH
Synonym for V_$SQLAREA_PLAN_HASH

V$SQLTEXT
Synonym for V_$SQLTEXT

V$SQLTEXT_WITH_NEWLINES
Synonym for V_$SQLTEXT_WITH_NEWLINES

V$SQL
Synonym for V_$SQL

V$SQLSTATS
Synonym for V_$SQLSTATS

V$SQL_SHARED_CURSOR
Synonym for V_$SQL_SHARED_CURSOR

V$DB_PIPES
Synonym for V_$DB_PIPES

V$DB_OBJECT_CACHE
Synonym for V_$DB_OBJECT_CACHE

V$OPEN_CURSOR
Synonym for V_$OPEN_CURSOR

V$OPTION
Synonym for V_$OPTION

V$VERSION
Synonym for V_$VERSION

V$PQ_SESSTAT
Synonym for V_$PQ_SESSTAT

V$PQ_SYSSTAT
Synonym for V_$PQ_SYSSTAT

V$PQ_SLAVE
Synonym for V_$PQ_SLAVE

V$QUEUE
Synonym for V_$QUEUE

V$SHARED_SERVER_MONITOR
Synonym for V_$SHARED_SERVER_MONITOR

V$DBLINK
Synonym for V_$DBLINK

V$PWFILE_USERS
Synonym for V_$PWFILE_USERS

V$REQDIST
Synonym for V_$REQDIST

V$SGASTAT
Synonym for V_$SGASTAT

V$SGAINFO
Synonym for V_$SGAINFO

V$WAITSTAT
Synonym for V_$WAITSTAT

V$SHARED_SERVER
Synonym for V_$SHARED_SERVER

V$TIMER
Synonym for V_$TIMER

V$RECOVER_FILE
Synonym for V_$RECOVER_FILE

V$BACKUP
Synonym for V_$BACKUP

V$BACKUP_SET
Synonym for V_$BACKUP_SET

V$BACKUP_PIECE
Synonym for V_$BACKUP_PIECE

V$BACKUP_DATAFILE
Synonym for V_$BACKUP_DATAFILE

V$BACKUP_SPFILE
Synonym for V_$BACKUP_SPFILE

V$BACKUP_REDOLOG
Synonym for V_$BACKUP_REDOLOG

V$BACKUP_CORRUPTION
Synonym for V_$BACKUP_CORRUPTION

V$COPY_CORRUPTION
Synonym for V_$COPY_CORRUPTION

V$DATABASE_BLOCK_CORRUPTION
Synonym for V_$DATABASE_BLOCK_CORRUPTION

V$MTTR_TARGET_ADVICE
Synonym for V_$MTTR_TARGET_ADVICE

V$STATISTICS_LEVEL
Synonym for V_$STATISTICS_LEVEL

V$DELETED_OBJECT
Synonym for V_$DELETED_OBJECT

V$PROXY_DATAFILE
Synonym for V_$PROXY_DATAFILE

V$PROXY_ARCHIVEDLOG
Synonym for V_$PROXY_ARCHIVEDLOG

V$CONTROLFILE_RECORD_SECTION
Synonym for V_$CONTROLFILE_RECORD_SECTION

V$ARCHIVED_LOG
Synonym for V_$ARCHIVED_LOG

V$OFFLINE_RANGE
Synonym for V_$OFFLINE_RANGE

V$DATAFILE_COPY
Synonym for V_$DATAFILE_COPY

V$LOG_HISTORY
Synonym for V_$LOG_HISTORY

V$RECOVERY_LOG
Synonym for V_$RECOVERY_LOG

V$ARCHIVE_GAP
Synonym for V_$ARCHIVE_GAP

V$DATAFILE_HEADER
Synonym for V_$DATAFILE_HEADER

V$DATAFILE
Synonym for V_$DATAFILE

V$TEMPFILE
Synonym for V_$TEMPFILE

V$TABLESPACE
Synonym for V_$TABLESPACE

V$BACKUP_DEVICE
Synonym for V_$BACKUP_DEVICE

V$MANAGED_STANDBY
Synonym for V_$MANAGED_STANDBY

V$ARCHIVE_PROCESSES
Synonym for V_$ARCHIVE_PROCESSES

V$ARCHIVE_DEST
Synonym for V_$ARCHIVE_DEST

V$DATAGUARD_CONFIG
Synonym for V_$DATAGUARD_CONFIG

V$DATAGUARD_STATS
Synonym for V_$DATAGUARD_STATS

V$FIXED_TABLE
Synonym for V_$FIXED_TABLE

V$FIXED_VIEW_DEFINITION
Synonym for V_$FIXED_VIEW_DEFINITION

V$INDEXED_FIXED_COLUMN
Synonym for V_$INDEXED_FIXED_COLUMN

V$SESSION_CURSOR_CACHE
Synonym for V_$SESSION_CURSOR_CACHE

V$SESSION_WAIT_CLASS
Synonym for V_$SESSION_WAIT_CLASS

V$SESSION_WAIT
Synonym for V_$SESSION_WAIT

V$SESSION_WAIT_HISTORY
Synonym for V_$SESSION_WAIT_HISTORY

V$SESSION_EVENT
Synonym for V_$SESSION_EVENT

V$SESSION_CONNECT_INFO
Synonym for V_$SESSION_CONNECT_INFO

V$SYSTEM_WAIT_CLASS
Synonym for V_$SYSTEM_WAIT_CLASS

V$SYSTEM_EVENT
Synonym for V_$SYSTEM_EVENT

V$EVENT_NAME
Synonym for V_$EVENT_NAME

V$EVENT_HISTOGRAM
Synonym for V_$EVENT_HISTOGRAM

V$FILE_HISTOGRAM
Synonym for V_$FILE_HISTOGRAM

V$TEMP_HISTOGRAM
Synonym for V_$TEMP_HISTOGRAM

V$EXECUTION
Synonym for V_$EXECUTION

V$SYSTEM_CURSOR_CACHE
Synonym for V_$SYSTEM_CURSOR_CACHE

V$SESS_IO
Synonym for V_$SESS_IO

V$RECOVERY_STATUS
Synonym for V_$RECOVERY_STATUS

V$RECOVERY_FILE_STATUS
Synonym for V_$RECOVERY_FILE_STATUS

V$RECOVERY_PROGRESS
Synonym for V_$RECOVERY_PROGRESS

V$SHARED_POOL_RESERVED
Synonym for V_$SHARED_POOL_RESERVED

V$SORT_SEGMENT
Synonym for V_$SORT_SEGMENT

V$TEMPSEG_USAGE
Synonym for V_$SORT_USAGE

V$SORT_USAGE
Synonym for V_$SORT_USAGE

V$RESOURCE_LIMIT
Synonym for V_$RESOURCE_LIMIT

V$ENQUEUE_LOCK
Synonym for V_$ENQUEUE_LOCK

V$TRANSACTION_ENQUEUE
Synonym for V_$TRANSACTION_ENQUEUE

V$PQ_TQSTAT
Synonym for V_$PQ_TQSTAT

V$ACTIVE_INSTANCES
Synonym for V_$ACTIVE_INSTANCES

V$SQL_CURSOR
Synonym for V_$SQL_CURSOR

V$SQL_BIND_METADATA
Synonym for V_$SQL_BIND_METADATA

V$SQL_BIND_DATA
Synonym for V_$SQL_BIND_DATA

V$SQL_SHARED_MEMORY
Synonym for V_$SQL_SHARED_MEMORY

V$GLOBAL_TRANSACTION
Synonym for V_$GLOBAL_TRANSACTION

V$SESSION_OBJECT_CACHE
Synonym for V_$SESSION_OBJECT_CACHE

V$LOCK_ACTIVITY
Synonym for V_$LOCK_ACTIVITY

V$AQ1
Synonym for V_$AQ1

V$HS_AGENT
Synonym for V_$HS_AGENT

V$HS_SESSION
Synonym for V_$HS_SESSION

V$HS_PARAMETER
Synonym for V_$HS_PARAMETER

V$RSRC_CONSUMER_GROUP_CPU_MTH
Synonym for V_$RSRC_CONSUMER_GROUP_CPU_MTH

V$RSRC_PLAN_CPU_MTH
Synonym for V_$RSRC_PLAN_CPU_MTH

V$RSRC_CONSUMER_GROUP
Synonym for V_$RSRC_CONSUMER_GROUP

V$RSRC_SESSION_INFO
Synonym for V_$RSRC_SESSION_INFO

V$RSRC_PLAN
Synonym for V_$RSRC_PLAN

V$RSRC_CONS_GROUP_HISTORY
Synonym for V_$RSRC_CONS_GROUP_HISTORY

V$RSRC_PLAN_HISTORY
Synonym for V_$RSRC_PLAN_HISTORY

V$BLOCKING_QUIESCE
Synonym for V_$BLOCKING_QUIESCE

V$PX_BUFFER_ADVICE
Synonym for V_$PX_BUFFER_ADVICE

V$PX_SESSION
Synonym for V_$PX_SESSION

V$PX_SESSTAT
Synonym for V_$PX_SESSTAT

V$BACKUP_SYNC_IO
Synonym for V_$BACKUP_SYNC_IO

V$BACKUP_ASYNC_IO
Synonym for V_$BACKUP_ASYNC_IO

V$TEMPORARY_LOBS
Synonym for V_$TEMPORARY_LOBS

V$PX_PROCESS
Synonym for V_$PX_PROCESS

V$PX_PROCESS_SYSSTAT
Synonym for V_$PX_PROCESS_SYSSTAT

V$LOGMNR_CONTENTS
Synonym for V_$LOGMNR_CONTENTS

V$LOGMNR_PARAMETERS
Synonym for V_$LOGMNR_PARAMETERS

V$LOGMNR_DICTIONARY
Synonym for V_$LOGMNR_DICTIONARY

V$LOGMNR_LOGS
Synonym for V_$LOGMNR_LOGS

V$LOGMNR_STATS
Synonym for V_$LOGMNR_STATS

V$LOGMNR_DICTIONARY_LOAD
Synonym for V_$LOGMNR_DICTIONARY_LOAD

V$RFS_THREAD
Synonym for V_$RFS_THREAD

V$STANDBY_APPLY_SNAPSHOT
Synonym for V_$STANDBY_APPLY_SNAPSHOT

V$GLOBAL_BLOCKED_LOCKS
Synonym for V_$GLOBAL_BLOCKED_LOCKS

V$AW_OLAP
Synonym for V_$AW_OLAP

V$AW_CALC
Synonym for V_$AW_CALC

V$AW_SESSION_INFO
Synonym for V_$AW_SESSION_INFO

GV$AW_AGGREGATE_OP
Synonym for GV_$AW_AGGREGATE_OP

V$AW_AGGREGATE_OP
Synonym for V_$AW_AGGREGATE_OP

GV$AW_ALLOCATE_OP
Synonym for GV_$AW_ALLOCATE_OP

V$AW_ALLOCATE_OP
Synonym for V_$AW_ALLOCATE_OP

V$AW_LONGOPS
Synonym for V_$AW_LONGOPS

V$MAX_ACTIVE_SESS_TARGET_MTH
Synonym for V_$MAX_ACTIVE_SESS_TARGET_MTH

V$ACTIVE_SESS_POOL_MTH
Synonym for V_$ACTIVE_SESS_POOL_MTH

V$PARALLEL_DEGREE_LIMIT_MTH
Synonym for V_$PARALLEL_DEGREE_LIMIT_MTH

V$QUEUEING_MTH
Synonym for V_$QUEUEING_MTH

V$RESERVED_WORDS
Synonym for V_$RESERVED_WORDS

V$ARCHIVE_DEST_STATUS
Synonym for V_$ARCHIVE_DEST_STATUS

V$DB_CACHE_ADVICE
Synonym for V_$DB_CACHE_ADVICE

V$SGA_TARGET_ADVICE
Synonym for V_$SGA_TARGET_ADVICE

V$SEGMENT_STATISTICS
Synonym for V_$SEGMENT_STATISTICS

V$SEGSTAT_NAME
Synonym for V_$SEGSTAT_NAME

V$SEGSTAT
Synonym for V_$SEGSTAT

V$LIBRARY_CACHE_MEMORY
Synonym for V_$LIBRARY_CACHE_MEMORY

V$JAVA_LIBRARY_CACHE_MEMORY
Synonym for V_$JAVA_LIBRARY_CACHE_MEMORY

V$SHARED_POOL_ADVICE
Synonym for V_$SHARED_POOL_ADVICE

V$JAVA_POOL_ADVICE
Synonym for V_$JAVA_POOL_ADVICE

V$STREAMS_POOL_ADVICE
Synonym for V_$STREAMS_POOL_ADVICE

V$SGA_CURRENT_RESIZE_OPS
Synonym for V_$SGA_CURRENT_RESIZE_OPS

V$SGA_RESIZE_OPS
Synonym for V_$SGA_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$RESUMABLE
Synonym for V_$RESUMABLE

V$TIMEZONE_NAMES
Synonym for V_$TIMEZONE_NAMES

V$TIMEZONE_FILE
Synonym for V_$TIMEZONE_FILE

V$ENQUEUE_STAT
Synonym for V_$ENQUEUE_STAT

V$ENQUEUE_STATISTICS
Synonym for V_$ENQUEUE_STATISTICS

V$LOCK_TYPE
Synonym for V_$LOCK_TYPE

V$RMAN_CONFIGURATION
Synonym for V_$RMAN_CONFIGURATION

V$DATABASE_INCARNATION
Synonym for V_$DATABASE_INCARNATION

V$METRIC
Synonym for V_$METRIC

V$METRIC_HISTORY
Synonym for V_$METRIC_HISTORY

V$SYSMETRIC
Synonym for V_$SYSMETRIC

V$SYSMETRIC_HISTORY
Synonym for V_$SYSMETRIC_HISTORY

V$METRICNAME
Synonym for V_$METRICNAME

V$METRICGROUP
Synonym for V_$METRICGROUP

V$SERVICE_WAIT_CLASS
Synonym for V_$SERVICE_WAIT_CLASS

V$SERVICE_EVENT
Synonym for V_$SERVICE_EVENT

V$ACTIVE_SERVICES
Synonym for V_$ACTIVE_SERVICES

V$SERVICES
Synonym for V_$SERVICES

V$SYSMETRIC_SUMMARY
Synonym for V_$SYSMETRIC_SUMMARY

V$SESSMETRIC
Synonym for V_$SESSMETRIC

V$FILEMETRIC
Synonym for V_$FILEMETRIC

V$FILEMETRIC_HISTORY
Synonym for V_$FILEMETRIC_HISTORY

V$EVENTMETRIC
Synonym for V_$EVENTMETRIC

V$WAITCLASSMETRIC
Synonym for V_$WAITCLASSMETRIC

V$WAITCLASSMETRIC_HISTORY
Synonym for V_$WAITCLASSMETRIC_HISTORY

V$SERVICEMETRIC
Synonym for V_$SERVICEMETRIC

V$SERVICEMETRIC_HISTORY
Synonym for V_$SERVICEMETRIC_HISTORY

V$ADVISOR_PROGRESS
Synonym for V_$ADVISOR_PROGRESS

V$XML_AUDIT_TRAIL
Synonym for V_$XML_AUDIT_TRAIL

V$SQL_JOIN_FILTER
Synonym for V_$SQL_JOIN_FILTER

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$MUTEX_SLEEP
Synonym for V_$MUTEX_SLEEP

V$MUTEX_SLEEP_HISTORY
Synonym for V_$MUTEX_SLEEP_HISTORY

GV$MUTEX_SLEEP
Synonym for GV_$MUTEX_SLEEP

GV$MUTEX_SLEEP_HISTORY
Synonym for GV_$MUTEX_SLEEP_HISTORY

GV$SQLSTATS
Synonym for GV_$SQL

GV$MAP_LIBRARY
Synonym for GV_$MAP_LIBRARY

GV$MAP_FILE
Synonym for GV_$MAP_FILE

GV$MAP_FILE_EXTENT
Synonym for GV_$MAP_FILE_EXTENT

GV$MAP_ELEMENT
Synonym for GV_$MAP_ELEMENT

GV$MAP_EXT_ELEMENT
Synonym for GV_$MAP_EXT_ELEMENT

GV$MAP_COMP_LIST
Synonym for GV_$MAP_COMP_LIST

GV$MAP_SUBELEMENT
Synonym for GV_$MAP_SUBELEMENT

GV$MAP_FILE_IO_STACK
Synonym for GV_$MAP_FILE_IO_STACK

GV$BSP
Synonym for GV_$BSP

GV$OBSOLETE_PARAMETER
Synonym for GV_$OBSOLETE_PARAMETER

GV$FAST_START_SERVERS
Synonym for GV_$FAST_START_SERVERS

GV$FAST_START_TRANSACTIONS
Synonym for GV_$FAST_START_TRANSACTIONS

GV$ENQUEUE_LOCK
Synonym for GV_$ENQUEUE_LOCK

GV$TRANSACTION_ENQUEUE
Synonym for GV_$TRANSACTION_ENQUEUE

GV$RESOURCE_LIMIT
Synonym for GV_$RESOURCE_LIMIT

GV$SQL_REDIRECTION
Synonym for GV_$SQL_REDIRECTION

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_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$PGA_TARGET_ADVICE
Synonym for GV_$PGA_TARGET_ADVICE

GV$PGA_TARGET_ADVICE_HISTOGRAM
Synonym for GV_$PGATARGET_ADVICE_HISTOGRAM

GV$PGASTAT
Synonym for GV_$PGASTAT

GV$SYS_OPTIMIZER_ENV
Synonym for GV_$SYS_OPTIMIZER_ENV

GV$SES_OPTIMIZER_ENV
Synonym for GV_$SES_OPTIMIZER_ENV

GV$SQL_OPTIMIZER_ENV
Synonym for GV_$SQL_OPTIMIZER_ENV

GV$DLM_MISC
Synonym for GV_$DLM_MISC

GV$DLM_LATCH
Synonym for GV_$DLM_LATCH

GV$DLM_CONVERT_LOCAL
Synonym for GV_$DLM_CONVERT_LOCAL

GV$DLM_CONVERT_REMOTE
Synonym for GV_$DLM_CONVERT_REMOTE

GV$DLM_ALL_LOCKS
Synonym for GV_$DLM_ALL_LOCKS

GV$DLM_LOCKS
Synonym for GV_$DLM_LOCKS

GV$DLM_RESS
Synonym for GV_$DLM_RESS

GV$HVMASTER_INFO
Synonym for GV_$HVMASTER_INFO

GV$GCSHVMASTER_INFO
Synonym for GV_$GCSHVMASTER_INFO

GV$GCSPFMASTER_INFO
Synonym for GV_$GCSPFMASTER_INFO

GV$GES_ENQUEUE
Synonym for GV_$GES_ENQUEUE

GV$GES_BLOCKING_ENQUEUE
Synonym for GV_$GES_BLOCKING_ENQUEUE

GV$GC_ELEMENT
Synonym for GV_$GC_ELEMENT

GV$CR_BLOCK_SERVER
Synonym for GV_$CR_BLOCK_SERVER

GV$CURRENT_BLOCK_SERVER
Synonym for GV_$CURRENT_BLOCK_SERVER

GV$GC_ELEMENTS_WITH_COLLISIONS
Synonym for GV_$GC_ELEMENTS_W_COLLISIONS

GV$FILE_CACHE_TRANSFER
Synonym for GV_$FILE_CACHE_TRANSFER

GV$TEMP_CACHE_TRANSFER
Synonym for GV_$TEMP_CACHE_TRANSFER

GV$CLASS_CACHE_TRANSFER
Synonym for GV_$CLASS_CACHE_TRANSFER

GV$BH
Synonym for GV_$BH

GV$LOCK_ELEMENT
Synonym for GV_$LOCK_ELEMENT

GV$LOCKS_WITH_COLLISIONS
Synonym for GV_$LOCKS_WITH_COLLISIONS

GV$FILE_PING
Synonym for GV_$FILE_PING

GV$TEMP_PING
Synonym for GV_$TEMP_PING

GV$CLASS_PING
Synonym for GV_$CLASS_PING

GV$INSTANCE_CACHE_TRANSFER
Synonym for GV_$INSTANCE_CACHE_TRANSFER

GV$BUFFER_POOL
Synonym for GV_$BUFFER_POOL

GV$BUFFER_POOL_STATISTICS
Synonym for GV_$BUFFER_POOL_STATISTICS

GV$INSTANCE_RECOVERY
Synonym for GV_$INSTANCE_RECOVERY

GV$CONTROLFILE
Synonym for GV_$CONTROLFILE

GV$LOG
Synonym for GV_$LOG

GV$STANDBY_LOG
Synonym for GV_$STANDBY_LOG

GV$DATAGUARD_STATUS
Synonym for GV_$DATAGUARD_STATUS

GV$THREAD
Synonym for GV_$THREAD

GV$PROCESS
Synonym for GV_$PROCESS

GV$BGPROCESS
Synonym for GV_$BGPROCESS

GV$SESSION
Synonym for GV_$SESSION

GV$LICENSE
Synonym for GV_$LICENSE

GV$TRANSACTION
Synonym for GV_$TRANSACTION

GV$LOCKED_OBJECT
Synonym for GV_$LOCKED_OBJECT

GV$LATCH
Synonym for GV_$LATCH

GV$LATCH_CHILDREN
Synonym for GV_$LATCH_CHILDREN

GV$LATCH_PARENT
Synonym for GV_$LATCH_PARENT

GV$LATCHNAME
Synonym for GV_$LATCHNAME

GV$LATCHHOLDER
Synonym for GV_$LATCHHOLDER

GV$LATCH_MISSES
Synonym for GV_$LATCH_MISSES

GV$SESSION_LONGOPS
Synonym for GV_$SESSION_LONGOPS

GV$RESOURCE
Synonym for GV_$RESOURCE

GV$_LOCK
Synonym for GV_$_LOCK

GV$LOCK
Synonym for GV_$LOCK

GV$SESSTAT
Synonym for GV_$SESSTAT

GV$MYSTAT
Synonym for GV_$MYSTAT

GV$SUBCACHE
Synonym for GV_$SUBCACHE

GV$SYSSTAT
Synonym for GV_$SYSSTAT

GV$STATNAME
Synonym for GV_$STATNAME

GV$OSSTAT
Synonym for GV_$OSSTAT

GV$ACCESS
Synonym for GV_$ACCESS

GV$OBJECT_DEPENDENCY
Synonym for GV_$OBJECT_DEPENDENCY

GV$DBFILE
Synonym for GV_$DBFILE

GV$DATAFILE
Synonym for GV_$DATAFILE

GV$TEMPFILE
Synonym for GV_$TEMPFILE

GV$TABLESPACE
Synonym for GV_$TABLESPACE

GV$FILESTAT
Synonym for GV_$FILESTAT

GV$TEMPSTAT
Synonym for GV_$TEMPSTAT

GV$LOGFILE
Synonym for GV_$LOGFILE

GV$FLASHBACK_DATABASE_LOGFILE
Synonym for GV_$FLASHBACK_DATABASE_LOGFILE

GV$FLASHBACK_DATABASE_LOG
Synonym for GV_$FLASHBACK_DATABASE_LOG

GV$FLASHBACK_DATABASE_STAT
Synonym for GV_$FLASHBACK_DATABASE_STAT

GV$RESTORE_POINT
Synonym for GV_$RESTORE_POINT

GV$ROLLSTAT
Synonym for GV_$ROLLSTAT

GV$UNDOSTAT
Synonym for GV_$UNDOSTAT

GV$SGA
Synonym for GV_$SGA

GV$CLUSTER_INTERCONNECTS
Synonym for GV_$CLUSTER_INTERCONNECTS

GV$CONFIGURED_INTERCONNECTS
Synonym for GV_$CONFIGURED_INTERCONNECTS

GV$PARAMETER
Synonym for GV_$PARAMETER

GV$PARAMETER2
Synonym for GV_$PARAMETER2

GV$SYSTEM_PARAMETER
Synonym for GV_$SYSTEM_PARAMETER

GV$SYSTEM_PARAMETER2
Synonym for GV_$SYSTEM_PARAMETER2

GV$SPPARAMETER
Synonym for GV_$SPPARAMETER

GV$PARAMETER_VALID_VALUES
Synonym for GV_$PARAMETER_VALID_VALUES

GV$ROWCACHE
Synonym for GV_$ROWCACHE

GV$ROWCACHE_PARENT
Synonym for GV_$ROWCACHE_PARENT

GV$ROWCACHE_SUBORDINATE
Synonym for GV_$ROWCACHE_SUBORDINATE

GV$ENABLEDPRIVS
Synonym for GV_$ENABLEDPRIVS

GV$NLS_PARAMETERS
Synonym for GV_$NLS_PARAMETERS

GV$NLS_VALID_VALUES
Synonym for GV_$NLS_VALID_VALUES

GV$LIBRARYCACHE
Synonym for GV_$LIBRARYCACHE

GV$TYPE_SIZE
Synonym for GV_$TYPE_SIZE

GV$ARCHIVE
Synonym for GV_$ARCHIVE

GV$CIRCUIT
Synonym for GV_$CIRCUIT

GV$DATABASE
Synonym for GV_$DATABASE

GV$INSTANCE
Synonym for GV_$INSTANCE

GV$DISPATCHER
Synonym for GV_$DISPATCHER

GV$DISPATCHER_CONFIG
Synonym for GV_$DISPATCHER_CONFIG

GV$DISPATCHER_RATE
Synonym for GV_$DISPATCHER_RATE

GV$LOGHIST
Synonym for GV_$LOGHIST

GV$SQLAREA
Synonym for GV_$SQLAREA

GV$SQLAREA_PLAN_HASH
Synonym for GV_$SQLAREA_PLAN_HASH

GV$SQLTEXT
Synonym for GV_$SQLTEXT

GV$SQLTEXT_WITH_NEWLINES
Synonym for GV_$SQLTEXT_WITH_NEWLINES

GV$SQL
Synonym for GV_$SQL

GV$SQL_SHARED_CURSOR
Synonym for GV_$SQL_SHARED_CURSOR

GV$DB_PIPES
Synonym for GV_$DB_PIPES

GV$DB_OBJECT_CACHE
Synonym for GV_$DB_OBJECT_CACHE

GV$OPEN_CURSOR
Synonym for GV_$OPEN_CURSOR

GV$OPTION
Synonym for GV_$OPTION

GV$VERSION
Synonym for GV_$VERSION

GV$PQ_SESSTAT
Synonym for GV_$PQ_SESSTAT

GV$PQ_SYSSTAT
Synonym for GV_$PQ_SYSSTAT

GV$PQ_SLAVE
Synonym for GV_$PQ_SLAVE

GV$QUEUE
Synonym for GV_$QUEUE

GV$SHARED_SERVER_MONITOR
Synonym for GV_$SHARED_SERVER_MONITOR

GV$DBLINK
Synonym for GV_$DBLINK

GV$PWFILE_USERS
Synonym for GV_$PWFILE_USERS

GV$REQDIST
Synonym for GV_$REQDIST

GV$SGASTAT
Synonym for GV_$SGASTAT

GV$SGAINFO
Synonym for GV_$SGAINFO

GV$WAITSTAT
Synonym for GV_$WAITSTAT

GV$SHARED_SERVER
Synonym for GV_$SHARED_SERVER

GV$TIMER
Synonym for GV_$TIMER

GV$RECOVER_FILE
Synonym for GV_$RECOVER_FILE

GV$BACKUP
Synonym for GV_$BACKUP

GV$BACKUP_SET
Synonym for GV_$BACKUP_SET

GV$BACKUP_PIECE
Synonym for GV_$BACKUP_PIECE

GV$BACKUP_DATAFILE
Synonym for GV_$BACKUP_DATAFILE

GV$BACKUP_SPFILE
Synonym for GV_$BACKUP_SPFILE

GV$BACKUP_REDOLOG
Synonym for GV_$BACKUP_REDOLOG

GV$BACKUP_CORRUPTION
Synonym for GV_$BACKUP_CORRUPTION

GV$COPY_CORRUPTION
Synonym for GV_$COPY_CORRUPTION

GV$DATABASE_BLOCK_CORRUPTION
Synonym for GV_$DATABASE_BLOCK_CORRUPTION

GV$MTTR_TARGET_ADVICE
Synonym for GV_$MTTR_TARGET_ADVICE

GV$STATISTICS_LEVEL
Synonym for GV_$STATISTICS_LEVEL

GV$DELETED_OBJECT
Synonym for GV_$DELETED_OBJECT

GV$PROXY_DATAFILE
Synonym for GV_$PROXY_DATAFILE

GV$PROXY_ARCHIVEDLOG
Synonym for GV_$PROXY_ARCHIVEDLOG

GV$CONTROLFILE_RECORD_SECTION
Synonym for GV_$CONTROLFILE_RECORD_SECTION

GV$ARCHIVED_LOG
Synonym for GV_$ARCHIVED_LOG

GV$OFFLINE_RANGE
Synonym for GV_$OFFLINE_RANGE

GV$DATAFILE_COPY
Synonym for GV_$DATAFILE_COPY

GV$LOG_HISTORY
Synonym for GV_$LOG_HISTORY

GV$RECOVERY_LOG
Synonym for GV_$RECOVERY_LOG

GV$ARCHIVE_GAP
Synonym for GV_$ARCHIVE_GAP

GV$DATAFILE_HEADER
Synonym for GV_$DATAFILE_HEADER

GV$BACKUP_DEVICE
Synonym for GV_$BACKUP_DEVICE

GV$MANAGED_STANDBY
Synonym for GV_$MANAGED_STANDBY

GV$ARCHIVE_PROCESSES
Synonym for GV_$ARCHIVE_PROCESSES

GV$ARCHIVE_DEST
Synonym for GV_$ARCHIVE_DEST

GV$DATAGUARD_CONFIG
Synonym for GV_$DATAGUARD_CONFIG

GV$FIXED_TABLE
Synonym for GV_$FIXED_TABLE

GV$FIXED_VIEW_DEFINITION
Synonym for GV_$FIXED_VIEW_DEFINITION

GV$INDEXED_FIXED_COLUMN
Synonym for GV_$INDEXED_FIXED_COLUMN

GV$SESSION_CURSOR_CACHE
Synonym for GV_$SESSION_CURSOR_CACHE

GV$SESSION_WAIT_CLASS
Synonym for GV_$SESSION_WAIT_CLASS

GV$SESSION_WAIT
Synonym for GV_$SESSION_WAIT

GV$SESSION_WAIT_HISTORY
Synonym for GV_$SESSION_WAIT_HISTORY

GV$SESSION_EVENT
Synonym for GV_$SESSION_EVENT

GV$SESSION_CONNECT_INFO
Synonym for GV_$SESSION_CONNECT_INFO

GV$SYSTEM_WAIT_CLASS
Synonym for GV_$SYSTEM_WAIT_CLASS

GV$SYSTEM_EVENT
Synonym for GV_$SYSTEM_EVENT

GV$EVENT_NAME
Synonym for GV_$EVENT_NAME

GV$EVENT_HISTOGRAM
Synonym for GV_$EVENT_HISTOGRAM

GV$FILE_HISTOGRAM
Synonym for GV_$FILE_HISTOGRAM

GV$TEMP_HISTOGRAM
Synonym for GV_$TEMP_HISTOGRAM

GV$EXECUTION
Synonym for GV_$EXECUTION

GV$SYSTEM_CURSOR_CACHE
Synonym for GV_$SYSTEM_CURSOR_CACHE

GV$SESS_IO
Synonym for GV_$SESS_IO

GV$RECOVERY_STATUS
Synonym for GV_$RECOVERY_STATUS

GV$RECOVERY_FILE_STATUS
Synonym for GV_$RECOVERY_FILE_STATUS

GV$RECOVERY_PROGRESS
Synonym for GV_$RECOVERY_PROGRESS

GV$SHARED_POOL_RESERVED
Synonym for GV_$SHARED_POOL_RESERVED

GV$SORT_SEGMENT
Synonym for GV_$SORT_SEGMENT

GV$TEMPSEG_USAGE
Synonym for GV_$SORT_USAGE

GV$SORT_USAGE
Synonym for GV_$SORT_USAGE

GV$PQ_TQSTAT
Synonym for GV_$PQ_TQSTAT

GV$ACTIVE_INSTANCES
Synonym for GV_$ACTIVE_INSTANCES

GV$SQL_CURSOR
Synonym for GV_$SQL_CURSOR

GV$SQL_BIND_METADATA
Synonym for GV_$SQL_BIND_METADATA

GV$SQL_BIND_DATA
Synonym for GV_$SQL_BIND_DATA

GV$SQL_SHARED_MEMORY
Synonym for GV_$SQL_SHARED_MEMORY

GV$GLOBAL_TRANSACTION
Synonym for GV_$GLOBAL_TRANSACTION

GV$SESSION_OBJECT_CACHE
Synonym for GV_$SESSION_OBJECT_CACHE

GV$AQ1
Synonym for GV_$AQ1

GV$LOCK_ACTIVITY
Synonym for GV_$LOCK_ACTIVITY

GV$HS_AGENT
Synonym for GV_$HS_AGENT

GV$HS_SESSION
Synonym for GV_$HS_SESSION

GV$HS_PARAMETER
Synonym for GV_$HS_PARAMETER

GV$RSRC_CONSUMER_GROUP_CPU_MTH
Synonym for GV_$RSRC_CONSUME_GROUP_CPU_MTH

GV$RSRC_PLAN_CPU_MTH
Synonym for GV_$RSRC_PLAN_CPU_MTH

GV$RSRC_CONSUMER_GROUP
Synonym for GV_$RSRC_CONSUMER_GROUP

GV$RSRC_SESSION_INFO
Synonym for GV_$RSRC_SESSION_INFO

GV$RSRC_PLAN
Synonym for GV_$RSRC_PLAN

GV$RSRC_CONS_GROUP_HISTORY
Synonym for GV_$RSRC_CONS_GROUP_HISTORY

GV$RSRC_PLAN_HISTORY
Synonym for GV_$RSRC_PLAN_HISTORY

GV$BLOCKING_QUIESCE
Synonym for GV_$BLOCKING_QUIESCE

GV$PX_BUFFER_ADVICE
Synonym for GV_$PX_BUFFER_ADVICE

GV$PX_SESSION
Synonym for GV_$PX_SESSION

GV$PX_SESSTAT
Synonym for GV_$PX_SESSTAT

GV$BACKUP_SYNC_IO
Synonym for GV_$BACKUP_SYNC_IO

GV$BACKUP_ASYNC_IO
Synonym for GV_$BACKUP_ASYNC_IO

GV$TEMPORARY_LOBS
Synonym for GV_$TEMPORARY_LOBS

GV$PX_PROCESS
Synonym for GV_$PX_PROCESS

GV$PX_PROCESS_SYSSTAT
Synonym for GV_$PX_PROCESS_SYSSTAT

GV$LOGMNR_CONTENTS
Synonym for GV_$LOGMNR_CONTENTS

GV$LOGMNR_PARAMETERS
Synonym for GV_$LOGMNR_PARAMETERS

GV$LOGMNR_DICTIONARY
Synonym for GV_$LOGMNR_DICTIONARY

GV$LOGMNR_LOGS
Synonym for GV_$LOGMNR_LOGS

GV$RFS_THREAD
Synonym for GV_$RFS_THREAD

GV$STANDBY_APPLY_SNAPSHOT
Synonym for GV_$STANDBY_APPLY_SNAPSHOT

GV$GLOBAL_BLOCKED_LOCKS
Synonym for GV_$GLOBAL_BLOCKED_LOCKS

GV$AW_OLAP
Synonym for GV_$AW_OLAP

GV$AW_CALC
Synonym for GV_$AW_CALC

GV$AW_SESSION_INFO
Synonym for GV_$AW_SESSION_INFO

GV$AW_LONGOPS
Synonym for GV_$AW_LONGOPS

GV$MAX_ACTIVE_SESS_TARGET_MTH
Synonym for GV_$MAX_ACTIVE_SESS_TARGET_MTH

GV$ACTIVE_SESS_POOL_MTH
Synonym for GV_$ACTIVE_SESS_POOL_MTH

GV$PARALLEL_DEGREE_LIMIT_MTH
Synonym for GV_$PARALLEL_DEGREE_LIMIT_MTH

GV$QUEUEING_MTH
Synonym for GV_$QUEUEING_MTH

GV$RESERVED_WORDS
Synonym for GV_$RESERVED_WORDS

GV$ARCHIVE_DEST_STATUS
Synonym for GV_$ARCHIVE_DEST_STATUS

V$LOGMNR_LOGFILE
Synonym for V_$LOGMNR_LOGFILE

V$LOGMNR_PROCESS
Synonym for V_$LOGMNR_PROCESS

V$LOGMNR_LATCH
Synonym for V_$LOGMNR_LATCH

V$LOGMNR_TRANSACTION
Synonym for V_$LOGMNR_TRANSACTION

V$LOGMNR_REGION
Synonym for V_$LOGMNR_REGION

V$LOGMNR_CALLBACK
Synonym for V_$LOGMNR_CALLBACK

V$LOGMNR_SESSION
Synonym for V_$LOGMNR_SESSION

GV$LOGMNR_LOGFILE
Synonym for GV_$LOGMNR_LOGFILE

GV$LOGMNR_PROCESS
Synonym for GV_$LOGMNR_PROCESS

GV$LOGMNR_LATCH
Synonym for GV_$LOGMNR_LATCH

GV$LOGMNR_TRANSACTION
Synonym for GV_$LOGMNR_TRANSACTION

GV$LOGMNR_REGION
Synonym for GV_$LOGMNR_REGION

GV$LOGMNR_CALLBACK
Synonym for GV_$LOGMNR_CALLBACK

GV$LOGMNR_SESSION
Synonym for GV_$LOGMNR_SESSION

GV$LOGMNR_STATS
Synonym for GV_$LOGMNR_STATS

GV$LOGMNR_DICTIONARY_LOAD
Synonym for GV_$LOGMNR_DICTIONARY_LOAD

GV$DB_CACHE_ADVICE
Synonym for GV_$DB_CACHE_ADVICE

GV$SGA_TARGET_ADVICE
Synonym for GV_$SGA_TARGET_ADVICE

GV$SEGMENT_STATISTICS
Synonym for GV_$SEGMENT_STATISTICS

GV$SEGSTAT_NAME
Synonym for GV_$SEGSTAT_NAME

GV$SEGSTAT
Synonym for GV_$SEGSTAT

GV$LIBRARY_CACHE_MEMORY
Synonym for GV_$LIBRARY_CACHE_MEMORY

GV$JAVA_LIBRARY_CACHE_MEMORY
Synonym for GV_$JAVA_LIBRARY_CACHE_MEMORY

GV$SHARED_POOL_ADVICE
Synonym for GV_$SHARED_POOL_ADVICE

GV$JAVA_POOL_ADVICE
Synonym for GV_$JAVA_POOL_ADVICE

GV$STREAMS_POOL_ADVICE
Synonym for GV_$STREAMS_POOL_ADVICE

GV$SGA_CURRENT_RESIZE_OPS
Synonym for GV_$SGA_CURRENT_RESIZE_OPS

GV$SGA_RESIZE_OPS
Synonym for GV_$SGA_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$RESUMABLE
Synonym for GV_$RESUMABLE

GV$TIMEZONE_NAMES
Synonym for GV_$TIMEZONE_NAMES

GV$TIMEZONE_FILE
Synonym for GV_$TIMEZONE_FILE

GV$ENQUEUE_STAT
Synonym for GV_$ENQUEUE_STAT

GV$ENQUEUE_STATISTICS
Synonym for GV_$ENQUEUE_STATISTICS

GV$LOCK_TYPE
Synonym for GV_$LOCK_TYPE

GV$RMAN_CONFIGURATION
Synonym for GV_$RMAN_CONFIGURATION

GV$VPD_POLICY
Synonym for GV_$VPD_POLICY

V$VPD_POLICY
Synonym for V_$VPD_POLICY

GV$DATABASE_INCARNATION
Synonym for GV_$DATABASE_INCARNATION

GV$ASM_TEMPLATE
Synonym for GV_$ASM_TEMPLATE

V$ASM_TEMPLATE
Synonym for V_$ASM_TEMPLATE

GV$ASM_FILE
Synonym for GV_$ASM_FILE

V$ASM_FILE
Synonym for V_$ASM_FILE

GV$ASM_DISKGROUP
Synonym for GV_$ASM_DISKGROUP

V$ASM_DISKGROUP
Synonym for V_$ASM_DISKGROUP

GV$ASM_DISKGROUP_STAT
Synonym for GV_$ASM_DISKGROUP_STAT

V$ASM_DISKGROUP_STAT
Synonym for V_$ASM_DISKGROUP_STAT

GV$ASM_DISK
Synonym for GV_$ASM_DISK

V$ASM_DISK
Synonym for V_$ASM_DISK

GV$ASM_DISK_STAT
Synonym for GV_$ASM_DISK_STAT

V$ASM_DISK_STAT
Synonym for V_$ASM_DISK_STAT

GV$ASM_CLIENT
Synonym for GV_$ASM_CLIENT

V$ASM_CLIENT
Synonym for V_$ASM_CLIENT

GV$ASM_ALIAS
Synonym for GV_$ASM_ALIAS

V$ASM_ALIAS
Synonym for V_$ASM_ALIAS

GV$ASM_OPERATION
Synonym for GV_$ASM_OPERATION

V$ASM_OPERATION
Synonym for V_$ASM_OPERATION

GV$RULE_SET
Synonym for GV_$RULE_SET

V$RULE_SET
Synonym for V_$RULE_SET

GV$RULE
Synonym for GV_$RULE

V$RULE
Synonym for V_$RULE

GV$RULE_SET_AGGREGATE_STATS
Synonym for GV_$RULE_SET_AGGREGATE_STATS

V$RULE_SET_AGGREGATE_STATS
Synonym for V_$RULE_SET_AGGREGATE_STATS

GV$JAVAPOOL
Synonym for GV_$JAVAPOOL

V$JAVAPOOL
Synonym for V_$JAVAPOOL

GV$SYSAUX_OCCUPANTS
Synonym for GV_$SYSAUX_OCCUPANTS

V$SYSAUX_OCCUPANTS
Synonym for V_$SYSAUX_OCCUPANTS

V$RMAN_STATUS
Synonym for V_$RMAN_STATUS

V$RMAN_OUTPUT
Synonym for V_$RMAN_OUTPUT

GV$RMAN_OUTPUT
Synonym for GV_$RMAN_OUTPUT

V$RECOVERY_FILE_DEST
Synonym for V_$RECOVERY_FILE_DEST

V$FLASH_RECOVERY_AREA_USAGE
Synonym for V_$FLASH_RECOVERY_AREA_USAGE

V$BLOCK_CHANGE_TRACKING
Synonym for V_$BLOCK_CHANGE_TRACKING

GV$METRIC
Synonym for GV_$METRIC

GV$METRIC_HISTORY
Synonym for GV_$METRIC_HISTORY

GV$SYSMETRIC
Synonym for GV_$SYSMETRIC

GV$SYSMETRIC_HISTORY
Synonym for GV_$SYSMETRIC_HISTORY

GV$METRICNAME
Synonym for GV_$METRICNAME

GV$METRICGROUP
Synonym for GV_$METRICGROUP

GV$ACTIVE_SESSION_HISTORY
Synonym for GV_$ACTIVE_SESSION_HISTORY

V$ACTIVE_SESSION_HISTORY
Synonym for V_$ACTIVE_SESSION_HISTORY

GV$INSTANCE_LOG_GROUP
Synonym for GV_$INSTANCE_LOG_GROUP

V$INSTANCE_LOG_GROUP
Synonym for V_$INSTANCE_LOG_GROUP

GV$SERVICE_WAIT_CLASS
Synonym for GV_$SERVICE_WAIT_CLASS

GV$SERVICE_EVENT
Synonym for GV_$SERVICE_EVENT

GV$ACTIVE_SERVICES
Synonym for GV_$ACTIVE_SERVICES

GV$SERVICES
Synonym for GV_$SERVICES

V$SCHEDULER_RUNNING_JOBS
Synonym for V_$SCHEDULER_RUNNING_JOBS

GV$SCHEDULER_RUNNING_JOBS
Synonym for GV_$SCHEDULER_RUNNING_JOBS

GV$BUFFERED_QUEUES
Synonym for GV_$BUFFERED_QUEUES

V$BUFFERED_QUEUES
Synonym for V_$BUFFERED_QUEUES

GV$BUFFERED_SUBSCRIBERS
Synonym for GV_$BUFFERED_SUBSCRIBERS

V$BUFFERED_SUBSCRIBERS
Synonym for V_$BUFFERED_SUBSCRIBERS

GV$BUFFERED_PUBLISHERS
Synonym for GV_$BUFFERED_PUBLISHERS

V$BUFFERED_PUBLISHERS
Synonym for V_$BUFFERED_PUBLISHERS

GV$TSM_SESSIONS
Synonym for GV_$TSM_SESSIONS

V$TSM_SESSIONS
Synonym for V_$TSM_SESSIONS

GV$PROPAGATION_SENDER
Synonym for GV_$PROPAGATION_SENDER

V$PROPAGATION_SENDER
Synonym for V_$PROPAGATION_SENDER

GV$PROPAGATION_RECEIVER
Synonym for GV_$PROPAGATION_RECEIVER

V$PROPAGATION_RECEIVER
Synonym for V_$PROPAGATION_RECEIVER

GV$SYSMETRIC_SUMMARY
Synonym for GV_$SYSMETRIC_SUMMARY

GV$SESSMETRIC
Synonym for GV_$SESSMETRIC

GV$FILEMETRIC
Synonym for GV_$FILEMETRIC

GV$FILEMETRIC_HISTORY
Synonym for GV_$FILEMETRIC_HISTORY

GV$EVENTMETRIC
Synonym for GV_$EVENTMETRIC

GV$WAITCLASSMETRIC
Synonym for GV_$WAITCLASSMETRIC

GV$WAITCLASSMETRIC_HISTORY
Synonym for GV_$WAITCLASSMETRIC_HISTORY

GV$SERVICEMETRIC
Synonym for GV_$SERVICEMETRIC

GV$SERVICEMETRIC_HISTORY
Synonym for GV_$SERVICEMETRIC_HISTORY

GV$ADVISOR_PROGRESS
Synonym for GV_$ADVISOR_PROGRESS

GV$XML_AUDIT_TRAIL
Synonym for GV_$XML_AUDIT_TRAIL

GV$SQL_JOIN_FILTER
Synonym for GV_$SQL_JOIN_FILTER

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$WALLET
Synonym for GV_$WALLET

V$WALLET
Synonym for V_$WALLET

CAT
Synonym for USER_CATALOG

CLU
Synonym for USER_CLUSTERS

DICT
Synonym for DICTIONARY

IND
Synonym for USER_INDEXES

OBJ
Synonym for USER_OBJECTS

SEQ
Synonym for USER_SEQUENCES

SYN
Synonym for USER_SYNONYMS

TABS
Synonym for USER_TABLES

COLS
Synonym for USER_TAB_COLUMNS

USER_HISTOGRAMS
Synonym for USER_TAB_HISTOGRAMS

ALL_HISTOGRAMS
Synonym for ALL_TAB_HISTOGRAMS

DBA_HISTOGRAMS
Synonym for DBA_TAB_HISTOGRAMS

GV$LOADPSTAT
Synonym for GV_$LOADPSTAT

GV$LOADISTAT
Synonym for GV_$LOADISTAT

V$LOADPSTAT
Synonym for V_$LOADPSTAT

V$LOADISTAT
Synonym for V_$LOADISTAT

RECYCLEBIN
Synonym for USER_RECYCLEBIN

V$TRANSPORTABLE_PLATFORM
Synonym for V_$TRANSPORTABLE_PLATFORM

V$DB_TRANSPORTABLE_PLATFORM
Synonym for V_$DB_TRANSPORTABLE_PLATFORM

DBA_LOCKS
Synonym for DBA_LOCK

ALL_JOBS
Synonym for USER_JOBS

V$TEMP_EXTENT_MAP
Synonym for V_$TEMP_EXTENT_MAP

GV$TEMP_EXTENT_MAP
Synonym for GV_$TEMP_EXTENT_MAP

V$TEMP_EXTENT_POOL
Synonym for V_$TEMP_EXTENT_POOL

GV$TEMP_EXTENT_POOL
Synonym for GV_$TEMP_EXTENT_POOL

V$TEMP_SPACE_HEADER
Synonym for V_$TEMP_SPACE_HEADER

GV$TEMP_SPACE_HEADER
Synonym for GV_$TEMP_SPACE_HEADER

V$FILESPACE_USAGE
Synonym for V_$FILESPACE_USAGE

GV$FILESPACE_USAGE
Synonym for GV_$FILESPACE_USAGE

V$CONTEXT
Synonym for V_$CONTEXT

GV$CONTEXT
Synonym for GV_$CONTEXT

V$GLOBALCONTEXT
Synonym for V_$GLOBALCONTEXT

GV$GLOBALCONTEXT
Synonym for GV_$GLOBALCONTEXT

SM$VERSION
Synonym for SM_$VERSION

V$AQ
Synonym for V_$AQ

GV$AQ
Synonym for GV_$AQ

GV$REPLQUEUE
Synonym for GV_$REPLQUEUE

V$REPLQUEUE
Synonym for V_$REPLQUEUE

GV$REPLPROP
Synonym for GV_$REPLPROP

V$REPLPROP
Synonym for V_$REPLPROP

GV$MVREFRESH
Synonym for GV_$MVREFRESH

V$MVREFRESH
Synonym for V_$MVREFRESH

DBA_SNAPSHOT_REFRESH_TIMES
Synonym for DBA_MVIEW_REFRESH_TIMES

ALL_SNAPSHOT_REFRESH_TIMES
Synonym for ALL_MVIEW_REFRESH_TIMES

USER_SNAPSHOT_REFRESH_TIMES
Synonym for USER_MVIEW_REFRESH_TIMES

DBA_SNAPSHOT_LOG_FILTER_COLS
Synonym for DBA_MVIEW_LOG_FILTER_COLS

V$BACKUP_FILES
Synonym for V_$BACKUP_FILES

V$RMAN_BACKUP_SUBJOB_DETAILS
Synonym for V_$RMAN_BACKUP_SUBJOB_DETAILS

V$RMAN_BACKUP_JOB_DETAILS
Synonym for V_$RMAN_BACKUP_JOB_DETAILS

V$BACKUP_SET_DETAILS
Synonym for V_$BACKUP_SET_DETAILS

V$BACKUP_PIECE_DETAILS
Synonym for V_$BACKUP_PIECE_DETAILS

V$BACKUP_COPY_DETAILS
Synonym for V_$BACKUP_COPY_DETAILS

V$PROXY_COPY_DETAILS
Synonym for V_$PROXY_COPY_DETAILS

V$PROXY_ARCHIVELOG_DETAILS
Synonym for V_$PROXY_ARCHIVELOG_DETAILS

V$BACKUP_DATAFILE_DETAILS
Synonym for V_$BACKUP_DATAFILE_DETAILS

V$BACKUP_CONTROLFILE_DETAILS
Synonym for V_$BACKUP_CONTROLFILE_DETAILS

V$BACKUP_ARCHIVELOG_DETAILS
Synonym for V_$BACKUP_ARCHIVELOG_DETAILS

V$BACKUP_SPFILE_DETAILS
Synonym for V_$BACKUP_SPFILE_DETAILS

V$BACKUP_SET_SUMMARY
Synonym for V_$BACKUP_SET_SUMMARY

V$BACKUP_DATAFILE_SUMMARY
Synonym for V_$BACKUP_DATAFILE_SUMMARY

V$BACKUP_CONTROLFILE_SUMMARY
Synonym for V_$BACKUP_CONTROLFILE_SUMMARY

V$BACKUP_ARCHIVELOG_SUMMARY
Synonym for V_$BACKUP_ARCHIVELOG_SUMMARY

V$BACKUP_SPFILE_SUMMARY
Synonym for V_$BACKUP_SPFILE_SUMMARY

V$BACKUP_COPY_SUMMARY
Synonym for V_$BACKUP_COPY_SUMMARY

V$PROXY_COPY_SUMMARY
Synonym for V_$PROXY_COPY_SUMMARY

V$PROXY_ARCHIVELOG_SUMMARY
Synonym for V_$PROXY_ARCHIVELOG_SUMMARY

V$UNUSABLE_BACKUPFILE_DETAILS
Synonym for V_$UNUSABLE_BACKUPFILE_DETAILS

V$RMAN_BACKUP_TYPE
Synonym for V_$RMAN_BACKUP_TYPE

ALL_OUTLINES
Synonym for USER_OUTLINES

ALL_OUTLINE_HINTS
Synonym for USER_OUTLINE_HINTS

V$DATAPUMP_JOB
Synonym for V_$DATAPUMP_JOB

V$DATAPUMP_SESSION
Synonym for V_$DATAPUMP_SESSION

GV$DATAPUMP_JOB
Synonym for GV_$DATAPUMP_JOB

GV$DATAPUMP_SESSION
Synonym for GV_$DATAPUMP_SESSION

V$LOGSTDBY
Synonym for V_$LOGSTDBY

V$LOGSTDBY_STATS
Synonym for V_$LOGSTDBY_STATS

V$LOGSTDBY_TRANSACTION
Synonym for V_$LOGSTDBY_TRANSACTION

V$LOGSTDBY_PROGRESS
Synonym for V_$LOGSTDBY_PROGRESS

V$LOGSTDBY_PROCESS
Synonym for V_$LOGSTDBY_PROCESS

V$LOGSTDBY_STATE
Synonym for V_$LOGSTDBY_STATE

GV$LOGSTDBY
Synonym for GV_$LOGSTDBY

GV$LOGSTDBY_STATS
Synonym for GV_$LOGSTDBY_STATS

GV$LOGSTDBY_TRANSACTION
Synonym for GV_$LOGSTDBY_TRANSACTION

GV$LOGSTDBY_PROGRESS
Synonym for GV_$LOGSTDBY_PROGRESS

GV$LOGSTDBY_PROCESS
Synonym for GV_$LOGSTDBY_PROCESS

GV$LOGSTDBY_STATE
Synonym for GV_$LOGSTDBY_STATE

GV$STREAMS_CAPTURE
Synonym for GV_$STREAMS_CAPTURE

V$STREAMS_CAPTURE
Synonym for V_$STREAMS_CAPTURE

DBA_APPLY_VALUE_DEPENDENCIES
Synonym for _DBA_APPLY_CONSTRAINT_COLUMNS

DBA_APPLY_OBJECT_DEPENDENCIES
Synonym for _DBA_APPLY_OBJECT_CONSTRAINTS

GV$STREAMS_APPLY_COORDINATOR
Synonym for GV_$STREAMS_APPLY_COORDINATOR

V$STREAMS_APPLY_COORDINATOR
Synonym for V_$STREAMS_APPLY_COORDINATOR

GV$STREAMS_APPLY_SERVER
Synonym for GV_$STREAMS_APPLY_SERVER

V$STREAMS_APPLY_SERVER
Synonym for V_$STREAMS_APPLY_SERVER

GV$STREAMS_APPLY_READER
Synonym for GV_$STREAMS_APPLY_READER

V$STREAMS_APPLY_READER
Synonym for V_$STREAMS_APPLY_READER

GV$STREAMS_TRANSACTION
Synonym for GV_$STREAMS_TRANSACTION

V$STREAMS_TRANSACTION
Synonym for V_$STREAMS_TRANSACTION

V$SQL_BIND_CAPTURE
Synonym for V_$SQL_BIND_CAPTURE

GV$SQL_BIND_CAPTURE
Synonym for GV_$SQL_BIND_CAPTURE

V$ALERT_TYPES
Synonym for V_$ALERT_TYPES

GV$ALERT_TYPES
Synonym for GV_$ALERT_TYPES

V$THRESHOLD_TYPES
Synonym for V_$THRESHOLD_TYPES

GV$THRESHOLD_TYPES
Synonym for GV_$THRESHOLD_TYPES

V$CLIENT_STATS
Synonym for V_$CLIENT_STATS

GV$CLIENT_STATS
Synonym for GV_$CLIENT_STATS

V$SERV_MOD_ACT_STATS
Synonym for V_$SERV_MOD_ACT_STATS

GV$SERV_MOD_ACT_STATS
Synonym for GV_$SERV_MOD_ACT_STATS

V$SERVICE_STATS
Synonym for V_$SERVICE_STATS

GV$SERVICE_STATS
Synonym for GV_$SERVICE_STATS

V$SYS_TIME_MODEL
Synonym for V_$SYS_TIME_MODEL

GV$SYS_TIME_MODEL
Synonym for GV_$SYS_TIME_MODEL

V$SESS_TIME_MODEL
Synonym for V_$SESS_TIME_MODEL

GV$SESS_TIME_MODEL
Synonym for GV_$SESS_TIME_MODEL

DBA_SQLSET_DEFINITIONS
Synonym for DBA_SQLSET

USER_SQLSET_DEFINITIONS
Synonym for USER_SQLSET

ALL_OLAP_ALTER_SESSION
Synonym for V$OLAP_ALTER_SESSION

I hope you all have enjoyed reading this article. Comments are welcome....