您好,登录后才能下订单哦!
TABLE_NAME COMMENTS
DBA_CONS_COLUMNS Information about accessible columns in constraint definitions
DBA_LOG_GROUP_COLUMNS Information about columns in log group definitions
DBA_LOBS Description of LOBs contained in all tables
DBA_CATALOG All database Tables, Views, Synonyms, Sequences
DBA_CLUSTERS Description of all clusters in the database
DBA_CLU_COLUMNS Mapping of table columns to cluster columns
DBA_COL_COMMENTS Comments on columns of all tables and views
DBA_COL_PRIVS All grants on columns in the database
DBA_ENCRYPTED_COLUMNS Encryption information on columns in the database
DBA_INDEXES Description for all indexes in the database
DBA_IND_COLUMNS COLUMNs comprising INDEXes on all TABLEs and CLUSTERs
DBA_IND_EXPRESSIONS FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLUSTERS
DBA_JOIN_IND_COLUMNS Join Index columns comprising the join conditions
DBA_OBJECTS All objects in the database
DBA_OBJECTS_AE All objects in the database
DBA_ROLLBACK_SEGS Description of rollback segments
DBA_ROLE_PRIVS Roles granted to users and roles
DBA_SEQUENCES Description of all SEQUENCEs in the database
DBA_SYNONYMS All synonyms in the database
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
DBA_TAB_COLS Columns of user's tables, views and clusters
DBA_TAB_COLUMNS Columns of user's tables, views and clusters
DBA_TAB_COMMENTS Comments on all tables and views in the database
DBA_TAB_PRIVS All grants on objects in the database
DBA_VIEWS Description of all views in the database
DBA_VIEWS_AE Description of all views in the database
DBA_CONSTRAINTS Constraint definitions on all tables
DBA_LOG_GROUPS Log group definitions on all tables
DBA_CLUSTER_HASH_EXPRESSIONS Hash functions for all clusters
DBA_UPDATABLE_COLUMNS Description of dba updatable columns
DBA_UNUSED_COL_TABS All tables with unused columns in the database
DBA_PARTIAL_DROP_TABS All tables with partially dropped columns in the database
DBA_RESUMABLE Resumable session information in the system
DBA_EDITIONING_VIEWS Description of all Editioning Views in the database
DBA_EDITIONING_VIEWS_AE Description of all Editioning Views in the database
DBA_EDITIONING_VIEW_COLS Relationship between columns of all Editioning Views in the database and the table columns to which they map
DBA_EDITIONING_VIEW_COLS_AE Relationship between columns of all Editioning Views in the database and the table columns to which they map
DBA_EDITIONS Describes all editions in the database
DBA_EDITION_COMMENTS Describes comments on all editions in the database
DBA_LIBRARIES Description of all libraries in the database
DBA_PROCEDURES Description of the dba functions/procedures/packages/types/triggers
DBA_STORED_SETTINGS Parameter settings for all objects
DBA_PLSQL_OBJECT_SETTINGS Compiler settings of all objects in the database
DBA_ARGUMENTS All arguments for objects in the database
DBA_ASSEMBLIES Description of all assemblies in the database
DBA_IDENTIFIERS Identifiers in stored objects accessible to sys
DBA_DB_LINKS All database links in the database
DBA_RECYCLEBIN Description of the Recyclebin view accessible to the user
DBA_2PC_PENDING info about distributed transactions awaiting recovery
DBA_2PC_NEIGHBORS information about incoming and outgoing connections for pending transactions
DBA_PROFILES Display all profiles and their limits
DBA_USERS Information about all users of the database
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
DBA_AUDIT_SESSION All audit trail records concerning CONNECT and DISCONNECT
DBA_AUDIT_STATEMENT Audit trail records concerning grant, revoke, audit, noaudit and alter system
DBA_AUDIT_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
DBA_ROLES All Roles which exist in the database
DBA_SYS_PRIVS System privileges granted to users and roles
DBA_PROXIES Information about all proxy connections
DBA_CONNECT_ROLE_GRANTEES Information regarding which users are granted CONNECT
DBA_TYPES Description of all types in the database
DBA_COLL_TYPES Description of all named collection types in the database
DBA_TYPE_ATTRS Description of attributes of all types in the database
DBA_TYPE_METHODS Description of methods of all types in the database
DBA_METHOD_PARAMS Description of method parameters of all types in the database
DBA_METHOD_RESULTS Description of method results of all types in the database
DBA_SQLJ_TYPES Description of all types in the database
DBA_TYPE_VERSIONS Description of each type version in the database
DBA_PENDING_CONV_TABLES All tables which are not upgraded to the latest type version in the database
DBA_SQLJ_TYPE_ATTRS Description of attributes of all types in the database
DBA_SQLJ_TYPE_METHODS Description of methods of all types in the database
DBA_OLDIMAGE_COLUMNS Gives all object tables and columns in old (8.0) p_w_picpath format
DBA_NESTED_TABLE_COLS Columns of nested tables
DBA_DIRECTORIES Description of all directories
DBA_REFS Description of REF columns contained in all tables
DBA_NESTED_TABLES Description of nested tables contained in all tables
DBA_VARRAYS Description of varrays in tables accessible to the user
DBA_OBJ_COLATTRS Description of object columns and attributes contained in all tables in the database
DBA_CONS_OBJ_COLUMNS List of types an object column or attribute is constrained to in all tables in the database
DBA_OPERATORS All operators
DBA_OPBINDINGS All operator binding functiosn or methods
DBA_OPANCILLARY All ancillary operators
DBA_OPARGUMENTS All operator arguments
DBA_OPERATOR_COMMENTS Comments for user-defined operators
DBA_INDEXTYPES All indextypes
DBA_INDEXTYPE_COMMENTS Comments for user-defined indextypes
DBA_INDEXTYPE_ARRAYTYPES All array types specified by the indextype
DBA_INDEXTYPE_OPERATORS All indextype operators
DBA_SECONDARY_OBJECTS All secondary objects for domain indexes
DBA_SOURCE_TABLES Source tables available for Change Data Capture
DBA_PUBLISHED_COLUMNS Source columns available for Change Data Capture
DBA_SUBSCRIPTIONS Change Data Capture subscriptions
DBA_SUBSCRIBED_TABLES Change Data Capture subscribed tables
DBA_SUBSCRIBED_COLUMNS Change Data Capture subscribed columns
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
DBA_EXTERNAL_TABLES Description of the external tables accessible to the DBA
DBA_EXTERNAL_LOCATIONS Description of the external tables locations accessible to the DBA
DBA_MINING_MODELS Description of all the models in the database
DBA_MINING_MODEL_ATTRIBUTES Description of all the model attributes in the database
DBA_MINING_MODEL_SETTINGS Description of all the model settings in the database
DBA_MINING_MODEL_TABLES Description of all the mining model tables in the system
DBA_TAB_COL_STATISTICS Columns of user's tables, views and clusters
DBA_TAB_HISTOGRAMS Histograms on columns of all tables
DBA_ASSOCIATIONS All associations
DBA_USTATS All statistics collected on either tables or indexes
DBA_TAB_MODIFICATIONS Information regarding modifications to tables
DBA_OPTSTAT_OPERATIONS History of statistics operations performed
DBA_TAB_STATS_HISTORY History of table statistics modifications
DBA_TAB_STAT_PREFS Statistics preferences for tables
DBA_TAB_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
DBA_IND_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
DBA_COL_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
DBA_TAB_HISTGRM_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
DBA_DIMENSIONS Description of the dimension objects accessible to the DBA
DBA_DIM_LEVELS Description of dimension levels visible to DBA
DBA_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
DBA_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
DBA_DIM_JOIN_KEY Representation of a join between two dimension tables.
DBA_SUMMARIES Description of the summaries accessible to dba
DBA_MVIEW_ANALYSIS Description of the materialized views accessible to dba
DBA_MVIEW_AGGREGATES Description of the materialized view aggregates accessible to dba
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
DBA_MVIEW_JOINS Description of a join between two columns in the
WHERE clause of a materialized view accessible to dba
DBA_MVIEW_COMMENTS Comments on all materialized views in the database
DBA_REWRITE_EQUIVALENCES Description of rewrite equivalence accessible to DBA
DBA_MVIEW_DETAIL_PARTITION Freshness information of all PCT materialized views in the database
DBA_MVIEW_DETAIL_SUBPARTITION Freshness information of all PCT materialized views in the database
DBA_TSTZ_TAB_COLS Columns of all tables in the database, which have column(s) defined on timestamp with time zone data type or ADT type containing attribute(s) of timestamp with time zone data type
DBA_TSTZ_TABLES Description of all tables in the database, which have column(s) defined on timestamp with time zone data type or ADT type containing attribute(s) of timestamp with time zone data type
DBA_ERRORS Current errors on all stored objects in the database
DBA_ERRORS_AE Current errors on all stored objects in the database
DBA_SOURCE_AE Source of all stored objects in the database
DBA_SOURCE Source of all stored objects in the database
DBA_TRIGGERS All triggers in the database
DBA_INTERNAL_TRIGGERS Description of the internal triggers on all tables in the database
DBA_TRIGGER_COLS Column usage in all triggers
DBA_DEPENDENCIES Dependencies to and from objects
DBA_OBJECT_SIZE Sizes, in bytes, of various pl/sql objects
DBA_TRIGGER_ORDERING All triggers having FOLLOWS or PRECEDES ordering in the database
DBA_JOBS_RUNNING All jobs in the database which are currently running, join v$lock and job$
DBA_JOBS All jobs in the database
DBA_SEGMENTS Storage allocated for all database segments
DBA_SEGMENTS_OLD Storage allocated for all database segments
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
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
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
DBA_TS_QUOTAS Tablespace quotas for all users
DBA_TEMP_FREE_SPACE Summary of temporary space usage
DBA_CONTEXT Description of all context namespace information
DBA_GLOBAL_CONTEXT Description of all context information accessible globally
DBA_RULE_SETS Rule sets in the database
DBA_RULESETS Rulesets in the database: maintained for backward compatibility
DBA_RULES Rules in the databse
DBA_RULE_SET_RULES Rules in all rule sets in the database
DBA_EVALUATION_CONTEXTS rule evaluation contexts in the database
DBA_EVALUATION_CONTEXT_TABLES tables in all rule evaluation contexts in the database
DBA_EVALUATION_CONTEXT_VARS variables in all rule evaluation contexts in the database
DBA_SNAPSHOTS All snapshots in the database
DBA_SNAPSHOT_LOGS All snapshot logs in the database
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
DBA_REFRESH_CHILDREN All the objects in refresh groups
DBA_REGISTERED_SNAPSHOTS Remote snapshots of local tables
DBA_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
DBA_MVIEW_LOGS All materialized view logs in the database
DBA_BASE_TABLE_MVIEWS All materialized views with log(s) in the database
DBA_REGISTERED_MVIEWS Remote materialized views of local tables
DBA_MVIEW_LOG_FILTER_COLS All filter columns (excluding PK cols) being logged in the materialized view logs
DBA_POLICIES All row level security policies in the database
DBA_POLICY_GROUPS All policy groups defined for any synonym, table, view in the database
DBA_POLICY_CONTEXTS All policy driving context defined for any synonym, table, or view in the database
DBA_SEC_RELEVANT_COLS Security Relevant columns of all VPD policies in the database
DBA_AUDIT_POLICIES Fine grained auditing policies in the database
DBA_AUDIT_POLICY_COLUMNS All 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_AUDIT_MGMT_CONFIG_PARAMS The view displays the currently configured audit trail properties that are defined by the DBMS_AUDIT_MGMT PL/SQL package
DBA_AUDIT_MGMT_LAST_ARCH_TS The Last Archive Timestamps set for the Audit Trail Clean up
DBA_AUDIT_MGMT_CLEANUP_JOBS The view displays the currently configured audit trail purge jobs
DBA_AUDIT_MGMT_CLEAN_EVENTS The history of cleanup events
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
DBA_CQ_NOTIFICATION_QUERIES Description of registered queries for CQ notification
DBA_CPOOL_INFO Connection pool info
DBA_SSCR_CAPTURE Session state capture statistics
DBA_SSCR_RESTORE Session state restore statistics
DBA_SUBSCR_REGISTRATIONS All subscription registrations created in the database
DBA_QUEUE_TABLES All queue tables created in the database
DBA_QUEUES All database queues
DBA_RESOURCE_INCARNATIONS Resource incarnations that are running or eligible for HA status notification
DBA_RSRC_PLANS All the resource plans
DBA_RSRC_CONSUMER_GROUPS all the resource consumer groups
DBA_RSRC_CATEGORIES All resource consumer group categories
DBA_RSRC_PLAN_DIRECTIVES all the resource plan directives
DBA_RSRC_CONSUMER_GROUP_PRIVS Switch privileges for consumer groups
DBA_RSRC_MANAGER_SYSTEM_PRIVS system privileges for the resource manager
DBA_RSRC_GROUP_MAPPINGS all the consumer group mappings
DBA_RSRC_MAPPING_PRIORITY the consumer group mapping attribute priorities
DBA_RSRC_STORAGE_POOL_MAPPING resource manager rules for mapping files to storage pools
DBA_RSRC_CAPABILITY settings for database resources that are capable of being managed by the
Resource Manager
DBA_RSRC_INSTANCE_CAPABILITY per-instance settings for database resources that are capable of being
managed by the Resource Manager
DBA_RSRC_IO_CALIBRATE Results of the most recent I/O calibration
DBA_OUTLINES Stored outlines
DBA_OUTLINE_HINTS Hints stored in outlines
DBA_DATAPUMP_JOBS Datapump jobs
DBA_DATAPUMP_SESSIONS Datapump sessions attached to a job
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_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_COLORED_SQL Marked SQLs for snapshots
DBA_HIST_BASELINE_METADATA Baseline Metadata Information
DBA_HIST_BASELINE_TEMPLATE Baseline Template 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_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_EVENT_HISTOGRAM Event Histogram Historical Statistics Information
DBA_HIST_MUTEX_SLEEP Mutex Sleep 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_MEMORY_TARGET_ADVICE Memory Target Advice History
DBA_HIST_MEMORY_RESIZE_OPS Memory Resize Operations 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_PLAN_OPERATION_NAME Optimizer Explain Plan Operation Names
DBA_HIST_PLAN_OPTION_NAME Optimizer Explain Plan Option Names
DBA_HIST_SQLCOMMAND_NAME Sql command types
DBA_HIST_TOPLEVELCALL_NAME Oracle top level call type
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_HIST_PERSISTENT_QUEUES STREAMS AQ Persistent Queues Historical Statistics Information
DBA_HIST_PERSISTENT_SUBS STREAMS AQ Persistent Queue Subscribers Historical Statistics Information
DBA_HIST_IOSTAT_FUNCTION Historical I/O statistics by function
DBA_HIST_IOSTAT_FUNCTION_NAME Function names for historical I/O statistics
DBA_HIST_IOSTAT_FILETYPE Historical I/O statistics by file type
DBA_HIST_IOSTAT_FILETYPE_NAME File type names for historical I/O statistics
DBA_HIST_IOSTAT_DETAIL Historical I/O statistics by function and filetype
DBA_HIST_RSRC_CONSUMER_GROUP Historical resource consumer group statistics
DBA_HIST_RSRC_PLAN Historical resource plan statistics
DBA_HIST_CLUSTER_INTERCON Cluster Interconnect Historical Stats
DBA_HIST_MEM_DYNAMIC_COMP Historical memory component sizes
DBA_HIST_IC_CLIENT_STATS Historical interconnect client statistics
DBA_HIST_IC_DEVICE_STATS Historical interconnect device statistics
DBA_HIST_INTERCONNECT_PINGS Instance to instance ping stats
DBA_HIST_DISPATCHER Dispatcher statistics
DBA_HIST_SHARED_SERVER_SUMMARY Shared Server summary statistics
DBA_HIST_DYN_REMASTER_STATS Dynamic remastering statistics
DBA_SQL_PROFILES set of sql profiles
DBA_SQL_PLAN_BASELINES set of plan baselines
DBA_SQL_PATCHES set of sql patches
DBA_REGISTERED_SNAPSHOT_GROUPS Snapshot repgroup registration information
DBA_REGISTERED_MVIEW_GROUPS Materialized view repgroup registration information
DBA_REPGROUP_PRIVILEGES Information about users who are registered for object group privileges
DBA_REPGROUP Information about all replicated object groups
DBA_REPSITES N-way replication information
DBA_REPSCHEMA N-way replication information
DBA_REPOBJECT Information about replicated objects
DBA_REPCOLUMN Replicated top-level columns (table) sorted alphabetically in ascending order
DBA_REPPROP Propagation information about replicated objects
DBA_REPKEY_COLUMNS Primary columns for a table using column-level replication
DBA_REPGENOBJECTS Objects generated to support replication
DBA_REPGENERATED Objects generated to support replication
DBA_REPCATLOG Information about asynchronous administration requests
DBA_REPDDL Arguments that do not fit in a single repcat log record
DBA_REPPRIORITY_GROUP Information about all priority groups in the database
DBA_REPPRIORITY Values and their corresponding priorities in all priority groups in the database
DBA_REPCOLUMN_GROUP All column groups of replicated tables in the database
DBA_REPGROUPED_COLUMN Columns in the all column groups of replicated tables in the database
DBA_REPCONFLICT All conflicts for which users have specified resolutions in the database
DBA_REPRESOLUTION_METHOD All conflict resolution methods in the database
DBA_REPRESOLUTION Description of all conflict resolutions in the database
DBA_REPRESOLUTION_STATISTICS Statistics for conflict resolutions for all replicated tables in the database
DBA_REPRESOL_STATS_CONTROL Information about statistics collection for conflict resolutions for all replicated tables in the database
DBA_REPPARAMETER_COLUMN All columns used for resolving conflicts in the database
DBA_REPAUDIT_ATTRIBUTE Information about attributes automatically maintained for replication
DBA_REPAUDIT_COLUMN Information about columns in all shadow tables for all replicated tables in the database
DBA_REPFLAVORS Flavors defined for replicated object groups
DBA_REPFLAVOR_OBJECTS Replicated objects in flavors
DBA_REPFLAVOR_COLUMNS Replicated columns 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_USERS_WITH_DEFPWD Users that are still using their default passwords
DBA_WARNING_SETTINGS warning settings for all objects
DBA_STAT_EXTENSIONS Optimizer statistics extensions
DBA_TAB_STATISTICS Optimizer statistics for all tables in the database
DBA_IND_STATISTICS Optimizer statistics for all indexes in the database
DBA_PENDING_TRANSACTIONS information about unresolved global transactions
DBA_AWS Analytic Workspaces in the database
DBA_AW_PS Pagespaces in Analytic Workspaces owned by the user
DBA_CUBES OLAP Cubes in the database
DBA_CUBE_DIMENSIONALITY OLAP Cube Dimensionality in the database
DBA_CUBE_MEASURES OLAP Measures in the database
DBA_CUBE_DIMENSIONS OLAP Cube Dimensions in the database
DBA_CUBE_HIERARCHIES OLAP Hierarchies in the database
DBA_CUBE_HIER_LEVELS OLAP Hierarchy Levels in the database
DBA_CUBE_DIM_LEVELS OLAP Dimension Levels in the database
DBA_CUBE_ATTRIBUTES OLAP Attributes in the database
DBA_CUBE_ATTR_VISIBILITY OLAP Attributes visible for Dimensions, Hierarchies, and Levels
DBA_CUBE_DIM_MODELS OLAP Dimension Models in the database
DBA_CUBE_CALCULATED_MEMBERS OLAP Calculated Members in the database
DBA_CUBE_VIEWS OLAP Cube Views in the database
DBA_CUBE_VIEW_COLUMNS OLAP Cube View Columns in the database
DBA_CUBE_DIM_VIEWS OLAP Dimension Views in the database
DBA_CUBE_DIM_VIEW_COLUMNS OLAP Dimesion View Columns in the database
DBA_CUBE_HIER_VIEWS OLAP Hierarchy Views in the database
DBA_CUBE_HIER_VIEW_COLUMNS OLAP Hierarchy View Columns in the database
DBA_MEASURE_FOLDERS OLAP Measure Folders in the database
DBA_MEASURE_FOLDER_CONTENTS OLAP Measure Folder Contents in the database
DBA_CUBE_BUILD_PROCESSES OLAP Build Processes in the database
DBA_QUEUE_SUBSCRIBERS queue subscribers in the database
DBA_SCHEDULER_PROGRAMS All scheduler programs in the database
DBA_SCHEDULER_DESTS All possible destination objects for jobs in the database
DBA_SCHEDULER_EXTERNAL_DESTS All destination objects in the database pointing to remote agents
DBA_SCHEDULER_DB_DESTS All destination objects in the database pointing to remote databases
DBA_SCHEDULER_JOB_DESTS State of all jobs at each of their destinations
DBA_SCHEDULER_JOBS All scheduler jobs in the database
DBA_SCHEDULER_JOB_ROLES All scheduler jobs in the database by database role
DBA_SCHEDULER_JOB_CLASSES All scheduler classes in the database
DBA_SCHEDULER_WINDOWS All scheduler windows in the database
DBA_SCHEDULER_PROGRAM_ARGS All arguments of all scheduler programs in the database
DBA_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
DBA_SCHEDULER_WINDOW_LOG Logged information for all scheduler windows
DBA_SCHEDULER_WINDOW_DETAILS The details of a window
DBA_SCHEDULER_WINDOW_GROUPS All scheduler window groups in the database
DBA_SCHEDULER_WINGROUP_MEMBERS Members of all scheduler window groups in the database
DBA_SCHEDULER_GROUP_MEMBERS Members of all scheduler object groups in the database
DBA_SCHEDULER_GROUPS All scheduler object groups in the database
DBA_SCHEDULER_SCHEDULES All schedules in the database
DBA_SCHEDULER_REMOTE_DATABASES List of registered remote databases for jobs
DBA_SCHEDULER_REMOTE_JOBSTATE Remote state of all jobs originating from this database
DBA_SCHEDULER_GLOBAL_ATTRIBUTE All scheduler global attributes
DBA_SCHEDULER_CHAINS All scheduler chains in the database
DBA_SCHEDULER_CHAIN_RULES All rules from scheduler chains in the database
DBA_SCHEDULER_CHAIN_STEPS All steps of scheduler chains in the database
DBA_SCHEDULER_RUNNING_CHAINS All steps of all running chains in the database
DBA_SCHEDULER_CREDENTIALS All scheduler credentials in the database
DBA_SCHEDULER_FILE_WATCHERS All scheduler file watch requests in the database
DBA_SCHEDULER_NOTIFICATIONS All job e-mail notifications in the database
DBA_EXPORT_OBJECTS Export INCLUDE and EXCLUDE object type names
DBA_LOGSTDBY_UNSUPPORTED_TABLE List of all the data tables that are not supported by Logical Standby
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_LOGSTDBY_EDS_TABLES List of all tables that have EDS-based replication for Logical Standby
DBA_LOGSTDBY_EDS_SUPPORTED List of all tables that could have EDS-based replication for Logical Standby
DBA_OUTSTANDING_ALERTS Description of all outstanding alerts
DBA_ALERT_HISTORY Description on alert history
DBA_THRESHOLDS Desription of all thresholds
DBA_TABLESPACE_THRESHOLDS Space Utilization Threshold settings for all tablespaces
DBA_AUTOTASK_OPERATION Automated Maintenance Task Operation Configuration
DBA_AUTOTASK_TASK Information about current and past autmated maintenance tasks
DBA_AUTOTASK_SCHEDULE Schedule of Maintenance Windows for the next 32 days
DBA_AUTOTASK_CLIENT_JOB Current automated maintenance jobs
DBA_AUTOTASK_WINDOW_CLIENTS Description of per-mainteance window activity
DBA_AUTOTASK_WINDOW_HISTORY Automated Maintenance view of window history
DBA_AUTOTASK_CLIENT_HISTORY Automated Maintenance Jobs history
DBA_AUTOTASK_JOB_HISTORY Automated Maintenance Jobs history
DBA_AUTOTASK_CLIENT Autotask Client Summary Information
DBA_HIST_BASELINE Baseline Metadata Information
DBA_HIST_BASELINE_DETAILS Baseline Stats on per Instance Level
DBA_HIST_SQLBIND SQL Bind Information
DBA_TUNE_MVIEW Catalog View to show the result after executing TUNE_MVIEW() API
DBA_FLASHBACK_ARCHIVE Description of the flashback archives available in the system
DBA_FLASHBACK_ARCHIVE_TS Description of tablespaces in the flashback archives available in the system
DBA_FLASHBACK_ARCHIVE_TABLES Information about the tables that are enabled for Flashback Archive
DBA_CAPTURE Details about the capture process
DBA_STREAMS_SPLIT_MERGE view of details of split/merge jobs/status about streams
DBA_STREAMS_SPLIT_MERGE_HIST history view of details of split/merge jobs/status about streams
DBA_CAPTURE_PARAMETERS All parameters for capture process
DBA_CAPTURE_PREPARED_DATABASE Is the local database prepared for instantiation?
DBA_CAPTURE_PREPARED_SCHEMAS All schemas at the local database that are prepared for instantiation
DBA_CAPTURE_PREPARED_TABLES All tables prepared for instantiation
DBA_SYNC_CAPTURE_PREPARED_TABS All tables prepared for synchronous capture instantiation
DBA_CAPTURE_EXTRA_ATTRIBUTES Extra attributes for a capture process
DBA_REGISTERED_ARCHIVED_LOG Details about the registered log files
DBA_SYNC_CAPTURE Details about the sync capture process
DBA_APPLY Details about the apply process
DBA_APPLY_PARAMETERS All parameters for apply process
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
DBA_APPLY_CONFLICT_COLUMNS Details about conflict resolution
DBA_APPLY_TABLE_COLUMNS Details about the destination table columns
DBA_APPLY_DML_HANDLERS Details about the dml handler
DBA_APPLY_PROGRESS Information about the progress made by apply process
DBA_APPLY_ERROR Error transactions
DBA_APPLY_ENQUEUE Details about the apply enqueue action
DBA_APPLY_EXECUTE Details about the apply execute action
DBA_APPLY_SPILL_TXN Streams apply spilled transactions info
DBA_XSTREAM_OUTBOUND Details about the XStream outbound server
DBA_XSTREAM_INBOUND Details about the XStream inbound server
DBA_APPLY_CHANGE_HANDLERS Details about apply change handler
DBA_PROPAGATION Streams propagation in the database
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
DBA_STREAMS_TP_DATABASE DBA Streams Database
DBA_STREAMS_TP_COMPONENT DBA Streams Component
DBA_STREAMS_TP_COMPONENT_LINK DBA Streams Component Link (Streams Topology Links)
DBA_STREAMS_TP_COMPONENT_STAT DBA Streams Component Statistics
DBA_STREAMS_TP_PATH_STAT DBA Streams Path Statistics
DBA_STREAMS_TP_PATH_BOTTLENECK DBA Streams Path Bottleneck
DBA_STREAMS_MESSAGE_CONSUMERS Streams messaging consumers
DBA_STREAMS_GLOBAL_RULES Global rules created by streams administrative APIs
DBA_STREAMS_SCHEMA_RULES Schema rules created by streams administrative APIs
DBA_STREAMS_TABLE_RULES Table rules created by streams administrative APIs
DBA_STREAMS_MESSAGE_RULES Rules for Streams messaging
DBA_STREAMS_RULES Rules used by Streams processes
DBA_SYNC_CAPTURE_TABLES All tables that are captured by synchronous streams captures.
DBA_XSTREAM_RULES Details about the XStream server rules
DBA_STREAMS_TRANSFORM_FUNCTION Rules-based transform functions used by Streams
DBA_STREAMS_ADMINISTRATOR Users granted the privileges to be a streams administrator
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_KEEP_COLUMNS Keep columns 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_HIST Details about executed or purged 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_COMPARISON Details about the comparison object
DBA_COMPARISON_COLUMNS Details about the comparison object's columns
DBA_COMPARISON_SCAN Details about a comparison scan
DBA_COMPARISON_SCAN_SUMMARY Details about a comparison scan
DBA_COMPARISON_SCAN_VALUES Details about a comparison scan's values
DBA_COMPARISON_ROW_DIF Details about the differing rows in a comparison scan
DBA_STREAMS_COLUMNS Supportability info about streams columns
DBA_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 capture
DBA_JAVA_POLICY java security Permissions for all users
DBA_JAVA_CLASSES class level information of all stored java classes
DBA_JAVA_LAYOUTS class layout information about stored java class
DBA_JAVA_IMPLEMENTS interfaces implemented by the stored java class
DBA_JAVA_INNERS list of inner classes refered by the stored java class
DBA_JAVA_FIELDS field information of all stored java class
DBA_JAVA_METHODS method information of all stored java class
DBA_JAVA_ARGUMENTS argument information of all stored java class
DBA_JAVA_THROWS list of exceptions thrown from a method of a class owned by user
DBA_JAVA_DERIVATIONS this view maps java source objects and their derived java class objects and java resource objects for all java classes
DBA_JAVA_RESOLVERS resolver of java class owned by user
DBA_JAVA_COMPILER_OPTIONS all native-compiler options
DBA_EPG_DAD_AUTHORIZATION DADs authorized to use different user's privileges
DBA_XML_TABLES Description of all XML tables in the database
DBA_XML_TAB_COLS Description of all XML tables in the database
DBA_XML_VIEWS Description of all XML views in the database
DBA_XML_VIEW_COLS Description of all XML views in the database
DBA_XML_SCHEMAS Description of all the XML Schemas registered
DBA_XML_INDEXES Description of all XML indexes in the database
DBA_NETWORK_ACL_PRIVILEGES Privileges defined in network access control lists
DBA_WALLET_ACLS Access control lists assigned to restrict access to wallets through PL/SQL network utility packages
DBA_XDS_OBJECTS All XDS enabled objects in the database
DBA_NETWORK_ACLS Access control lists assigned to restrict access to network hosts through PL/SQL network utility packages
DBA_XDS_INSTANCE_SETS All instance sets in the database
DBA_XDS_ATTRIBUTE_SECS All XDS column security defined in the database
DBA_AW_PROP Object properties in Analytic Workspaces in the database
DBA_AW_OBJ Objects in Analytic Workspaces in the database
DBA_TRANSFORMATIONS
DBA_ADVISOR_PARAMETERS
DBA_PARALLEL_EXECUTE_TASKS
DBA_ADVISOR_RATIONALE
DBA_ADVISOR_ACTIONS
DBA_QUEUE_PUBLISHERS
DBA_SQLSET_BINDS
DBA_ADDM_FINDINGS
DBA_PARALLEL_EXECUTE_CHUNKS
DBA_EXPORT_PATHS
DBA_QUEUE_SCHEDULES
DBA_WORKLOAD_CONNECTION_MAP
DBA_ADVISOR_SQLW_COLVOL
DBA_ADVISOR_RECOMMENDATIONS
DBA_ADVISOR_SQLA_COLVOL
DBA_PART_TABLES
DBA_ADVISOR_DEF_PARAMETERS
DBA_ADVISOR_FINDINGS
DBA_ADVISOR_DIR_INSTANCES
DBA_SQLTUNE_RATIONALE_PLAN
DBA_TAB_SUBPARTITIONS
DBA_DBFS_HS_FIXED_PROPERTIES
DBA_WAITERS
DBA_LOCK_INTERNAL
DBA_ADVISOR_DIR_DEFINITIONS
DBA_DML_LOCKS
DBA_REGISTRY_DEPENDENCIES
DBA_IAS_OBJECTS
DBA_IND_SUBPARTITIONS
DBA_WORKLOAD_REPLAYS
DBA_PART_COL_STATISTICS
DBA_ADVISOR_SQLA_WK_MAP
DBA_BLOCKERS
DBA_SQLTUNE_PLANS
DBA_REGISTRY
DBA_ADVISOR_LOG
DBA_REGISTRY_HISTORY
DBA_ADVISOR_SQLA_REC_SUM
DBA_ADVISOR_EXECUTION_TYPES
DBA_SQLSET_STATEMENTS
DBA_ADVISOR_DEFINITIONS
DBA_IAS_GEN_STMTS_EXP
DBA_WORKLOAD_REPLAY_FILTER_SET
DBA_ADVISOR_SQLA_TABLES
DBA_ADVISOR_USAGE
DBA_WORKLOAD_CAPTURES
DBA_LOGMNR_PURGED_LOG
DBA_ADVISOR_PARAMETERS_PROJ
DBA_ADVISOR_SQLW_SUM
DBA_KGLLOCK
DBA_IND_PARTITIONS
DBA_SQLSET_REFERENCES
DBA_SUBPART_KEY_COLUMNS
DBA_ADVISOR_SQLA_WK_SUM
DBA_ADVISOR_OBJECT_TYPES
DBA_ADDM_TASK_DIRECTIVES
DBA_ADVISOR_SQLW_STMTS
DBA_IAS_TEMPLATES
DBA_SQLSET_PLANS
DBA_IAS_POSTGEN_STMTS
DBA_ADVISOR_TEMPLATES
DBA_JAVA_NCOMPS
DBA_ADVISOR_SQLW_TEMPLATES
DBA_ADVISOR_FDG_BREAKDOWN
DBA_ADDM_SYSTEM_DIRECTIVES
DBA_IAS_PREGEN_STMTS
DBA_LOCK
DBA_SQLSET
DBA_TAB_PARTITIONS
DBA_SUBPART_HISTOGRAMS
DBA_ADDM_FDG_BREAKDOWN
DBA_IAS_CONSTRAINT_EXP
DBA_FLASHBACK_TXN_STATE
DBA_LOB_SUBPARTITIONS
DBA_KEEPSIZES
DBA_AQ_AGENT_PRIVS
DBA_ADVISOR_COMMANDS
DBA_DBFS_HS_PROPERTIES
DBA_SQLTUNE_BINDS
DBA_REPCAT
DBA_ADVISOR_EXECUTIONS
DBA_REGISTRY_PROGRESS
DBA_PART_LOBS
DBA_IAS_OBJECTS_BASE
DBA_SERVER_REGISTRY
DBA_ATTRIBUTE_TRANSFORMATIONS
DBA_REGISTRY_LOG
DBA_IAS_SITES
DBA_PART_INDEXES
DBA_ADVISOR_SQLA_TABVOL
DBA_WORKLOAD_FILTERS
DBA_IAS_OBJECTS_EXP
DBA_ADDM_INSTANCES
DBA_ADVISOR_JOURNAL
DBA_HIST_ASH_SNAPSHOT
DBA_ADVISOR_EXEC_PARAMETERS
DBA_ADVISOR_FINDING_NAMES
DBA_ADVISOR_SQLW_TABLES
DBA_DBFS_HS_COMMANDS
DBA_ADVISOR_SQLW_TABVOL
DBA_LOGMNR_SESSION
DBA_DDL_LOCKS
DBA_SUBPART_COL_STATISTICS
DBA_WORKLOAD_REPLAY_DIVERGENCE
DBA_ADVISOR_OBJECTS
DBA_SUBPARTITION_TEMPLATES
DBA_LOGMNR_LOG
DBA_REGISTRY_HIERARCHY
DBA_ADVISOR_SQLW_PARAMETERS
DBA_ADVISOR_TASKS
DBA_LOB_TEMPLATES
DBA_REGISTRY_DATABASE
DBA_ANALYZE_OBJECTS
DBA_SQLTUNE_STATISTICS
DBA_SQL_MONITOR_USAGE
DBA_ADVISOR_SQLSTATS
DBA_AQ_AGENTS
DBA_PART_HISTOGRAMS
DBA_PART_KEY_COLUMNS
DBA_ADVISOR_DIR_TASK_INST
DBA_LOB_PARTITIONS
DBA_ADDM_TASKS
DBA_ADVISOR_SQLA_WK_STMTS
DBA_IAS_GEN_STMTS
DBA_FLASHBACK_TXN_REPORT
DBA_INVALID_OBJECTS
DBA_DBFS_HS
DBA_ADVISOR_SQLW_JOURNAL
DBA_ADVISOR_SQLPLANS
ALL$OLAP2_AWS
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_CHANGE_HANDLERS Details about apply change handler
ALL_APPLY_CONFLICT_COLUMNS Details about conflict resolution on tables visible to the current user
ALL_APPLY_DML_HANDLERS Details about the dml handler on tables visible to the current user
ALL_APPLY_ENQUEUE Details about the apply enqueue action for user accessible rules where the destination queue exists and is visible to the user
ALL_APPLY_ERROR Error transactions that were generated after dequeuing from the queue visible to the current user
ALL_APPLY_EXECUTE Details about the apply execute action for all rules visible to the user
ALL_APPLY_KEY_COLUMNS Alternative key columns for a STREAMS table visible to the current user
ALL_APPLY_PARAMETERS Details about parameters of each apply process that dequeues from the queue visible to the current user
ALL_APPLY_PROGRESS Information about the progress made by the apply process that dequeues from the queue visible to the current user
ALL_APPLY_TABLE_COLUMNS Details about the columns of destination table object visible to the user
ALL_ARGUMENTS Arguments in object accessible to the user
ALL_ASSEMBLIES Description of assemblies accessible to the user
ALL_ASSOCIATIONS All associations available to the user
ALL_ATTRIBUTE_TRANSFORMATIONS
ALL_AUDIT_POLICIES All fine grained auditing policies in the database
ALL_AUDIT_POLICY_COLUMNS All fine grained auditing policy columns in the database
ALL_AWS Analytic Workspaces accessible to the user
ALL_AW_AC Active Catalog Analytic Workspaces accessible to the user
ALL_AW_AC_10G
ALL_AW_OBJ Objects in Analytic Workspaces accessible to the user
ALL_AW_PROP Object properties in Analytic Workspaces accessible to the user
ALL_AW_PROP_NAME Analytic Workspace property names accessible to the user
ALL_AW_PS Pagespaces in Analytic Workspaces accessible to the user
ALL_BASE_TABLE_MVIEWS All materialized views with log(s) in the database that the user can see
ALL_CAPTURE Details about each capture process that stores the captured changes in a queue visible to the current user
ALL_CAPTURE_EXTRA_ATTRIBUTES Extra attributes for a capture process that is visible to the current user
ALL_CAPTURE_PARAMETERS Details about parameters for each capture process that stores the captured changes in a queue visible to the current user
ALL_CAPTURE_PREPARED_DATABASE Is the local database prepared for instantiation?
ALL_CAPTURE_PREPARED_SCHEMAS All user schemas at the local database that are prepared for instantiation
ALL_CAPTURE_PREPARED_TABLES All tables visible to the current user that are prepared for instantiation
ALL_CATALOG All tables, views, synonyms, sequences accessible to the user
ALL_CHANGE_PROPAGATIONS Change Data Capture propagations
ALL_CHANGE_PROPAGATION_SETS Change Data Capture propagated change set
ALL_CHANGE_SETS Change Data Capture change sets
ALL_CHANGE_SOURCES Change Data Capture change sources
ALL_CHANGE_TABLES Change Data Capture change tables
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_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
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_CUBES OLAP Cubes in the database accessible to the user
ALL_CUBE_ATTRIBUTES OLAP Attributes in the database accessible by the user
ALL_CUBE_ATTR_VISIBILITY OLAP Attributes visible for Dimensions, Hierarchies, and Levels
ALL_CUBE_BUILD_PROCESSES OLAP Build Processes in the database accessible to the user
ALL_CUBE_CALCULATED_MEMBERS OLAP Calculated Members in the database accessible to the user
ALL_CUBE_DIMENSIONALITY OLAP Cube Dimensionality in the database accessible to the user
ALL_CUBE_DIMENSIONS OLAP Cube Dimensions in the database accessible by the user
ALL_CUBE_DIM_LEVELS OLAP Dimension Levels in the database accessible by the user
ALL_CUBE_DIM_MODELS OLAP Dimension Models in the database accessible to the user
ALL_CUBE_DIM_VIEWS OLAP Dimension Views in the database accessible by the user
ALL_CUBE_DIM_VIEW_COLUMNS OLAP Dimesion View Columns in the database accessible to the user
ALL_CUBE_HIERARCHIES OLAP Hierarchies in the database accessible by the user
ALL_CUBE_HIER_LEVELS OLAP Hierarchy Levels in the database accessible to the user
ALL_CUBE_HIER_VIEWS OLAP Hierarchy Views in the database accessible to the user
ALL_CUBE_HIER_VIEW_COLUMNS OLAP Hierarchy View Columns in the database accessible to the user
ALL_CUBE_MEASURES OLAP Measures in the database accessible to the user
ALL_CUBE_VIEWS OLAP Cube Views in the database accessible by the user
ALL_CUBE_VIEW_COLUMNS OLAP Cube View Columns in the database accessible by the user
ALL_DB_LINKS Database links accessible to the user
ALL_DEF_AUDIT_OPTS Auditing options for newly created objects
ALL_DEPENDENCIES Dependencies to and from objects accessible to the user
ALL_DEQUEUE_QUEUES All queues accessible to the user
ALL_DIMENSIONS Description of the dimension objects accessible to the DBA
ALL_DIM_ATTRIBUTES Representation of the relationship between a dimension level and
a functionally dependent column
ALL_DIM_CHILD_OF Representaion of a 1:n hierarchical relationship between a pair of levels in
a dimension
ALL_DIM_HIERARCHIES Representation of a dimension hierarchy
ALL_DIM_JOIN_KEY Representation of a join between two dimension tables.
ALL_DIM_LEVELS Description of dimension levels visible to DBA
ALL_DIM_LEVEL_KEY Representations of columns of a dimension level
ALL_DIRECTORIES Description of all directories accessible to the user
ALL_EDITIONING_VIEWS Description of Editioning Views accessible to the user
ALL_EDITIONING_VIEWS_AE Description of Editioning Views accessible to the user
ALL_EDITIONING_VIEW_COLS Relationship between columns of Editioning Views accessible to the user and the table columns to which they map
ALL_EDITIONING_VIEW_COLS_AE Relationship between columns of Editioning Views accessible to the user and the table columns to which they map
ALL_EDITIONS Describes all editions in the database
ALL_EDITION_COMMENTS Describes comments on all editions in the database
ALL_ENCRYPTED_COLUMNS Encryption information on all accessible columns
ALL_ERRORS Current errors on stored objects that user is allowed to create
ALL_ERRORS_AE Current errors on stored objects that user is allowed to create
ALL_EVALUATION_CONTEXTS rule evaluation contexts seen by user
ALL_EVALUATION_CONTEXT_TABLES tables in all rule evaluation contexts seen by the user
ALL_EVALUATION_CONTEXT_VARS variables in all rule evaluation contexts seen by the user
ALL_EXTERNAL_LOCATIONS Description of the external tables locations accessible to the user
ALL_EXTERNAL_TABLES Description of the external tables accessible to the user
ALL_FILE_GROUPS Details about file groups
ALL_FILE_GROUP_EXPORT_INFO Details about export information of file group versions
ALL_FILE_GROUP_FILES Details about file group files
ALL_FILE_GROUP_TABLES Details about the tables in the file group repository
ALL_FILE_GROUP_TABLESPACES Details about the transportable tablespaces in the file group repository
ALL_FILE_GROUP_VERSIONS Details about file group versions
ALL_IDENTIFIERS All identifiers in stored objects 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_ARRAYTYPES All array types specified by the indextype
ALL_INDEXTYPE_COMMENTS Comments for user-defined indextypes
ALL_INDEXTYPE_OPERATORS All operators available to the user
ALL_IND_COLUMNS COLUMNs comprising INDEXes on accessible TABLES
ALL_IND_EXPRESSIONS FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES
ALL_IND_PARTITIONS
ALL_IND_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
ALL_IND_STATISTICS Optimizer statistics for all indexes on tables accessible to the user
ALL_IND_SUBPARTITIONS
ALL_INTERNAL_TRIGGERS Description of the internal triggers on the tables accessible to the user
ALL_INT_DEQUEUE_QUEUES All queues accessible to the user
ALL_JAVA_ARGUMENTS argument information of stored java class accessible to the user
ALL_JAVA_CLASSES class level information of stored java class accessible to the user
ALL_JAVA_COMPILER_OPTIONS native-compiler options applicable to user
ALL_JAVA_DERIVATIONS this view maps java source objects and their derived java class objects and java resource objects for the java class accessible to user
ALL_JAVA_FIELDS field information of stored java class accessible to user
ALL_JAVA_IMPLEMENTS interfaces implemented by the stored java class accessible to the user
ALL_JAVA_INNERS list of inner classes refered by the stored java class accessible to user
ALL_JAVA_LAYOUTS class layout information about stored java class accessible to the user
ALL_JAVA_METHODS method information of stored java class accessible to user
ALL_JAVA_NCOMPS ncomp related information of all java classes
ALL_JAVA_RESOLVERS resolver of java class owned by user
ALL_JAVA_THROWS list of exceptions thrown from a method of a class accessible to user
ALL_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_MEASURE_FOLDERS OLAP Measure Folders in the database accessible to the user
ALL_MEASURE_FOLDER_CONTENTS OLAP Measure Folder Contents in the database accessible by the user
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_MINING_MODELS Description of the models accessible to the user
ALL_MINING_MODEL_ATTRIBUTES Description of all the model attributes accessible to the user
ALL_MINING_MODEL_SETTINGS Description of all the settings accessible to the user
ALL_MVIEWS All materialized views in the database
ALL_MVIEW_AGGREGATES Description of the materialized view aggregates accessible to the user
ALL_MVIEW_ANALYSIS Description of the materialized views accessible to the user
ALL_MVIEW_COMMENTS Comments on materialized views accessible to the user
ALL_MVIEW_DETAIL_PARTITION Freshness information of all PCT materialized views in the database
ALL_MVIEW_DETAIL_RELATIONS Description of the materialized view detail tables accessible to the user
ALL_MVIEW_DETAIL_SUBPARTITION Freshness information of all PCT materialized views in the database
ALL_MVIEW_JOINS Description of a join between two columns in the
WHERE clause of a materialized view accessible to the user
ALL_MVIEW_KEYS Description of the columns that appear in the GROUP BY
list of a materialized view accessible to the user
ALL_MVIEW_LOGS All materialized view logs in the database that the user can see
ALL_MVIEW_REFRESH_TIMES Materialized views and their last refresh times for each master table that the user can look at
ALL_NESTED_TABLES Description of nested tables in tables accessible to the user
ALL_NESTED_TABLE_COLS Columns of nested tables
ALL_OBJECTS Objects accessible to the user
ALL_OBJECTS_AE 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_PLSQL_OBJECT_SETTINGS Compiler settings of stored objects accessible to the user
ALL_POLICIES All policies for objects if the user has system privileges or owns the objects
ALL_POLICY_CONTEXTS All policy driving context defined for all synonyms, tables, or views accessable to the user
ALL_POLICY_GROUPS All policy groups defined for any synonym, table or view accessable to the user
ALL_PROBE_OBJECTS
ALL_PROCEDURES Functions/procedures/packages/types/triggers available to the user
ALL_PROPAGATION Streams propagation seen by the user
ALL_QUEUES All queues accessible to the user
ALL_QUEUE_PUBLISHERS
ALL_QUEUE_SCHEDULES
ALL_QUEUE_SUBSCRIBERS All queue subscribers accessible to user
ALL_QUEUE_TABLES All queue tables accessible to the user
ALL_REFRESH All the refresh groups that the user can touch
ALL_REFRESH_CHILDREN All the objects in refresh groups, where the user can touch the group
ALL_REFRESH_DEPENDENCIES Description of the detail tables that materialized views depend on for
refresh
ALL_REFS Description of REF columns contained in tables accessible to the user
ALL_REGISTERED_MVIEWS Remote materialized views of local tables that the user can see
ALL_REGISTERED_SNAPSHOTS Remote snapshots of local tables that the user can see
ALL_REGISTRY_BANNERS
ALL_REPAUDIT_ATTRIBUTE Information about attributes automatically maintained for replication
ALL_REPAUDIT_COLUMN Information about columns in all shadow tables for replicated tables which are accessible to the user
ALL_REPCAT
ALL_REPCATLOG Information about asynchronous administration requests
ALL_REPCOLUMN Replicated top-level columns (table) sorted alphabetically in ascending order
ALL_REPCOLUMN_GROUP All column groups of replicated tables which are accessible to the user
ALL_REPCONFLICT All conflicts with available resolutions for user's replicated tables
ALL_REPDDL Arguments that do not fit in a single repcat log record
ALL_REPFLAVORS Flavors defined for replicated object groups
ALL_REPFLAVOR_COLUMNS Replicated columns in flavors
ALL_REPFLAVOR_OBJECTS Replicated objects in flavors
ALL_REPGENERATED Objects generated to support replication
ALL_REPGENOBJECTS Objects generated to support replication
ALL_REPGROUP Information about replicated object groups
ALL_REPGROUPED_COLUMN Columns in the all column groups of replicated tables which are accessible to the user
ALL_REPGROUP_PRIVILEGES Information about users who are registered for object group privileges
ALL_REPKEY_COLUMNS Primary columns for a table using column-level replication
ALL_REPOBJECT Information about replicated objects
ALL_REPPARAMETER_COLUMN All columns used for resolving conflicts in replicated tables which are accessible to the user
ALL_REPPRIORITY Values and their corresponding priorities in all priority groups which are accessible to the user
ALL_REPPRIORITY_GROUP Information about all priority groups which are accessible to the user
ALL_REPPROP Propagation information about replicated objects
ALL_REPRESOLUTION Description of all conflict resolutions for replicated tables which are accessible to the user
ALL_REPRESOLUTION_METHOD All conflict resolution methods accessible to the user
ALL_REPRESOLUTION_STATISTICS Statistics for conflict resolutions for replicated tables which are accessible to the user
ALL_REPRESOL_STATS_CONTROL Information about statistics collection for conflict resolutions for replicated tables which are accessible to the user
ALL_REPSCHEMA N-way replication information
ALL_REPSITES N-way replication information
ALL_REWRITE_EQUIVALENCES Description of all rewrite equivalence accessible to the user
ALL_RULES Rules seen by the user
ALL_RULESETS Rulesets seen by the user: maintained for backward compatibility
ALL_RULE_SETS Rule sets seen by the user
ALL_RULE_SET_RULES Rules in all rule sets seen by the user
ALL_SCHEDULER_CHAINS All scheduler chains in the database visible to current user
ALL_SCHEDULER_CHAIN_RULES All rules from scheduler chains visible to the current user
ALL_SCHEDULER_CHAIN_STEPS All steps of scheduler chains visible to the current user
ALL_SCHEDULER_CREDENTIALS All scheduler credentials visible to the user
ALL_SCHEDULER_DB_DESTS User-visible destination objects in the database pointing to remote databases
ALL_SCHEDULER_DESTS All destination objects for jobs in the database visible to current user
ALL_SCHEDULER_EXTERNAL_DESTS User-visible destination objects in the database pointing to remote agents
ALL_SCHEDULER_FILE_WATCHERS Scheduler file watch requests visible to the current user
ALL_SCHEDULER_GLOBAL_ATTRIBUTE All scheduler global attributes
ALL_SCHEDULER_GROUPS All scheduler object groups visible to current user
ALL_SCHEDULER_GROUP_MEMBERS Members of all scheduler object groups visible to current user
ALL_SCHEDULER_JOBS All scheduler jobs visible to the user
ALL_SCHEDULER_JOB_ARGS All arguments with set values of all scheduler jobs in the database
ALL_SCHEDULER_JOB_CLASSES All scheduler classes visible to the user
ALL_SCHEDULER_JOB_DESTS State of all jobs visible to current user at each of their destinations
ALL_SCHEDULER_JOB_LOG Logged information for all scheduler jobs
ALL_SCHEDULER_JOB_RUN_DETAILS The details of a job run
ALL_SCHEDULER_NOTIFICATIONS All job e-mail notifications visible to the current user
ALL_SCHEDULER_PROGRAMS All scheduler programs visible to the user
ALL_SCHEDULER_PROGRAM_ARGS All arguments of all scheduler programs visible to the user
ALL_SCHEDULER_REMOTE_DATABASES
ALL_SCHEDULER_REMOTE_JOBSTATE Remote state of all jobs originating from this database visible to current user
ALL_SCHEDULER_RUNNING_CHAINS All job steps of running job chains visible to the user
ALL_SCHEDULER_SCHEDULES All schedules in the database
ALL_SCHEDULER_WINDOWS All scheduler windows in the database
ALL_SCHEDULER_WINDOW_DETAILS The details of a window
ALL_SCHEDULER_WINDOW_GROUPS All scheduler window groups in the database
ALL_SCHEDULER_WINDOW_LOG Logged information for all scheduler windows
ALL_SCHEDULER_WINGROUP_MEMBERS Members of all scheduler window groups in the database
ALL_SECONDARY_OBJECTS All secondary objects for domain indexes
ALL_SEC_RELEVANT_COLS Security Relevant columns of all VPD policies for tables or views which the user has access
ALL_SEQUENCES Description of SEQUENCEs accessible to the user
ALL_SERVICES
ALL_SNAPSHOTS Snapshots the user can access
ALL_SNAPSHOT_LOGS All snapshot logs in the database that the user can see
ALL_SOURCE Current source on stored objects that user is allowed to create
ALL_SOURCE_AE Current source on stored objects that user is allowed to create
ALL_SQLJ_TYPES Description of types accessible to the user
ALL_SQLJ_TYPE_ATTRS Description of attributes of types accessible to the user
ALL_SQLJ_TYPE_METHODS Description of methods of types accessible to the user
ALL_SQLSET
ALL_SQLSET_BINDS
ALL_SQLSET_PLANS
ALL_SQLSET_REFERENCES
ALL_SQLSET_STATEMENTS
ALL_STAT_EXTENSIONS Optimizer statistics extensions
ALL_STORED_SETTINGS Parameter settings for objects accessible to the user
ALL_STREAMS_COLUMNS Streams unsupported columns
ALL_STREAMS_GLOBAL_RULES Global rules created on the streams capture/apply/propagation process that interact with the queue visible to the current user
ALL_STREAMS_MESSAGE_CONSUMERS Streams messaging consumers visible to the current user
ALL_STREAMS_MESSAGE_RULES Rules for Streams messaging visible to the current user
ALL_STREAMS_NEWLY_SUPPORTED List of objects that are newly supported by Streams
ALL_STREAMS_RULES Rules used by streams processes
ALL_STREAMS_SCHEMA_RULES Rules created by streams administrative APIs on all user schemas
ALL_STREAMS_TABLE_RULES Rules created by streams administrative APIs on tables visible to the current user
ALL_STREAMS_TRANSFORM_FUNCTION Rules-based transform functions used by Streams
ALL_STREAMS_UNSUPPORTED List of all the tables that are not supported by Streams in this release
ALL_SUBPARTITION_TEMPLATES
ALL_SUBPART_COL_STATISTICS
ALL_SUBPART_HISTOGRAMS
ALL_SUBPART_KEY_COLUMNS
ALL_SUMDELTA Direct path load entries accessible to the user
ALL_SUMMAP mapping entries of transaction ID and commit SCN accessible to the user
ALL_SUMMARIES Description of the summaries accessible to the user
ALL_SYNC_CAPTURE Details about each sync capture process that stores the captured changes in a queue visible to the current user
ALL_SYNC_CAPTURE_PREPARED_TABS All tables prepared for synchronous capture instantiation
ALL_SYNC_CAPTURE_TABLES All tables that are captured by synchronous streams captures.
ALL_SYNONYMS All synonyms for base objects accessible to the user and session
ALL_TABLES Description of relational tables accessible to the user
ALL_TAB_COLS Columns of user's tables, views and clusters
ALL_TAB_COLUMNS Columns of user's tables, views and clusters
ALL_TAB_COL_STATISTICS Columns of user's tables, views and clusters
ALL_TAB_COMMENTS Comments on tables and views accessible to the user
ALL_TAB_HISTGRM_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
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_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
ALL_TAB_PRIVS Grants on objects for which the user is the grantor, grantee, owner,
or an enabled role or PUBLIC is the grantee
ALL_TAB_PRIVS_MADE User's grants and grants on user's objects
ALL_TAB_PRIVS_RECD Grants on objects for which the user, PUBLIC or enabled role is the grantee
ALL_TAB_STATISTICS Optimizer statistics for all tables accessible to the user
ALL_TAB_STATS_HISTORY History of table statistics modifications
ALL_TAB_STAT_PREFS Statistics preferences for tables
ALL_TAB_SUBPARTITIONS
ALL_TRANSFORMATIONS
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_TRIGGER_ORDERING Triggers having FOLLOWS or PRECEDES ordering accessible to the current user
ALL_TSTZ_TABLES Description of tables accessible to the user, which have column(s) defined on timestamp with time zone data type or ADT type containing attribute(s) of timestamp with time zone data type
ALL_TSTZ_TAB_COLS Columns of user's tables, which have column(s) defined on timestamp with time zone data type or ADT type containing attribute(s) of timestamp with time zone data type
ALL_TYPES Description of types accessible to the user
ALL_TYPE_ATTRS Description of attributes of types accessible to the user
ALL_TYPE_METHODS Description of methods of types accessible to the user
ALL_TYPE_VERSIONS Description of each type version accessible to the user
ALL_UNUSED_COL_TABS All tables with unused columns accessible to the user
ALL_UPDATABLE_COLUMNS Description of all updatable columns
ALL_USERS Information about all users of the database
ALL_USTATS All statistics
ALL_VARRAYS Description of varrays in tables accessible to the user
ALL_VIEWS Description of views accessible to the user
ALL_VIEWS_AE Description of views accessible to the user
ALL_WARNING_SETTINGS Warnings ettings for objects accessible to the user
ALL_XDS_ATTRIBUTE_SECS All objects with XDS column security and accessible to the user
ALL_XDS_INSTANCE_SETS All instance sets for objects accessible to the user in the database
ALL_XDS_OBJECTS All XDS enabled objects accessible to the user
ALL_XML_INDEXES Description of the all XMLType indexes that the user has privileges on
ALL_XML_SCHEMAS Description of all XML Schemas that user has privilege to reference
ALL_XML_SCHEMAS2 Dummy version of ALL_XML_SCHEMAS that does not have an XMLTYPE column
ALL_XML_TABLES Description of the all XMLType tables that the user has privileges on
ALL_XML_TAB_COLS Description of the all XMLType tables that the user has privileges on
ALL_XML_VIEWS Description of the all XMLType views that the user has privileges on
ALL_XML_VIEW_COLS Description of the all XMLType views that the user has privileges on
ALL_XSC_AGGREGATE_PRIVILEGE All privileges that make up an aggregate privilege in the database
ALL_XSC_PRIVILEGE All mappings of privileges to security classes in the database
ALL_XSC_SECURITY_CLASS All security class definitions in the database
ALL_XSC_SECURITY_CLASS_DEP All security class dependencies in the database
ALL_XSC_SECURITY_CLASS_STATUS Security class ""enable"" and ""mutable"" status
ALL_XSTREAM_INBOUND Details about the XStream inbound server visible to user
ALL_XSTREAM_OUTBOUND Details about the XStream outbound server visible to user
ALL_XSTREAM_RULES Details about the XStream server rules visible to user
USER_CONS_COLUMNS Information about accessible columns in constraint definitions
USER_LOG_GROUP_COLUMNS Information about columns in log group definitions
USER_LOBS Description of the user's own LOBs contained in the user's own tables
USER_CATALOG Tables, Views, Synonyms and Sequences owned by the user
USER_CLUSTERS Descriptions of user's own clusters
USER_CLU_COLUMNS Mapping of table columns to cluster columns
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_ENCRYPTED_COLUMNS Encryption information on columns of tables owned by the user
USER_INDEXES Description of the user's own indexes
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_JOIN_IND_COLUMNS Join Index columns comprising the join conditions
USER_OBJECTS Objects owned by the user
USER_OBJECTS_AE Objects owned by the user
USER_ROLE_PRIVS Roles granted to current user
USER_SEQUENCES Description of the user's own SEQUENCEs
USER_SYNONYMS The user's private synonyms
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
USER_TAB_COLS Columns of user's tables, views and clusters
USER_TAB_COLUMNS Columns of user's tables, views and clusters
USER_TAB_COMMENTS Comments on the tables and views owned by the user
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_VIEWS Description of the user's own views
USER_VIEWS_AE Description of the user's own views
USER_CONSTRAINTS Constraint definitions on user's own tables
USER_LOG_GROUPS Log group definitions on user's own tables
USER_CLUSTER_HASH_EXPRESSIONS Hash functions for the user's hash clusters
USER_UPDATABLE_COLUMNS Description of updatable columns
USER_UNUSED_COL_TABS User tables with unused columns
USER_PARTIAL_DROP_TABS User tables with unused columns
USER_RESUMABLE Resumable session information for current user
USER_EDITIONING_VIEWS Descriptions of the user's own Editioning Views
USER_EDITIONING_VIEWS_AE Descriptions of the user's own Editioning Views
USER_EDITIONING_VIEW_COLS Relationship between columns of user's Editioning Views and the table columns to which they map
USER_EDITIONING_VIEW_COLS_AE Relationship between columns of user's Editioning Views and the table columns to which they map
USER_LIBRARIES Description of the user's own libraries
USER_PROCEDURES Description of the user functions/procedures/packages/types/triggers
USER_STORED_SETTINGS Parameter settings for objects owned by the user
USER_PLSQL_OBJECT_SETTINGS Compiler settings of stored objects owned by the user
USER_ARGUMENTS Arguments in object accessible to the user
USER_ASSEMBLIES Description of the user's own assemblies
USER_IDENTIFIERS Identifiers in stored objects accessible to the user
USER_DB_LINKS Database links owned by the user
USER_RECYCLEBIN User view of his recyclebin
USER_RESOURCE_LIMITS Display resource limit of the user
USER_PASSWORD_LIMITS Display password limits of the user
USER_USERS Information about the current user
USER_OBJ_AUDIT_OPTS Auditing options for user's own tables and views with atleast one option set
USER_AUDIT_TRAIL Audit trail entries relevant to the user
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_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_SYS_PRIVS System privileges granted to current user
USER_PROXIES Description of connections the user is allowed to proxy
USER_TYPES Description of the user's own types
USER_COLL_TYPES Description of the user's own named collection 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_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_SQLJ_TYPES Description of the user's own types
USER_TYPE_VERSIONS Description of each version of the user's types
USER_PENDING_CONV_TABLES All user's tables which are not upgraded to the latest type version
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_OLDIMAGE_COLUMNS Gives all object tables and columns in old (8.0) p_w_picpath format
USER_NESTED_TABLE_COLS Columns of nested tables
USER_REFS Description of the user's own REF columns contained in the user's own tables
USER_NESTED_TABLES Description of nested tables contained in the user's own tables
USER_VARRAYS Description of varrays contained in the user's own tables
USER_OBJ_COLATTRS Description of object columns and attributes contained in tables owned by the user
USER_CONS_OBJ_COLUMNS List of types an object column or attribute is constrained to in the tables owned by the user
USER_OPERATORS All user operators
USER_OPBINDINGS All binding functions or methods on operators defined by the user
USER_OPANCILLARY All ancillary opertors defined by user
USER_OPARGUMENTS All operator arguments of operators defined by user
USER_OPERATOR_COMMENTS Comments for user-defined operators
USER_INDEXTYPES All user indextypes
USER_INDEXTYPE_COMMENTS Comments for user-defined indextypes
USER_INDEXTYPE_ARRAYTYPES All array types specified by the indextype
USER_INDEXTYPE_OPERATORS All user indextype operators
USER_SECONDARY_OBJECTS All secondary objects for domain indexes
USER_SOURCE_TABLES Source tables available for Change Data Capture
USER_PUBLISHED_COLUMNS Source columns available for Change Data Capture
USER_SUBSCRIPTIONS Change Data Capture subscriptions
USER_SUBSCRIBED_TABLES Change Data Capture subscribed tables
USER_SUBSCRIBED_COLUMNS Change Data Capture subscribed columns
USER_EXTERNAL_TABLES Description of the user's own external tables
USER_EXTERNAL_LOCATIONS Description of the user's external tables locations
USER_MINING_MODELS Description of the user's own models
USER_MINING_MODEL_ATTRIBUTES Description of the user's own model attributes
USER_MINING_MODEL_SETTINGS Description of the user's own model settings
USER_TAB_COL_STATISTICS Columns of user's tables, views and clusters
USER_TAB_HISTOGRAMS Histograms on columns of user's tables
USER_ASSOCIATIONS All assocations defined by the user
USER_USTATS All statistics on tables or indexes owned by the user
USER_TAB_MODIFICATIONS Information regarding modifications to tables
USER_TAB_STATS_HISTORY History of table statistics modifications
USER_TAB_STAT_PREFS Statistics preferences for tables
USER_TAB_PENDING_STATS History of table statistics modifications
USER_IND_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
USER_COL_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
USER_TAB_HISTGRM_PENDING_STATS Pending statistics of tables, partitions, and subpartitions
USER_DIMENSIONS Description of the dimension objects accessible to the DBA
USER_DIM_LEVELS Description of dimension levels visible to DBA
USER_DIM_LEVEL_KEY Representations of columns of a dimension level
USER_DIM_ATTRIBUTES Representation of the relationship between a dimension level and
a functionally dependent column
USER_DIM_HIERARCHIES Representation of a dimension hierarchy
USER_DIM_CHILD_OF Representaion of a 1:n hierarchical relationship between a pair of levels in
a dimension
USER_DIM_JOIN_KEY Representation of a join between two dimension tables.
USER_SUMMARIES Description of the summaries created by the user
USER_MVIEW_ANALYSIS Description of the materialized views created by the user
USER_MVIEW_AGGREGATES Description of the materialized view aggregates 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_KEYS Description of the columns that appear in the GROUP BY
list of a materialized view 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_COMMENTS Comments on materialized views owned by the user
USER_REWRITE_EQUIVALENCES Description of all rewrite equivalence owned by the user
USER_MVIEW_DETAIL_PARTITION Freshness information of all PCT materialized views in the database
USER_MVIEW_DETAIL_SUBPARTITION Freshness information of all PCT materialized views in the database
USER_TSTZ_TAB_COLS Columns of user's tables, which have column(s) defined on timestamp with time zone data type or ADT type containing attribute(s) of timestamp with time zone data type
USER_TSTZ_TABLES Description of the user's own tables, which have column(s) defined on timestamp with time zone data type or ADT type containing attribute(s) of timestamp with time zone data type
USER_ERRORS Current errors on stored objects owned by the user
USER_ERRORS_AE Current errors on stored objects owned by the user
USER_SOURCE_AE Source of stored objects accessible to the user
USER_SOURCE Source of stored objects accessible to the user
USER_TRIGGERS Triggers having FOLLOWS or PRECEDES ordering owned by the user
USER_INTERNAL_TRIGGERS Description of the internal triggers on the user's own tables
USER_TRIGGER_COLS Column usage in user's triggers
USER_DEPENDENCIES Dependencies to and from a users objects
USER_OBJECT_SIZE Sizes, in bytes, of various pl/sql objects
USER_JOBS All jobs owned by this user
USER_SEGMENTS Storage allocated for all database segments
USER_EXTENTS Extents comprising segments owned by the user
USER_FREE_SPACE Free extents in tablespaces accessible to the user
USER_TABLESPACES Description of accessible tablespaces
USER_TS_QUOTAS Tablespace quotas for the user
USER_RULE_SETS Rule sets owned by the user
USER_RULESETS Rulesets owned by the user: maintained for backward compatibility
USER_RULES Rules owned by the user
USER_RULE_SET_RULES Rules in user rule sets
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_SNAPSHOTS Snapshots the user can look at
USER_SNAPSHOT_LOGS All snapshot logs owned 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_REGISTERED_SNAPSHOTS Remote snapshots of local tables currently using logs owned by the user
USER_MVIEWS All materialized views in the database
USER_MVIEW_REFRESH_TIMES Materialized views and their last refresh times for each master table that the user can look at
USER_MVIEW_LOGS All materialized view logs owned by the user
USER_BASE_TABLE_MVIEWS All materialized views with log(s) owned by the user in the database
USER_REGISTERED_MVIEWS Remote materialized views of local tables currently using logs owned by the user
USER_POLICIES All row level security policies for synonyms, tables, or views owned by the user
USER_POLICY_GROUPS All policy groups defined for any synonym, table, or view
USER_POLICY_CONTEXTS All policy driving context defined for synonyms, tables, or views in current schema
USER_SEC_RELEVANT_COLS Security Relevant columns of VPD policies for tables or views owned by the user
USER_AUDIT_POLICIES All fine grained auditing policies for objects in user schema
USER_AUDIT_POLICY_COLUMNS Users fine grained auditing policy columns in the database
USER_CHANGE_NOTIFICATION_REGS change notification registrations for current user
USER_CQ_NOTIFICATION_QUERIES Description of registered queries for CQ notification
USER_SUBSCR_REGISTRATIONS All subscription registrations created by the user
USER_QUEUE_TABLES All queue tables created by the user
USER_QUEUES All queues owned by the 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_OUTLINES Stored outlines owned by the user
USER_OUTLINE_HINTS Hints stored in outlines owned by the user
USER_DATAPUMP_JOBS Datapump jobs for current user
USER_REPGROUP_PRIVILEGES Information about users who are registered for object group privileges
USER_REPGROUP Replication information about the current user
USER_REPSITES N-way replication information about the current user
USER_REPSCHEMA N-way replication information about the current user
USER_REPOBJECT Replication information about the current user's objects
USER_REPCOLUMN Replicated columns for the current user's table in ascending order
USER_REPPROP Propagation information about the current user's objects
USER_REPKEY_COLUMNS Primary columns for a table using column-level replication
USER_REPGENOBJECTS Objects generated for the current user to support replication
USER_REPGENERATED Objects generated for the current user to support replication
USER_REPCATLOG Information about the current user's asynchronous administration requests
USER_REPDDL Arguments that do not fit in a single repcat log record
USER_REPPRIORITY_GROUP Information about user's priority groups
USER_REPPRIORITY Values and their corresponding priorities in user's priority groups
USER_REPCOLUMN_GROUP All column groups of user's replicated tables
USER_REPGROUPED_COLUMN Columns in the all column groups of user's replicated tables
USER_REPRESOLUTION_METHOD All conflict resolution methods accessible to the user
USER_REPRESOLUTION Description of all conflict resolutions for user's replicated tables
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_REPPARAMETER_COLUMN All columns used for resolving conflicts in user's replicated tables
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_REPFLAVORS Flavors current user created for replicated object groups
USER_REPFLAVOR_OBJECTS Replicated user objects in flavors
USER_REPFLAVOR_COLUMNS Replicated columns from current user's tables in flavors
USER_WARNING_SETTINGS Warning Parameter settings for objects owned by the user
USER_STAT_EXTENSIONS Optimizer statistics extensions
USER_TAB_STATISTICS Optimizer statistics of the user's own tables
USER_IND_STATISTICS Optimizer statistics for user's own indexes
USER_AWS Analytic Workspaces owned by the user
USER_AW_PS Pagespaces in Analytic Workspaces owned by the user
USER_CUBES OLAP Cubes owned by the user in the database
USER_CUBE_DIMENSIONALITY OLAP Cube Dimensionality owned by the user in the database
USER_CUBE_MEASURES OLAP Measures owned by the user in the database
USER_CUBE_DIMENSIONS OLAP Cube Dimensions owned by the user in the database
USER_CUBE_HIERARCHIES OLAP Hierarchies owned by the user in the database
USER_CUBE_HIER_LEVELS OLAP Hierarchy Levels owned by the user in the database
USER_CUBE_DIM_LEVELS OLAP Dimension Levels owned by the user in the database
USER_CUBE_ATTRIBUTES OLAP Attributes owned by the user in the database
USER_CUBE_ATTR_VISIBILITY OLAP Attributes visible for Dimensions, Hierarchies, and Levels
USER_CUBE_DIM_MODELS OLAP Dimension Models in the database accessible to the user
USER_CUBE_CALCULATED_MEMBERS OLAP Calculated Members in the database accessible to the user
USER_CUBE_VIEWS OLAP Cube Views owned by the user in the database
USER_CUBE_VIEW_COLUMNS OLAP Cube View Columns owned by the user in the database
USER_CUBE_DIM_VIEWS OLAP Dimension Views owned by the user in the database
USER_CUBE_DIM_VIEW_COLUMNS OLAP Dimesion View Columns in the database accessible to the user
USER_CUBE_HIER_VIEWS OLAP Hierarchy Views owner by the user in the database
USER_CUBE_HIER_VIEW_COLUMNS OLAP Hierarchy View Columns owned by the user in the database
USER_MEASURE_FOLDERS OLAP Measure Folders owned by the user in the database
USER_MEASURE_FOLDER_CONTENTS OLAP Measure Folder Contents owned by the user in the database
USER_CUBE_BUILD_PROCESSES OLAP Build Processes owned by the user in the database
USER_QUEUE_SUBSCRIBERS queue subscribers under a user'schema
USER_SCHEDULER_PROGRAMS Scheduler programs owned by the current user
USER_SCHEDULER_DESTS Destination objects for jobs in the database owned by current user
USER_SCHEDULER_DB_DESTS User-owned destination objects in the database pointing to remote databases
USER_SCHEDULER_JOB_DESTS State of all jobs owned by current user at each of their destinations
USER_SCHEDULER_JOBS All scheduler jobs in the database
USER_SCHEDULER_PROGRAM_ARGS All arguments of all scheduler programs in the database
USER_SCHEDULER_JOB_ARGS All arguments with set values of all scheduler jobs in the database
USER_SCHEDULER_JOB_LOG Logged information for all scheduler jobs
USER_SCHEDULER_JOB_RUN_DETAILS The details of a job run
USER_SCHEDULER_GROUP_MEMBERS Members of all scheduler object groups owned by current user
USER_SCHEDULER_GROUPS All scheduler object groups owned by current user
USER_SCHEDULER_SCHEDULES Schedules belonging to the current user
USER_SCHEDULER_REMOTE_JOBSTATE Remote state of all jobs originating from this database owned by current user
USER_SCHEDULER_CHAINS All scheduler chains owned by the current user
USER_SCHEDULER_CHAIN_RULES All rules from scheduler chains owned by the current user
USER_SCHEDULER_CHAIN_STEPS All steps of scheduler chains owned by the current user
USER_SCHEDULER_RUNNING_CHAINS All steps of chains being run by jobs owned by the current user
USER_SCHEDULER_CREDENTIALS Scheduler credentials owned by the current user
USER_SCHEDULER_FILE_WATCHERS Scheduler file watch requests owned by the current user
USER_SCHEDULER_NOTIFICATIONS All e-mail notifications for jobs owned by the current user
USER_TUNE_MVIEW tune_mview catalog view owned by the user
USER_FLASHBACK_ARCHIVE Description of the flashback archives available to the user
USER_FLASHBACK_ARCHIVE_TABLES Information about the user tables that are enabled for Flashback Archive
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
USER_COMPARISON Details about the user's comparison objects
USER_COMPARISON_COLUMNS Details about the comparison object's columns
USER_COMPARISON_SCAN Details about a comparison scan
USER_COMPARISON_SCAN_SUMMARY Details about a comparison scan
USER_COMPARISON_SCAN_VALUES Details about a comparison scan's values
USER_COMPARISON_ROW_DIF Details about the differing rows in a comparison scan
USER_JAVA_POLICY java security Permissions for current user
USER_JAVA_CLASSES class level information of stored java class owned by the user
USER_JAVA_LAYOUTS class layout information about stored java class owned by the user
USER_JAVA_IMPLEMENTS interfaces implemented by the stored java class owned by user
USER_JAVA_INNERS list of inner classes refered by the stored java class owned by user
USER_JAVA_FIELDS field information of stored java class owned by the user
USER_JAVA_METHODS method information of stored java class owned by the user
USER_JAVA_ARGUMENTS argument information of stored java class owned by the user
USER_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
USER_JAVA_RESOLVERS resolver of java class owned by user
USER_JAVA_NCOMPS ncomp related information of java classes owned by user
USER_JAVA_COMPILER_OPTIONS native compiler options provided by the user
USER_EPG_DAD_AUTHORIZATION DADs authorized to use the user's privileges
USER_XML_TABLES Description of the user's own XMLType tables
USER_XML_TAB_COLS Description of the user's own XMLType tables
USER_XML_VIEWS Description of the user's own XMLType views
USER_XML_VIEW_COLS Description of the user's own XMLType views
USER_XML_SCHEMAS Description of XML Schemas registered by the user
USER_XML_INDEXES Description of the user's own XMLType indexes
USER_XDS_OBJECTS All XDS enabled objects owned by the user
USER_XDS_INSTANCE_SETS All instance sets for objects owned by the user
USER_XDS_ATTRIBUTE_SECS All objects with column security and owned by the user
USER_NETWORK_ACL_PRIVILEGES User privileges to access network hosts through PL/SQL network utility packages
USER_AW_PROP Object properties in Analytic Workspaces owned by the user
USER_AW_OBJ Objects in Analytic Workspaces owned by the user
USER_ADDM_FDG_BREAKDOWN
USER_ADDM_INSTANCES
USER_PART_INDEXES
USER_PART_COL_STATISTICS
USER_ADVISOR_SQLW_JOURNAL
USER_ADVISOR_DIR_TASK_INST
USER_XML_COLUMN_NAMES
USER_ADVISOR_FDG_BREAKDOWN
USER_ADDM_FINDINGS
USER_ADVISOR_SQLPLANS
USER_ADVISOR_SQLW_STMTS
USER_ADVISOR_FINDINGS
USER_ADVISOR_SQLW_SUM
USER_ADVISOR_PARAMETERS
USER_TAB_SUBPARTITIONS
USER_TS
USER_ATTRIBUTE_TRANSFORMATIONS
USER_SQLTUNE_RATIONALE_PLAN
USER_SUBPARTITION_TEMPLATES
USER_TRANSFORMATIONS
USER_SQLSET
USER_PART_LOBS
USER_FLASHBACK_TXN_REPORT
USER_LOB_PARTITIONS
USER_ADVISOR_SQLA_TABVOL
USER_ADDM_TASKS
USER_PART_HISTOGRAMS
USER_ADVISOR_OBJECTS
USER_ADVISOR_SQLW_COLVOL
USER_TAB_PARTITIONS
USER_DBFS_HS_FILES
USER_PART_KEY_COLUMNS
USER_REPCAT
USER_ADVISOR_TEMPLATES
USER_ADVISOR_SQLW_TABVOL
USER_QUEUE_PUBLISHERS
USER_REGISTRY
USER_SQLTUNE_PLANS
USER_SQLSET_REFERENCES
USER_QUEUE_SCHEDULES
USER_ADVISOR_RATIONALE
USER_IND_SUBPARTITIONS
USER_ADVISOR_TASKS
USER_ADVISOR_SQLA_WK_STMTS
USER_DBFS_HS_COMMANDS
USER_ADVISOR_SQLW_TABLES
USER_ADVISOR_SQLA_WK_SUM
USER_ADVISOR_RECOMMENDATIONS
USER_ADVISOR_EXEC_PARAMETERS
USER_ADVISOR_SQLA_TABLES
USER_PART_TABLES
USER_SUBPART_COL_STATISTICS
USER_ADVISOR_EXECUTIONS
USER_ADVISOR_JOURNAL
USER_ADVISOR_SQLW_TEMPLATES
USER_REPCONFLICT
USER_SQLSET_STATEMENTS
USER_LOB_TEMPLATES
USER_FLASHBACK_TXN_STATE
USER_ADVISOR_ACTIONS
USER_DBFS_HS_PROPERTIES
USER_ADVISOR_SQLA_WK_MAP
USER_SQLTUNE_BINDS
USER_SQLTUNE_STATISTICS
USER_ADVISOR_SQLSTATS
USER_ADVISOR_SQLA_REC_SUM
USER_ADVISOR_SQLW_PARAMETERS
USER_ADVISOR_SQLA_COLVOL
USER_DBFS_HS
USER_PARALLEL_EXECUTE_TASKS
USER_SQLSET_BINDS
USER_SQLSET_PLANS
USER_PARALLEL_EXECUTE_CHUNKS
USER_SUBPART_KEY_COLUMNS
USER_DBFS_HS_FIXED_PROPERTIES
USER_ADVISOR_LOG
USER_AQ_AGENT_PRIVS
USER_LOB_SUBPARTITIONS
USER_SUBPART_HISTOGRAMS
USER_ADDM_TASK_DIRECTIVES
USER_IND_PARTITIONS
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
V$PARALLEL_DEGREE_LIMIT_MTH Synonym for V_$PARALLEL_DEGREE_LIMIT_MTH
V$PARAMETER Synonym for V_$PARAMETER
V$PARAMETER2 Synonym for V_$PARAMETER2
V$PARAMETER_VALID_VALUES Synonym for V_$PARAMETER_VALID_VALUES
V$PERSISTENT_PUBLISHERS Synonym for V_$PERSISTENT_PUBLISHERS
V$PERSISTENT_QMN_CACHE Synonym for V_$PERSISTENT_QMN_CACHE
V$PERSISTENT_QUEUES Synonym for V_$PERSISTENT_QUEUES
V$PERSISTENT_SUBSCRIBERS Synonym for V_$PERSISTENT_SUBSCRIBERS
V$PGASTAT Synonym for V_$PGASTAT
V$PGA_TARGET_ADVICE Synonym for V_$PGA_TARGET_ADVICE
V$PGA_TARGET_ADVICE_HISTOGRAM Synonym for V_$PGA_TARGET_ADVICE_HISTOGRAM
V$POLICY_HISTORY Synonym for V_$POLICY_HISTORY
V$PQ_SESSTAT Synonym for V_$PQ_SESSTAT
V$PQ_SLAVE Synonym for V_$PQ_SLAVE
V$PQ_SYSSTAT Synonym for V_$PQ_SYSSTAT
V$PQ_TQSTAT Synonym for V_$PQ_TQSTAT
V$PROCESS Synonym for V_$PROCESS
V$PROCESS_GROUP Synonym for V_$PROCESS_GROUP
V$PROCESS_MEMORY Synonym for V_$PROCESS_MEMORY
V$PROCESS_MEMORY_DETAIL Synonym for V_$PROCESS_MEMORY_DETAIL
V$PROCESS_MEMORY_DETAIL_PROG Synonym for V_$PROCESS_MEMORY_DETAIL_PROG
V$PROPAGATION_RECEIVER Synonym for V_$PROPAGATION_RECEIVER
V$PROPAGATION_SENDER Synonym for V_$PROPAGATION_SENDER
V$PROXY_ARCHIVEDLOG Synonym for V_$PROXY_ARCHIVEDLOG
V$PROXY_ARCHIVELOG_DETAILS Synonym for V_$PROXY_ARCHIVELOG_DETAILS
V$PROXY_ARCHIVELOG_SUMMARY Synonym for V_$PROXY_ARCHIVELOG_SUMMARY
V$PROXY_COPY_DETAILS Synonym for V_$PROXY_COPY_DETAILS
V$PROXY_COPY_SUMMARY Synonym for V_$PROXY_COPY_SUMMARY
V$PROXY_DATAFILE Synonym for V_$PROXY_DATAFILE
V$PWFILE_USERS Synonym for V_$PWFILE_USERS
V$PX_BUFFER_ADVICE Synonym for V_$PX_BUFFER_ADVICE
V$PX_INSTANCE_GROUP Synonym for V_$PX_INSTANCE_GROUP
V$PX_PROCESS Synonym for V_$PX_PROCESS
V$PX_PROCESS_SYSSTAT Synonym for V_$PX_PROCESS_SYSSTAT
V$PX_SESSION Synonym for V_$PX_SESSION
V$PX_SESSTAT Synonym for V_$PX_SESSTAT
V$QMON_COORDINATOR_STATS Synonym for V_$QMON_COORDINATOR_STATS
V$QMON_SERVER_STATS Synonym for V_$QMON_SERVER_STATS
V$QMON_TASKS Synonym for V_$QMON_TASKS
V$QMON_TASK_STATS Synonym for V_$QMON_TASK_STATS
V$QUEUE Synonym for V_$QUEUE
V$QUEUEING_MTH Synonym for V_$QUEUEING_MTH
V$RECOVERY_AREA_USAGE Synonym for V_$RECOVERY_AREA_USAGE
V$RECOVERY_FILE_DEST Synonym for V_$RECOVERY_FILE_DEST
V$RECOVERY_FILE_STATUS Synonym for V_$RECOVERY_FILE_STATUS
V$RECOVERY_LOG Synonym for V_$RECOVERY_LOG
V$RECOVERY_PROGRESS Synonym for V_$RECOVERY_PROGRESS
V$RECOVERY_STATUS Synonym for V_$RECOVERY_STATUS
V$RECOVER_FILE Synonym for V_$RECOVER_FILE
V$REDO_DEST_RESP_HISTOGRAM Synonym for V_$REDO_DEST_RESP_HISTOGRAM
V$REPLPROP Synonym for V_$REPLPROP
V$REPLQUEUE Synonym for V_$REPLQUEUE
V$REQDIST Synonym for V_$REQDIST
V$RESERVED_WORDS Synonym for V_$RESERVED_WORDS
V$RESOURCE Synonym for V_$RESOURCE
V$RESOURCE_LIMIT Synonym for V_$RESOURCE_LIMIT
V$RESTORE_POINT Synonym for V_$RESTORE_POINT
V$RESULT_CACHE_DEPENDENCY Synonym for V_$RESULT_CACHE_DEPENDENCY
V$RESULT_CACHE_MEMORY Synonym for V_$RESULT_CACHE_MEMORY
V$RESULT_CACHE_OBJECTS Synonym for V_$RESULT_CACHE_OBJECTS
V$RESULT_CACHE_STATISTICS Synonym for V_$RESULT_CACHE_STATISTICS
V$RESUMABLE Synonym for V_$RESUMABLE
V$RFS_THREAD Synonym for V_$RFS_THREAD
V$RMAN_BACKUP_JOB_DETAILS Synonym for V_$RMAN_BACKUP_JOB_DETAILS
V$RMAN_BACKUP_SUBJOB_DETAILS Synonym for V_$RMAN_BACKUP_SUBJOB_DETAILS
V$RMAN_BACKUP_TYPE Synonym for V_$RMAN_BACKUP_TYPE
V$RMAN_COMPRESSION_ALGORITHM Synonym for V_$RMAN_COMPRESSION_ALGORITHM
V$RMAN_CONFIGURATION Synonym for V_$RMAN_CONFIGURATION
V$RMAN_ENCRYPTION_ALGORITHMS Synonym for V_$RMAN_ENCRYPTION_ALGORITHMS
V$RMAN_OUTPUT Synonym for V_$RMAN_OUTPUT
V$RMAN_STATUS Synonym for V_$RMAN_STATUS
V$ROLLNAME Synonym for V_$ROLLNAME
V$ROLLSTAT Synonym for V_$ROLLSTAT
V$ROWCACHE Synonym for V_$ROWCACHE
V$ROWCACHE_PARENT Synonym for V_$ROWCACHE_PARENT
V$ROWCACHE_SUBORDINATE Synonym for V_$ROWCACHE_SUBORDINATE
V$RSRCMGRMETRIC Synonym for V_$RSRCMGRMETRIC
V$RSRCMGRMETRIC_HISTORY Synonym for V_$RSRCMGRMETRIC_HISTORY
V$RSRC_CONSUMER_GROUP Synonym for V_$RSRC_CONSUMER_GROUP
V$RSRC_CONSUMER_GROUP_CPU_MTH Synonym for V_$RSRC_CONSUMER_GROUP_CPU_MTH
V$RSRC_CONS_GROUP_HISTORY Synonym for V_$RSRC_CONS_GROUP_HISTORY
V$RSRC_PLAN Synonym for V_$RSRC_PLAN
V$RSRC_PLAN_CPU_MTH Synonym for V_$RSRC_PLAN_CPU_MTH
V$RSRC_PLAN_HISTORY Synonym for V_$RSRC_PLAN_HISTORY
V$RSRC_SESSION_INFO Synonym for V_$RSRC_SESSION_INFO
V$RULE Synonym for V_$RULE
V$RULE_SET Synonym for V_$RULE_SET
V$RULE_SET_AGGREGATE_STATS Synonym for V_$RULE_SET_AGGREGATE_STATS
V$SYSAUX_OCCUPANTS Synonym for V_$SYSAUX_OCCUPANTS
V$SYSMETRIC Synonym for V_$SYSMETRIC
V$SYSMETRIC_HISTORY Synonym for V_$SYSMETRIC_HISTORY
V$SYSMETRIC_SUMMARY Synonym for V_$SYSMETRIC_SUMMARY
V$SYSSTAT Synonym for V_$SYSSTAT
V$SYSTEM_CURSOR_CACHE Synonym for V_$SYSTEM_CURSOR_CACHE
V$SYSTEM_EVENT Synonym for V_$SYSTEM_EVENT
V$SYSTEM_FIX_CONTROL Synonym for V_$SYSTEM_FIX_CONTROL
V$SYSTEM_PARAMETER Synonym for V_$SYSTEM_PARAMETER
V$SYSTEM_PARAMETER2 Synonym for V_$SYSTEM_PARAMETER2
V$SYSTEM_WAIT_CLASS Synonym for V_$SYSTEM_WAIT_CLASS
V$SYS_OPTIMIZER_ENV Synonym for V_$SYS_OPTIMIZER_ENV
V$SYS_TIME_MODEL Synonym for V_$SYS_TIME_MODEL
V$TABLESPACE Synonym for V_$TABLESPACE
V$TEMPFILE Synonym for V_$TEMPFILE
V$TEMPORARY_LOBS Synonym for V_$TEMPORARY_LOBS
V$TEMPSEG_USAGE Synonym for V_$SORT_USAGE
V$TEMPSTAT Synonym for V_$TEMPSTAT
V$TEMP_CACHE_TRANSFER Synonym for V_$TEMP_CACHE_TRANSFER
V$TEMP_EXTENT_MAP Synonym for V_$TEMP_EXTENT_MAP
V$TEMP_EXTENT_POOL Synonym for V_$TEMP_EXTENT_POOL
V$TEMP_PING Synonym for V_$TEMP_PING
V$TEMP_SPACE_HEADER Synonym for V_$TEMP_SPACE_HEADER
V$THREAD Synonym for V_$THREAD
V$THRESHOLD_TYPES Synonym for V_$THRESHOLD_TYPES
V$TIMER Synonym for V_$TIMER
V$TIMEZONE_FILE Synonym for V_$TIMEZONE_FILE
V$TIMEZONE_NAMES Synonym for V_$TIMEZONE_NAMES
V$TOPLEVELCALL Synonym for V_$TOPLEVELCALL
V$TRANSACTION Synonym for V_$TRANSACTION
V$TRANSACTION_ENQUEUE Synonym for V_$TRANSACTION_ENQUEUE
V$TRANSPORTABLE_PLATFORM Synonym for V_$TRANSPORTABLE_PLATFORM
V$TSM_SESSIONS Synonym for V_$TSM_SESSIONS
V$TYPE_SIZE Synonym for V_$TYPE_SIZE
V$UNDOSTAT Synonym for V_$UNDOSTAT
V$UNUSABLE_BACKUPFILE_DETAILS Synonym for V_$UNUSABLE_BACKUPFILE_DETAILS
V$VERSION Synonym for V_$VERSION
V$VPD_POLICY Synonym for V_$VPD_POLICY
V$WAITCLASSMETRIC Synonym for V_$WAITCLASSMETRIC
V$WAITCLASSMETRIC_HISTORY Synonym for V_$WAITCLASSMETRIC_HISTORY
V$WAITSTAT Synonym for V_$WAITSTAT
V$WAIT_CHAINS Synonym for V_$WAIT_CHAINS
V$WALLET Synonym for V_$WALLET
V$WLM_PCMETRIC Synonym for V_$WLM_PCMETRIC
V$WLM_PCMETRIC_HISTORY Synonym for V_$WLM_PCMETRIC_HISTORY
V$WLM_PC_STATS Synonym for V_$WLM_PC_STATS
V$WORKLOAD_REPLAY_THREAD Synonym for V_$WORKLOAD_REPLAY_THREAD
V$XML_AUDIT_TRAIL Synonym for V_$XML_AUDIT_TRAIL
V$_LOCK Synonym for V_$_LOCK
V$DLM_ALL_LOCKS Synonym for V_$DLM_ALL_LOCKS
V$DLM_CONVERT_LOCAL Synonym for V_$DLM_CONVERT_LOCAL
V$DLM_CONVERT_REMOTE Synonym for V_$DLM_CONVERT_REMOTE
V$DLM_LATCH Synonym for V_$DLM_LATCH
V$DLM_LOCKS Synonym for V_$DLM_LOCKS
V$DLM_MISC Synonym for V_$DLM_MISC
V$DLM_RESS Synonym for V_$DLM_RESS
V$DLM_TRAFFIC_CONTROLLER Synonym for V_$DLM_TRAFFIC_CONTROLLER
V$DNFS_CHANNELS Synonym for V_$DNFS_CHANNELS
V$DNFS_FILES Synonym for V_$DNFS_FILES
V$DNFS_SERVERS Synonym for V_$DNFS_SERVERS
V$DNFS_STATS Synonym for V_$DNFS_STATS
V$DYNAMIC_REMASTER_STATS Synonym for V_$DYNAMIC_REMASTER_STATS
V$EMON Synonym for V_$EMON
V$ENABLEDPRIVS Synonym for V_$ENABLEDPRIVS
V$ENCRYPTED_TABLESPACES Synonym for V_$ENCRYPTED_TABLESPACES
V$ENCRYPTION_WALLET Synonym for V_$ENCRYPTION_WALLET
V$ENQUEUE_LOCK Synonym for V_$ENQUEUE_LOCK
V$ENQUEUE_STAT Synonym for V_$ENQUEUE_STAT
V$ENQUEUE_STATISTICS Synonym for V_$ENQUEUE_STATISTICS
V$EVENTMETRIC Synonym for V_$EVENTMETRIC
V$EVENT_HISTOGRAM Synonym for V_$EVENT_HISTOGRAM
V$EVENT_NAME Synonym for V_$EVENT_NAME
V$EXECUTION Synonym for V_$EXECUTION
V$FAST_START_SERVERS Synonym for V_$FAST_START_SERVERS
V$FAST_START_TRANSACTIONS Synonym for V_$FAST_START_TRANSACTIONS
V$FILEMETRIC Synonym for V_$FILEMETRIC
V$FILEMETRIC_HISTORY Synonym for V_$FILEMETRIC_HISTORY
V$FILESPACE_USAGE Synonym for V_$FILESPACE_USAGE
V$FILESTAT Synonym for V_$FILESTAT
V$FILE_CACHE_TRANSFER Synonym for V_$FILE_CACHE_TRANSFER
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。