Skip to main content

v$ Performance Views


DBA_2PC_NEIGHBORS



DBA_2PC_PENDING



DBA_ALL_TABLES



ALL_ALL_TABLES
USER_ALL_TABLES



DBA_ANALYZE_OBJECTS



DBA_APPLICATION_ROLES
USER_APPLICATION_ROLES


DBA_APPLY


DBA_APPLY_CONFLICT_COLUMNS
ALL_APPLY_CONFLICT_COLUMNS


DBA_APPLY_DML_HANDLERS ALL_APPLY_DML_HANDLERS


DBA_APPLY_ERROR ALL_APPLY_ERROR


DBA_APPLY_INSTANTIATED_OBJECTS


DBA_APPLY_KEY_COLUMNS ALL_APPLY_KEY_COLUMNS


DBA_APPLY_PARAMETERS ALL_APPLY_PARAMETERS



DBA_APPLY_PROGRESS ALL_APPLY_PROGRESS


DBA_AQ_AGENTS


DBA_AQ_AGENT_PRIVS USER_AQ_AGENT_PRIVS



ALL_ARGUMENTS


USER_ARGUMENTS



DBA_ASSOCIATIONS ALL_ASSOCIATIONS USER_ASSOCIATIONS



USER_ASTATUS_MAP


DBA_ATTRIBUTE_TRANSFORMATIONS USER_ATTRIBUTE_TRANSFORMATIONS


DBA_AUDIT_EXISTS



DBA_AUDIT_OBJECT USER_AUDIT_OBJECT



DBA_AUDIT_POLICIES ALL_AUDIT_POLICIES USER_AUDIT_POLICIES



DBA_AUDIT_SESSION USER_AUDIT_SESSION



DBA_AUDIT_STATEMENT USER_AUDIT_STATEMENT


DBA_AUDIT_TRAIL USER_AUDIT_TRAIL


DBA_AWS USER_AWS


DBA_AW_PS USER_AW_PS


b


DBA_BLOCKERS


c


DBA_CACHEABLE_NONTABLE_OBJECTS


DBA_CACHEABLE_OBJECTS


DBA_CACHEABLE_OBJECTS_BASE


DBA_CACHEABLE_TABLES


DBA_CACHEABLE_TABLES_BASE


DBA_CAPTURE ALL_CAPTURE


DBA_CAPTURE_PARAMETERS ALL_CAPTURE_PARAMETERS


DBA_CAPTURE_PREPARED_DATABASE ALL_CAPTURE_PREPARED_DATABASE


DBA_CAPTURE_PREPARED_SCHEMAS ALL_CAPTURE_PREPARED_SCHEMAS


DBA_CAPTURE_PREPARED_TABLES ALL_CAPTURE_PREPARED_TABLES



DBA_CARTRIDGES


DBA_CARTRIDGE_COMPONENTS



DBA_CATALOG ALL_CATALOG USER_CATALOG CATALOG


SYSCATALOG


SYSCATALOG_


DBA_CLUSTERS ALL_CLUSTERS USER_CLUSTERS


DBA_CLUSTER_HASH_EXPRESSIONS ALL_CLUSTER_HASH_EXPRESSIONS USER_CLUSTER_HASH_EXPRESSIONS


DBA_CLU_COLUMNS USER_CLU_COLUMNS


CODE_PIECES


CODE_SIZE


DBA_COLL_TYPES ALL_COLL_TYPES USER_COLL_TYPES


COL


DBA_COL_COMMENTS ALL_COL_COMMENTS USER_COL_COMMENTS


DBA_COL_PRIVS ALL_COL_PRIVS USER_COL_PRIVS COLUMN_PRIVILEGES


ALL_COL_PRIVS_MADE USER_COL_PRIVS_MADE


ALL_COL_PRIVS_RECD USER_COL_PRIVS_RECD


DBA_CONSTRAINTS ALL_CONSTRAINTS USER_CONSTRAINTS


DBA_CONS_COLUMNS ALL_CONS_COLUMNS USER_CONS_COLUMNS


