TABLE_NAME |
COMMENTS |
ALL_ALL_TABLES |
Description of all object and relational tables accessible to the user |
ALL_APPLY |
Details about each apply process that dequeues from the queue visible to the current user |
ALL_APPLY_CONFLICT_COLUMNS |
Details about conflict resolution on tables visible to the current user |
ALL_APPLY_DML_HANDLERS |
Details about the dml handler on tables visible to the current user |
ALL_APPLY_ERROR |
Error transactions that were generated after dequeuing from the queue visible to the current user |
ALL_APPLY_KEY_COLUMNS |
Alternative key columns for a STREAMS table visible to the current user |
ALL_APPLY_PARAMETERS |
Details about parameters of each apply process that dequeues from the queue visible to the current user |
ALL_APPLY_PROGRESS |
Information about the progress made by the apply process that dequeues from the queue visible to the current user |
ALL_ARGUMENTS |
Arguments in object accessible to the user |
ALL_ASSOCIATIONS |
All associations available to the user |
ALL_AUDIT_POLICIES |
All fine grained auditing policies in the database |
ALL_BASE_TABLE_MVIEWS |
All materialized views with log(s) in the database that the user can see |
ALL_CAPTURE |
Details about each capture process that stores the captured changes in a queue visible to the current user |
ALL_CAPTURE_PARAMETERS |
Details about parameters for each capture process that stores the captured changes in a queue visible to the current user |
ALL_CAPTURE_PREPARED_DATABASE |
Is the local database prepared for instantiation? |
ALL_CAPTURE_PREPARED_SCHEMAS |
All user schemas at the local database that are prepared for instantiation |
ALL_CAPTURE_PREPARED_TABLES |
All tables visible to the current user that are prepared for instantiation |
ALL_CATALOG |
All tables, views, synonyms, sequences accessible to the user |
ALL_CLUSTERS |
Description of clusters accessible to the user |
ALL_CLUSTER_HASH_EXPRESSIONS |
Hash functions for all accessible clusters |
ALL_COLL_TYPES |
Description of named collection types accessible to the user |
ALL_COL_COMMENTS |
Comments on columns of accessible tables and views |
ALL_COL_PRIVS |
Grants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee |
ALL_COL_PRIVS_MADE |
Grants on columns for which the user is owner or grantor |
ALL_COL_PRIVS_RECD |
Grants on columns for which the user, PUBLIC or enabled role is the grantee |
ALL_CONSTRAINTS |
Constraint definitions on accessible tables |
ALL_CONS_COLUMNS |
Information about accessible columns in constraint definitions |
ALL_CONS_OBJ_COLUMNS |
List of types an object column or attribute is constrained to in the tables accessible to the user |
ALL_CONTEXT |
Description of all active context namespaces under the current session |
ALL_DB_LINKS |
Database links accessible to the user |
ALL_DEF_AUDIT_OPTS |
Auditing options for newly created objects |
ALL_DEPENDENCIES |
Dependencies to and from objects accessible to the user |
ALL_DIMENSIONS |
Description of the dimension objects accessible to the DBA |
ALL_DIM_ATTRIBUTES |
Representation of the relationship between a dimension level and a functionally dependent column |
ALL_DIM_CHILD_OF |
Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension |
ALL_DIM_HIERARCHIES |
Representation of a dimension hierarchy |
ALL_DIM_JOIN_KEY |
Representation of a join between two dimension tables. |
ALL_DIM_LEVELS |
Description of dimension levels visible to DBA |
ALL_DIM_LEVEL_KEY |
Representations of columns of a dimension level |
ALL_DIRECTORIES |
Description of all directories accessible to the user |
ALL_ERRORS |
Current errors on stored objects that user is allowed to create |
ALL_EVALUATION_CONTEXTS |
rule evaluation contexts seen by user |
ALL_EVALUATION_CONTEXT_TABLES |
tables in all rule evaluation contexts seen by the user |
ALL_EVALUATION_CONTEXT_VARS |
variables in all rule evaluation contexts seen by the user |
ALL_EXTERNAL_LOCATIONS |
Description of the external tables locations accessible to the user |
ALL_EXTERNAL_TABLES |
Description of the external tables accessible to the user |
ALL_INDEXES |
Descriptions of indexes on tables accessible to the user |
ALL_INDEXTYPES |
All indextypes available to the user |
ALL_INDEXTYPE_COMMENTS |
Comments for user-defined indextypes |
ALL_INDEXTYPE_OPERATORS |
All operators available to the user |
ALL_IND_COLUMNS |
COLUMNs comprising INDEXes on accessible TABLES |
ALL_IND_EXPRESSIONS |
FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES |
ALL_IND_PARTITIONS |
ALL_IND_SUBPARTITIONS |
ALL_INTERNAL_TRIGGERS |
Description of the internal triggers on the tables accessible to the user |
ALL_JOIN_IND_COLUMNS |
Join Index columns comprising the join conditions |
ALL_LIBRARIES |
Description of libraries accessible to the user |
ALL_LOBS |
Description of LOBs contained in tables accessible to the user |
ALL_LOB_PARTITIONS |
ALL_LOB_SUBPARTITIONS |
ALL_LOB_TEMPLATES |
ALL_LOG_GROUPS |
Log group definitions on accessible tables |
ALL_LOG_GROUP_COLUMNS |
Information about columns in log group definitions |
ALL_METHOD_PARAMS |
Description of method parameters of types accessible to the user |
ALL_METHOD_RESULTS |
Description of method results of types accessible to the user |
ALL_MVIEWS |
All materialized views in the database |
ALL_MVIEW_AGGREGATES |
Description of the materialized view aggregates accessible to the user |
ALL_MVIEW_ANALYSIS |
Description of the materialized views accessible to the user |
ALL_MVIEW_DETAIL_RELATIONS |
Description of the materialized view detail tables accessible to the user |
ALL_MVIEW_JOINS |
Description of a join between two columns in the WHERE clause of a materialized view accessible to the user |
ALL_MVIEW_KEYS |
Description of the columns that appear in the GROUP BY list of a materialized view accessible to the user |
ALL_MVIEW_LOGS |
All materialized view logs in the database that the user can see |
ALL_MVIEW_REFRESH_TIMES |
Materialized views and their last refresh times for each master table that the user can look at |
ALL_NESTED_TABLES |
Description of nested tables in tables accessible to the user |
ALL_OBJECTS |
Objects accessible to the user |
ALL_OBJECT_TABLES |
Description of all object tables accessible to the user |
ALL_OBJ_COLATTRS |
Description of object columns and attributes contained in the tables accessible to the user |
ALL_OPANCILLARY |
All ancillary operators available to the user |
ALL_OPARGUMENTS |
All arguments of the operators available to the user |
ALL_OPBINDINGS |
All binding functions for operators available to the user |
ALL_OPERATORS |
All operators available to the user |
ALL_OPERATOR_COMMENTS |
Comments for user-defined operators |
ALL_PARTIAL_DROP_TABS |
All tables with patially dropped columns accessible to the user |
ALL_PART_COL_STATISTICS |
ALL_PART_HISTOGRAMS |
ALL_PART_INDEXES |
ALL_PART_KEY_COLUMNS |
ALL_PART_LOBS |
ALL_PART_TABLES |
ALL_PENDING_CONV_TABLES |
All tables accessible to the user which are not upgraded to the latest type version |
ALL_POLICIES |
All policies for objects if the user has system privileges or owns the objects |
ALL_POLICY_CONTEXTS |
All policy driving context defined for all synonyms, tables, or views accessable to the user |
ALL_POLICY_GROUPS |
All policy groups defined for any synonym, table or view accessable to the user |
ALL_PROBE_OBJECTS |
ALL_PROCEDURES |
Description of all procedures available to the user |
ALL_PROPAGATION |
Streams propagation seen by the user |
ALL_PUBLISHED_COLUMNS |
ALL_QUEUES |
All queues accessible to the user |
ALL_QUEUE_PUBLISHERS |
ALL_QUEUE_TABLES |
All queue tables accessible to the user |
ALL_REFRESH |
All the refresh groups that the user can touch |
ALL_REFRESH_CHILDREN |
All the objects in refresh groups, where the user can touch the group |
ALL_REFRESH_DEPENDENCIES |
Description of the detail tables that materialized views depend on for refresh |
ALL_REFS |
Description of REF columns contained in tables accessible to the user |
ALL_REGISTERED_MVIEWS |
Remote materialized views of local tables that the user can see |
ALL_REGISTERED_SNAPSHOTS |
Remote snapshots of local tables that the user can see |
ALL_REGISTRY_BANNERS |
ALL_REPAUDIT_ATTRIBUTE |
Information about attributes automatically maintained for replication |
ALL_REPAUDIT_COLUMN |
Information about columns in all shadow tables for replicated tables which are accessible to the user |
ALL_REPCAT |
ALL_REPCATLOG |
Information about asynchronous administration requests |
ALL_REPCOLUMN |
Replicated top-level columns (table) sorted alphabetically in ascending order |
ALL_REPCOLUMN_GROUP |
All column groups of replicated tables which are accessible to the user |
ALL_REPCONFLICT |
All conflicts with available resolutions for user’s replicated tables |
ALL_REPDDL |
Arguments that do not fit in a single repcat log record |
ALL_REPFLAVORS |
Flavors defined for replicated object groups |
ALL_REPFLAVOR_COLUMNS |
Replicated columns in flavors |
ALL_REPFLAVOR_OBJECTS |
Replicated objects in flavors |
ALL_REPGENERATED |
Objects generated to support replication |
ALL_REPGENOBJECTS |
Objects generated to support replication |
ALL_REPGROUP |
Information about replicated object groups |
ALL_REPGROUPED_COLUMN |
Columns in the all column groups of replicated tables which are accessible to the user |
ALL_REPGROUP_PRIVILEGES |
Information about users who are registered for object group privileges |
ALL_REPKEY_COLUMNS |
Primary columns for a table using column-level replication |
ALL_REPOBJECT |
Information about replicated objects |
ALL_REPPARAMETER_COLUMN |
All columns used for resolving conflicts in replicated tables which are accessible to the user |
ALL_REPPRIORITY |
Values and their corresponding priorities in all priority groups which are accessible to the user |
ALL_REPPRIORITY_GROUP |
Information about all priority groups which are accessible to the user |
ALL_REPPROP |
Propagation information about replicated objects |
ALL_REPRESOLUTION |
Description of all conflict resolutions for replicated tables which are accessible to the user |
ALL_REPRESOLUTION_METHOD |
All conflict resolution methods accessible to the user |
ALL_REPRESOLUTION_STATISTICS |
Statistics for conflict resolutions for replicated tables which are accessible to the user |
ALL_REPRESOL_STATS_CONTROL |
Information about statistics collection for conflict resolutions for replicated tables which are accessible to the user |
ALL_REPSCHEMA |
N-way replication information |
ALL_REPSITES |
N-way replication information |
ALL_RULES |
Rules seen by the user |
ALL_RULESETS |
Rulesets seen by the user: maintained for backward compatibility |
ALL_RULE_SETS |
Rule sets seen by the user |
ALL_RULE_SET_RULES |
Rules in all rule sets seen by the user |
ALL_SECONDARY_OBJECTS |
All secondary objects for domain indexes |
ALL_SEQUENCES |
Description of SEQUENCEs accessible to the user |
ALL_SNAPSHOTS |
Snapshots the user can access |
ALL_SNAPSHOT_LOGS |
All snapshot logs in the database that the user can see |
ALL_SOURCE |
Current source on stored objects that user is allowed to create |
ALL_SOURCE_TABLES |
ALL_SOURCE_TAB_COLUMNS |
ALL_SQLJ_TYPES |
Description of types accessible to the user |
ALL_SQLJ_TYPE_ATTRS |
Description of attributes of types accessible to the user |
ALL_SQLJ_TYPE_METHODS |
Description of methods of types accessible to the user |
ALL_STORED_SETTINGS |
Parameter settings for objects accessible to the user |
ALL_STREAMS_GLOBAL_RULES |
Global rules created on the streams capture/apply/propagation process that interact with the queue visible to the current user |
ALL_STREAMS_SCHEMA_RULES |
Rules created by streams administrative APIs on all user schemas |
ALL_STREAMS_TABLE_RULES |
Rules created by streams administrative APIs on tables visible to the current user |
ALL_SUBPARTITION_TEMPLATES |
ALL_SUBPART_COL_STATISTICS |
ALL_SUBPART_HISTOGRAMS |
ALL_SUBPART_KEY_COLUMNS |
ALL_SUBSCRIBED_COLUMNS |
ALL_SUBSCRIBED_TABLES |
ALL_SUBSCRIPTIONS |
ALL_SUMDELTA |
Direct path load entries accessible to the user |
ALL_SUMMARIES |
Description of the summaries accessible to the user |
ALL_SYNONYMS |
All synonyms accessible to the user |
ALL_TABLES |
Description of relational tables accessible to the user |
ALL_TAB_COLS |
Columns of user’s tables, views and clusters |
ALL_TAB_COLUMNS |
Columns of user’s tables, views and clusters |
ALL_TAB_COL_STATISTICS |
Columns of user’s tables, views and clusters |
ALL_TAB_COMMENTS |
Comments on tables and views accessible to the user |
ALL_TAB_HISTOGRAMS |
Histograms on columns of all tables visible to user |
ALL_TAB_MODIFICATIONS |
Information regarding modifications to tables |
ALL_TAB_PARTITIONS |
ALL_TAB_PRIVS |
Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee |
ALL_TAB_PRIVS_MADE |
User’s grants and grants on user’s objects |
ALL_TAB_PRIVS_RECD |
Grants on objects for which the user, PUBLIC or enabled role is the grantee |
ALL_TAB_SUBPARTITIONS |
ALL_TRIGGERS |
Triggers accessible to the current user |
ALL_TRIGGER_COLS |
Column usage in user’s triggers or in triggers on user’s tables |
ALL_TYPES |
Description of types accessible to the user |
ALL_TYPE_ATTRS |
Description of attributes of types accessible to the user |
ALL_TYPE_METHODS |
Description of methods of types accessible to the user |
ALL_TYPE_VERSIONS |
Description of each type version accessible to the user |
ALL_UNUSED_COL_TABS |
All tables with unused columns accessible to the user |
ALL_UPDATABLE_COLUMNS |
Description of all updatable columns |
ALL_USERS |
Information about all users of the database |
ALL_USTATS |
All statistics |
ALL_VARRAYS |
Description of varrays in tables accessible to the user |
ALL_VIEWS |
Description of views accessible to the user |
USER_ALL_TABLES |
Description of all object and relational tables owned by the user’s |
USER_AQ_AGENT_PRIVS |
USER_ARGUMENTS |
Arguments in object accessible to the user |
USER_ASSOCIATIONS |
All assocations defined by the user |
USER_ATTRIBUTE_TRANSFORMATIONS |
USER_AUDIT_OBJECT |
Audit trail records for statements concerning objects, specifically: table, cluster, view, index, sequence, [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace, role, user |
USER_AUDIT_POLICIES |
All fine grained auditing policies for objects in user schema |
USER_AUDIT_SESSION |
All audit trail records concerning CONNECT and DISCONNECT |
USER_AUDIT_STATEMENT |
Audit trail records concerning grant, revoke, audit, noaudit and alter system |
USER_AUDIT_TRAIL |
Audit trail entries relevant to the user |
USER_AWS |
Analytic Workspaces owned by the user |
USER_AW_PS |
Pagespaces in Analytic Workspaces owned by the user |
USER_BASE_TABLE_MVIEWS |
All materialized views with log(s) owned by the user in the database |
USER_CATALOG |
Tables, Views, Synonyms and Sequences owned by the user |
USER_CLUSTERS |
Descriptions of user’s own clusters |
USER_CLUSTER_HASH_EXPRESSIONS |
Hash functions for the user’s hash clusters |
USER_CLU_COLUMNS |
Mapping of table columns to cluster columns |
USER_COLL_TYPES |
Description of the user’s own named collection types |
USER_COL_COMMENTS |
Comments on columns of user’s tables and views |
USER_COL_PRIVS |
Grants on columns for which the user is the owner, grantor or grantee |
USER_COL_PRIVS_MADE |
All grants on columns of objects owned by the user |
USER_COL_PRIVS_RECD |
Grants on columns for which the user is the grantee |
USER_CONSTRAINTS |
Constraint definitions on user’s own tables |
USER_CONS_COLUMNS |
Information about accessible columns in constraint definitions |
USER_CONS_OBJ_COLUMNS |
List of types an object column or attribute is constrained to in the tables owned by the user |
USER_DB_LINKS |
Database links owned by the user |
USER_DEPENDENCIES |
Dependencies to and from a users objects |
USER_DIMENSIONS |
Description of the dimension objects accessible to the DBA |
USER_DIM_ATTRIBUTES |
Representation of the relationship between a dimension level and a functionally dependent column |
USER_DIM_CHILD_OF |
Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension |
USER_DIM_HIERARCHIES |
Representation of a dimension hierarchy |
USER_DIM_JOIN_KEY |
Representation of a join between two dimension tables. |
USER_DIM_LEVELS |
Description of dimension levels visible to DBA |
USER_DIM_LEVEL_KEY |
Representations of columns of a dimension level |
USER_ERRORS |
Current errors on stored objects owned by the user |
USER_EVALUATION_CONTEXTS |
rule evaluation contexts owned by user |
USER_EVALUATION_CONTEXT_TABLES |
tables in user rule evaluation contexts |
USER_EVALUATION_CONTEXT_VARS |
variables in user rule evaluation contexts |
USER_EXTENTS |
Extents comprising segments owned by the user |
USER_EXTERNAL_LOCATIONS |
Description of the user’s external tables locations |
USER_EXTERNAL_TABLES |
Description of the user’s own external tables |
USER_FREE_SPACE |
Free extents in tablespaces accessible to the user |
USER_INDEXES |
Description of the user’s own indexes |
USER_INDEXTYPES |
All user indextypes |
USER_INDEXTYPE_COMMENTS |
Comments for user-defined indextypes |
USER_INDEXTYPE_OPERATORS |
All user indextype operators |
USER_IND_COLUMNS |
COLUMNs comprising user’s INDEXes and INDEXes on user’s TABLES |
USER_IND_EXPRESSIONS |
Functional index expressions in user’s indexes and indexes on user’s tables |
USER_IND_PARTITIONS |
USER_IND_SUBPARTITIONS |
USER_INTERNAL_TRIGGERS |
Description of the internal triggers on the user’s own tables |
USER_JOBS |
All jobs owned by this user |
USER_JOIN_IND_COLUMNS |
Join Index columns comprising the join conditions |
USER_LIBRARIES |
Description of the user’s own libraries |
USER_LOBS |
Description of the user’s own LOBs contained in the user’s own tables |
USER_LOB_PARTITIONS |
USER_LOB_SUBPARTITIONS |
USER_LOB_TEMPLATES |
USER_LOG_GROUPS |
Log group definitions on user’s own tables |
USER_LOG_GROUP_COLUMNS |
Information about columns in log group definitions |
USER_METHOD_PARAMS |
Description of method parameters of the user’s own types |
USER_METHOD_RESULTS |
Description of method results of the user’s own types |
USER_MVIEWS |
All materialized views in the database |
USER_MVIEW_AGGREGATES |
Description of the materialized view aggregates created by the user |
USER_MVIEW_ANALYSIS |
Description of the materialized views created by the user |
USER_MVIEW_DETAIL_RELATIONS |
Description of the materialized view detail tables of the materialized views created by the user |
USER_MVIEW_JOINS |
Description of a join between two columns in the WHERE clause of a materialized view created by the user |
USER_MVIEW_KEYS |
Description of the columns that appear in the GROUP BY list of a materialized view created by the user |
USER_MVIEW_LOGS |
All materialized view logs owned by the user |
USER_MVIEW_REFRESH_TIMES |
Materialized views and their last refresh times for each master table that the user can look at |
USER_NESTED_TABLES |
Description of nested tables contained in the user’s own tables |
USER_OBJECTS |
Objects owned by the user |
USER_OBJECT_SIZE |
Sizes, in bytes, of various pl/sql objects |
USER_OBJECT_TABLES |
Description of the user’s own object tables |
USER_OBJ_AUDIT_OPTS |
Auditing options for user’s own tables and views |
USER_OBJ_COLATTRS |
Description of object columns and attributes contained in tables owned by the user |
USER_OPANCILLARY |
All ancillary opertors defined by user |
USER_OPARGUMENTS |
All operator arguments of operators defined by user |
USER_OPBINDINGS |
All binding functions or methods on operators defined by the user |
USER_OPERATORS |
All user operators |
USER_OPERATOR_COMMENTS |
Comments for user-defined operators |
USER_OUTLINES |
Stored outlines owned by the user |
USER_OUTLINE_HINTS |
Hints stored in outlines owned by the user |
USER_PARTIAL_DROP_TABS |
User tables with unused columns |
USER_PART_COL_STATISTICS |
USER_PART_HISTOGRAMS |
USER_PART_INDEXES |
USER_PART_KEY_COLUMNS |
USER_PART_LOBS |
USER_PART_TABLES |
USER_PASSWORD_LIMITS |
Display password limits of the user |
USER_PENDING_CONV_TABLES |
All user’s tables which are not upgraded to the latest type version |
USER_POLICIES |
All row level security policies for synonyms, tables, or views owned by the user |
USER_POLICY_CONTEXTS |
All policy driving context defined for synonyms, tables, or views in current schema |
USER_POLICY_GROUPS |
All policy groups defined for any synonym, table, or view |
USER_PROCEDURES |
Description of the users own procedures |
USER_PROXIES |
Description of connections the user is allowed to proxy |
USER_PUBLISHED_COLUMNS |
USER_QUEUES |
All queues owned by the user |
USER_QUEUE_PUBLISHERS |
USER_QUEUE_SCHEDULES |
USER_QUEUE_TABLES |
All queue tables created by the user |
USER_REFRESH |
All the refresh groups |
USER_REFRESH_CHILDREN |
All the objects in refresh groups, where the user owns the refresh group |
USER_REFS |
Description of the user’s own REF columns contained in the user’s own tables |
USER_REGISTERED_MVIEWS |
Remote materialized views of local tables currently using logs owned by the user |
USER_REGISTERED_SNAPSHOTS |
Remote snapshots of local tables currently using logs owned by the user |
USER_REGISTRY |
USER_REPAUDIT_ATTRIBUTE |
Information about attributes automatically maintained for replication |
USER_REPAUDIT_COLUMN |
Information about columns in all shadow tables for user’s replicated tables |
USER_REPCAT |
USER_REPCATLOG |
Information about the current user’s asynchronous administration requests |
USER_REPCOLUMN |
Replicated columns for the current user’s table in ascending order |
USER_REPCOLUMN_GROUP |
All column groups of user’s replicated tables |
USER_REPCONFLICT |
USER_REPDDL |
Arguments that do not fit in a single repcat log record |
USER_REPFLAVORS |
Flavors current user created for replicated object groups |
USER_REPFLAVOR_COLUMNS |
Replicated columns from current user’s tables in flavors |
USER_REPFLAVOR_OBJECTS |
Replicated user objects in flavors |
USER_REPGENERATED |
Objects generated for the current user to support replication |
USER_REPGENOBJECTS |
Objects generated for the current user to support replication |
USER_REPGROUP |
Replication information about the current user |
USER_REPGROUPED_COLUMN |
Columns in the all column groups of user’s replicated tables |
USER_REPGROUP_PRIVILEGES |
Information about users who are registered for object group privileges |
USER_REPKEY_COLUMNS |
Primary columns for a table using column-level replication |
USER_REPOBJECT |
Replication information about the current user’s objects |
USER_REPPARAMETER_COLUMN |
All columns used for resolving conflicts in user’s replicated tables |
USER_REPPRIORITY |
Values and their corresponding priorities in user’s priority groups |
USER_REPPRIORITY_GROUP |
Information about user’s priority groups |
USER_REPPROP |
Propagation information about the current user’s objects |
USER_REPRESOLUTION |
Description of all conflict resolutions for user’s replicated tables |
USER_REPRESOLUTION_METHOD |
All conflict resolution methods accessible to the user |
USER_REPRESOLUTION_STATISTICS |
Statistics for conflict resolutions for user’s replicated tables |
USER_REPRESOL_STATS_CONTROL |
Information about statistics collection for conflict resolutions for user’s replicated tables |
USER_REPSCHEMA |
N-way replication information about the current user |
USER_REPSITES |
N-way replication information about the current user |
USER_RESOURCE_LIMITS |
Display resource limit of the user |
USER_RESUMABLE |
Resumable session information for current user |
USER_ROLE_PRIVS |
Roles granted to current user |
USER_RSRC_CONSUMER_GROUP_PRIVS |
Switch privileges for consumer groups for the user |
USER_RSRC_MANAGER_SYSTEM_PRIVS |
system privileges for the resource manager for the user |
USER_RULES |
Rules owned by the user |
USER_RULESETS |
Rulesets owned by the user: maintained for backward compatibility |
USER_RULE_SETS |
Rule sets owned by the user |
USER_RULE_SET_RULES |
Rules in user rule sets |
USER_SECONDARY_OBJECTS |
All secondary objects for domain indexes |
USER_SEGMENTS |
Storage allocated for all database segments |
USER_SEQUENCES |
Description of the user’s own SEQUENCEs |
USER_SNAPSHOTS |
Snapshots the user can look at |
USER_SNAPSHOT_LOGS |
All snapshot logs owned by the user |
USER_SOURCE |
Source of stored objects accessible to the user |
USER_SOURCE_TABLES |
USER_SOURCE_TAB_COLUMNS |
USER_SQLJ_TYPES |
Description of the user’s own types |
USER_SQLJ_TYPE_ATTRS |
Description of attributes of the user’s own types |
USER_SQLJ_TYPE_METHODS |
Description of methods of the user’s own types |
USER_STORED_SETTINGS |
Parameter settings for objects owned by the user |
USER_SUBPARTITION_TEMPLATES |
USER_SUBPART_COL_STATISTICS |
USER_SUBPART_HISTOGRAMS |
USER_SUBPART_KEY_COLUMNS |
USER_SUBSCRIBED_COLUMNS |
USER_SUBSCRIBED_TABLES |
USER_SUBSCRIPTIONS |
USER_SUMMARIES |
Description of the summaries created by the user |
USER_SYNONYMS |
The user’s private synonyms |
USER_SYS_PRIVS |
System privileges granted to current user |
USER_TABLES |
Description of the user’s own relational tables |
USER_TABLESPACES |
Description of accessible tablespaces |
USER_TAB_COLS |
Columns of user’s tables, views and clusters |
USER_TAB_COLUMNS |
Columns of user’s tables, views and clusters |
USER_TAB_COL_STATISTICS |
Columns of user’s tables, views and clusters |
USER_TAB_COMMENTS |
Comments on the tables and views owned by the user |
USER_TAB_HISTOGRAMS |
Histograms on columns of user’s tables |
USER_TAB_MODIFICATIONS |
Information regarding modifications to tables |
USER_TAB_PARTITIONS |
USER_TAB_PRIVS |
Grants on objects for which the user is the owner, grantor or grantee |
USER_TAB_PRIVS_MADE |
All grants on objects owned by the user |
USER_TAB_PRIVS_RECD |
Grants on objects for which the user is the grantee |
USER_TAB_SUBPARTITIONS |
USER_TRANSFORMATIONS |
USER_TRIGGERS |
Triggers owned by the user |
USER_TRIGGER_COLS |
Column usage in user’s triggers |
USER_TS_QUOTAS |
Tablespace quotas for the user |
USER_TYPES |
Description of the user’s own types |
USER_TYPE_ATTRS |
Description of attributes of the user’s own types |
USER_TYPE_METHODS |
Description of methods of the user’s own types |
USER_TYPE_VERSIONS |
Description of each version of the user’s types |
USER_UNUSED_COL_TABS |
User tables with unused columns |
USER_UPDATABLE_COLUMNS |
Description of updatable columns |
USER_USERS |
Information about the current user |
USER_USTATS |
All statistics on tables or indexes owned by the user |
USER_VARRAYS |
Description of varrays contained in the user’s own tables |
USER_VIEWS |
Description of the user’s own views |
AUDIT_ACTIONS |
Description table for audit trail action type codes. Maps action type numbers to action type names |
COLUMN_PRIVILEGES |
Grants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee |
DATABASE_COMPATIBLE_LEVEL |
Database compatible parameter set via init.ora |
DBMS_ALERT_INFO |
DBMS_LOCK_ALLOCATED |
DICTIONARY |
Description of data dictionary tables and views |
DICT_COLUMNS |
Description of columns in data dictionary tables and views |
DUAL |
|
GLOBAL_NAME |
global database name |
INDEX_HISTOGRAM |
statistics on keys with repeat count |
INDEX_STATS |
statistics on the b-tree |
NLS_DATABASE_PARAMETERS |
Permanent NLS parameters of the database |
NLS_INSTANCE_PARAMETERS |
NLS parameters of the instance |
NLS_SESSION_PARAMETERS |
NLS parameters of the user session |
RESOURCE_COST |
Cost for each resource |
ROLE_ROLE_PRIVS |
Roles which are granted to roles |
ROLE_SYS_PRIVS |
System privileges granted to roles |
ROLE_TAB_PRIVS |
Table privileges granted to roles |
SESSION_PRIVS |
Privileges which the user currently has set |
SESSION_ROLES |
Roles which the user currently has enabled. |
TABLE_PRIVILEGES |
Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee |
ALL_HISTOGRAMS |
Synonym for ALL_TAB_HISTOGRAMS |
ALL_JOBS |
Synonym for USER_JOBS |
ALL_OUTLINES |
Synonym for USER_OUTLINES |
ALL_OUTLINE_HINTS |
Synonym for USER_OUTLINE_HINTS |
ALL_SNAPSHOT_REFRESH_TIMES |
Synonym for ALL_MVIEW_REFRESH_TIMES |
CAT |
Synonym for USER_CATALOG |
CLU |
Synonym for USER_CLUSTERS |
COLS |
Synonym for USER_TAB_COLUMNS |
DICT |
Synonym for DICTIONARY |
GV$ACTIVE_INSTANCES |
Synonym for GV_$ACTIVE_INSTANCES |
GV$ACTIVE_SESS_POOL_MTH |
Synonym for GV_$ACTIVE_SESS_POOL_MTH |
GV$AW_CALC |
Synonym for GV_$AW_CALC |
GV$AW_OLAP |
Synonym for GV_$AW_OLAP |
GV$AW_SESSION_INFO |
Synonym for GV_$AW_SESSION_INFO |
GV$BH |
Synonym for GV_$BH |
GV$LOADISTAT |
Synonym for GV_$LOADISTAT |
GV$LOADPSTAT |
Synonym for GV_$LOADPSTAT |
GV$LOCK_ACTIVITY |
Synonym for GV_$LOCK_ACTIVITY |
GV$MAX_ACTIVE_SESS_TARGET_MTH |
Synonym for GV_$MAX_ACTIVE_SESS_TARGET_MTH |
GV$MLS_PARAMETERS |
Synonym for GV_$MLS_PARAMETERS |
GV$NLS_PARAMETERS |
Synonym for GV_$NLS_PARAMETERS |
GV$NLS_VALID_VALUES |
Synonym for GV_$NLS_VALID_VALUES |
GV$OPTION |
Synonym for GV_$OPTION |
GV$PARALLEL_DEGREE_LIMIT_MTH |
Synonym for GV_$PARALLEL_DEGREE_LIMIT_MTH |
GV$PQ_SESSTAT |
Synonym for GV_$PQ_SESSTAT |
GV$PQ_TQSTAT |
Synonym for GV_$PQ_TQSTAT |
GV$QUEUEING_MTH |
Synonym for GV_$QUEUEING_MTH |
GV$RSRC_CONSUMER_GROUP |
Synonym for GV_$RSRC_CONSUMER_GROUP |
GV$RSRC_CONSUMER_GROUP_CPU_MTH |
Synonym for GV_$RSRC_CONSUME_GROUP_CPU_MTH |
GV$RSRC_PLAN |
Synonym for GV_$RSRC_PLAN |
GV$RSRC_PLAN_CPU_MTH |
Synonym for GV_$RSRC_PLAN_CPU_MTH |
GV$SESSION_LONGOPS |
Synonym for GV_$SESSION_LONGOPS |
GV$TEMPORARY_LOBS |
Synonym for GV_$TEMPORARY_LOBS |
GV$TIMEZONE_NAMES |
Synonym for GV_$TIMEZONE_NAMES |
GV$VERSION |
Synonym for GV_$VERSION |
IND |
Synonym for USER_INDEXES |
OBJ |
Synonym for USER_OBJECTS |
SEQ |
Synonym for USER_SEQUENCES |
SM$VERSION |
Synonym for SM_$VERSION |
SYN |
Synonym for USER_SYNONYMS |
TABS |
Synonym for USER_TABLES |
USER_HISTOGRAMS |
Synonym for USER_TAB_HISTOGRAMS |
USER_SNAPSHOT_REFRESH_TIMES |
Synonym for USER_MVIEW_REFRESH_TIMES |
V$ACTIVE_INSTANCES |
Synonym for V_$ACTIVE_INSTANCES |
V$ACTIVE_SESS_POOL_MTH |
Synonym for V_$ACTIVE_SESS_POOL_MTH |
V$AW_CALC |
Synonym for V_$AW_CALC |
V$AW_OLAP |
Synonym for V_$AW_OLAP |
V$AW_SESSION_INFO |
Synonym for V_$AW_SESSION_INFO |
V$BH |
Synonym for V_$BH |
V$INSTANCE |
Synonym for V_$INSTANCE |
V$LOADISTAT |
Synonym for V_$LOADISTAT |
V$LOADPSTAT |
Synonym for V_$LOADPSTAT |
V$LOCK_ACTIVITY |
Synonym for V_$LOCK_ACTIVITY |
V$MAX_ACTIVE_SESS_TARGET_MTH |
Synonym for V_$MAX_ACTIVE_SESS_TARGET_MTH |
V$MLS_PARAMETERS |
Synonym for V_$MLS_PARAMETERS |
V$NLS_PARAMETERS |
Synonym for V_$NLS_PARAMETERS |
V$NLS_VALID_VALUES |
Synonym for V_$NLS_VALID_VALUES |
V$OPTION |
Synonym for V_$OPTION |
V$PARALLEL_DEGREE_LIMIT_MTH |
Synonym for V_$PARALLEL_DEGREE_LIMIT_MTH |
V$PARAMETER |
Synonym for V_$PARAMETER |
V$PQ_SESSTAT |
Synonym for V_$PQ_SESSTAT |
V$PQ_TQSTAT |
Synonym for V_$PQ_TQSTAT |
V$QUEUEING_MTH |
Synonym for V_$QUEUEING_MTH |
V$RSRC_CONSUMER_GROUP |
Synonym for V_$RSRC_CONSUMER_GROUP |
V$RSRC_CONSUMER_GROUP_CPU_MTH |
Synonym for V_$RSRC_CONSUMER_GROUP_CPU_MTH |
V$RSRC_PLAN |
Synonym for V_$RSRC_PLAN |
V$RSRC_PLAN_CPU_MTH |
Synonym for V_$RSRC_PLAN_CPU_MTH |
V$SESSION |
Synonym for V_$SESSION |
V$SESSION_CONNECT_INFO |
Synonym for V_$SESSION_CONNECT_INFO |
V$SESSION_LONGOPS |
Synonym for V_$SESSION_LONGOPS |
V$SQLAREA |
Synonym for V_$SQLAREA |
V$SQLTEXT |
Synonym for V_$SQLTEXT |
V$SYSTEM_PARAMETER |
Synonym for V_$SYSTEM_PARAMETER |
V$TEMPORARY_LOBS |
Synonym for V_$TEMPORARY_LOBS |
V$TIMEZONE_NAMES |
Synonym for V_$TIMEZONE_NAMES |
V$VERSION |
Synonym for V_$VERSION |