DBA_CONS_OBJ_COLUMNS ALL_CONS_OBJ_COLUMNS USER_CONS_OBJ_COLUMNS


DBA_CONTEXT ALL_CONTEXT


d


DBA_DATA_FILES


DATABASE_COMPATIBLE_LEVEL


DBA_DB_LINKS ALL_DB_LINKS USER_DB_LINKS


DBA_DDL_LOCKS


DBA_DML_LOCKS


ALL_DEF_AUDIT_OPTS


DBA_DEPENDENCIES ALL_DEPENDENCIES USER_DEPENDENCIES


DICTIONARY


DICT_COLUMNS


DISK_AND_FIXED_OBJECTS


DBA_DIMENSIONS ALL_DIMENSIONS USER_DIMENSIONS


DBA_DIM_ATTRIBUTES ALL_DIM_ATTRIBUTES USER_DIM_ATTRIBUTES


DBA_DIM_CHILD_OF ALL_DIM_CHILD_OF USER_DIM_CHILD_OF


DBA_DIM_HIERARCHIES ALL_DIM_HIERARCHIES USER_DIM_HIERARCHIES



DBA_DIM_JOIN_KEY ALL_DIM_JOIN_KEY USER_DIM_JOIN_KEY


DBA_DIM_LEVELS ALL_DIM_LEVELS USER_DIM_LEVELS


DBA_DIM_LEVEL_KEY ALL_DIM_LEVEL_KEY USER_DIM_LEVEL_KEY


DBA_DIRECTORIES ALL_DIRECTORIES


DBA_DMT_FREE_SPACE


DBA_DMT_USED_EXTENTS


e


DBA_ERRORS ALL_ERRORS USER_ERRORS ERROR_SIZE


DBA_EVALUATION_CONTEXTS ALL_EVALUATION_CONTEXTS USER_EVALUATION_CONTEXTS



DBA_EVALUATION_CONTEXT_TABLES ALL_EVALUATION_CONTEXT_TABLES USER_EVALUATION_CONTEXT_TABLES


DBA_EVALUATION_CONTEXT_VARS ALL_EVALUATION_CONTEXT_VARS USER_EVALUATION_CONTEXT_VARS


DBA_EXP_FILES


DBA_EXP_OBJECTS


DBA_EXP_VERSION


DBA_EXTENTS USER_EXTENTS


DBA_EXTERNAL_LOCATIONS ALL_EXTERNAL_LOCATIONS USER_EXTERNAL_LOCATIONS


DBA_EXTERNAL_TABLES ALL_EXTERNAL_TABLES USER_EXTERNAL_TABLES



f


DBA_FGA_AUDIT_TRAIL


FILEXT$


SYSFILES


DBA_FREE_SPACE USER_FREE_SPACE


DBA_FREE_SPACE_COALESCED


DBA_FREE_SPACE_COALESCED_TMP1


DBA_FREE_SPACE_COALESCED_TMP2


DBA_FREE_SPACE_COALESCED_TMP3


g


DBA_GLOBAL_CONTEXT GLOBAL_NAME


i


DBA_IAS_CONSTRAINT_EXP


DBA_IAS_GEN_STMTS


DBA_IAS_GEN_STMTS_EXP


DBA_IAS_OBJECTS


DBA_IAS_OBJECTS_BASE


DBA_IAS_OBJECTS_EXP


DBA_IAS_POSTGEN_STMTS


DBA_IAS_PREGEN_STMTS


DBA_IAS_SITES


DBA_IAS_TEMPLATES



DBA_INDEXES ALL_INDEXES USER_INDEXES


INDEX_HISTOGRAM


INDEX_STATS


DBA_INDEXTYPES ALL_INDEXTYPES USER_INDEXTYPES


DBA_INDEXTYPE_COMMENTS ALL_INDEXTYPE_COMMENTS HYPERLINK


DBA_INDEXTYPE_OPERATORS ALL_INDEXTYPE_OPERATORS USER_INDEXTYPE_OPERATORS



DBA_IND_COLUMNS ALL_IND_COLUMNS USER_IND_COLUMNS


DBA_IND_EXPRESSIONS ALL_IND_EXPRESSIONS USER_IND_EXPRESSIONS


DBA_IND_PARTITIONS ALL_IND_PARTITIONS USER_IND_PARTITIONS


DBA_IND_SUBPARTITIONS ALL_IND_SUBPARTITIONS USER_IND_SUBPARTITIONS


DBA_INTERNAL_TRIGGERS ALL_INTERNAL_TRIGGERS USER_INTERNAL_TRIGGERS


j


DBA_JAVA_ARGUMENTS ALL_JAVA_ARGUMENTS USER_JAVA_ARGUMENTS



DBA_JAVA_CLASSES ALL_JAVA_CLASSES USER_JAVA_CLASSES


DBA_JAVA_DERIVATIONS ALL_JAVA_DERIVATIONS USER_JAVA_DERIVATIONS



DBA_JAVA_FIELDS ALL_JAVA_FIELDS USER_JAVA_FIELDS



DBA_JAVA_IMPLEMENTS ALL_JAVA_IMPLEMENTS USER_JAVA_IMPLEMENTS


DBA_JAVA_INNERS ALL_JAVA_INNERS USER_JAVA_INNERS



DBA_JAVA_LAYOUTS ALL_JAVA_LAYOUTS USER_JAVA_LAYOUTS



DBA_JAVA_METHODS ALL_JAVA_METHODS USER_JAVA_METHODS



DBA_JAVA_NCOMPS ALL_JAVA_NCOMPS USER_JAVA_NCOMPS


DBA_JAVA_POLICY USER_JAVA_POLICY


DBA_JAVA_RESOLVERS ALL_JAVA_RESOLVERS USER_JAVA_RESOLVERS


DBA_JAVA_THROWS  ALL_JAVA_THROWS USER_JAVA_THROWS



DBA_JOBS USER_JOBS


DBA_JOBS_RUNNING


DBA_JOIN_IND_COLUMNS ALL_JOIN_IND_COLUMNS USER_JOIN_IND_COLUMNS


l


DBA_LIBRARIES ALL_LIBRARIES USER_LIBRARIES


DBA_LMT_FREE_SPACE


DBA_LMT_USED_EXTENTS


DBA_LOBS ALL_LOBS USER_LOBS


DBA_LOB_PARTITIONS ALL_LOB_PARTITIONS USER_LOB_PARTITIONS


DBA_LOB_SUBPARTITIONS ALL_LOB_SUBPARTITIONS USER_LOB_SUBPARTITIONS



DBA_LOB_TEMPLATES ALL_LOB_TEMPLATES USER_LOB_TEMPLATES


DBA_LOCK


DBA_LOCK_INTERNAL


DBA_LOG_GROUPS ALL_LOG_GROUPS USER_LOG_GROUPS


DBA_LOG_GROUP_COLUMNS ALL_LOG_GROUP_COLUMNS USER_LOG_GROUP_COLUMNS


DBA_LOGSTDBY_EVENTS


DBA_LOGSTDBY_LOG


DBA_LOGSTDBY_NOT_UNIQUE


DBA_LOGSTDBY_PARAMETERS


DBA_LOGSTDBY_PROGRESS


DBA_LOGSTDBY_SKIP


DBA_LOGSTDBY_SKIP_TRANSACTION


DBA_LOGSTDBY_UNSUPPORTED


m


DBA_METHOD_PARAMS ALL_METHOD_PARAMS USER_METHOD_PARAMS


DBA_METHOD_RESULTS ALL_METHOD_RESULTS USER_METHOD_RESULTS


DBA_BASE_TABLE_MVIEWS ALL_BASE_TABLE_MVIEWS USER_BASE_TABLE_MVIEWS


DBA_MVIEWS ALL_MVIEWS USER_MVIEWS


DBA_MVIEW_AGGREGATES ALL_MVIEW_AGGREGATES USER_MVIEW_AGGREGATES


DBA_MVIEW_ANALYSIS ALL_MVIEW_ANALYSIS USER_MVIEW_ANALYSIS


DBA_MVIEW_DETAIL_RELATIONS ALL_MVIEW_DETAIL_RELATIONS USER_MVIEW_DETAIL_RELATIONS


DBA_MVIEW_JOINS ALL_MVIEW_JOINS USER_MVIEW_JOINS


DBA_MVIEW_KEYS ALL_MVIEW_KEYS USER_MVIEW_KEYS


DBA_MVIEW_LOGS  ALL_MVIEW_LOGS  USER_MVIEW_LOGS


DBA_MVIEW_LOG_FILTER_COLS



DBA_MVIEW_REFRESH_TIMES ALL_MVIEW_REFRESH_TIMES USER_MVIEW_REFRESH_TIMES


n


DBA_NESTED_TABLES ALL_NESTED_TABLES USER_NESTED_TABLES


NLS_DATABASE_PARAMETERS


NLS_INSTANCE_PARAMETERS


NLS_SESSION_PARAMETERS


o


DBA_OBJECTS ALL_OBJECTS USER_OBJECTS SYS_OBJECTS


DBA_OBJECT_SIZE USER_OBJECT_SIZE


DBA_OBJECT_TABLES ALL_OBJECT_TABLES USER_OBJECT_TABLES


DBA_OBJ_AUDIT_OPTS USER_OBJ_AUDIT_OPTS


DBA_OBJ_COLATTRS ALL_OBJ_COLATTRS USER_OBJ_COLATTRS


DBA_OPANCILLARY ALL_OPANCILLARY USER_OPANCILLARY


DBA_OPARGUMENTS ALL_OPARGUMENTS USER_OPARGUMENTS


DBA_OPBINDINGS ALL_OPBINDINGS USER_OPBINDINGS


DBA_OPERATORS ALL_OPERATORS USER_OPERATORS


DBA_OPERATOR_COMMENTS ALL_OPERATOR_COMMENTS USER_OPERATOR_COMMENTS



DBA_OUTLINES USER_OUTLINES


DBA_OUTLINE_HINTS USER_OUTLINE_HINTS


p


DBA_PARTIAL_DROP_TABS ALL_PARTIAL_DROP_TABS USER_PARTIAL_DROP_TABS


DBA_PART_COL_STATISTICS ALL_PART_COL_STATISTICS USER_PART_COL_STATISTICS


DBA_PART_HISTOGRAMS ALL_PART_HISTOGRAMS USER_PART_HISTOGRAMS


DBA_PART_INDEXES ALL_PART_INDEXES USER_PART_INDEXES


DBA_PART_KEY_COLUMNS ALL_PART_KEY_COLUMNS USER_PART_KEY_COLUMNS


DBA_PART_LOBS ALL_PART_LOBS USER_PART_LOBS


DBA_PART_TABLES ALL_PART_TABLES USER_PART_TABLES


USER_PASSWORD_LIMITS


DBA_PENDING_TRANSACTIONS



DBA_PENDING_CONV_TABLES ALL_PENDING_CONV_TABLES USER_PENDING_CONV_TABLES



DBA_POLICIES ALL_POLICIES USER_POLICIES



DBA_POLICY_CONTEXTS ALL_POLICY_CONTEXTS USER_POLICY_CONTEXTS


DBA_POLICY_GROUPS ALL_POLICY_GROUPS USER_POLICY_GROUPS


DBA_PRIV_AUDIT_OPTS


ALL_PROBE_OBJECTS


DBA_PROCEDURES ALL_PROCEDURES USER_PROCEDURES


PRODUCT_PRIVS



DBA_PROFILES


DBA_PROPAGATION ALL_PROPAGATION


DBA_PROXIES USER_PROXIES


DBA_PUBLISHED_COLUMNS ALL_PUBLISHED_COLUMNS USER_PUBLISHED_COLUMNS







q


DBA_QUEUES ALL_QUEUES USER_QUEUES


QUEUE_PRIVILEGES



DBA_QUEUE_PUBLISHERS ALL_QUEUE_PUBLISHERS USER_QUEUE_PUBLISHERS


DBA_QUEUE_SCHEDULES USER_QUEUE_SCHEDULES


DBA_QUEUE_TABLES ALL_QUEUE_TABLES USER_QUEUE_TABLES


r


DBA_RCHILD


DBA_RECYCLEBIN USER_RECYCLEBIN


DBA_REFRESH ALL_REFRESH USER_REFRESH


DBA_REFRESH_CHILDREN ALL_REFRESH_CHILDREN USER_REFRESH_CHILDREN


ALL_REFRESH_DEPENDENCIES


DBA_REFS ALL_REFS USER_REFS


DBA_REGISTERED_MVIEWS ALL_REGISTERED_MVIEWS USER_REGISTERED_MVIEWS



DBA_REGISTERED_MVIEW_GROUPS


DBA_REGISTERED_SNAPSHOTS ALL_REGISTERED_SNAPSHOTS USER_REGISTERED_SNAPSHOTS


DBA_REGISTERED_SNAPSHOT_GROUPS


DBA_REGISTRY USER_REGISTRY


ALL_REGISTRY_BANNERS


DBA_REGISTRY_HIERARCHY


DBA_REPAUDIT_ATTRIBUTE ALL_REPAUDIT_ATTRIBUTE USER_REPAUDIT_ATTRIBUTE


DBA_REPAUDIT_COLUMN ALL_REPAUDIT_COLUMN USER_REPAUDIT_COLUMN


DBA_REPCAT ALL_REPCAT USER_REPCAT


DBA_REPCAT_EXCEPTIONS


DBA_REPCAT_REFRESH_TEMPLATES ALL_REPCAT_REFRESH_TEMPLATES USER_REPCAT_REFRESH_TEMPLATES


DBA_REPCAT_TEMPLATE_OBJECTS ALL_REPCAT_TEMPLATE_OBJECTS USER_REPCAT_TEMPLATE_OBJECTS


DBA_REPCAT_TEMPLATE_PARMS ALL_REPCAT_TEMPLATE_PARMS USER_REPCAT_TEMPLATE_PARMS


DBA_REPCAT_TEMPLATE_SITES ALL_REPCAT_TEMPLATE_SITES USER_REPCAT_TEMPLATE_SITES


DBA_REPCAT_USER_AUTHORIZATIONS ALL_REPCAT_USER_AUTHORIZATIONS USER_REPCAT_USER_AUTHORIZATION


DBA_REPCAT_USER_PARM_VALUES ALL_REPCAT_USER_PARM_VALUES USER_REPCAT_USER_PARM_VALUES


DBA_REPCATLOG ALL_REPCATLOG USER_REPCATLOG


DBA_REPCOLUMN ALL_REPCOLUMN USER_REPCOLUMN


DBA_REPCOLUMN_GROUP ALL_REPCOLUMN_GROUP USER_REPCOLUMN_GROUP


DBA_REPCONFLICT ALL_REPCONFLICT USER_REPCONFLICT


DBA_REPDDL ALL_REPDDL USER_REPDDL


DBA_REPEXTENSIONS


DBA_REPFLAVORS ALL_REPFLAVORS USER_REPFLAVORS


DBA_REPFLAVOR_COLUMNS ALL_REPFLAVOR_COLUMNS USER_REPFLAVOR_COLUMNS


DBA_REPFLAVOR_OBJECTS ALL_REPFLAVOR_OBJECTS USER_REPFLAVOR_OBJECTS


DBA_REPGENERATED ALL_REPGENERATED USER_REPGENERATED


DBA_REPGENOBJECTS ALL_REPGENOBJECTS USER_REPGENOBJECTS


DBA_REPGROUP ALL_REPGROUP USER_REPGROUP


DBA_REPGROUPED_COLUMN ALL_REPGROUPED_COLUMN USER_REPGROUPED_COLUMN


DBA_REPGROUP_PRIVILEGES ALL_REPGROUP_PRIVILEGES USER_REPGROUP_PRIVILEGES


DBA_REPKEY_COLUMNS ALL_REPKEY_COLUMNS USER_REPKEY_COLUMNS


DBA_REPOBJECT ALL_REPOBJECT USER_REPOBJECT


DBA_REPPARAMETER_COLUMN ALL_REPPARAMETER_COLUMN USER_REPPARAMETER_COLUMN


DBA_REPPRIORITY ALL_REPPRIORITY USER_REPPRIORITY


DBA_REPPRIORITY_GROUP ALL_REPPRIORITY_GROUP USER_REPPRIORITY_GROUP


DBA_REPPROP ALL_REPPROP USER_REPPROP


DBA_REPRESOLUTION ALL_REPRESOLUTION USER_REPRESOLUTION


DBA_REPRESOLUTION_METHOD ALL_REPRESOLUTION_METHOD USER_REPRESOLUTION_METHOD


DBA_REPRESOLUTION_STATISTICS ALL_REPRESOLUTION_STATISTICS USER_REPRESOLUTION_STATISTICS


DBA_REPRESOL_STATS_CONTROL ALL_REPRESOL_STATS_CONTROL USER_REPRESOL_STATS_CONTROL


DBA_REPSCHEMA ALL_REPSCHEMA USER_REPSCHEMA


DBA_REPSITES ALL_REPSITES USER_REPSITES


DBA_REPSITES_NEW


USER_RESOURCE_LIMITS


RESOURCE_COST


DBA_RESUMABLE USER_RESUMABLE



DBA_RULES ALL_RULES USER_RULES


ALL_RULESETS



DBA_RULE_



ALL_RULE_SETS  USER_RULE_SETS 
 DBA_RULE_SET_RULES
 ALL_RULE_SET_RULES
 USER_RULE_SET_RULES





DBA_RGROUP


DBA_ROLES


DBA_ROLE_PRIVS USER_ROLE_PRIVS ROLE_ROLE_PRIVS


DBA_ROLLBACK_SEGS


DBA_RSRC_CONSUMER_GROUPS


DBA_RSRC_CONSUMER_GROUP_PRIVS USER_RSRC_CONSUMER_GROUP_PRIVS


DBA_RSRC_MANAGER_SYSTEM_PRIVS USER_RSRC_MANAGER_SYSTEM_PRIVS


DBA_RSRC_PLANS


DBA_RSRC_PLAN_DIRECTIVES


DBA_RULESETS USER_RULESETS


s


DBA_SECONDARY_OBJECTS ALL_SECONDARY_OBJECTS USER_SECONDARY_OBJECTS



DBA_SEGMENTS USER_SEGMENTS SYS_DBA_SEGS


SYS_USER_SEGS


DBA_SEQUENCES ALL_SEQUENCES USER_SEQUENCES


SESSION_ROLES


SESSION_PRIVS


SESSION_CONTEXT


DBA_SNAPSHOTS ALL_SNAPSHOTS USER_SNAPSHOTS


DBA_SNAPSHOT_LOGS ALL_SNAPSHOT_LOGS USER_SNAPSHOT_LOGS


DBA_SNAPSHOT_REFRESH_TIMES ALL_SNAPSHOT_REFRESH_TIMES USER_SNAPSHOT_REFRESH_TIMES



DBA_SOURCE ALL_SOURCE USER_SOURCE


DBA_SOURCE_TABLES ALL_SOURCE_TABLES USER_SOURCE_TABLES


DBA_SOURCE_TAB_COLUMNS ALL_SOURCE_TAB_COLUMNS USER_SOURCE_TAB_COLUMNS



DBA_SQLJ_TYPES ALL_SQLJ_TYPES USER_SQLJ_TYPES


DBA_SQLJ_TYPE_ATTRS ALL_SQLJ_TYPE_ATTRS USER_SQLJ_TYPE_ATTRS


DBA_SQLJ_TYPE_METHODS ALL_SQLJ_TYPE_METHODS USER_SQLJ_TYPE_METHODS


DBA_STMT_AUDIT_OPTS


DBA_STORED_SETTINGS ALL_STORED_SETTINGS USER_STORED_SETTINGS


DBA_STREAMS_GLOBAL_RULES ALL_STREAMS_GLOBAL_RULES


DBA_STREAMS_SCHEMA_RULES ALL_STREAMS_SCHEMA_RULES



DBA_STREAMS_TABLE_RULES ALL_STREAMS_TABLE_RULES


DBA_SUBPART_COL_STATISTICS ALL_SUBPART_COL_STATISTICS USER_SUBPART_COL_STATISTICS


DBA_SUBPART_HISTOGRAMS ALL_SUBPART_HISTOGRAMS USER_SUBPART_HISTOGRAMS


DBA_SUBPART_KEY_COLUMNS ALL_SUBPART_KEY_COLUMNS USER_SUBPART_KEY_COLUMNS


DBA_SUBPARTITION_TEMPLATES ALL_SUBPARTITION_TEMPLATES USER_SUBPARTITION_TEMPLATES


DBA_SUBSCRIBED_COLUMNS ALL_SUBSCRIBED_COLUMNS USER_SUBSCRIBED_COLUMNS


DBA_SUBSCRIBED_TABLES ALL_SUBSCRIBED_TABLES USER_SUBSCRIBED_TABLES


DBA_SUBSCRIPTIONS ALL_SUBSCRIPTIONS USER_SUBSCRIPTIONS


ALL_SUMDELTA



DBA_SUMMARIES ALL_SUMMARIES USER_SUMMARIES


DBA_SUMMARY_AGGREGATES ALL_SUMMARY_AGGREGATES USER_SUMMARY_AGGREGATES


DBA_SUMMARY_DETAIL_TABLES ALL_SUMMARY_DETAIL_TABLES USER_SUMMARY_DETAIL_TABLES


DBA_SUMMARY_JOINS ALL_SUMMARY_JOINS USER_SUMMARY_JOINS


DBA_SUMMARY_KEYS ALL_SUMMARY_KEYS USER_SUMMARY_KEYS


DBA_SYNONYMS ALL_SYNONYMS USER_SYNONYMS PUBLICSYN


DBA_SYS_PRIVS USER_SYS_PRIVS ROLE_SYS_PRIVS


t


DBA_ALL_TABLES ALL_ALL_TABLES USER_ALL_TABLES



DBA_TABLES ALL_TABLES USER_TABLES TAB


DBA_TABLESPACES USER_TABLESPACES


DBA_TAB_COLUMNS ALL_TAB_COLUMNS USER_TAB_COLUMNS


DBA_TAB_COLS ALL_TAB_COLS USER_TAB_COLS


DBA_TAB_COL_STATISTICS ALL_TAB_COL_STATISTICS USER_TAB_COL_STATISTICS


DBA_TAB_COMMENTS ALL_TAB_COMMENTS USER_TAB_COMMENTS


DBA_TAB_HISTOGRAMS ALL_TAB_HISTOGRAMS USER_TAB_HISTOGRAMS


DBA_TAB_MODIFICATIONS ALL_TAB_MODIFICATIONS USER_TAB_MODIFICATIONS


DBA_TAB_PARTITIONS ALL_TAB_PARTITIONS USER_TAB_PARTITIONS


DBA_TAB_PRIVS ALL_TAB_PRIVS USER_TAB_PRIVS TABLE_PRIVILEGES


ROLE_TAB_PRIVS


ALL_TAB_PRIVS_MADE USER_TAB_PRIVS_MADE


ALL_TAB_PRIVS_RECD USER_TAB_PRIVS_RECD


TABQUOTAS


DBA_TAB_SUBPARTITIONS ALL_TAB_SUBPARTITIONS USER_TAB_SUBPARTITIONS


DBA_TEMP_FILES


DBA_TEMPLATE_REFGROUPS


DBA_TEMPLATE_TARGETS


DBA_TRANSFORMATIONS USER_TRANSFORMATIONS


DBA_TRIGGERS ALL_TRIGGERS USER_TRIGGERS


DBA_TRIGGER_COLS ALL_TRIGGER_COLS USER_TRIGGER_COLS


DBA_TS_QUOTAS USER_TS_QUOTAS


DBA_TYPES ALL_TYPES USER_TYPES



DBA_TYPE_ATTRS ALL_TYPE_ATTRS USER_TYPE_ATTRS



DBA_TYPE_METHODS ALL_TYPE_METHODS USER_TYPE_METHODS



DBA_TYPE_VERSIONS ALL_TYPE_VERSIONS USER_TYPE_VERSIONS


u


DBA_UNDO_EXTENTS


DBA_UNUSED_COL_TABS ALL_UNUSED_COL_TABS USER_UNUSED_COL_TABS


DBA_UPDATABLE_COLUMNS ALL_UPDATABLE_COLUMNS USER_UPDATABLE_COLUMNS


DBA_USERS ALL_USERS USER_USERS USER_HISTORY$



DBA_USTATS ALL_USTATS USER_USTATS


v


DBA_VARRAYS ALL_VARRAYS USER_VARRAYS


PRODUCT_COMPONENT_VERSION



DBA_VIEWS ALL_VIEWS USER_VIEWS


w


DBA_WAITERS


DBA_WORKSPACES ALL_WORKSPACES USER_WORKSPACES


DBA_WORKSPACE_SESSIONS



x


DBA_XML_SCHEMAS ALL_XML_SCHEMAS USER_XML_SCHEMAS


DBA_XML_TABLES ALL_XML_TABLES USER_XML_TABLES


DBA_XML_TAB_COLS ALL_XML_TAB_COLS USER_XML_TAB_COLS


DBA_XML_VIEWS ALL_XML_VIEWS USER_XML_VIEWS



DBA_XML_VIEW_COLS ALL_XML_VIEW_COLS USER_XML_VIEW_COLS





















































Comments

Popular posts from this blog

Hard dependency with ip address Oracle RAC Cluster.

Command error out due to hard dependency with ip address [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource RDBMS_DB -n Node2 CRS-2527: Unable to start 'RDBMS_DB' because it has a 'hard' dependency on 'sDB' CRS-2525: All instances of the resource 'sDB' are already running; relocate is not allowed because the force option was not specified CRS-4000: Command Relocate failed, or completed with errors. [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource sDB  -n Node2 CRS-2529: Unable to act on 'DB' because that would require stopping or relocating 'LISTENER_DB', but the force option was not specified CRS-4000: Command Relocate failed, or completed with errors. [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource LISTENER_DB  -n Node2 CRS-2527: Unable to start 'LISTENER_DB' because it has a 'hard' dependency on 'sD...

19C NID ( Rename Database)

 [oracle@localhost ~]$ nid DBNEWID: Release 19.0.0.0.0 - Production on Thu Dec 23 00:05:36 2021 Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved. Keyword     Description                    (Default) ---------------------------------------------------- TARGET      Username/Password              (NONE) DBNAME      New database name              (NONE) LOGFILE     Output Log                     (NONE) REVERT      Revert failed change           NO SETNAME     Set a new database name only   NO APPEND      Append to output log           NO HELP        Displays these messages    ...

ORA-01017/ORA-28000 with AUDIT_TRAIL

With default profile in Oracle 11g, accounts are automatically locked 1 day ( PASSWORD_LOCK_TIME ) after 10 failed login attempt ( FAILED_LOGIN_ATTEMPTS ): SQL > SET lines 200 SQL > SET pages 200 SQL > SELECT * FROM dba_profiles WHERE PROFILE = 'DEFAULT' ORDER BY resource_name; PROFILE                         RESOURCE_NAME                      RESOURCE LIMIT ------------------------------ -------------------------------- -------- ---------------------------------------- DEFAULT                         COMPOSITE_LIMIT                 ...