select * from DBA_CONS_COLUMNS ; ---Information about accessible columns in constraint definitions
select * from DBA_LOG_GROUP_COLUMNS ; ---Information about columns in log group definitions
select * from DBA_LOBS ; ---Description of LOBs contained in all tables
select * from DBA_CATALOG ; ---All database Tables, Views, Synonyms, Sequences
select * from DBA_CLUSTERS ; ---Description of all clusters in the database
select * from DBA_CLU_COLUMNS ; ---Mapping of table columns to cluster columns
select * from DBA_COL_COMMENTS ; ---Comments on columns of all tables and views
select * from DBA_COL_PRIVS ; ---All grants on columns in the database
select * from DBA_ENCRYPTED_COLUMNS ; ---Encryption information on columns in the database
select * from DBA_INDEXES ; ---Description for all indexes in the database
select * from DBA_IND_COLUMNS ; ---COLUMNs comprising INDEXes on all TABLEs and CLUSTERs
select * from DBA_IND_EXPRESSIONS ; ---FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLUSTERS
select * from DBA_JOIN_IND_COLUMNS ; ---Join Index columns comprising the join conditions
select * from DBA_OBJECTS ; ---All objects in the database
select * from DBA_OBJECTS_AE ; ---All objects in the database
select * from DBA_ROLLBACK_SEGS ; ---Description of rollback segments
select * from DBA_ROLE_PRIVS ; ---Roles granted to users and roles
select * from DBA_SEQUENCES ; ---Description of all SEQUENCEs in the database
select * from DBA_SYNONYMS ; ---All synonyms in the database
select * from DBA_TABLES ; ---Description of all relational tables in the database
select * from DBA_OBJECT_TABLES ; ---Description of all object tables in the database
select * from DBA_ALL_TABLES ; ---Description of all object and relational tables in the database
select * from DBA_TAB_COLS ; ---Columns of user's tables, views and clusters
select * from DBA_TAB_COLUMNS ; ---Columns of user's tables, views and clusters
select * from DBA_TAB_COMMENTS ; ---Comments on all tables and views in the database
select * from DBA_TAB_PRIVS ; ---All grants on objects in the database
select * from DBA_VIEWS ; ---Description of all views in the database
select * from DBA_VIEWS_AE ; ---Description of all views in the database
select * from DBA_CONSTRAINTS ; ---Constraint definitions on all tables
select * from DBA_LOG_GROUPS ; ---Log group definitions on all tables
select * from DBA_CLUSTER_HASH_EXPRESSIONS ; ---Hash functions for all clusters
select * from DBA_UPDATABLE_COLUMNS ; ---Description of dba updatable columns
select * from DBA_UNUSED_COL_TABS ; ---All tables with unused columns in the database
select * from DBA_PARTIAL_DROP_TABS ; ---All tables with partially dropped columns in the database
select * from DBA_RESUMABLE ; ---Resumable session information in the system
select * from DBA_EDITIONING_VIEWS ; ---Description of all Editioning Views in the database
select * from DBA_EDITIONING_VIEWS_AE ; ---Description of all Editioning Views in the database
select * from DBA_EDITIONING_VIEW_COLS ; ---Relationship between columns of all Editioning Views in the database and the table columns to which they map
select * from DBA_EDITIONING_VIEW_COLS_AE ; ---Relationship between columns of all Editioning Views in the database and the table columns to which they map
select * from DBA_EDITIONS ; ---Describes all editions in the database
select * from DBA_EDITION_COMMENTS ; ---Describes comments on all editions in the database
select * from DBA_LIBRARIES ; ---Description of all libraries in the database
select * from DBA_PROCEDURES ; ---Description of the dba functions/procedures/packages/types/triggers
select * from DBA_STORED_SETTINGS ; ---Parameter settings for all objects
select * from DBA_PLSQL_OBJECT_SETTINGS ; ---Compiler settings of all objects in the database
select * from DBA_ARGUMENTS ; ---All arguments for objects in the database
select * from DBA_ASSEMBLIES ; ---Description of all assemblies in the database
select * from DBA_IDENTIFIERS ; ---Identifiers in stored objects accessible to sys
select * from DBA_DB_LINKS ; ---All database links in the database
select * from DBA_RECYCLEBIN ; ---Description of the Recyclebin view accessible to the user
select * from DBA_2PC_PENDING ; ---info about distributed transactions awaiting recovery
select * from DBA_2PC_NEIGHBORS ; ---information about incoming and outgoing connections for pending transactions
select * from DBA_PROFILES ; ---Display all profiles and their limits
select * from DBA_USERS ; ---Information about all users of the database
select * from DBA_OBJ_AUDIT_OPTS ; ---Auditing options for all tables and views with atleast one option set
select * from DBA_STMT_AUDIT_OPTS ; ---Describes current system auditing options across the system and by user
select * from DBA_PRIV_AUDIT_OPTS ; ---Describes current system privileges being audited across the system and by user
select * from DBA_AUDIT_TRAIL ; ---All audit trail entries
select * from DBA_AUDIT_SESSION ; ---All audit trail records concerning CONNECT and DISCONNECT
select * from DBA_AUDIT_STATEMENT ; ---Audit trail records concerning  grant, revoke, audit, noaudit and alter system
select * from 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
select * from DBA_AUDIT_EXISTS ; ---Lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS
select * from DBA_ROLES ; ---All Roles which exist in the database
select * from DBA_SYS_PRIVS ; ---System privileges granted to users and roles
select * from DBA_PROXIES ; ---Information about all proxy connections
select * from DBA_CONNECT_ROLE_GRANTEES ; ---Information regarding which users are granted CONNECT
select * from DBA_TYPES ; ---Description of all types in the database
select * from DBA_COLL_TYPES ; ---Description of all named collection types in the database
select * from DBA_TYPE_ATTRS ; ---Description of attributes of all types in the database
select * from DBA_TYPE_METHODS ; ---Description of methods of all types in the database
select * from DBA_METHOD_PARAMS ; ---Description of method parameters of all types in the database
select * from DBA_METHOD_RESULTS ; ---Description of method results of all types in the database
select * from DBA_SQLJ_TYPES ; ---Description of all types in the database
select * from DBA_TYPE_VERSIONS ; ---Description of each type version in the database
select * from DBA_PENDING_CONV_TABLES ; ---All tables which are not upgraded to the latest type version in the database
select * from DBA_SQLJ_TYPE_ATTRS ; ---Description of attributes of all types in the database
select * from DBA_SQLJ_TYPE_METHODS ; ---Description of methods of all types in the database
select * from DBA_OLDIMAGE_COLUMNS ; ---Gives all object tables and columns in old (8.0) image format
select * from DBA_NESTED_TABLE_COLS ; ---Columns of nested tables
select * from DBA_DIRECTORIES ; ---Description of all directories
select * from DBA_REFS ; ---Description of REF columns contained in all tables
select * from DBA_NESTED_TABLES ; ---Description of nested tables contained in all tables
select * from DBA_VARRAYS ; ---Description of varrays in tables accessible to the user
select * from DBA_OBJ_COLATTRS ; ---Description of object columns and attributes contained in all tables in the database
select * from DBA_CONS_OBJ_COLUMNS ; ---List of types an object column or attribute is constrained to in all tables in the database
select * from DBA_OPERATORS ; ---All operators
select * from DBA_OPBINDINGS ; ---All operator binding functiosn or methods
select * from DBA_OPANCILLARY ; ---All ancillary operators
select * from DBA_OPARGUMENTS ; ---All operator arguments
select * from DBA_OPERATOR_COMMENTS ; ---Comments for user-defined operators
select * from DBA_INDEXTYPES ; ---All indextypes
select * from DBA_INDEXTYPE_COMMENTS ; ---Comments for user-defined indextypes
select * from DBA_INDEXTYPE_ARRAYTYPES ; ---All array types specified by the indextype
select * from DBA_INDEXTYPE_OPERATORS ; ---All indextype operators
select * from DBA_SECONDARY_OBJECTS ; ---All secondary objects for domain indexes
select * from DBA_SOURCE_TABLES ; ---Source tables available for Change Data Capture
select * from DBA_PUBLISHED_COLUMNS ; ---Source columns available for Change Data Capture
select * from DBA_SUBSCRIPTIONS ; ---Change Data Capture subscriptions
select * from DBA_SUBSCRIBED_TABLES ; ---Change Data Capture subscribed tables
select * from DBA_SUBSCRIBED_COLUMNS ; ---Change Data Capture subscribed columns
select * from DBA_EXP_OBJECTS ; ---Objects that have been incrementally exported
select * from DBA_EXP_VERSION ; ---Version number of the last export session
select * from DBA_EXP_FILES ; ---Description of export files
select * from DBA_EXTERNAL_TABLES ; ---Description of the external tables accessible to the DBA
select * from DBA_EXTERNAL_LOCATIONS ; ---Description of the external tables locations accessible to the DBA
select * from DBA_MINING_MODELS ; ---Description of all the models in the database
select * from DBA_MINING_MODEL_ATTRIBUTES ; ---Description of all the model attributes in the database
select * from DBA_MINING_MODEL_SETTINGS ; ---Description of all the model settings in the database
select * from DBA_MINING_MODEL_TABLES ; ---Description of all the mining model tables in the system
select * from DBA_TAB_COL_STATISTICS ; ---Columns of user's tables, views and clusters
select * from DBA_TAB_HISTOGRAMS ; ---Histograms on columns of all tables
select * from DBA_ASSOCIATIONS ; ---All associations
select * from DBA_USTATS ; ---All statistics collected on either tables or indexes
select * from DBA_TAB_MODIFICATIONS ; ---Information regarding modifications to tables
select * from DBA_OPTSTAT_OPERATIONS ; ---History of statistics operations performed
select * from DBA_TAB_STATS_HISTORY ; ---History of table statistics modifications
select * from DBA_TAB_STAT_PREFS ; ---Statistics preferences for tables
select * from DBA_TAB_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
select * from DBA_IND_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
select * from DBA_COL_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
select * from DBA_TAB_HISTGRM_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
select * from DBA_DIMENSIONS ; ---Description of the dimension objects accessible to the DBA
select * from DBA_DIM_LEVELS ; ---Description of dimension levels visible to DBA
select * from DBA_DIM_LEVEL_KEY ; ---Representations of columns of a dimension level
"select * from DBA_DIM_ATTRIBUTES ; ---Representation of the relationship between a dimension level and
 a functionally dependent column"
select * from DBA_DIM_HIERARCHIES ; ---Representation of a dimension hierarchy
"select * from DBA_DIM_CHILD_OF ; ---Representaion of a 1:n hierarchical relationship between a pair of levels in
 a dimension"
select * from DBA_DIM_JOIN_KEY ; ---Representation of a join between two dimension tables.
select * from DBA_SUMMARIES ; ---Description of the summaries accessible to dba
select * from DBA_MVIEW_ANALYSIS ; ---Description of the materialized views accessible to dba
select * from DBA_MVIEW_AGGREGATES ; ---Description of the materialized view aggregates accessible to dba
select * from DBA_MVIEW_DETAIL_RELATIONS ; ---Description of the materialized view detail tables accessible to dba
"select * from DBA_MVIEW_KEYS ; ---Description of the columns that appear in the GROUP BY
list of a materialized view accessible to dba"
"select * from DBA_MVIEW_JOINS ; ---Description of a join between two columns in the
WHERE clause of a materialized view accessible to dba"
select * from DBA_MVIEW_COMMENTS ; ---Comments on all materialized views in the database
select * from DBA_REWRITE_EQUIVALENCES ; ---Description of rewrite equivalence accessible to DBA
select * from DBA_MVIEW_DETAIL_PARTITION ; ---Freshness information of all PCT materialized views in the database
select * from DBA_MVIEW_DETAIL_SUBPARTITION ; ---Freshness information of all PCT materialized views in the database
select * from 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
select * from 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
select * from DBA_ERRORS ; ---Current errors on all stored objects in the database
select * from DBA_ERRORS_AE ; ---Current errors on all stored objects in the database
select * from DBA_SOURCE_AE ; ---Source of all stored objects in the database
select * from DBA_SOURCE ; ---Source of all stored objects in the database
select * from DBA_TRIGGERS ; ---All triggers in the database
select * from DBA_INTERNAL_TRIGGERS ; ---Description of the internal triggers on all tables in the database
select * from DBA_TRIGGER_COLS ; ---Column usage in all triggers
select * from DBA_DEPENDENCIES ; ---Dependencies to and from objects
select * from DBA_OBJECT_SIZE ; ---Sizes, in bytes, of various pl/sql objects
select * from DBA_TRIGGER_ORDERING ; ---All triggers having FOLLOWS or PRECEDES ordering in the database
select * from DBA_JOBS_RUNNING ; ---All jobs in the database which are currently running, join v$lock and job$
select * from DBA_JOBS ; ---All jobs in the database
select * from DBA_SEGMENTS ; ---Storage allocated for all database segments
select * from DBA_SEGMENTS_OLD ; ---Storage allocated for all database segments
select * from DBA_EXTENTS ; ---Extents comprising all segments in the database
select * from DBA_UNDO_EXTENTS ; ---Extents comprising all segments in the system managed undo tablespaces
select * from DBA_LMT_USED_EXTENTS ; ---All extents in the locally managed tablespaces
select * from DBA_DMT_USED_EXTENTS ; ---All extents in the dictionary managed tablespaces
select * from DBA_FREE_SPACE ; ---Free extents in all tablespaces
select * from DBA_LMT_FREE_SPACE ; ---Free extents in all locally managed tablespaces
select * from DBA_DMT_FREE_SPACE ; ---Free extents in all dictionary managed tablespaces
select * from DBA_FREE_SPACE_COALESCED ; ---Statistics on Coalesced Space in Tablespaces
select * from DBA_DATA_FILES ; ---Information about database data files
select * from DBA_TABLESPACES ; ---Description of all tablespaces
select * from DBA_TEMP_FILES ; ---Information about database temp files
select * from DBA_TABLESPACE_GROUPS ; ---Description of all tablespace groups
select * from DBA_TABLESPACE_USAGE_METRICS ; ---Description of all tablespace space usage metrics
select * from DBA_TS_QUOTAS ; ---Tablespace quotas for all users
select * from DBA_TEMP_FREE_SPACE ; ---Summary of temporary space usage
select * from DBA_CONTEXT ; ---Description of all context namespace information
select * from DBA_GLOBAL_CONTEXT ; ---Description of all context information accessible globally
select * from DBA_RULE_SETS ; ---Rule sets in the database
select * from DBA_RULESETS ; ---Rulesets in the database: maintained for backward compatibility
select * from DBA_RULES ; ---Rules in the databse
select * from DBA_RULE_SET_RULES ; ---Rules in all rule sets in the database
select * from DBA_EVALUATION_CONTEXTS ; ---rule evaluation contexts in the database
select * from DBA_EVALUATION_CONTEXT_TABLES ; ---tables in all rule evaluation contexts in the database
select * from DBA_EVALUATION_CONTEXT_VARS ; ---variables in all rule evaluation contexts in the database
select * from DBA_SNAPSHOTS ; ---All snapshots in the database
select * from DBA_SNAPSHOT_LOGS ; ---All snapshot logs in the database
select * from DBA_RCHILD ; ---All the children in any refresh group.  This view is not a join.
select * from DBA_RGROUP ; ---All refresh groups.  This view is not a join.
select * from DBA_REFRESH ; ---All the refresh groups
select * from DBA_REFRESH_CHILDREN ; ---All the objects in refresh groups
select * from DBA_REGISTERED_SNAPSHOTS ; ---Remote snapshots of local tables
select * from DBA_MVIEWS ; ---All materialized views in the database
select * from DBA_MVIEW_REFRESH_TIMES ; ---All fast refreshable materialized views and their last refresh times for each master table
select * from DBA_MVIEW_LOGS ; ---All materialized view logs in the database
select * from DBA_BASE_TABLE_MVIEWS ; ---All materialized views with log(s) in the database
select * from DBA_REGISTERED_MVIEWS ; ---Remote materialized views of local tables
select * from DBA_MVIEW_LOG_FILTER_COLS ; ---All filter columns (excluding PK cols) being logged in the materialized view logs
select * from DBA_POLICIES ; ---All row level security policies in the database
select * from DBA_POLICY_GROUPS ; ---All policy groups defined for any synonym, table, view in the database
select * from DBA_POLICY_CONTEXTS ; ---All policy driving context defined for any synonym, table, or view in the database
select * from DBA_SEC_RELEVANT_COLS ; ---Security Relevant columns of all VPD policies in the database
select * from DBA_AUDIT_POLICIES ; ---Fine grained auditing policies in the database
select * from DBA_AUDIT_POLICY_COLUMNS ; ---All fine grained auditing policy columns in the database
select * from DBA_FGA_AUDIT_TRAIL ; ---All fine grained audit event logs
select * from DBA_COMMON_AUDIT_TRAIL ; ---Combined Standard and Fine Grained audit trail entries
select * from 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
select * from DBA_AUDIT_MGMT_LAST_ARCH_TS ; ---The Last Archive Timestamps set for the Audit Trail Clean up
select * from DBA_AUDIT_MGMT_CLEANUP_JOBS ; ---The view displays the currently configured audit trail purge jobs
select * from DBA_AUDIT_MGMT_CLEAN_EVENTS ; ---The history of cleanup events
select * from DBA_TSM_SOURCE ; ---Transparent session migration source session statistics
select * from DBA_TSM_DESTINATION ; ---Transparent session migration source session statistics
select * from DBA_TSM_HISTORY ; ---Transparent session migration statistics
select * from DBA_CHANGE_NOTIFICATION_REGS ; ---Description of the registrations for change notification
select * from DBA_CQ_NOTIFICATION_QUERIES ; ---Description of registered queries for CQ notification
select * from DBA_CPOOL_INFO ; ---Connection pool info
select * from DBA_SSCR_CAPTURE ; ---Session state capture statistics
select * from DBA_SSCR_RESTORE ; ---Session state restore statistics
select * from DBA_SUBSCR_REGISTRATIONS ; ---All subscription registrations created in the database
select * from DBA_QUEUE_TABLES ; ---All queue tables created in the database
select * from DBA_QUEUES ; ---All database queues
select * from DBA_RESOURCE_INCARNATIONS ; ---Resource incarnations that are running or eligible for HA status notification
select * from DBA_RSRC_PLANS ; ---All the resource plans
select * from DBA_RSRC_CONSUMER_GROUPS ; ---all the resource consumer groups
select * from DBA_RSRC_CATEGORIES ; ---All resource consumer group categories
select * from DBA_RSRC_PLAN_DIRECTIVES ; ---all the resource plan directives
select * from DBA_RSRC_CONSUMER_GROUP_PRIVS ; ---Switch privileges for consumer groups
select * from DBA_RSRC_MANAGER_SYSTEM_PRIVS ; ---system privileges for the resource manager
select * from DBA_RSRC_GROUP_MAPPINGS ; ---all the consumer group mappings
select * from DBA_RSRC_MAPPING_PRIORITY ; ---the consumer group mapping attribute priorities
select * from DBA_RSRC_STORAGE_POOL_MAPPING ; ---resource manager rules for mapping files to storage pools
"select * from DBA_RSRC_CAPABILITY ; ---settings for database resources that are capable of being managed by the
Resource Manager"
"select * from DBA_RSRC_INSTANCE_CAPABILITY ; ---per-instance settings for database resources that are capable of being
managed by the Resource Manager"
select * from DBA_RSRC_IO_CALIBRATE ; ---Results of the most recent I/O calibration
select * from DBA_OUTLINES ; ---Stored outlines
select * from DBA_OUTLINE_HINTS ; ---Hints stored in outlines
select * from DBA_DATAPUMP_JOBS ; ---Datapump jobs
select * from DBA_DATAPUMP_SESSIONS ; ---Datapump sessions attached to a job
select * from DBA_FEATURE_USAGE_STATISTICS ; ---Database Feature Usage Statistics
select * from DBA_HIGH_WATER_MARK_STATISTICS ; ---Database High Water Mark Statistics
select * from DBA_CPU_USAGE_STATISTICS ; ---Database CPU Usage Statistics
select * from DBA_ALERT_ARGUMENTS ; ---Message Id and arguments of outstanding alerts
select * from DBA_ENABLED_TRACES ; ---Information about enabled SQL traces
select * from DBA_ENABLED_AGGREGATIONS ; ---Information about enabled on-demand statistic aggregation
select * from DBA_HIST_DATABASE_INSTANCE ; ---Database Instance Information
select * from DBA_HIST_SNAPSHOT ; ---Snapshot Information
select * from DBA_HIST_SNAP_ERROR ; ---Snapshot Error Information
select * from DBA_HIST_COLORED_SQL ; ---Marked SQLs for snapshots
select * from DBA_HIST_BASELINE_METADATA ; ---Baseline Metadata Information
select * from DBA_HIST_BASELINE_TEMPLATE ; ---Baseline Template Information
select * from DBA_HIST_WR_CONTROL ; ---Workload Repository Control Information
select * from DBA_HIST_TABLESPACE ; ---Tablespace Static Information
select * from DBA_HIST_DATAFILE ; ---Names of Datafiles
select * from DBA_HIST_FILESTATXS ; ---Datafile Historical Statistics Information
select * from DBA_HIST_TEMPFILE ; ---Names of Temporary Datafiles
select * from DBA_HIST_TEMPSTATXS ; ---Temporary Datafile Historical Statistics Information
select * from DBA_HIST_COMP_IOSTAT ; ---I/O stats aggregated on component level
select * from DBA_HIST_SQLSTAT ; ---SQL Historical Statistics Information
select * from DBA_HIST_SQLTEXT ; ---SQL Text
select * from DBA_HIST_SQL_SUMMARY ; ---Summary of SQL Statistics
select * from DBA_HIST_SQL_PLAN ; ---SQL Plan Information
select * from DBA_HIST_SQL_BIND_METADATA ; ---SQL Bind Metadata Information
select * from DBA_HIST_OPTIMIZER_ENV ; ---Optimizer Environment Information
select * from DBA_HIST_EVENT_NAME ; ---Event Names
select * from DBA_HIST_SYSTEM_EVENT ; ---System Event Historical Statistics Information
select * from DBA_HIST_BG_EVENT_SUMMARY ; ---Summary of Background Event Historical Statistics Information
select * from DBA_HIST_WAITSTAT ; ---Wait Historical Statistics Information
select * from DBA_HIST_ENQUEUE_STAT ; ---Enqueue Historical Statistics Information
select * from DBA_HIST_LATCH_NAME ; ---Latch Names
select * from DBA_HIST_LATCH ; ---Latch Historical Statistics Information
select * from DBA_HIST_LATCH_CHILDREN ; ---Latch Children Historical Statistics Information
select * from DBA_HIST_LATCH_PARENT ; ---Latch Parent Historical Historical Statistics Information
select * from DBA_HIST_LATCH_MISSES_SUMMARY ; ---Latch Misses Summary Historical Statistics Information
select * from DBA_HIST_EVENT_HISTOGRAM ; ---Event Histogram Historical Statistics Information
select * from DBA_HIST_MUTEX_SLEEP ; ---Mutex Sleep Summary Historical Statistics Information
select * from DBA_HIST_LIBRARYCACHE ; ---Library Cache Historical Statistics Information
select * from DBA_HIST_DB_CACHE_ADVICE ; ---DB Cache Advice History Information
select * from DBA_HIST_BUFFER_POOL_STAT ; ---Buffer Pool Historical Statistics Information
select * from DBA_HIST_ROWCACHE_SUMMARY ; ---Row Cache Historical Statistics Information Summary
select * from DBA_HIST_SGA ; ---SGA Historical Statistics Information
select * from DBA_HIST_SGASTAT ; ---SGA Pool Historical Statistics Information
select * from DBA_HIST_PGASTAT ; ---PGA Historical Statistics Information
select * from DBA_HIST_PROCESS_MEM_SUMMARY ; ---Process Memory Historical Summary Information
select * from DBA_HIST_RESOURCE_LIMIT ; ---Resource Limit Historical Statistics Information
select * from DBA_HIST_SHARED_POOL_ADVICE ; ---Shared Pool Advice History
select * from DBA_HIST_STREAMS_POOL_ADVICE ; ---Streams Pool Advice History
select * from DBA_HIST_SQL_WORKAREA_HSTGRM ; ---SQL Workarea Histogram History
select * from DBA_HIST_PGA_TARGET_ADVICE ; ---PGA Target Advice History
select * from DBA_HIST_SGA_TARGET_ADVICE ; ---SGA Target Advice History
select * from DBA_HIST_MEMORY_TARGET_ADVICE ; ---Memory Target Advice History
select * from DBA_HIST_MEMORY_RESIZE_OPS ; ---Memory Resize Operations History
select * from DBA_HIST_INSTANCE_RECOVERY ; ---Instance Recovery Historical Statistics Information
select * from DBA_HIST_JAVA_POOL_ADVICE ; ---Java Pool Advice History
select * from DBA_HIST_THREAD ; ---Thread Historical Statistics Information
select * from DBA_HIST_STAT_NAME ; ---Statistic Names
select * from DBA_HIST_SYSSTAT ; ---System Historical Statistics Information
select * from DBA_HIST_SYS_TIME_MODEL ; ---System Time Model Historical Statistics Information
select * from DBA_HIST_OSSTAT_NAME ; ---Operating System Statistic Names
select * from DBA_HIST_OSSTAT ; ---Operating System Historical Statistics Information
select * from DBA_HIST_PARAMETER_NAME ; ---Parameter Names
select * from DBA_HIST_PARAMETER ; ---Parameter Historical Statistics Information
select * from DBA_HIST_MVPARAMETER ; ---Multi-valued Parameter Historical Statistics Information
select * from DBA_HIST_UNDOSTAT ; ---Undo Historical Statistics Information
select * from DBA_HIST_SEG_STAT ; --- Historical Statistics Information
select * from DBA_HIST_SEG_STAT_OBJ ; ---Segment Names
select * from DBA_HIST_METRIC_NAME ; ---Segment Names
select * from DBA_HIST_SYSMETRIC_HISTORY ; ---System Metrics History
select * from DBA_HIST_SYSMETRIC_SUMMARY ; ---System Metrics History
select * from DBA_HIST_SESSMETRIC_HISTORY ; ---System Metrics History
select * from DBA_HIST_FILEMETRIC_HISTORY ; ---File Metrics History
select * from DBA_HIST_WAITCLASSMET_HISTORY ; ---Wait Class Metric History
select * from DBA_HIST_DLM_MISC ; ---Distributed Lock Manager Miscellaneous Historical Statistics Information
select * from DBA_HIST_CR_BLOCK_SERVER ; ---Consistent Read Block Server Historical Statistics
select * from DBA_HIST_CURRENT_BLOCK_SERVER ; ---Current Block Server Historical Statistics
select * from DBA_HIST_INST_CACHE_TRANSFER ; ---Instance Cache Transfer Historical Statistics
select * from DBA_HIST_PLAN_OPERATION_NAME ; ---Optimizer Explain Plan Operation Names
select * from DBA_HIST_PLAN_OPTION_NAME ; ---Optimizer Explain Plan Option Names
select * from DBA_HIST_SQLCOMMAND_NAME ; ---Sql command types
select * from DBA_HIST_TOPLEVELCALL_NAME ; ---Oracle top level call type
select * from DBA_HIST_ACTIVE_SESS_HISTORY ; ---Active Session Historical Statistics Information
select * from DBA_HIST_TABLESPACE_STAT ; ---Tablespace Historical Statistics Information
select * from DBA_HIST_LOG ; ---Log Historical Statistics Information
select * from DBA_HIST_MTTR_TARGET_ADVICE ; ---Mean-Time-To-Recover Target Advice History
select * from DBA_HIST_TBSPC_SPACE_USAGE ; ---Tablespace Usage Historical Statistics Information
select * from DBA_HIST_SERVICE_NAME ; ---Service Names
select * from DBA_HIST_SERVICE_STAT ; ---Historical Service Statistics
select * from DBA_HIST_SERVICE_WAIT_CLASS ; ---Historical Service Wait Class Statistics
select * from DBA_HIST_SESS_TIME_STATS ; ---CPU and I/O time for interesting (STREAMS) sessions
select * from DBA_HIST_STREAMS_CAPTURE ; ---STREAMS Capture Historical Statistics Information
select * from DBA_HIST_STREAMS_APPLY_SUM ; ---STREAMS Apply Historical Statistics Information
select * from DBA_HIST_BUFFERED_QUEUES ; ---STREAMS Buffered Queues Historical Statistics Information
select * from DBA_HIST_BUFFERED_SUBSCRIBERS ; ---STREAMS Buffered Queue Subscribers Historical Statistics Information
select * from DBA_HIST_RULE_SET ; ---Rule sets historical statistics information
select * from DBA_HIST_PERSISTENT_QUEUES ; ---STREAMS AQ Persistent Queues Historical Statistics Information
select * from DBA_HIST_PERSISTENT_SUBS ; ---STREAMS AQ Persistent Queue Subscribers Historical Statistics Information
select * from DBA_HIST_IOSTAT_FUNCTION ; ---Historical I/O statistics by function
select * from DBA_HIST_IOSTAT_FUNCTION_NAME ; ---Function names for historical I/O statistics
select * from DBA_HIST_IOSTAT_FILETYPE ; ---Historical I/O statistics by file type
select * from DBA_HIST_IOSTAT_FILETYPE_NAME ; ---File type names for historical I/O statistics
select * from DBA_HIST_IOSTAT_DETAIL ; ---Historical I/O statistics by function and filetype
select * from DBA_HIST_RSRC_CONSUMER_GROUP ; ---Historical resource consumer group statistics
select * from DBA_HIST_RSRC_PLAN ; ---Historical resource plan statistics
select * from DBA_HIST_CLUSTER_INTERCON ; ---Cluster Interconnect Historical Stats
select * from DBA_HIST_MEM_DYNAMIC_COMP ; ---Historical memory component sizes
select * from DBA_HIST_IC_CLIENT_STATS ; ---Historical interconnect client statistics
select * from DBA_HIST_IC_DEVICE_STATS ; ---Historical interconnect device statistics
select * from DBA_HIST_INTERCONNECT_PINGS ; ---Instance to instance ping stats
select * from DBA_HIST_DISPATCHER ; ---Dispatcher statistics
select * from DBA_HIST_SHARED_SERVER_SUMMARY ; ---Shared Server summary statistics
select * from DBA_HIST_DYN_REMASTER_STATS ; ---Dynamic remastering statistics
select * from DBA_HIST_PERSISTENT_QMN_CACHE ; ---STREAMS AQ Persistent QMN Cache Historical Statistics Information
select * from DBA_SQL_PROFILES ; ---set of sql profiles
select * from DBA_SQL_PLAN_BASELINES ; ---set of plan baselines
select * from DBA_SQL_PATCHES ; ---set of sql patches
select * from DBA_REGISTERED_SNAPSHOT_GROUPS ; ---Snapshot repgroup registration information
select * from DBA_REGISTERED_MVIEW_GROUPS ; ---Materialized view repgroup registration information
select * from DBA_REPGROUP_PRIVILEGES ; ---Information about users who are registered for object group privileges
select * from DBA_REPGROUP ; ---Information about all replicated object groups
select * from DBA_REPSITES ; ---N-way replication information
select * from DBA_REPSCHEMA ; ---N-way replication information
select * from DBA_REPOBJECT ; ---Information about replicated objects
select * from DBA_REPCOLUMN ; ---Replicated top-level columns (table) sorted alphabetically in ascending order
select * from DBA_REPPROP ; ---Propagation information about replicated objects
select * from DBA_REPKEY_COLUMNS ; ---Primary columns for a table using column-level replication
select * from DBA_REPGENOBJECTS ; ---Objects generated to support replication
select * from DBA_REPGENERATED ; ---Objects generated to support replication
select * from DBA_REPCATLOG ; ---Information about asynchronous administration requests
select * from DBA_REPDDL ; ---Arguments that do not fit in a single repcat log record
select * from DBA_REPPRIORITY_GROUP ; ---Information about all priority groups in the database
select * from DBA_REPPRIORITY ; ---Values and their corresponding priorities in all priority groups in the database
select * from DBA_REPCOLUMN_GROUP ; ---All column groups of replicated tables in the database
select * from DBA_REPGROUPED_COLUMN ; ---Columns in the all column groups of replicated tables in the database
select * from DBA_REPCONFLICT ; ---All conflicts for which users have specified resolutions in the database
select * from DBA_REPRESOLUTION_METHOD ; ---All conflict resolution methods in the database
select * from DBA_REPRESOLUTION ; ---Description of all conflict resolutions in the database
select * from DBA_REPRESOLUTION_STATISTICS ; ---Statistics for conflict resolutions for all replicated tables in the database
select * from DBA_REPRESOL_STATS_CONTROL ; ---Information about statistics collection for conflict resolutions for all replicated tables in the database
select * from DBA_REPPARAMETER_COLUMN ; ---All columns used for resolving conflicts in the database
select * from DBA_REPAUDIT_ATTRIBUTE ; ---Information about attributes automatically maintained for replication
select * from DBA_REPAUDIT_COLUMN ; ---Information about columns in all shadow tables for all replicated tables in the database
select * from DBA_REPFLAVORS ; ---Flavors defined for replicated object groups
select * from DBA_REPFLAVOR_OBJECTS ; ---Replicated objects in flavors
select * from DBA_REPFLAVOR_COLUMNS ; ---Replicated columns in flavors
select * from DBA_TEMPLATE_REFGROUPS ; ---Table for maintaining refresh group information for template.
select * from DBA_TEMPLATE_TARGETS ; ---Internal table for tracking potential target databases for templates.
select * from DBA_REPCAT_EXCEPTIONS ; ---Repcat processing exceptions table.
select * from DBA_REPEXTENSIONS ; ---Information about replication extension requests
select * from DBA_REPSITES_NEW ; ---Information about new masters for replication extension
select * from DBA_USERS_WITH_DEFPWD ; ---Users that are still using their default passwords
select * from DBA_WARNING_SETTINGS ; ---warning settings for all objects
select * from DBA_STAT_EXTENSIONS ; ---Optimizer statistics extensions
select * from DBA_TAB_STATISTICS ; ---Optimizer statistics for all tables in the database
select * from DBA_IND_STATISTICS ; ---Optimizer statistics for all indexes in the database
select * from DBA_PENDING_TRANSACTIONS ; ---information about unresolved global transactions
select * from DBA_AWS ; ---Analytic Workspaces in the database
select * from DBA_AW_PS ; ---Pagespaces in Analytic Workspaces owned by the user
select * from DBA_CUBES ; ---OLAP Cubes in the database
select * from DBA_CUBE_DIMENSIONALITY ; ---OLAP Cube Dimensionality in the database
select * from DBA_CUBE_MEASURES ; ---OLAP Measures in the database
select * from DBA_CUBE_DIMENSIONS ; ---OLAP Cube Dimensions in the database
select * from DBA_CUBE_HIERARCHIES ; ---OLAP Hierarchies in the database
select * from DBA_CUBE_HIER_LEVELS ; ---OLAP Hierarchy Levels in the database
select * from DBA_CUBE_DIM_LEVELS ; ---OLAP Dimension Levels in the database
select * from DBA_CUBE_ATTRIBUTES ; ---OLAP Attributes in the database
select * from DBA_CUBE_ATTR_VISIBILITY ; ---OLAP Attributes visible for Dimensions, Hierarchies, and Levels
select * from DBA_CUBE_DIM_MODELS ; ---OLAP Dimension Models in the database
select * from DBA_CUBE_CALCULATED_MEMBERS ; ---OLAP Calculated Members in the database
select * from DBA_CUBE_VIEWS ; ---OLAP Cube Views in the database
select * from DBA_CUBE_VIEW_COLUMNS ; ---OLAP Cube View Columns in the database
select * from DBA_CUBE_DIM_VIEWS ; ---OLAP Dimension Views in the database
select * from DBA_CUBE_DIM_VIEW_COLUMNS ; ---OLAP Dimesion View Columns in the database
select * from DBA_CUBE_HIER_VIEWS ; ---OLAP Hierarchy Views in the database
select * from DBA_CUBE_HIER_VIEW_COLUMNS ; ---OLAP Hierarchy View Columns in the database
select * from DBA_MEASURE_FOLDERS ; ---OLAP Measure Folders in the database
select * from DBA_MEASURE_FOLDER_CONTENTS ; ---OLAP Measure Folder Contents in the database
select * from DBA_CUBE_BUILD_PROCESSES ; ---OLAP Build Processes in the database
select * from DBA_QUEUE_SUBSCRIBERS ; ---queue subscribers in the database
select * from DBA_SCHEDULER_PROGRAMS ; ---All scheduler programs in the database
select * from DBA_SCHEDULER_DESTS ; ---All possible destination objects for jobs in the database
select * from DBA_SCHEDULER_EXTERNAL_DESTS ; ---All destination objects in the database pointing to remote agents
select * from DBA_SCHEDULER_DB_DESTS ; ---All destination objects in the database pointing to remote databases
select * from DBA_SCHEDULER_JOB_DESTS ; ---State of all jobs at each of their destinations
select * from DBA_SCHEDULER_JOBS ; ---All scheduler jobs in the database
select * from DBA_SCHEDULER_JOB_ROLES ; ---All scheduler jobs in the database by database role
select * from DBA_SCHEDULER_JOB_CLASSES ; ---All scheduler classes in the database
select * from DBA_SCHEDULER_WINDOWS ; ---All scheduler windows in the database
select * from DBA_SCHEDULER_PROGRAM_ARGS ; ---All arguments of all scheduler programs in the database
select * from DBA_SCHEDULER_JOB_ARGS ; ---All arguments with set values of all scheduler jobs in the database
select * from DBA_SCHEDULER_JOB_LOG ; ---Logged information for all scheduler jobs
select * from DBA_SCHEDULER_JOB_RUN_DETAILS ; ---The details of a job run
select * from DBA_SCHEDULER_WINDOW_LOG ; ---Logged information for all scheduler windows
select * from DBA_SCHEDULER_WINDOW_DETAILS ; ---The details of a window
select * from DBA_SCHEDULER_WINDOW_GROUPS ; ---All scheduler window groups in the database
select * from DBA_SCHEDULER_WINGROUP_MEMBERS ; ---Members of all scheduler window groups in the database
select * from DBA_SCHEDULER_GROUP_MEMBERS ; ---Members of all scheduler object groups in the database
select * from DBA_SCHEDULER_GROUPS ; ---All scheduler object groups in the database
select * from DBA_SCHEDULER_SCHEDULES ; ---All schedules in the database
select * from DBA_SCHEDULER_REMOTE_DATABASES ; ---List of registered remote databases for jobs
select * from DBA_SCHEDULER_REMOTE_JOBSTATE ; ---Remote state of all jobs originating from this database
select * from DBA_SCHEDULER_GLOBAL_ATTRIBUTE ; ---All scheduler global attributes
select * from DBA_SCHEDULER_CHAINS ; ---All scheduler chains in the database
select * from DBA_SCHEDULER_CHAIN_RULES ; ---All rules from scheduler chains in the database
select * from DBA_SCHEDULER_CHAIN_STEPS ; ---All steps of scheduler chains in the database
select * from DBA_SCHEDULER_RUNNING_CHAINS ; ---All steps of all running chains in the database
select * from DBA_SCHEDULER_CREDENTIALS ; ---All scheduler credentials in the database
select * from DBA_SCHEDULER_FILE_WATCHERS ; ---All scheduler file watch requests in the database
select * from DBA_SCHEDULER_NOTIFICATIONS ; ---All job e-mail notifications in the database
select * from DBA_EXPORT_OBJECTS ; ---Export INCLUDE and EXCLUDE object type names
select * from DBA_LOGSTDBY_UNSUPPORTED_TABLE ; ---List of all the data tables that are not supported by Logical Standby
select * from DBA_LOGSTDBY_UNSUPPORTED ; ---List of all the columns that are not supported by Logical Standby
select * from DBA_LOGSTDBY_NOT_UNIQUE ; ---List of all the tables with out primary or unique key not null constraints
select * from DBA_LOGSTDBY_PARAMETERS ; ---Miscellaneous options and settings for Logical Standby
select * from DBA_LOGSTDBY_PROGRESS ; ---List the SCN values describing read and apply progress
select * from DBA_LOGSTDBY_LOG ; ---List the information about received logs from the primary
select * from DBA_LOGSTDBY_SKIP_TRANSACTION ; ---List the transactions to be skipped
select * from DBA_LOGSTDBY_SKIP ; ---List the skip settings choosen
select * from DBA_LOGSTDBY_EVENTS ; ---Information on why logical standby events
select * from DBA_LOGSTDBY_HISTORY ; ---Information on processed, active, and pending log streams
select * from DBA_LOGSTDBY_EDS_TABLES ; ---List of all tables that have EDS-based replication for Logical Standby
select * from DBA_LOGSTDBY_EDS_SUPPORTED ; ---List of all tables that could have EDS-based replication for Logical Standby
select * from DBA_OUTSTANDING_ALERTS ; ---Description of all outstanding alerts
select * from DBA_ALERT_HISTORY ; ---Description on alert history
select * from DBA_THRESHOLDS ; ---Desription of all thresholds
select * from DBA_TABLESPACE_THRESHOLDS ; ---Space Utilization Threshold settings for all tablespaces
select * from DBA_AUTOTASK_OPERATION ; ---Automated Maintenance Task Operation Configuration
select * from DBA_AUTOTASK_TASK ; ---Information about current and past autmated maintenance tasks
select * from DBA_AUTOTASK_SCHEDULE ; ---Schedule of Maintenance Windows for the next 32 days
select * from DBA_AUTOTASK_CLIENT_JOB ; ---Current automated maintenance jobs
select * from DBA_AUTOTASK_WINDOW_CLIENTS ; ---Description of per-mainteance window activity
select * from DBA_AUTOTASK_WINDOW_HISTORY ; ---Automated Maintenance view of window history
select * from DBA_AUTOTASK_CLIENT_HISTORY ; ---Automated Maintenance Jobs history
select * from DBA_AUTOTASK_JOB_HISTORY ; ---Automated Maintenance Jobs history
select * from DBA_AUTOTASK_CLIENT ; ---Autotask Client Summary Information
select * from DBA_HIST_BASELINE ; ---Baseline Metadata Information
select * from DBA_HIST_BASELINE_DETAILS ; ---Baseline Stats on per Instance Level
select * from DBA_HIST_SQLBIND ; ---SQL Bind Information
select * from DBA_TUNE_MVIEW ; ---Catalog View to show the result after executing TUNE_MVIEW() API
select * from DBA_FLASHBACK_ARCHIVE ; ---Description of the flashback archives available in the system
select * from DBA_FLASHBACK_ARCHIVE_TS ; ---Description of tablespaces in the flashback archives available in the system
select * from DBA_FLASHBACK_ARCHIVE_TABLES ; ---Information about the tables that are enabled for Flashback Archive
select * from DBA_CAPTURE ; ---Details about the capture process
select * from DBA_STREAMS_SPLIT_MERGE ; ---view of details of split/merge jobs/status about streams
select * from DBA_STREAMS_SPLIT_MERGE_HIST ; ---history view of details of split/merge jobs/status about streams
select * from DBA_CAPTURE_PARAMETERS ; ---All parameters for capture process
select * from DBA_CAPTURE_PREPARED_DATABASE ; ---Is the local database prepared for instantiation?
select * from DBA_CAPTURE_PREPARED_SCHEMAS ; ---All schemas at the local database that are prepared for instantiation
select * from DBA_CAPTURE_PREPARED_TABLES ; ---All tables prepared for instantiation
select * from DBA_SYNC_CAPTURE_PREPARED_TABS ; ---All tables prepared for synchronous capture instantiation
select * from DBA_CAPTURE_EXTRA_ATTRIBUTES ; ---Extra attributes for a capture process
select * from DBA_REGISTERED_ARCHIVED_LOG ; ---Details about the registered log files
select * from DBA_SYNC_CAPTURE ; ---Details about the sync capture process
select * from DBA_APPLY ; ---Details about the apply process
select * from DBA_APPLY_PARAMETERS ; ---All parameters for apply process
select * from DBA_APPLY_INSTANTIATED_OBJECTS ; ---Details about objects instantiated
select * from DBA_APPLY_INSTANTIATED_SCHEMAS ; ---Details about schemas instantiated
select * from DBA_APPLY_INSTANTIATED_GLOBAL ; ---Details about database instantiated
select * from DBA_APPLY_KEY_COLUMNS ; ---alternative key columns for a table for STREAMS
select * from DBA_APPLY_CONFLICT_COLUMNS ; ---Details about conflict resolution
select * from DBA_APPLY_TABLE_COLUMNS ; ---Details about the destination table columns
select * from DBA_APPLY_DML_HANDLERS ; ---Details about the dml handler
select * from DBA_APPLY_PROGRESS ; ---Information about the progress made by apply process
select * from DBA_APPLY_ERROR ; ---Error transactions
select * from DBA_APPLY_ERROR_MESSAGES ; ---Details about individual messages in an error transaction
select * from DBA_APPLY_ENQUEUE ; ---Details about the apply enqueue action
select * from DBA_APPLY_EXECUTE ; ---Details about the apply execute action
select * from DBA_APPLY_SPILL_TXN ; ---Streams apply spilled transactions info
select * from DBA_XSTREAM_OUTBOUND ; ---Details about the XStream outbound server
select * from DBA_XSTREAM_INBOUND ; ---Details about the XStream inbound server
select * from DBA_APPLY_CHANGE_HANDLERS ; ---Details about apply change handler
select * from DBA_APPLY_DML_CONF_HANDLERS ; ---Details about DML conflict handlers
select * from DBA_APPLY_DML_CONF_COLUMNS ; ---Details about DML conflict handler column groups
select * from DBA_APPLY_HANDLE_COLLISIONS ; ---Details about apply collision handlers
select * from DBA_APPLY_REPERROR_HANDLERS ; ---Details about apply reperror handlers
select * from DBA_PROPAGATION ; ---Streams propagation in the database
select * from DBA_FILE_GROUPS ; ---Details about file groups
select * from DBA_FILE_GROUP_VERSIONS ; ---Details about file group versions
select * from DBA_FILE_GROUP_EXPORT_INFO ; ---Details about export information of file group versions
select * from DBA_FILE_GROUP_FILES ; ---Details about file group files
select * from DBA_FILE_GROUP_TABLESPACES ; ---Details about the transportable tablespaces in the file group repository
select * from DBA_FILE_GROUP_TABLES ; ---Details about the tables in the file group repository
select * from DBA_STREAMS_TP_DATABASE ; ---DBA Streams Database
select * from DBA_STREAMS_TP_COMPONENT ; ---DBA Streams Component
select * from DBA_STREAMS_TP_COMPONENT_LINK ; ---DBA Streams Component Link (Streams Topology Links)
select * from DBA_STREAMS_TP_COMPONENT_STAT ; ---DBA Streams Component Statistics
select * from DBA_STREAMS_TP_PATH_STAT ; ---DBA Streams Path Statistics
select * from DBA_STREAMS_TP_PATH_BOTTLENECK ; ---DBA Streams Path Bottleneck
select * from DBA_STREAMS_MESSAGE_CONSUMERS ; ---Streams messaging consumers
select * from DBA_STREAMS_GLOBAL_RULES ; ---Global rules created by streams administrative APIs
select * from DBA_STREAMS_SCHEMA_RULES ; ---Schema rules created by streams administrative APIs
select * from DBA_STREAMS_TABLE_RULES ; ---Table rules created by streams administrative APIs
select * from DBA_STREAMS_MESSAGE_RULES ; ---Rules for Streams messaging
select * from DBA_STREAMS_RULES ; ---Rules used by Streams processes
select * from DBA_SYNC_CAPTURE_TABLES ; ---All tables that are captured by synchronous streams captures.
select * from DBA_XSTREAM_RULES ; ---Details about the XStream server rules
select * from DBA_STREAMS_TRANSFORM_FUNCTION ; ---Rules-based transform functions used by Streams
select * from DBA_STREAMS_ADMINISTRATOR ; ---Users granted the privileges to be a streams administrator
select * from DBA_XSTREAM_ADMINISTRATOR ; ---Users granted the privileges to be a XStream administrator
select * from DBA_STREAMS_TRANSFORMATIONS ; ---Transformations defined on rules
select * from DBA_STREAMS_RENAME_SCHEMA ; ---Rename schema transformations
select * from DBA_STREAMS_RENAME_TABLE ; ---Rename table transformations
select * from DBA_STREAMS_DELETE_COLUMN ; ---Delete column transformations
select * from DBA_STREAMS_KEEP_COLUMNS ; ---Keep columns transformations
select * from DBA_STREAMS_RENAME_COLUMN ; ---Rename column transformations
select * from DBA_STREAMS_ADD_COLUMN ; ---Add column transformations
select * from DBA_RECOVERABLE_SCRIPT ; ---Details about recoverable operations
select * from DBA_RECOVERABLE_SCRIPT_HIST ; ---Details about executed or purged recoverable operations
select * from DBA_RECOVERABLE_SCRIPT_PARAMS ; ---Details about the recoverable operation parameters
select * from DBA_RECOVERABLE_SCRIPT_BLOCKS ; ---Details about the recoverable script blocks
select * from DBA_RECOVERABLE_SCRIPT_ERRORS ; ---Details showing errors during script execution
select * from DBA_GOLDENGATE_PRIVILEGES ; ---Details about goldengate privileges
select * from DBA_COMPARISON ; ---Details about the comparison object
select * from DBA_COMPARISON_COLUMNS ; ---Details about the comparison object's columns
select * from DBA_COMPARISON_SCAN ; ---Details about a comparison scan
select * from DBA_COMPARISON_SCAN_SUMMARY ; ---Details about a comparison scan
select * from DBA_COMPARISON_SCAN_VALUES ; ---Details about a comparison scan's values
select * from DBA_COMPARISON_ROW_DIF ; ---Details about the differing rows in a comparison scan
select * from DBA_STREAMS_COLUMNS ; ---Supportability info about streams columns
select * from DBA_STREAMS_UNSUPPORTED ; ---List of all the tables that are not supported by Streams in this release
select * from DBA_STREAMS_NEWLY_SUPPORTED ; ---List of tables that are newly supported by Streams capture
select * from DBA_XSTREAM_OUT_SUPPORT_MODE ; ---List of support mode for objects by XStream Out
select * from DBA_JAVA_POLICY ; ---java security Permissions for all users
select * from DBA_JAVA_CLASSES ; ---class level information of all stored java classes
select * from DBA_JAVA_LAYOUTS ; ---class layout information about stored java class
select * from DBA_JAVA_IMPLEMENTS ; ---interfaces implemented by the stored java class
select * from DBA_JAVA_INNERS ; ---list of inner classes refered by the stored java class
select * from DBA_JAVA_FIELDS ; ---field information of all stored java class
select * from DBA_JAVA_METHODS ; ---method information of all stored java class
select * from DBA_JAVA_ARGUMENTS ; ---argument information of all stored java class
select * from DBA_JAVA_THROWS ; ---list of exceptions thrown from a method of a class owned by user
select * from DBA_JAVA_DERIVATIONS ; ---this view maps java source objects and their derived java class objects and java resource objects  for all java classes
select * from DBA_JAVA_RESOLVERS ; ---resolver of java class owned by user
select * from DBA_JAVA_COMPILER_OPTIONS ; ---all native-compiler options
select * from DBA_EPG_DAD_AUTHORIZATION ; ---DADs authorized to use different user's privileges
select * from DBA_XML_TABLES ; ---Description of all XML tables in the database
select * from DBA_XML_TAB_COLS ; ---Description of all XML tables in the database
select * from DBA_XML_VIEWS ; ---Description of all XML views in the database
select * from DBA_XML_VIEW_COLS ; ---Description of all XML views in the database
select * from DBA_XML_SCHEMAS ; ---Description of all the XML Schemas registered
select * from DBA_XML_INDEXES ; ---Description of all XML indexes in the database
select * from DBA_XML_SCHEMA_IMPORTS ; ---Description of all XML schema first level dependencies on imported XML schemas
select * from DBA_XML_SCHEMA_INCLUDES ; ---Description of all XML schema first level dependencies on included XML schemas
select * from DBA_XML_SCHEMA_DEPENDENCY ; ---Description of all XML schema first level dependencies on imported and included XML schemas
select * from DBA_NETWORK_ACL_PRIVILEGES ; ---Privileges defined in network access control lists
select * from DBA_WALLET_ACLS ; ---Access control lists assigned to restrict access to wallets through PL/SQL network utility packages
select * from DBA_XDS_OBJECTS ; ---All XDS enabled objects in the database
select * from DBA_NETWORK_ACLS ; ---Access control lists assigned to restrict access to network hosts through PL/SQL network utility packages
select * from DBA_XDS_INSTANCE_SETS ; ---All instance sets in the database
select * from DBA_XDS_ATTRIBUTE_SECS ; ---All XDS column security defined in the database
select * from DBA_AW_PROP ; ---Object properties in Analytic Workspaces in the database
select * from DBA_AW_OBJ ; ---Objects in Analytic Workspaces in the database
select * from DBA_REGISTRY_DEPENDENCIES ; ---
select * from DBA_PARALLEL_EXECUTE_CHUNKS ; ---
select * from DBA_SQLSET_PLANS ; ---
select * from DBA_DBFS_HS ; ---
select * from DBA_ADVISOR_DEFINITIONS ; ---
select * from DBA_WORKLOAD_REPLAY_DIVERGENCE ; ---
select * from DBA_WORKLOAD_FILTERS ; ---
select * from DBA_SQLSET_STATEMENTS ; ---
select * from DBA_IAS_OBJECTS_BASE ; ---
select * from DBA_ADVISOR_EXECUTIONS ; ---
select * from DBA_PART_TABLES ; ---
select * from DBA_PART_INDEXES ; ---
select * from DBA_QUEUE_PUBLISHERS ; ---
select * from DBA_ADVISOR_COMMANDS ; ---
select * from DBA_ADVISOR_SQLPLANS ; ---
select * from DBA_ADVISOR_SQLW_PARAMETERS ; ---
select * from DBA_REPCAT ; ---
select * from DBA_BLOCKERS ; ---
select * from DBA_IAS_TEMPLATES ; ---
select * from DBA_EXPORT_PATHS ; ---
select * from DBA_ADDM_SYSTEM_DIRECTIVES ; ---
select * from DBA_PARALLEL_EXECUTE_TASKS ; ---
select * from DBA_ADVISOR_OBJECT_TYPES ; ---
select * from DBA_SQLSET_BINDS ; ---
select * from DBA_TYPE_XMLSCHEMA_DEP ; ---
select * from DBA_ADVISOR_OBJECTS ; ---
select * from DBA_WORKLOAD_CONNECTION_MAP ; ---
select * from DBA_ADVISOR_DIR_INSTANCES ; ---
select * from DBA_IAS_GEN_STMTS ; ---
select * from DBA_LOB_PARTITIONS ; ---
select * from DBA_ADVISOR_TASKS ; ---
select * from DBA_SQLSET ; ---
select * from DBA_ADVISOR_DEF_PARAMETERS ; ---
select * from DBA_LOCK ; ---
select * from DBA_IAS_OBJECTS ; ---
select * from DBA_PART_KEY_COLUMNS ; ---
select * from DBA_ADVISOR_FDG_BREAKDOWN ; ---
select * from DBA_ADVISOR_SQLA_TABVOL ; ---
select * from DBA_SQLTUNE_STATISTICS ; ---
select * from DBA_ADVISOR_SQLA_COLVOL ; ---
select * from DBA_ADVISOR_PARAMETERS ; ---
select * from DBA_LOGMNR_LOG ; ---
select * from DBA_TRANSFORMATIONS ; ---
select * from DBA_PART_HISTOGRAMS ; ---
select * from DBA_IAS_PREGEN_STMTS ; ---
select * from DBA_ADVISOR_SQLA_WK_STMTS ; ---
select * from DBA_ADVISOR_USAGE ; ---
select * from DBA_ADVISOR_SQLW_STMTS ; ---
select * from DBA_ADDM_FDG_BREAKDOWN ; ---
select * from DBA_QUEUE_SCHEDULES ; ---
select * from DBA_DBFS_HS_COMMANDS ; ---
select * from DBA_AQ_AGENTS ; ---
select * from DBA_SUBPARTITION_TEMPLATES ; ---
select * from DBA_SUBPART_KEY_COLUMNS ; ---
select * from DBA_SUBPART_HISTOGRAMS ; ---
select * from DBA_AQ_AGENT_PRIVS ; ---
select * from DBA_ADVISOR_TEMPLATES ; ---
select * from DBA_ADDM_FINDINGS ; ---
select * from DBA_PART_LOBS ; ---
select * from DBA_LOB_TEMPLATES ; ---
select * from DBA_JAVA_NCOMPS ; ---
select * from DBA_REGISTRY_HIERARCHY ; ---
select * from DBA_SQLTUNE_BINDS ; ---
select * from DBA_IAS_GEN_STMTS_EXP ; ---
select * from DBA_REGISTRY_PROGRESS ; ---
select * from DBA_ADVISOR_DIR_DEFINITIONS ; ---
select * from DBA_ADVISOR_JOURNAL ; ---
select * from DBA_SQLSET_REFERENCES ; ---
select * from DBA_SERVER_REGISTRY ; ---
select * from DBA_ADVISOR_FINDING_NAMES ; ---
select * from DBA_ADVISOR_RECOMMENDATIONS ; ---
select * from DBA_KGLLOCK ; ---
select * from DBA_DDL_LOCKS ; ---
select * from DBA_ADVISOR_LOG ; ---
select * from DBA_IAS_CONSTRAINT_EXP ; ---
select * from DBA_SQL_MONITOR_USAGE ; ---
select * from DBA_ADVISOR_SQLA_TABLES ; ---
select * from DBA_ADVISOR_SQLSTATS ; ---
select * from DBA_TAB_SUBPARTITIONS ; ---
select * from DBA_ADVISOR_ACTIONS ; ---
select * from DBA_FLASHBACK_TXN_REPORT ; ---
select * from DBA_SQLTUNE_PLANS ; ---
select * from DBA_ADDM_INSTANCES ; ---
select * from DBA_ADVISOR_SQLW_SUM ; ---
select * from DBA_ADVISOR_SQLW_COLVOL ; ---
select * from DBA_WAITERS ; ---
select * from DBA_ADVISOR_EXECUTION_TYPES ; ---
select * from DBA_ADVISOR_SQLA_WK_SUM ; ---
select * from DBA_IAS_SITES ; ---
select * from DBA_ADVISOR_SQLW_JOURNAL ; ---
select * from DBA_REGISTRY ; ---
select * from DBA_ADVISOR_SQLW_TEMPLATES ; ---
select * from DBA_DBFS_HS_FIXED_PROPERTIES ; ---
select * from DBA_WORKLOAD_REPLAY_FILTER_SET ; ---
select * from DBA_LOCK_INTERNAL ; ---
select * from DBA_KEEPSIZES ; ---
select * from DBA_ADVISOR_DIR_TASK_INST ; ---
select * from DBA_ADVISOR_RATIONALE ; ---
select * from DBA_FLASHBACK_TXN_STATE ; ---
select * from DBA_ADVISOR_SQLW_TABLES ; ---
select * from DBA_IND_SUBPARTITIONS ; ---
select * from DBA_PART_COL_STATISTICS ; ---
select * from DBA_TAB_PARTITIONS ; ---
select * from DBA_DML_LOCKS ; ---
select * from DBA_XMLSCHEMA_LEVEL_VIEW ; ---
select * from DBA_IAS_POSTGEN_STMTS ; ---
select * from DBA_LOGMNR_SESSION ; ---
select * from DBA_ADVISOR_EXEC_PARAMETERS ; ---
select * from DBA_INVALID_OBJECTS ; ---
select * from DBA_XMLSCHEMA_LEVEL_VIEW_DUP ; ---
select * from DBA_REGISTRY_HISTORY ; ---
select * from DBA_REGISTRY_LOG ; ---
select * from DBA_SUBPART_COL_STATISTICS ; ---
select * from DBA_ATTRIBUTE_TRANSFORMATIONS ; ---
select * from DBA_ADDM_TASK_DIRECTIVES ; ---
select * from DBA_LOB_SUBPARTITIONS ; ---
select * from DBA_ANALYZE_OBJECTS ; ---
select * from DBA_WORKLOAD_CAPTURES ; ---
select * from DBA_ADVISOR_PARAMETERS_PROJ ; ---
select * from DBA_WORKLOAD_REPLAYS ; ---
select * from DBA_ADVISOR_SQLA_REC_SUM ; ---
select * from DBA_LOGMNR_PURGED_LOG ; ---
select * from DBA_ADVISOR_FINDINGS ; ---
select * from DBA_SQLTUNE_RATIONALE_PLAN ; ---
select * from DBA_IND_PARTITIONS ; ---
select * from DBA_DBFS_HS_PROPERTIES ; ---
select * from DBA_HIST_ASH_SNAPSHOT ; ---
select * from DBA_ADDM_TASKS ; ---
select * from DBA_REGISTRY_DATABASE ; ---
select * from DBA_ADVISOR_SQLA_WK_MAP ; ---
select * from DBA_IAS_OBJECTS_EXP ; ---
select * from DBA_ADVISOR_SQLW_TABVOL ; ---
select * from USER_CONS_COLUMNS ; ---Information about accessible columns in constraint definitions
select * from USER_LOG_GROUP_COLUMNS ; ---Information about columns in log group definitions
select * from USER_LOBS ; ---Description of the user's own LOBs contained in the user's own tables
select * from USER_CATALOG ; ---Tables, Views, Synonyms and Sequences owned by the user
select * from USER_CLUSTERS ; ---Descriptions of user's own clusters
select * from USER_CLU_COLUMNS ; ---Mapping of table columns to cluster columns
select * from USER_COL_COMMENTS ; ---Comments on columns of user's tables and views
select * from USER_COL_PRIVS ; ---Grants on columns for which the user is the owner, grantor or grantee
select * from USER_COL_PRIVS_MADE ; ---All grants on columns of objects owned by the user
select * from USER_COL_PRIVS_RECD ; ---Grants on columns for which the user is the grantee
select * from USER_ENCRYPTED_COLUMNS ; ---Encryption information on columns of tables owned by the user
select * from USER_INDEXES ; ---Description of the user's own indexes
select * from USER_IND_COLUMNS ; ---COLUMNs comprising user's INDEXes and INDEXes on user's TABLES
select * from USER_IND_EXPRESSIONS ; ---Functional index expressions in user's indexes and indexes on user's tables
select * from USER_JOIN_IND_COLUMNS ; ---Join Index columns comprising the join conditions
select * from USER_OBJECTS ; ---Objects owned by the user
select * from USER_OBJECTS_AE ; ---Objects owned by the user
select * from USER_ROLE_PRIVS ; ---Roles granted to current user
select * from USER_SEQUENCES ; ---Description of the user's own SEQUENCEs
select * from USER_SYNONYMS ; ---The user's private synonyms
select * from USER_TABLES ; ---Description of the user's own relational tables
select * from USER_OBJECT_TABLES ; ---Description of the user's own object tables
select * from USER_ALL_TABLES ; ---Description of all object and relational tables owned by the user's
select * from USER_TAB_COLS ; ---Columns of user's tables, views and clusters
select * from USER_TAB_COLUMNS ; ---Columns of user's tables, views and clusters
select * from USER_TAB_COMMENTS ; ---Comments on the tables and views owned by the user
select * from USER_TAB_PRIVS ; ---Grants on objects for which the user is the owner, grantor or grantee
select * from USER_TAB_PRIVS_MADE ; ---All grants on objects owned by the user
select * from USER_TAB_PRIVS_RECD ; ---Grants on objects for which the user is the grantee
select * from USER_VIEWS ; ---Description of the user's own views
select * from USER_VIEWS_AE ; ---Description of the user's own views
select * from USER_CONSTRAINTS ; ---Constraint definitions on user's own tables
select * from USER_LOG_GROUPS ; ---Log group definitions on user's own tables
select * from USER_CLUSTER_HASH_EXPRESSIONS ; ---Hash functions for the user's hash clusters
select * from USER_UPDATABLE_COLUMNS ; ---Description of updatable columns
select * from USER_UNUSED_COL_TABS ; ---User tables with unused columns
select * from USER_PARTIAL_DROP_TABS ; ---User tables with unused columns
select * from USER_RESUMABLE ; ---Resumable session information for current user
select * from USER_EDITIONING_VIEWS ; ---Descriptions of the user's own Editioning Views
select * from USER_EDITIONING_VIEWS_AE ; ---Descriptions of the user's own Editioning Views
select * from USER_EDITIONING_VIEW_COLS ; ---Relationship between columns of user's Editioning Views and the table columns to which they map
select * from USER_EDITIONING_VIEW_COLS_AE ; ---Relationship between columns of user's Editioning Views and the table columns to which they map
select * from USER_LIBRARIES ; ---Description of the user's own libraries
select * from USER_PROCEDURES ; ---Description of the user functions/procedures/packages/types/triggers
select * from USER_STORED_SETTINGS ; ---Parameter settings for objects owned by the user
select * from USER_PLSQL_OBJECT_SETTINGS ; ---Compiler settings of stored objects owned by the user
select * from USER_ARGUMENTS ; ---Arguments in object accessible to the user
select * from USER_ASSEMBLIES ; ---Description of the user's own assemblies
select * from USER_IDENTIFIERS ; ---Identifiers in stored objects accessible to the user
select * from USER_DB_LINKS ; ---Database links owned by the user
select * from USER_RECYCLEBIN ; ---User view of his recyclebin
select * from USER_RESOURCE_LIMITS ; ---Display resource limit of the user
select * from USER_PASSWORD_LIMITS ; ---Display password limits of the user
select * from USER_USERS ; ---Information about the current user
select * from USER_OBJ_AUDIT_OPTS ; ---Auditing options for user's own tables and views with atleast one option set
select * from USER_AUDIT_TRAIL ; ---Audit trail entries relevant to the user
select * from USER_AUDIT_SESSION ; ---All audit trail records concerning CONNECT and DISCONNECT
select * from USER_AUDIT_STATEMENT ; ---Audit trail records concerning  grant, revoke, audit, noaudit and alter system
select * from 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
select * from USER_SYS_PRIVS ; ---System privileges granted to current user
select * from USER_PROXIES ; ---Description of connections the user is allowed to proxy
select * from USER_TYPES ; ---Description of the user's own types
select * from USER_COLL_TYPES ; ---Description of the user's own named collection types
select * from USER_TYPE_ATTRS ; ---Description of attributes of the user's own types
select * from USER_TYPE_METHODS ; ---Description of methods of the user's own types
select * from USER_METHOD_PARAMS ; ---Description of method parameters of the user's own types
select * from USER_METHOD_RESULTS ; ---Description of method results of the user's own types
select * from USER_SQLJ_TYPES ; ---Description of the user's own types
select * from USER_TYPE_VERSIONS ; ---Description of each version of the user's types
select * from USER_PENDING_CONV_TABLES ; ---All user's tables which are not upgraded to the latest type version
select * from USER_SQLJ_TYPE_ATTRS ; ---Description of attributes of the user's own types
select * from USER_SQLJ_TYPE_METHODS ; ---Description of methods of the user's own types
select * from USER_OLDIMAGE_COLUMNS ; ---Gives all object tables and columns in old (8.0) image format
select * from USER_NESTED_TABLE_COLS ; ---Columns of nested tables
select * from USER_REFS ; ---Description of the user's own REF columns contained in the user's own tables
select * from USER_NESTED_TABLES ; ---Description of nested tables contained in the user's own tables
select * from USER_VARRAYS ; ---Description of varrays contained in the user's own tables
select * from USER_OBJ_COLATTRS ; ---Description of object columns and attributes contained in tables owned by the user
select * from USER_CONS_OBJ_COLUMNS ; ---List of types an object column or attribute is constrained to in the tables owned by the user
select * from USER_OPERATORS ; ---All user operators
select * from USER_OPBINDINGS ; ---All binding functions or methods on operators defined by the user
select * from USER_OPANCILLARY ; ---All ancillary opertors defined by user
select * from USER_OPARGUMENTS ; ---All operator arguments of operators defined by user
select * from USER_OPERATOR_COMMENTS ; ---Comments for user-defined operators
select * from USER_INDEXTYPES ; ---All user indextypes
select * from USER_INDEXTYPE_COMMENTS ; ---Comments for user-defined indextypes
select * from USER_INDEXTYPE_ARRAYTYPES ; ---All array types specified by the indextype
select * from USER_INDEXTYPE_OPERATORS ; ---All user indextype operators
select * from USER_SECONDARY_OBJECTS ; ---All secondary objects for domain indexes
select * from USER_SOURCE_TABLES ; ---Source tables available for Change Data Capture
select * from USER_PUBLISHED_COLUMNS ; ---Source columns available for Change Data Capture
select * from USER_SUBSCRIPTIONS ; ---Change Data Capture subscriptions
select * from USER_SUBSCRIBED_TABLES ; ---Change Data Capture subscribed tables
select * from USER_SUBSCRIBED_COLUMNS ; ---Change Data Capture subscribed columns
select * from USER_EXTERNAL_TABLES ; ---Description of the user's own external tables
select * from USER_EXTERNAL_LOCATIONS ; ---Description of the user's external tables locations
select * from USER_MINING_MODELS ; ---Description of the user's own models
select * from USER_MINING_MODEL_ATTRIBUTES ; ---Description of the user's own model attributes
select * from USER_MINING_MODEL_SETTINGS ; ---Description of the user's own model settings
select * from USER_TAB_COL_STATISTICS ; ---Columns of user's tables, views and clusters
select * from USER_TAB_HISTOGRAMS ; ---Histograms on columns of user's tables
select * from USER_ASSOCIATIONS ; ---All assocations defined by the user
select * from USER_USTATS ; ---All statistics on tables or indexes owned by the user
select * from USER_TAB_MODIFICATIONS ; ---Information regarding modifications to tables
select * from USER_TAB_STATS_HISTORY ; ---History of table statistics modifications
select * from USER_TAB_STAT_PREFS ; ---Statistics preferences for tables
select * from USER_TAB_PENDING_STATS ; ---History of table statistics modifications
select * from USER_IND_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
select * from USER_COL_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
select * from USER_TAB_HISTGRM_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
select * from USER_DIMENSIONS ; ---Description of the dimension objects accessible to the DBA
select * from USER_DIM_LEVELS ; ---Description of dimension levels visible to DBA
select * from USER_DIM_LEVEL_KEY ; ---Representations of columns of a dimension level
"select * from USER_DIM_ATTRIBUTES ; ---Representation of the relationship between a dimension level and
 a functionally dependent column"
select * from USER_DIM_HIERARCHIES ; ---Representation of a dimension hierarchy
"select * from USER_DIM_CHILD_OF ; ---Representaion of a 1:n hierarchical relationship between a pair of levels in
 a dimension"
select * from USER_DIM_JOIN_KEY ; ---Representation of a join between two dimension tables.
select * from USER_SUMMARIES ; ---Description of the summaries created by the user
select * from USER_MVIEW_ANALYSIS ; ---Description of the materialized views created by the user
select * from USER_MVIEW_AGGREGATES ; ---Description of the materialized view aggregates created by the user
"select * from USER_MVIEW_DETAIL_RELATIONS ; ---Description of the materialized view detail tables of the materialized
views created by the user"
"select * from USER_MVIEW_KEYS ; ---Description of the columns that appear in the GROUP BY
list of a materialized view  created by the user"
"select * from USER_MVIEW_JOINS ; ---Description of a join between two columns in the
WHERE clause of a materialized view created by the user"
select * from USER_MVIEW_COMMENTS ; ---Comments on materialized views owned by the user
select * from USER_REWRITE_EQUIVALENCES ; ---Description of all rewrite equivalence owned by the user
select * from USER_MVIEW_DETAIL_PARTITION ; ---Freshness information of all PCT materialized views in the database
select * from USER_MVIEW_DETAIL_SUBPARTITION ; ---Freshness information of all PCT materialized views in the database
select * from 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
select * from 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
select * from USER_ERRORS ; ---Current errors on stored objects owned by the user
select * from USER_ERRORS_AE ; ---Current errors on stored objects owned by the user
select * from USER_SOURCE_AE ; ---Source of stored objects accessible to the user
select * from USER_SOURCE ; ---Source of stored objects accessible to the user
select * from USER_TRIGGERS ; ---Triggers having FOLLOWS or PRECEDES ordering owned by the user
select * from USER_INTERNAL_TRIGGERS ; ---Description of the internal triggers on the user's own tables
select * from USER_TRIGGER_COLS ; ---Column usage in user's triggers
select * from USER_DEPENDENCIES ; ---Dependencies to and from a users objects
select * from USER_OBJECT_SIZE ; ---Sizes, in bytes, of various pl/sql objects
select * from USER_JOBS ; ---All jobs owned by this user
select * from USER_SEGMENTS ; ---Storage allocated for all database segments
select * from USER_EXTENTS ; ---Extents comprising segments owned by the user
select * from USER_FREE_SPACE ; ---Free extents in tablespaces accessible to the user
select * from USER_TABLESPACES ; ---Description of accessible tablespaces
select * from USER_TS_QUOTAS ; ---Tablespace quotas for the user
select * from USER_RULE_SETS ; ---Rule sets owned by the user
select * from USER_RULESETS ; ---Rulesets owned by the user: maintained for backward compatibility
select * from USER_RULES ; ---Rules owned by the user
select * from USER_RULE_SET_RULES ; ---Rules in user rule sets
select * from USER_EVALUATION_CONTEXTS ; ---rule evaluation contexts owned by user
select * from USER_EVALUATION_CONTEXT_TABLES ; ---tables in user rule evaluation contexts
select * from USER_EVALUATION_CONTEXT_VARS ; ---variables in user rule evaluation contexts
select * from USER_SNAPSHOTS ; ---Snapshots the user can look at
select * from USER_SNAPSHOT_LOGS ; ---All snapshot logs owned by the user
select * from USER_REFRESH ; ---All the refresh groups
select * from USER_REFRESH_CHILDREN ; ---All the objects in refresh groups, where the user owns the refresh group
select * from USER_REGISTERED_SNAPSHOTS ; ---Remote snapshots of local tables currently using logs owned by the user
select * from USER_MVIEWS ; ---All materialized views in the database
select * from USER_MVIEW_REFRESH_TIMES ; ---Materialized views and their last refresh times for each master table that the user can look at
select * from USER_MVIEW_LOGS ; ---All materialized view logs owned by the user
select * from USER_BASE_TABLE_MVIEWS ; ---All materialized views with log(s) owned by the user in the database
select * from USER_REGISTERED_MVIEWS ; ---Remote materialized views of local tables currently using logs owned by the user
select * from USER_POLICIES ; ---All row level security policies for synonyms, tables, or views owned by the user
select * from USER_POLICY_GROUPS ; ---All policy groups defined for any synonym, table, or view
select * from USER_POLICY_CONTEXTS ; ---All policy driving context defined for synonyms, tables, or views in current schema
select * from USER_SEC_RELEVANT_COLS ; ---Security Relevant columns of VPD policies for tables or views owned by the user
select * from USER_AUDIT_POLICIES ; ---All fine grained auditing policies for objects in user schema
select * from USER_AUDIT_POLICY_COLUMNS ; ---Users fine grained auditing policy columns in the database
select * from USER_CHANGE_NOTIFICATION_REGS ; ---change notification registrations for current user
select * from USER_CQ_NOTIFICATION_QUERIES ; ---Description of registered queries for CQ notification
select * from USER_SUBSCR_REGISTRATIONS ; ---All subscription registrations created by the user
select * from USER_QUEUE_TABLES ; ---All queue tables created by the user
select * from USER_QUEUES ; ---All queues owned by the user
select * from USER_RSRC_CONSUMER_GROUP_PRIVS ; ---Switch privileges for consumer groups for the user
select * from USER_RSRC_MANAGER_SYSTEM_PRIVS ; ---system privileges for the resource manager for the user
select * from USER_OUTLINES ; ---Stored outlines owned by the user
select * from USER_OUTLINE_HINTS ; ---Hints stored in outlines owned by the user
select * from USER_DATAPUMP_JOBS ; ---Datapump jobs for current user
select * from USER_REPGROUP_PRIVILEGES ; ---Information about users who are registered for object group privileges
select * from USER_REPGROUP ; ---Replication information about the current user
select * from USER_REPSITES ; ---N-way replication information about the current user
select * from USER_REPSCHEMA ; ---N-way replication information about the current user
select * from USER_REPOBJECT ; ---Replication information about the current user's objects
select * from USER_REPCOLUMN ; ---Replicated columns for the current user's table in ascending order
select * from USER_REPPROP ; ---Propagation information about the current user's objects
select * from USER_REPKEY_COLUMNS ; ---Primary columns for a table using column-level replication
select * from USER_REPGENOBJECTS ; ---Objects generated for the current user to support replication
select * from USER_REPGENERATED ; ---Objects generated for the current user to support replication
select * from USER_REPCATLOG ; ---Information about the current user's asynchronous administration requests
select * from USER_REPDDL ; ---Arguments that do not fit in a single repcat log record
select * from USER_REPPRIORITY_GROUP ; ---Information about user's priority groups
select * from USER_REPPRIORITY ; ---Values and their corresponding priorities in user's priority groups
select * from USER_REPCOLUMN_GROUP ; ---All column groups of user's replicated tables
select * from USER_REPGROUPED_COLUMN ; ---Columns in the all column groups of user's replicated tables
select * from USER_REPRESOLUTION_METHOD ; ---All conflict resolution methods accessible to the user
select * from USER_REPRESOLUTION ; ---Description of all conflict resolutions for user's replicated tables
select * from USER_REPRESOLUTION_STATISTICS ; ---Statistics for conflict resolutions for user's replicated tables
select * from USER_REPRESOL_STATS_CONTROL ; ---Information about statistics collection for conflict resolutions for user's replicated tables
select * from USER_REPPARAMETER_COLUMN ; ---All columns used for resolving conflicts in user's replicated tables
select * from USER_REPAUDIT_ATTRIBUTE ; ---Information about attributes automatically maintained for replication
select * from USER_REPAUDIT_COLUMN ; ---Information about columns in all shadow tables for user's replicated tables
select * from USER_REPFLAVORS ; ---Flavors current user created for replicated object groups
select * from USER_REPFLAVOR_OBJECTS ; ---Replicated user objects in flavors
select * from USER_REPFLAVOR_COLUMNS ; ---Replicated columns from current user's tables in flavors
select * from USER_WARNING_SETTINGS ; ---Warning Parameter settings for objects owned by the user
select * from USER_STAT_EXTENSIONS ; ---Optimizer statistics extensions
select * from USER_TAB_STATISTICS ; ---Optimizer statistics of the user's own tables
select * from USER_IND_STATISTICS ; ---Optimizer statistics for user's own indexes
select * from USER_AWS ; ---Analytic Workspaces owned by the user
select * from USER_AW_PS ; ---Pagespaces in Analytic Workspaces owned by the user
select * from USER_CUBES ; ---OLAP Cubes owned by the user in the database
select * from USER_CUBE_DIMENSIONALITY ; ---OLAP Cube Dimensionality owned by the user in the database
select * from USER_CUBE_MEASURES ; ---OLAP Measures owned by the user in the database
select * from USER_CUBE_DIMENSIONS ; ---OLAP Cube Dimensions owned by the user in the database
select * from USER_CUBE_HIERARCHIES ; ---OLAP Hierarchies owned by the user in the database
select * from USER_CUBE_HIER_LEVELS ; ---OLAP Hierarchy Levels owned by the user in the database
select * from USER_CUBE_DIM_LEVELS ; ---OLAP Dimension Levels owned by the user in the database
select * from USER_CUBE_ATTRIBUTES ; ---OLAP Attributes owned by the user in the database
select * from USER_CUBE_ATTR_VISIBILITY ; ---OLAP Attributes visible for Dimensions, Hierarchies, and Levels
select * from USER_CUBE_DIM_MODELS ; ---OLAP Dimension Models in the database accessible to the user
select * from USER_CUBE_CALCULATED_MEMBERS ; ---OLAP Calculated Members in the database accessible to the user
select * from USER_CUBE_VIEWS ; ---OLAP Cube Views owned by the user in the database
select * from USER_CUBE_VIEW_COLUMNS ; ---OLAP Cube View Columns owned by the user in the database
select * from USER_CUBE_DIM_VIEWS ; ---OLAP Dimension Views owned by the user in the database
select * from USER_CUBE_DIM_VIEW_COLUMNS ; ---OLAP Dimesion View Columns in the database accessible to the user
select * from USER_CUBE_HIER_VIEWS ; ---OLAP Hierarchy Views owner by the user in the database
select * from USER_CUBE_HIER_VIEW_COLUMNS ; ---OLAP Hierarchy View Columns owned by the user in the database
select * from USER_MEASURE_FOLDERS ; ---OLAP Measure Folders owned by the user in the database
select * from USER_MEASURE_FOLDER_CONTENTS ; ---OLAP Measure Folder Contents owned by the user in the database
select * from USER_CUBE_BUILD_PROCESSES ; ---OLAP Build Processes owned by the user in the database
select * from USER_QUEUE_SUBSCRIBERS ; ---queue subscribers under a user'schema
select * from USER_SCHEDULER_PROGRAMS ; ---Scheduler programs owned by the current user
select * from USER_SCHEDULER_DESTS ; ---Destination objects for jobs in the database owned by current user
select * from USER_SCHEDULER_DB_DESTS ; ---User-owned destination objects in the database pointing to remote databases
select * from USER_SCHEDULER_JOB_DESTS ; ---State of all jobs owned by current user at each of their destinations
select * from USER_SCHEDULER_JOBS ; ---All scheduler jobs in the database
select * from USER_SCHEDULER_PROGRAM_ARGS ; ---All arguments of all scheduler programs in the database
select * from USER_SCHEDULER_JOB_ARGS ; ---All arguments with set values of all scheduler jobs in the database
select * from USER_SCHEDULER_JOB_LOG ; ---Logged information for all scheduler jobs
select * from USER_SCHEDULER_JOB_RUN_DETAILS ; ---The details of a job run
select * from USER_SCHEDULER_GROUP_MEMBERS ; ---Members of all scheduler object groups owned by current user
select * from USER_SCHEDULER_GROUPS ; ---All scheduler object groups owned by current user
select * from USER_SCHEDULER_SCHEDULES ; ---Schedules belonging to the current user
select * from USER_SCHEDULER_REMOTE_JOBSTATE ; ---Remote state of all jobs originating from this database owned by current user
select * from USER_SCHEDULER_CHAINS ; ---All scheduler chains owned by the current user
select * from USER_SCHEDULER_CHAIN_RULES ; ---All rules from scheduler chains owned by the current user
select * from USER_SCHEDULER_CHAIN_STEPS ; ---All steps of scheduler chains owned by the current user
select * from USER_SCHEDULER_RUNNING_CHAINS ; ---All steps of chains being run by jobs owned by the current user
select * from USER_SCHEDULER_CREDENTIALS ; ---Scheduler credentials owned by the current user
select * from USER_SCHEDULER_FILE_WATCHERS ; ---Scheduler file watch requests owned by the current user
select * from USER_SCHEDULER_NOTIFICATIONS ; ---All e-mail notifications for jobs owned by the current user
select * from USER_TUNE_MVIEW ; ---tune_mview catalog view owned by the user
select * from USER_FLASHBACK_ARCHIVE ; ---Description of the flashback archives available to the user
select * from USER_FLASHBACK_ARCHIVE_TABLES ; ---Information about the user tables that are enabled for Flashback Archive
select * from USER_APPLY_ERROR ; ---Error transactions owned by an apply visible to the current user
select * from USER_FILE_GROUPS ; ---Details about file groups
select * from USER_FILE_GROUP_VERSIONS ; ---Details about file group versions
select * from USER_FILE_GROUP_EXPORT_INFO ; ---Details about export information of file group versions
select * from USER_FILE_GROUP_FILES ; ---Details about file group files
select * from USER_FILE_GROUP_TABLESPACES ; ---Details about the transportable tablespaces in the file group repository
select * from USER_FILE_GROUP_TABLES ; ---Details about the tables in the file group repository
select * from USER_GOLDENGATE_PRIVILEGES ; ---Details about goldengate privileges
select * from USER_COMPARISON ; ---Details about the user's comparison objects
select * from USER_COMPARISON_COLUMNS ; ---Details about the comparison object's columns
select * from USER_COMPARISON_SCAN ; ---Details about a comparison scan
select * from USER_COMPARISON_SCAN_SUMMARY ; ---Details about a comparison scan
select * from USER_COMPARISON_SCAN_VALUES ; ---Details about a comparison scan's values
select * from USER_COMPARISON_ROW_DIF ; ---Details about the differing rows in a comparison scan
select * from USER_JAVA_POLICY ; ---java security Permissions for current user
select * from USER_JAVA_CLASSES ; ---class level information of stored java class owned by the user
select * from USER_JAVA_LAYOUTS ; ---class layout information about stored java class owned by the user
select * from USER_JAVA_IMPLEMENTS ; ---interfaces implemented by the stored java class owned by user
select * from USER_JAVA_INNERS ; ---list of inner classes refered by the stored java class owned by user
select * from USER_JAVA_FIELDS ; ---field information of stored java class owned by the user
select * from USER_JAVA_METHODS ; ---method information of stored java class owned by the user
select * from USER_JAVA_ARGUMENTS ; ---argument information of stored java class owned by the user
select * from USER_JAVA_THROWS ; ---list of exceptions thrown from a method of a class owned by user
select * from 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
select * from USER_JAVA_RESOLVERS ; ---resolver of java class owned by user
select * from USER_JAVA_NCOMPS ; ---ncomp related information of java classes owned by user
select * from USER_JAVA_COMPILER_OPTIONS ; ---native compiler options provided by the user
select * from USER_EPG_DAD_AUTHORIZATION ; ---DADs authorized to use the user's privileges
select * from USER_XML_TABLES ; ---Description of the user's own XMLType tables
select * from USER_XML_TAB_COLS ; ---Description of the user's own XMLType tables
select * from USER_XML_VIEWS ; ---Description of the user's own XMLType views
select * from USER_XML_VIEW_COLS ; ---Description of the user's own XMLType views
select * from USER_XML_SCHEMAS ; ---Description of XML Schemas registered by the user
select * from USER_XML_INDEXES ; ---Description of the user's own XMLType indexes
select * from USER_XDS_OBJECTS ; ---All XDS enabled objects owned by the user
select * from USER_XDS_INSTANCE_SETS ; ---All instance sets for objects owned by the user
select * from USER_XDS_ATTRIBUTE_SECS ; ---All objects with column security and owned by the user
select * from USER_NETWORK_ACL_PRIVILEGES ; ---User privileges to access network hosts through PL/SQL network utility packages
select * from USER_AW_PROP ; ---Object properties in Analytic Workspaces owned by the user
select * from USER_AW_OBJ ; ---Objects in Analytic Workspaces owned by the user
select * from USER_ATTRIBUTE_TRANSFORMATIONS ; ---
select * from USER_ADVISOR_SQLSTATS ; ---
select * from USER_PARALLEL_EXECUTE_TASKS ; ---
select * from USER_ADVISOR_SQLW_STMTS ; ---
select * from USER_LOB_SUBPARTITIONS ; ---
select * from USER_REGISTRY ; ---
select * from USER_SQLSET_BINDS ; ---
select * from USER_ADVISOR_LOG ; ---
select * from USER_ADVISOR_DIR_TASK_INST ; ---
select * from USER_ADVISOR_SQLA_WK_MAP ; ---
select * from USER_ADVISOR_OBJECTS ; ---
select * from USER_ADDM_FINDINGS ; ---
select * from USER_ADVISOR_SQLW_PARAMETERS ; ---
select * from USER_ADVISOR_EXEC_PARAMETERS ; ---
select * from USER_ADVISOR_SQLA_TABLES ; ---
select * from USER_ADVISOR_SQLA_COLVOL ; ---
select * from USER_ADVISOR_FINDINGS ; ---
select * from USER_FLASHBACK_TXN_REPORT ; ---
select * from USER_SUBPART_HISTOGRAMS ; ---
select * from USER_TRANSFORMATIONS ; ---
select * from USER_DBFS_HS_COMMANDS ; ---
select * from USER_PART_TABLES ; ---
select * from USER_ADVISOR_TEMPLATES ; ---
select * from USER_SQLTUNE_PLANS ; ---
select * from USER_ADVISOR_RECOMMENDATIONS ; ---
select * from USER_SUBPART_COL_STATISTICS ; ---
select * from USER_TS ; ---
select * from USER_SQLSET_PLANS ; ---
select * from USER_ADVISOR_EXECUTIONS ; ---
select * from USER_PART_INDEXES ; ---
select * from USER_SQLTUNE_STATISTICS ; ---
select * from USER_TAB_PARTITIONS ; ---
select * from USER_LOB_TEMPLATES ; ---
select * from USER_ADVISOR_SQLA_WK_STMTS ; ---
select * from USER_IND_SUBPARTITIONS ; ---
select * from USER_ADVISOR_SQLW_COLVOL ; ---
select * from USER_ADVISOR_JOURNAL ; ---
select * from USER_DBFS_HS ; ---
select * from USER_ADVISOR_SQLW_TEMPLATES ; ---
select * from USER_PART_LOBS ; ---
select * from USER_TAB_SUBPARTITIONS ; ---
select * from USER_ADVISOR_TASKS ; ---
select * from USER_REPCONFLICT ; ---
select * from USER_PART_HISTOGRAMS ; ---
select * from USER_DBFS_HS_FILES ; ---
select * from USER_ADVISOR_SQLW_TABVOL ; ---
select * from USER_SUBPART_KEY_COLUMNS ; ---
select * from USER_ADDM_INSTANCES ; ---
select * from USER_SUBPARTITION_TEMPLATES ; ---
select * from USER_SQLSET ; ---
select * from USER_ADVISOR_SQLA_WK_SUM ; ---
select * from USER_ADDM_TASKS ; ---
select * from USER_SQLSET_REFERENCES ; ---
select * from USER_ADVISOR_SQLW_TABLES ; ---
select * from USER_ADVISOR_SQLW_JOURNAL ; ---
select * from USER_PART_COL_STATISTICS ; ---
select * from USER_ADVISOR_SQLPLANS ; ---
select * from USER_REPCAT ; ---
select * from USER_AQ_AGENT_PRIVS ; ---
select * from USER_SQLTUNE_RATIONALE_PLAN ; ---
select * from USER_DBFS_HS_PROPERTIES ; ---
select * from USER_FLASHBACK_TXN_STATE ; ---
select * from USER_ADDM_TASK_DIRECTIVES ; ---
select * from USER_IND_PARTITIONS ; ---
select * from USER_DBFS_HS_FIXED_PROPERTIES ; ---
select * from USER_XML_COLUMN_NAMES ; ---
select * from USER_ADDM_FDG_BREAKDOWN ; ---
select * from USER_ADVISOR_RATIONALE ; ---
select * from USER_SQLTUNE_BINDS ; ---
select * from USER_ADVISOR_SQLA_TABVOL ; ---
select * from USER_ADVISOR_SQLA_REC_SUM ; ---
select * from USER_PART_KEY_COLUMNS ; ---
select * from USER_ADVISOR_ACTIONS ; ---
select * from USER_ADVISOR_FDG_BREAKDOWN ; ---
select * from USER_QUEUE_SCHEDULES ; ---
select * from USER_SQLSET_STATEMENTS ; ---
select * from USER_ADVISOR_PARAMETERS ; ---
select * from USER_QUEUE_PUBLISHERS ; ---
select * from USER_PARALLEL_EXECUTE_CHUNKS ; ---
select * from USER_LOB_PARTITIONS ; ---
select * from USER_ADVISOR_SQLW_SUM ; ---
select * from ALL_CONS_COLUMNS ; ---Information about accessible columns in constraint definitions
select * from ALL_LOG_GROUP_COLUMNS ; ---Information about columns in log group definitions
select * from ALL_LOBS ; ---Description of LOBs contained in tables accessible to the user
select * from ALL_CATALOG ; ---All tables, views, synonyms, sequences accessible to the user
select * from ALL_CLUSTERS ; ---Description of clusters accessible to the user
select * from ALL_COL_COMMENTS ; ---Comments on columns of accessible tables and views
"select * from ALL_COL_PRIVS ; ---Grants on columns for which the user is the grantor, grantee, owner,
 or an enabled role or PUBLIC is the grantee"
select * from ALL_COL_PRIVS_MADE ; ---Grants on columns for which the user is owner or grantor
select * from ALL_COL_PRIVS_RECD ; ---Grants on columns for which the user, PUBLIC or enabled role is the grantee
select * from ALL_ENCRYPTED_COLUMNS ; ---Encryption information on all accessible columns
select * from ALL_INDEXES ; ---Descriptions of indexes on tables accessible to the user
select * from ALL_IND_COLUMNS ; ---COLUMNs comprising INDEXes on accessible TABLES
select * from ALL_IND_EXPRESSIONS ; ---FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES
select * from ALL_JOIN_IND_COLUMNS ; ---Join Index columns comprising the join conditions
select * from ALL_OBJECTS ; ---Objects accessible to the user
select * from ALL_OBJECTS_AE ; ---Objects accessible to the user
select * from ALL_SEQUENCES ; ---Description of SEQUENCEs accessible to the user
select * from ALL_SYNONYMS ; ---All synonyms for base objects accessible to the user and session
select * from ALL_TABLES ; ---Description of relational tables accessible to the user
select * from ALL_OBJECT_TABLES ; ---Description of all object tables accessible to the user
select * from ALL_ALL_TABLES ; ---Description of all object and relational tables accessible to the user
select * from ALL_TAB_COLS ; ---Columns of user's tables, views and clusters
select * from ALL_TAB_COLUMNS ; ---Columns of user's tables, views and clusters
select * from ALL_TAB_COMMENTS ; ---Comments on tables and views accessible to the user
"select * from ALL_TAB_PRIVS ; ---Grants on objects for which the user is the grantor, grantee, owner,
 or an enabled role or PUBLIC is the grantee"
select * from ALL_TAB_PRIVS_MADE ; ---User's grants and grants on user's objects
select * from ALL_TAB_PRIVS_RECD ; ---Grants on objects for which the user, PUBLIC or enabled role is the grantee
select * from ALL_VIEWS ; ---Description of views accessible to the user
select * from ALL_VIEWS_AE ; ---Description of views accessible to the user
select * from ALL_CONSTRAINTS ; ---Constraint definitions on accessible tables
select * from ALL_LOG_GROUPS ; ---Log group definitions on accessible tables
select * from ALL_CLUSTER_HASH_EXPRESSIONS ; ---Hash functions for all accessible clusters
select * from ALL_UPDATABLE_COLUMNS ; ---Description of all updatable columns
select * from ALL_UNUSED_COL_TABS ; ---All tables with unused columns accessible to the user
select * from ALL_PARTIAL_DROP_TABS ; ---All tables with patially dropped columns accessible to the user
select * from ALL_EDITIONING_VIEWS ; ---Description of Editioning Views accessible to the user
select * from ALL_EDITIONING_VIEWS_AE ; ---Description of Editioning Views accessible to the user
select * from ALL_EDITIONING_VIEW_COLS ; ---Relationship between columns of Editioning Views accessible to the user and the table columns to which they map
select * from ALL_EDITIONING_VIEW_COLS_AE ; ---Relationship between columns of Editioning Views accessible to the user and the table columns to which they map
select * from ALL_EDITIONS ; ---Describes all editions in the database
select * from ALL_EDITION_COMMENTS ; ---Describes comments on all editions in the database
select * from ALL_LIBRARIES ; ---Description of libraries accessible to the user
select * from ALL_PROCEDURES ; ---Functions/procedures/packages/types/triggers available to the user
select * from ALL_STORED_SETTINGS ; ---Parameter settings for objects accessible to the user
select * from ALL_PLSQL_OBJECT_SETTINGS ; ---Compiler settings of stored objects accessible to the user
select * from ALL_ARGUMENTS ; ---Arguments in object accessible to the user
select * from ALL_ASSEMBLIES ; ---Description of assemblies accessible to the user
select * from ALL_IDENTIFIERS ; ---All identifiers in stored objects accessible to the user
select * from ALL_DB_LINKS ; ---Database links accessible to the user
select * from ALL_USERS ; ---Information about all users of the database
select * from ALL_DEF_AUDIT_OPTS ; ---Auditing options for newly created objects
select * from ALL_TYPES ; ---Description of types accessible to the user
select * from ALL_COLL_TYPES ; ---Description of named collection types accessible to the user
select * from ALL_TYPE_ATTRS ; ---Description of attributes of types accessible to the user
select * from ALL_TYPE_METHODS ; ---Description of methods of types accessible to the user
"select * from ALL_METHOD_PARAMS ; ---Description of method parameters of types accessible
to the user"
"select * from ALL_METHOD_RESULTS ; ---Description of method results of types accessible
to the user"
select * from ALL_SQLJ_TYPES ; ---Description of types accessible to the user
select * from ALL_TYPE_VERSIONS ; ---Description of each type version accessible to the user
select * from ALL_PENDING_CONV_TABLES ; ---All tables accessible to the user which are not upgraded to the latest type version
select * from ALL_SQLJ_TYPE_ATTRS ; ---Description of attributes of types accessible to the user
select * from ALL_SQLJ_TYPE_METHODS ; ---Description of methods of types accessible to the user
select * from ALL_NESTED_TABLE_COLS ; ---Columns of nested tables
select * from ALL_DIRECTORIES ; ---Description of all directories accessible to the user
select * from ALL_REFS ; ---Description of REF columns contained in tables accessible to the user
select * from ALL_NESTED_TABLES ; ---Description of nested tables in tables accessible to the user
select * from ALL_VARRAYS ; ---Description of varrays in tables accessible to the user
select * from ALL_OBJ_COLATTRS ; ---Description of object columns and attributes contained in the tables accessible to the user
select * from ALL_CONS_OBJ_COLUMNS ; ---List of types an object column or attribute is constrained to in the tables accessible to the user
select * from ALL_OPERATORS ; ---All operators available to the user
select * from ALL_OPBINDINGS ; ---All binding functions for operators available to the user
select * from ALL_OPANCILLARY ; ---All ancillary operators available to the user
select * from ALL_OPARGUMENTS ; ---All arguments of the operators available to the user
select * from ALL_OPERATOR_COMMENTS ; ---Comments for user-defined operators
select * from ALL_INDEXTYPES ; ---All indextypes available to the user
select * from ALL_INDEXTYPE_COMMENTS ; ---Comments for user-defined indextypes
select * from ALL_INDEXTYPE_ARRAYTYPES ; ---All array types specified by the indextype
select * from ALL_INDEXTYPE_OPERATORS ; ---All operators available to the user
select * from ALL_SECONDARY_OBJECTS ; ---All secondary objects for domain indexes
select * from ALL_CHANGE_SOURCES ; ---Change Data Capture change sources
select * from ALL_CHANGE_SETS ; ---Change Data Capture change sets
select * from ALL_CHANGE_TABLES ; ---Change Data Capture change tables
select * from ALL_CHANGE_PROPAGATIONS ; ---Change Data Capture propagations
select * from ALL_CHANGE_PROPAGATION_SETS ; ---Change Data Capture propagated change set
select * from ALL_SUMDELTA ; ---Direct path load entries accessible to the user
select * from ALL_SUMMAP ; ---mapping entries of transaction ID and commit SCN accessible to the user
select * from ALL_EXTERNAL_TABLES ; ---Description of the external tables accessible to the user
select * from ALL_EXTERNAL_LOCATIONS ; ---Description of the external tables locations accessible to the user
select * from ALL_MINING_MODELS ; ---Description of the models accessible to the user
select * from ALL_MINING_MODEL_ATTRIBUTES ; ---Description of all the model attributes accessible to the user
select * from ALL_MINING_MODEL_SETTINGS ; ---Description of all the settings accessible to the user
select * from ALL_TAB_COL_STATISTICS ; ---Columns of user's tables, views and clusters
select * from ALL_TAB_HISTOGRAMS ; ---Histograms on columns of all tables visible to user
select * from ALL_ASSOCIATIONS ; ---All associations available to the user
select * from ALL_USTATS ; ---All statistics
select * from ALL_TAB_MODIFICATIONS ; ---Information regarding modifications to tables
select * from ALL_TAB_STATS_HISTORY ; ---History of table statistics modifications
select * from ALL_TAB_STAT_PREFS ; ---Statistics preferences for tables
select * from ALL_TAB_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
select * from ALL_IND_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
select * from ALL_COL_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
select * from ALL_TAB_HISTGRM_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
select * from ALL_DIMENSIONS ; ---Description of the dimension objects accessible to the DBA
select * from ALL_DIM_LEVELS ; ---Description of dimension levels visible to DBA
select * from ALL_DIM_LEVEL_KEY ; ---Representations of columns of a dimension level
"select * from ALL_DIM_ATTRIBUTES ; ---Representation of the relationship between a dimension level and
 a functionally dependent column"
select * from ALL_DIM_HIERARCHIES ; ---Representation of a dimension hierarchy
"select * from ALL_DIM_CHILD_OF ; ---Representaion of a 1:n hierarchical relationship between a pair of levels in
 a dimension"
select * from ALL_DIM_JOIN_KEY ; ---Representation of a join between two dimension tables.
select * from ALL_SUMMARIES ; ---Description of the summaries accessible to the user
select * from ALL_MVIEW_ANALYSIS ; ---Description of the materialized views accessible to the user
select * from ALL_MVIEW_AGGREGATES ; ---Description of the materialized view aggregates accessible to the user
select * from ALL_MVIEW_DETAIL_RELATIONS ; ---Description of the materialized view detail tables accessible to the user
"select * from ALL_MVIEW_KEYS ; ---Description of the columns that appear in the GROUP BY
list of a materialized view accessible to the user"
"select * from ALL_MVIEW_JOINS ; ---Description of a join between two columns in the
WHERE clause of a materialized view accessible to the user"
select * from ALL_MVIEW_COMMENTS ; ---Comments on materialized views accessible to the user
"select * from ALL_REFRESH_DEPENDENCIES ; ---Description of the detail tables that materialized views depend on for
refresh"
select * from ALL_REWRITE_EQUIVALENCES ; ---Description of all rewrite equivalence accessible to the user
select * from ALL_MVIEW_DETAIL_PARTITION ; ---Freshness information of all PCT materialized views in the database
select * from ALL_MVIEW_DETAIL_SUBPARTITION ; ---Freshness information of all PCT materialized views in the database
select * from 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
select * from 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
select * from ALL_ERRORS ; ---Current errors on stored objects that user is allowed to create
select * from ALL_ERRORS_AE ; ---Current errors on stored objects that user is allowed to create
select * from ALL_SOURCE_AE ; ---Current source on stored objects that user is allowed to create
select * from ALL_SOURCE ; ---Current source on stored objects that user is allowed to create
select * from ALL_TRIGGERS ; ---Triggers accessible to the current user
select * from ALL_INTERNAL_TRIGGERS ; ---Description of the internal triggers on the tables accessible to the user
select * from ALL_TRIGGER_COLS ; ---Column usage in user's triggers or in triggers on user's tables
select * from ALL_DEPENDENCIES ; ---Dependencies to and from objects accessible to the user
select * from ALL_TRIGGER_ORDERING ; ---Triggers having FOLLOWS or PRECEDES ordering accessible to the current user
select * from ALL_CONTEXT ; ---Description of all active context namespaces under the current session
select * from ALL_RULE_SETS ; ---Rule sets seen by the user
select * from ALL_RULESETS ; ---Rulesets seen by the user: maintained for backward compatibility
select * from ALL_RULES ; ---Rules seen by the user
select * from ALL_RULE_SET_RULES ; ---Rules in all rule sets seen by the user
select * from ALL_EVALUATION_CONTEXTS ; ---rule evaluation contexts seen by user
select * from ALL_EVALUATION_CONTEXT_TABLES ; ---tables in all rule evaluation contexts seen by the user
select * from ALL_EVALUATION_CONTEXT_VARS ; ---variables in all rule evaluation contexts seen by the user
select * from ALL_SNAPSHOTS ; ---Snapshots the user can access
select * from ALL_SNAPSHOT_LOGS ; ---All snapshot logs in the database that the user can see
select * from ALL_REFRESH ; ---All the refresh groups that the user can touch
select * from ALL_REFRESH_CHILDREN ; ---All the objects in refresh groups, where the user can touch the group
select * from ALL_REGISTERED_SNAPSHOTS ; ---Remote snapshots of local tables that the user can see
select * from ALL_MVIEWS ; ---All materialized views in the database
select * from ALL_MVIEW_REFRESH_TIMES ; ---Materialized views and their last refresh times  for each master table that the user can look at
select * from ALL_MVIEW_LOGS ; ---All materialized view logs in the database that the user can see
select * from ALL_BASE_TABLE_MVIEWS ; ---All materialized views with log(s) in the database that the user can see
select * from ALL_REGISTERED_MVIEWS ; ---Remote materialized views of local tables that the user can see
select * from ALL_POLICIES ; ---All policies for objects if the user has system privileges or owns the objects
select * from ALL_POLICY_GROUPS ; ---All policy groups defined for any synonym, table or view accessable to the user
select * from ALL_POLICY_CONTEXTS ; ---All policy driving context defined for all synonyms, tables, or views accessable to the user
select * from ALL_SEC_RELEVANT_COLS ; ---Security Relevant columns of all VPD policies for tables or views which the user has access
select * from ALL_AUDIT_POLICIES ; ---All fine grained auditing policies in the database
select * from ALL_AUDIT_POLICY_COLUMNS ; ---All fine grained auditing policy columns in the database
select * from ALL_QUEUE_TABLES ; ---All queue tables accessible to the user
select * from ALL_QUEUES ; ---All queues accessible to the user
select * from ALL_DEQUEUE_QUEUES ; ---All queues accessible to the user
select * from ALL_INT_DEQUEUE_QUEUES ; ---All queues accessible to the user
select * from ALL_REPGROUP_PRIVILEGES ; ---Information about users who are registered for object group privileges
select * from ALL_REPGROUP ; ---Information about replicated object groups
select * from ALL_REPSITES ; ---N-way replication information
select * from ALL_REPSCHEMA ; ---N-way replication information
select * from ALL_REPOBJECT ; ---Information about replicated objects
select * from ALL_REPCOLUMN ; ---Replicated top-level columns (table) sorted alphabetically in ascending order
select * from ALL_REPPROP ; ---Propagation information about replicated objects
select * from ALL_REPKEY_COLUMNS ; ---Primary columns for a table using column-level replication
select * from ALL_REPGENOBJECTS ; ---Objects generated to support replication
select * from ALL_REPGENERATED ; ---Objects generated to support replication
select * from ALL_REPCATLOG ; ---Information about asynchronous administration requests
select * from ALL_REPDDL ; ---Arguments that do not fit in a single repcat log record
select * from ALL_REPPRIORITY_GROUP ; ---Information about all priority groups which are accessible to the user
select * from ALL_REPPRIORITY ; ---Values and their corresponding priorities in all priority groups which are accessible to the user
select * from ALL_REPCOLUMN_GROUP ; ---All column groups of replicated tables which are accessible to the user
select * from ALL_REPGROUPED_COLUMN ; ---Columns in the all column groups of replicated tables which are accessible to the user
select * from ALL_REPCONFLICT ; ---All conflicts with available resolutions for user's replicated tables
select * from ALL_REPRESOLUTION_METHOD ; ---All conflict resolution methods accessible to the user
select * from ALL_REPRESOLUTION ; ---Description of all conflict resolutions for replicated tables which are accessible to the user
select * from ALL_REPRESOLUTION_STATISTICS ; ---Statistics for conflict resolutions for replicated tables which are accessible to the user
select * from ALL_REPRESOL_STATS_CONTROL ; ---Information about statistics collection for conflict resolutions for replicated tables which are accessible to the user
select * from ALL_REPPARAMETER_COLUMN ; ---All columns used for resolving conflicts in replicated tables which are accessible to the user
select * from ALL_REPAUDIT_ATTRIBUTE ; ---Information about attributes automatically maintained for replication
select * from ALL_REPAUDIT_COLUMN ; ---Information about columns in all shadow tables for replicated tables which are accessible to the user
select * from ALL_REPFLAVORS ; ---Flavors defined for replicated object groups
select * from ALL_REPFLAVOR_OBJECTS ; ---Replicated objects in flavors
select * from ALL_REPFLAVOR_COLUMNS ; ---Replicated columns in flavors
select * from ALL_WARNING_SETTINGS ; ---Warnings ettings for objects accessible to the user
select * from ALL_STAT_EXTENSIONS ; ---Optimizer statistics extensions
select * from ALL_TAB_STATISTICS ; ---Optimizer statistics for all tables accessible to the user
select * from ALL_IND_STATISTICS ; ---Optimizer statistics for all indexes on tables accessible to the user
select * from ALL_AWS ; ---Analytic Workspaces accessible to the user
select * from ALL_AW_PS ; ---Pagespaces in Analytic Workspaces accessible to the user
select * from ALL_CUBES ; ---OLAP Cubes in the database accessible to the user
select * from ALL_CUBE_DIMENSIONALITY ; ---OLAP Cube Dimensionality in the database accessible to the user
select * from ALL_CUBE_MEASURES ; ---OLAP Measures in the database accessible to the user
select * from ALL_CUBE_DIMENSIONS ; ---OLAP Cube Dimensions in the database accessible by the user
select * from ALL_CUBE_HIERARCHIES ; ---OLAP Hierarchies in the database accessible by the user
select * from ALL_CUBE_HIER_LEVELS ; ---OLAP Hierarchy Levels in the database accessible to the user
select * from ALL_CUBE_DIM_LEVELS ; ---OLAP Dimension Levels in the database accessible by the user
select * from ALL_CUBE_ATTRIBUTES ; ---OLAP Attributes in the database accessible by the user
select * from ALL_CUBE_ATTR_VISIBILITY ; ---OLAP Attributes visible for Dimensions, Hierarchies, and Levels
select * from ALL_CUBE_DIM_MODELS ; ---OLAP Dimension Models in the database accessible to the user
select * from ALL_CUBE_CALCULATED_MEMBERS ; ---OLAP Calculated Members in the database accessible to the user
select * from ALL_CUBE_VIEWS ; ---OLAP Cube Views in the database accessible by the user
select * from ALL_CUBE_VIEW_COLUMNS ; ---OLAP Cube View Columns in the database accessible by the user
select * from ALL_CUBE_DIM_VIEWS ; ---OLAP Dimension Views in the database accessible by the user
select * from ALL_CUBE_DIM_VIEW_COLUMNS ; ---OLAP Dimesion View Columns in the database accessible to the user
select * from ALL_CUBE_HIER_VIEWS ; ---OLAP Hierarchy Views in the database accessible to the user
select * from ALL_CUBE_HIER_VIEW_COLUMNS ; ---OLAP Hierarchy View Columns in the database accessible to the user
select * from ALL_MEASURE_FOLDERS ; ---OLAP Measure Folders in the database accessible to the user
select * from ALL_MEASURE_FOLDER_CONTENTS ; ---OLAP Measure Folder Contents in the database accessible by the user
select * from ALL_CUBE_BUILD_PROCESSES ; ---OLAP Build Processes in the database accessible to the user
select * from ALL_QUEUE_SUBSCRIBERS ; ---All queue subscribers accessible to user
select * from ALL_SCHEDULER_PROGRAMS ; ---All scheduler programs visible to the user
select * from ALL_SCHEDULER_DESTS ; ---All destination objects for jobs in the database visible to current user
select * from ALL_SCHEDULER_EXTERNAL_DESTS ; ---User-visible destination objects in the database pointing to remote agents
select * from ALL_SCHEDULER_DB_DESTS ; ---User-visible destination objects in the database pointing to remote databases
select * from ALL_SCHEDULER_JOB_DESTS ; ---State of all jobs visible to current user at each of their destinations
select * from ALL_SCHEDULER_JOBS ; ---All scheduler jobs visible to the user
select * from ALL_SCHEDULER_JOB_CLASSES ; ---All scheduler classes visible to the user
select * from ALL_SCHEDULER_WINDOWS ; ---All scheduler windows in the database
select * from ALL_SCHEDULER_PROGRAM_ARGS ; ---All arguments of all scheduler programs visible to the user
select * from ALL_SCHEDULER_JOB_ARGS ; ---All arguments with set values of all scheduler jobs in the database
select * from ALL_SCHEDULER_JOB_LOG ; ---Logged information for all scheduler jobs
select * from ALL_SCHEDULER_JOB_RUN_DETAILS ; ---The details of a job run
select * from ALL_SCHEDULER_WINDOW_LOG ; ---Logged information for all scheduler windows
select * from ALL_SCHEDULER_WINDOW_DETAILS ; ---The details of a window
select * from ALL_SCHEDULER_WINDOW_GROUPS ; ---All scheduler window groups in the database
select * from ALL_SCHEDULER_WINGROUP_MEMBERS ; ---Members of all scheduler window groups in the database
select * from ALL_SCHEDULER_GROUP_MEMBERS ; ---Members of all scheduler object groups visible to current user
select * from ALL_SCHEDULER_GROUPS ; ---All scheduler object groups visible to current user
select * from ALL_SCHEDULER_SCHEDULES ; ---All schedules in the database
select * from ALL_SCHEDULER_REMOTE_JOBSTATE ; ---Remote state of all jobs originating from this database visible to current user
select * from ALL_SCHEDULER_GLOBAL_ATTRIBUTE ; ---All scheduler global attributes
select * from ALL_SCHEDULER_CHAINS ; ---All scheduler chains in the database visible to current user
select * from ALL_SCHEDULER_CHAIN_RULES ; ---All rules from scheduler chains visible to the current user
select * from ALL_SCHEDULER_CHAIN_STEPS ; ---All steps of scheduler chains visible to the current user
select * from ALL_SCHEDULER_RUNNING_CHAINS ; ---All job steps of running job chains visible to the user
select * from ALL_SCHEDULER_CREDENTIALS ; ---All scheduler credentials visible to the user
select * from ALL_SCHEDULER_FILE_WATCHERS ; ---Scheduler file watch requests visible to the current user
select * from ALL_SCHEDULER_NOTIFICATIONS ; ---All job e-mail notifications visible to the current user
select * from ALL_CAPTURE ; ---Details about each capture process that stores the captured changes in a queue visible to the current user
select * from ALL_CAPTURE_PARAMETERS ; ---Details about parameters for each capture process that stores the captured changes in a queue visible to the current user
select * from ALL_CAPTURE_PREPARED_DATABASE ; ---Is the local database prepared for instantiation?
select * from ALL_CAPTURE_PREPARED_SCHEMAS ; ---All user schemas at the local database that are prepared for instantiation
select * from ALL_CAPTURE_PREPARED_TABLES ; ---All tables visible to the current user that are prepared for instantiation
select * from ALL_SYNC_CAPTURE_PREPARED_TABS ; ---All tables prepared for synchronous capture instantiation
select * from ALL_CAPTURE_EXTRA_ATTRIBUTES ; ---Extra attributes for a capture process that is visible to the current user
select * from ALL_SYNC_CAPTURE ; ---Details about each sync capture process that stores the captured changes in a queue visible to the current user
select * from ALL_APPLY ; ---Details about each apply process that dequeues from the queue visible to the current user
select * from ALL_APPLY_PARAMETERS ; ---Details about parameters of each apply process that dequeues from the queue visible to the current user
select * from ALL_APPLY_INSTANTIATED_OBJECTS ; ---Details about objects instantiated for the user
select * from ALL_APPLY_INSTANTIATED_SCHEMAS ; ---Details about schemas instantiated for the user
select * from ALL_APPLY_INSTANTIATED_GLOBAL ; ---Details about database instantiated for the user
select * from ALL_APPLY_KEY_COLUMNS ; ---Alternative key columns for a STREAMS table visible to the current user
select * from ALL_APPLY_CONFLICT_COLUMNS ; ---Details about conflict resolution on tables visible to the current user
select * from ALL_APPLY_TABLE_COLUMNS ; ---Details about the columns of destination table object visible to the user
select * from ALL_APPLY_DML_HANDLERS ; ---Details about the dml handler on tables visible to the current user
select * from ALL_APPLY_PROGRESS ; ---Information about the progress made by the apply process that dequeues from the queue visible to the current user
select * from ALL_APPLY_ERROR ; ---Error transactions that were generated after dequeuing from the queue visible to the current user
select * from ALL_APPLY_ERROR_MESSAGES ; ---Details about individual messages in an error transaction
select * from ALL_APPLY_ENQUEUE ; ---Details about the apply enqueue action for user accessible rules where the destination queue exists and is visible to the user
select * from ALL_APPLY_EXECUTE ; ---Details about the apply execute action for all rules visible to the user
select * from ALL_APPLY_SPILL_TXN ; ---Streams apply spilled transactions info to the user
select * from ALL_XSTREAM_OUTBOUND ; ---Details about the XStream outbound server visible to user
select * from ALL_XSTREAM_INBOUND ; ---Details about the XStream inbound server visible to user
select * from ALL_APPLY_CHANGE_HANDLERS ; ---Details about apply change handler
select * from ALL_APPLY_DML_CONF_HANDLERS ; ---Details about dml conflict handlers on objects visible to the current user
select * from ALL_APPLY_DML_CONF_COLUMNS ; ---Details about dml conflict handler column groups on objects visible to the current user
select * from ALL_APPLY_HANDLE_COLLISIONS ; ---Details about apply collision handlers on objects visible to the user
select * from ALL_APPLY_REPERROR_HANDLERS ; ---Details about apply reperror handlers on objects visible to the user
select * from ALL_PROPAGATION ; ---Streams propagation seen by the user
select * from ALL_FILE_GROUPS ; ---Details about file groups
select * from ALL_FILE_GROUP_VERSIONS ; ---Details about file group versions
select * from ALL_FILE_GROUP_EXPORT_INFO ; ---Details about export information of file group versions
select * from ALL_FILE_GROUP_FILES ; ---Details about file group files
select * from ALL_FILE_GROUP_TABLESPACES ; ---Details about the transportable tablespaces in the file group repository
select * from ALL_FILE_GROUP_TABLES ; ---Details about the tables in the file group repository
select * from ALL_STREAMS_MESSAGE_CONSUMERS ; ---Streams messaging consumers visible to the current user
select * from ALL_STREAMS_GLOBAL_RULES ; ---Global rules created on the streams capture/apply/propagation process that interact with the queue visible to the current user
select * from ALL_STREAMS_SCHEMA_RULES ; ---Rules created by streams administrative APIs on all user schemas
select * from ALL_STREAMS_TABLE_RULES ; ---Rules created by streams administrative APIs on tables visible to the current user
select * from ALL_STREAMS_MESSAGE_RULES ; ---Rules for Streams messaging visible to the current user
select * from ALL_STREAMS_RULES ; ---Rules used by streams processes
select * from ALL_SYNC_CAPTURE_TABLES ; ---All tables that are captured by synchronous streams captures.
select * from ALL_XSTREAM_RULES ; ---Details about the XStream server rules visible to user
select * from ALL_STREAMS_TRANSFORM_FUNCTION ; ---Rules-based transform functions used by Streams
select * from ALL_XSTREAM_ADMINISTRATOR ; ---Users granted the privileges to be a XStream administrator for the user
select * from ALL_STREAMS_TRANSFORMATIONS ; ---Transformations defined on rules for the user
select * from ALL_STREAMS_KEEP_COLUMNS ; ---Keep columns transformations for the user
select * from ALL_GOLDENGATE_PRIVILEGES ; ---Details about goldengate privileges for the user
select * from ALL_COMPARISON_SCAN_SUMMARY ; ---Details about a comparison scan for the user
select * from ALL_STREAMS_COLUMNS ; ---Streams unsupported columns
select * from ALL_STREAMS_UNSUPPORTED ; ---List of all the tables that are not supported by Streams in this release
select * from ALL_STREAMS_NEWLY_SUPPORTED ; ---List of objects that are newly supported by Streams
select * from ALL_XSTREAM_OUT_SUPPORT_MODE ; ---List of support mode for objects by XStream Out
select * from ALL_JAVA_CLASSES ; ---class level information of stored java class accessible to the user
select * from ALL_JAVA_LAYOUTS ; ---class layout information about stored java class accessible to the user
select * from ALL_JAVA_IMPLEMENTS ; ---interfaces implemented by the stored java class accessible to the user
select * from ALL_JAVA_INNERS ; ---list of inner classes refered by the stored java class accessible to user
select * from ALL_JAVA_FIELDS ; ---field information of stored java class accessible to user
select * from ALL_JAVA_METHODS ; ---method information of stored java class accessible to user
select * from ALL_JAVA_ARGUMENTS ; ---argument information of stored java class accessible to the user
select * from ALL_JAVA_THROWS ; ---list of exceptions thrown from a method of a class accessible to user
select * from 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
select * from ALL_JAVA_RESOLVERS ; ---resolver of java class owned by user
select * from ALL_JAVA_NCOMPS ; ---ncomp related information of all java classes
select * from ALL_JAVA_COMPILER_OPTIONS ; ---native-compiler options applicable to user
select * from ALL_XML_TABLES ; ---Description of the all XMLType tables that the user has privileges on
select * from ALL_XML_TAB_COLS ; ---Description of the all XMLType tables that the user has privileges on
select * from ALL_XML_VIEWS ; ---Description of the all XMLType views that the user has privileges on
select * from ALL_XML_VIEW_COLS ; ---Description of the all XMLType views that the user has privileges on
select * from ALL_XML_SCHEMAS ; ---Description of all XML Schemas that user has privilege to reference
select * from ALL_XML_SCHEMAS2 ; ---Dummy version of ALL_XML_SCHEMAS that does not have an XMLTYPE column
select * from ALL_XML_INDEXES ; ---Description of the all XMLType indexes that the user has privileges on
select * from ALL_XDS_OBJECTS ; ---All XDS enabled objects accessible to the user
select * from ALL_XDS_INSTANCE_SETS ; ---All instance sets for objects accessible to the user in the database
select * from ALL_XDS_ATTRIBUTE_SECS ; ---All objects with XDS column security and accessible to the user
select * from ALL_XSC_SECURITY_CLASS ; ---All security class definitions in the database
select * from ALL_XSC_SECURITY_CLASS_STATUS ; ---Security class "enable" and "mutable" status
select * from ALL_XSC_SECURITY_CLASS_DEP ; ---All security class dependencies in the database
select * from ALL_XSC_PRIVILEGE ; ---All mappings of privileges to security classes in the database
select * from ALL_XSC_AGGREGATE_PRIVILEGE ; ---All privileges that make up an aggregate privilege in the database
select * from ALL_AW_PROP ; ---Object properties in Analytic Workspaces accessible to the user
select * from ALL_AW_OBJ ; ---Objects in Analytic Workspaces accessible to the user
select * from ALL_AW_PROP_NAME ; ---Analytic Workspace property names accessible to the user
select * from ALL_AW_AC ; ---Active Catalog Analytic Workspaces accessible to the user
select * from ALL_PART_LOBS ; ---
select * from ALL_IND_PARTITIONS ; ---
select * from ALL_QUEUE_SCHEDULES ; ---
select * from ALL_PROBE_OBJECTS ; ---
select * from ALL_PART_KEY_COLUMNS ; ---
select * from ALL_SUBPARTITION_TEMPLATES ; ---
select * from ALL_REPCAT ; ---
select * from ALL_PART_INDEXES ; ---
select * from ALL_SUBPART_KEY_COLUMNS ; ---
select * from ALL_QUEUE_PUBLISHERS ; ---
select * from ALL_AW_AC_10G ; ---
select * from ALL_SUBPART_HISTOGRAMS ; ---
select * from ALL_LOB_PARTITIONS ; ---
select * from ALL_SUBPART_COL_STATISTICS ; ---
select * from ALL_SQLSET_PLANS ; ---
select * from ALL_SQLSET_REFERENCES ; ---
select * from ALL_PART_HISTOGRAMS ; ---
select * from ALL_LOB_TEMPLATES ; ---
select * from ALL_TAB_SUBPARTITIONS ; ---
select * from ALL_TRANSFORMATIONS ; ---
select * from ALL_SCHEDULER_REMOTE_DATABASES ; ---
select * from ALL$OLAP2_AWS ; ---
select * from ALL_SQLSET_BINDS ; ---
select * from ALL_TAB_PARTITIONS ; ---
select * from ALL_PART_TABLES ; ---
select * from ALL_PART_COL_STATISTICS ; ---
select * from ALL_SQLSET_STATEMENTS ; ---
select * from ALL_REGISTRY_BANNERS ; ---
select * from ALL_LOB_SUBPARTITIONS ; ---
select * from ALL_IND_SUBPARTITIONS ; ---
select * from ALL_SQLSET ; ---
select * from ALL_SERVICES ; ---
select * from ALL_ATTRIBUTE_TRANSFORMATIONS ; ---
select * from AUDIT_ACTIONS ; ---Description table for audit trail action type codes.  Maps action type numbers to action type names
"select * from COLUMN_PRIVILEGES ; ---Grants on columns for which the user is the grantor, grantee, owner, or
 an enabled role or PUBLIC is the grantee"
select * from DATABASE_COMPATIBLE_LEVEL ; ---Database compatible parameter set via init.ora
select * from DBMS_ALERT_INFO ; ---
select * from DBMS_LOCK_ALLOCATED ; ---
select * from DICTIONARY ; ---Description of data dictionary tables and views
select * from DICT_COLUMNS ; ---Description of columns in data dictionary tables and views
select * from DUAL ; ---
select * from GLOBAL_NAME ; ---global database name
select * from INDEX_HISTOGRAM ; ---statistics on keys with repeat count
select * from INDEX_STATS ; ---statistics on the b-tree
select * from NLS_DATABASE_PARAMETERS ; ---Permanent NLS parameters of the database
select * from NLS_INSTANCE_PARAMETERS ; ---NLS parameters of the instance
select * from NLS_SESSION_PARAMETERS ; ---NLS parameters of the user session
select * from RESOURCE_COST ; ---Cost for each resource
select * from ROLE_ROLE_PRIVS ; ---Roles which are granted to roles
select * from ROLE_SYS_PRIVS ; ---System privileges granted to roles
select * from ROLE_TAB_PRIVS ; ---Table privileges granted to roles
select * from SESSION_PRIVS ; ---Privileges which the user currently has set
select * from SESSION_ROLES ; ---Roles which the user currently has enabled.
"select * from TABLE_PRIVILEGES ; ---Grants on objects for which the user is the grantor, grantee, owner,
 or an enabled role or PUBLIC is the grantee"
select * from V$ACCESS ; ---Synonym for V_$ACCESS
select * from V$ACTIVE_INSTANCES ; ---Synonym for V_$ACTIVE_INSTANCES
select * from V$ACTIVE_SERVICES ; ---Synonym for V_$ACTIVE_SERVICES
select * from V$ACTIVE_SESSION_HISTORY ; ---Synonym for V_$ACTIVE_SESSION_HISTORY
select * from V$ACTIVE_SESS_POOL_MTH ; ---Synonym for V_$ACTIVE_SESS_POOL_MTH
select * from V$ADVISOR_CURRENT_SQLPLAN ; ---Synonym for V_$ADVISOR_CURRENT_SQLPLAN
select * from V$ADVISOR_PROGRESS ; ---Synonym for V_$ADVISOR_PROGRESS
select * from V$ALERT_TYPES ; ---Synonym for V_$ALERT_TYPES
select * from V$AQ ; ---Synonym for V_$AQ
select * from V$AQ1 ; ---Synonym for V_$AQ1
select * from V$ARCHIVE ; ---Synonym for V_$ARCHIVE
select * from V$ARCHIVED_LOG ; ---Synonym for V_$ARCHIVED_LOG
select * from V$ARCHIVE_DEST ; ---Synonym for V_$ARCHIVE_DEST
select * from V$ARCHIVE_DEST_STATUS ; ---Synonym for V_$ARCHIVE_DEST_STATUS
select * from V$ARCHIVE_GAP ; ---Synonym for V_$ARCHIVE_GAP
select * from V$ARCHIVE_PROCESSES ; ---Synonym for V_$ARCHIVE_PROCESSES
select * from V$ASH_INFO ; ---Synonym for V_$ASH_INFO
select * from V$ASM_ACFSSNAPSHOTS ; ---Synonym for V_$ASM_ACFSSNAPSHOTS
select * from V$ASM_ACFSVOLUMES ; ---Synonym for V_$ASM_ACFSVOLUMES
select * from V$ASM_ACFS_ENCRYPTION_INFO ; ---Synonym for V_$ASM_ACFS_ENCRYPTION_INFO
select * from V$ASM_ACFS_SECURITY_INFO ; ---Synonym for V_$ASM_ACFS_SECURITY_INFO
select * from V$ASM_ALIAS ; ---Synonym for V_$ASM_ALIAS
select * from V$ASM_ATTRIBUTE ; ---Synonym for V_$ASM_ATTRIBUTE
select * from V$ASM_CLIENT ; ---Synonym for V_$ASM_CLIENT
select * from V$ASM_DISK ; ---Synonym for V_$ASM_DISK
select * from V$ASM_DISKGROUP ; ---Synonym for V_$ASM_DISKGROUP
select * from V$ASM_DISKGROUP_STAT ; ---Synonym for V_$ASM_DISKGROUP_STAT
select * from V$ASM_DISK_IOSTAT ; ---Synonym for V_$ASM_DISK_IOSTAT
select * from V$ASM_DISK_STAT ; ---Synonym for V_$ASM_DISK_STAT
select * from V$ASM_FILE ; ---Synonym for V_$ASM_FILE
select * from V$ASM_FILESYSTEM ; ---Synonym for V_$ASM_FILESYSTEM
select * from V$ASM_OPERATION ; ---Synonym for V_$ASM_OPERATION
select * from V$ASM_TEMPLATE ; ---Synonym for V_$ASM_TEMPLATE
select * from V$ASM_USER ; ---Synonym for V_$ASM_USER
select * from V$ASM_USERGROUP ; ---Synonym for V_$ASM_USERGROUP
select * from V$ASM_USERGROUP_MEMBER ; ---Synonym for V_$ASM_USERGROUP_MEMBER
select * from V$ASM_VOLUME ; ---Synonym for V_$ASM_VOLUME
select * from V$ASM_VOLUME_STAT ; ---Synonym for V_$ASM_VOLUME_STAT
select * from V$AW_AGGREGATE_OP ; ---Synonym for V_$AW_AGGREGATE_OP
select * from V$AW_ALLOCATE_OP ; ---Synonym for V_$AW_ALLOCATE_OP
select * from V$AW_CALC ; ---Synonym for V_$AW_CALC
select * from V$AW_LONGOPS ; ---Synonym for V_$AW_LONGOPS
select * from V$AW_OLAP ; ---Synonym for V_$AW_OLAP
select * from V$AW_SESSION_INFO ; ---Synonym for V_$AW_SESSION_INFO
select * from V$BACKUP ; ---Synonym for V_$BACKUP
select * from V$BACKUP_ARCHIVELOG_DETAILS ; ---Synonym for V_$BACKUP_ARCHIVELOG_DETAILS
select * from V$BACKUP_ARCHIVELOG_SUMMARY ; ---Synonym for V_$BACKUP_ARCHIVELOG_SUMMARY
select * from V$BACKUP_ASYNC_IO ; ---Synonym for V_$BACKUP_ASYNC_IO
select * from V$BACKUP_CONTROLFILE_DETAILS ; ---Synonym for V_$BACKUP_CONTROLFILE_DETAILS
select * from V$BACKUP_CONTROLFILE_SUMMARY ; ---Synonym for V_$BACKUP_CONTROLFILE_SUMMARY
select * from V$BACKUP_COPY_DETAILS ; ---Synonym for V_$BACKUP_COPY_DETAILS
select * from V$BACKUP_COPY_SUMMARY ; ---Synonym for V_$BACKUP_COPY_SUMMARY
select * from V$BACKUP_CORRUPTION ; ---Synonym for V_$BACKUP_CORRUPTION
select * from V$BACKUP_DATAFILE ; ---Synonym for V_$BACKUP_DATAFILE
select * from V$BACKUP_DATAFILE_DETAILS ; ---Synonym for V_$BACKUP_DATAFILE_DETAILS
select * from V$BACKUP_DATAFILE_SUMMARY ; ---Synonym for V_$BACKUP_DATAFILE_SUMMARY
select * from V$BACKUP_DEVICE ; ---Synonym for V_$BACKUP_DEVICE
select * from V$BACKUP_FILES ; ---Synonym for V_$BACKUP_FILES
select * from V$BACKUP_PIECE ; ---Synonym for V_$BACKUP_PIECE
select * from V$BACKUP_PIECE_DETAILS ; ---Synonym for V_$BACKUP_PIECE_DETAILS
select * from V$BACKUP_REDOLOG ; ---Synonym for V_$BACKUP_REDOLOG
select * from V$BACKUP_SET ; ---Synonym for V_$BACKUP_SET
select * from V$BACKUP_SET_DETAILS ; ---Synonym for V_$BACKUP_SET_DETAILS
select * from V$BACKUP_SET_SUMMARY ; ---Synonym for V_$BACKUP_SET_SUMMARY
select * from V$BACKUP_SPFILE ; ---Synonym for V_$BACKUP_SPFILE
select * from V$BACKUP_SPFILE_DETAILS ; ---Synonym for V_$BACKUP_SPFILE_DETAILS
select * from V$BACKUP_SPFILE_SUMMARY ; ---Synonym for V_$BACKUP_SPFILE_SUMMARY
select * from V$BACKUP_SYNC_IO ; ---Synonym for V_$BACKUP_SYNC_IO
select * from V$BGPROCESS ; ---Synonym for V_$BGPROCESS
select * from V$BH ; ---Synonym for V_$BH
select * from V$BLOCKING_QUIESCE ; ---Synonym for V_$BLOCKING_QUIESCE
select * from V$BLOCK_CHANGE_TRACKING ; ---Synonym for V_$BLOCK_CHANGE_TRACKING
select * from V$BSP ; ---Synonym for V_$BSP
select * from V$BUFFERED_PUBLISHERS ; ---Synonym for V_$BUFFERED_PUBLISHERS
select * from V$BUFFERED_QUEUES ; ---Synonym for V_$BUFFERED_QUEUES
select * from V$BUFFERED_SUBSCRIBERS ; ---Synonym for V_$BUFFERED_SUBSCRIBERS
select * from V$BUFFER_POOL ; ---Synonym for V_$BUFFER_POOL
select * from V$BUFFER_POOL_STATISTICS ; ---Synonym for V_$BUFFER_POOL_STATISTICS
select * from V$CALLTAG ; ---Synonym for V_$CALLTAG
select * from V$CELL ; ---Synonym for V_$CELL
select * from V$CELL_CONFIG ; ---Synonym for V_$CELL_CONFIG
select * from V$CELL_REQUEST_TOTALS ; ---Synonym for V_$CELL_REQUEST_TOTALS
select * from V$CELL_STATE ; ---Synonym for V_$CELL_STATE
select * from V$CELL_THREAD_HISTORY ; ---Synonym for V_$CELL_THREAD_HISTORY
select * from V$CIRCUIT ; ---Synonym for V_$CIRCUIT
select * from V$CLASS_CACHE_TRANSFER ; ---Synonym for V_$CLASS_CACHE_TRANSFER
select * from V$CLASS_PING ; ---Synonym for V_$CLASS_PING
select * from V$CLIENT_STATS ; ---Synonym for V_$CLIENT_STATS
select * from V$CLUSTER_INTERCONNECTS ; ---Synonym for V_$CLUSTER_INTERCONNECTS
select * from V$CONFIGURED_INTERCONNECTS ; ---Synonym for V_$CONFIGURED_INTERCONNECTS
select * from V$CONTEXT ; ---Synonym for V_$CONTEXT
select * from V$CONTROLFILE ; ---Synonym for V_$CONTROLFILE
select * from V$CONTROLFILE_RECORD_SECTION ; ---Synonym for V_$CONTROLFILE_RECORD_SECTION
select * from V$COPY_CORRUPTION ; ---Synonym for V_$COPY_CORRUPTION
select * from V$CORRUPT_XID_LIST ; ---Synonym for V_$CORRUPT_XID_LIST
select * from V$CPOOL_CC_INFO ; ---Synonym for V_$CPOOL_CC_INFO
select * from V$CPOOL_CC_STATS ; ---Synonym for V_$CPOOL_CC_STATS
select * from V$CPOOL_CONN_INFO ; ---Synonym for V_$CPOOL_CONN_INFO
select * from V$CPOOL_STATS ; ---Synonym for V_$CPOOL_STATS
select * from V$CR_BLOCK_SERVER ; ---Synonym for V_$CR_BLOCK_SERVER
select * from V$CURRENT_BLOCK_SERVER ; ---Synonym for V_$CURRENT_BLOCK_SERVER
select * from V$SYSAUX_OCCUPANTS ; ---Synonym for V_$SYSAUX_OCCUPANTS
select * from V$SYSMETRIC ; ---Synonym for V_$SYSMETRIC
select * from V$SYSMETRIC_HISTORY ; ---Synonym for V_$SYSMETRIC_HISTORY
select * from V$SYSMETRIC_SUMMARY ; ---Synonym for V_$SYSMETRIC_SUMMARY
select * from V$SYSSTAT ; ---Synonym for V_$SYSSTAT
select * from V$SYSTEM_CURSOR_CACHE ; ---Synonym for V_$SYSTEM_CURSOR_CACHE
select * from V$SYSTEM_EVENT ; ---Synonym for V_$SYSTEM_EVENT
select * from V$SYSTEM_FIX_CONTROL ; ---Synonym for V_$SYSTEM_FIX_CONTROL
select * from V$SYSTEM_PARAMETER ; ---Synonym for V_$SYSTEM_PARAMETER
select * from V$SYSTEM_PARAMETER2 ; ---Synonym for V_$SYSTEM_PARAMETER2
select * from V$SYSTEM_WAIT_CLASS ; ---Synonym for V_$SYSTEM_WAIT_CLASS
select * from V$SYS_OPTIMIZER_ENV ; ---Synonym for V_$SYS_OPTIMIZER_ENV
select * from V$SYS_TIME_MODEL ; ---Synonym for V_$SYS_TIME_MODEL
select * from V$TABLESPACE ; ---Synonym for V_$TABLESPACE
select * from V$TEMPFILE ; ---Synonym for V_$TEMPFILE
select * from V$TEMPORARY_LOBS ; ---Synonym for V_$TEMPORARY_LOBS
select * from V$TEMPSEG_USAGE ; ---Synonym for V_$SORT_USAGE
select * from V$TEMPSTAT ; ---Synonym for V_$TEMPSTAT
select * from V$TEMP_CACHE_TRANSFER ; ---Synonym for V_$TEMP_CACHE_TRANSFER
select * from V$TEMP_EXTENT_MAP ; ---Synonym for V_$TEMP_EXTENT_MAP
select * from V$TEMP_EXTENT_POOL ; ---Synonym for V_$TEMP_EXTENT_POOL
select * from V$TEMP_PING ; ---Synonym for V_$TEMP_PING
select * from V$TEMP_SPACE_HEADER ; ---Synonym for V_$TEMP_SPACE_HEADER
select * from V$THREAD ; ---Synonym for V_$THREAD
select * from V$THRESHOLD_TYPES ; ---Synonym for V_$THRESHOLD_TYPES
select * from V$TIMER ; ---Synonym for V_$TIMER
select * from V$TIMEZONE_FILE ; ---Synonym for V_$TIMEZONE_FILE
select * from V$TIMEZONE_NAMES ; ---Synonym for V_$TIMEZONE_NAMES
select * from V$TOPLEVELCALL ; ---Synonym for V_$TOPLEVELCALL
select * from V$TRANSACTION ; ---Synonym for V_$TRANSACTION
select * from V$TRANSACTION_ENQUEUE ; ---Synonym for V_$TRANSACTION_ENQUEUE
select * from V$TRANSPORTABLE_PLATFORM ; ---Synonym for V_$TRANSPORTABLE_PLATFORM
select * from V$TSM_SESSIONS ; ---Synonym for V_$TSM_SESSIONS
select * from V$TYPE_SIZE ; ---Synonym for V_$TYPE_SIZE
select * from V$UNDOSTAT ; ---Synonym for V_$UNDOSTAT
select * from V$UNUSABLE_BACKUPFILE_DETAILS ; ---Synonym for V_$UNUSABLE_BACKUPFILE_DETAILS
select * from V$VERSION ; ---Synonym for V_$VERSION
select * from V$VPD_POLICY ; ---Synonym for V_$VPD_POLICY
select * from V$WAITCLASSMETRIC ; ---Synonym for V_$WAITCLASSMETRIC
select * from V$WAITCLASSMETRIC_HISTORY ; ---Synonym for V_$WAITCLASSMETRIC_HISTORY
select * from V$WAITSTAT ; ---Synonym for V_$WAITSTAT
select * from V$WAIT_CHAINS ; ---Synonym for V_$WAIT_CHAINS
select * from V$WALLET ; ---Synonym for V_$WALLET
select * from V$WLM_PCMETRIC ; ---Synonym for V_$WLM_PCMETRIC
select * from V$WLM_PCMETRIC_HISTORY ; ---Synonym for V_$WLM_PCMETRIC_HISTORY
select * from V$WLM_PC_STATS ; ---Synonym for V_$WLM_PC_STATS
select * from V$WORKLOAD_REPLAY_THREAD ; ---Synonym for V_$WORKLOAD_REPLAY_THREAD
select * from V$XML_AUDIT_TRAIL ; ---Synonym for V_$XML_AUDIT_TRAIL
select * from V$XSTREAM_CAPTURE ; ---Synonym for V_$XSTREAM_CAPTURE
select * from V$XSTREAM_MESSAGE_TRACKING ; ---Synonym for V_$XSTREAM_MESSAGE_TRACKING
select * from V$XSTREAM_OUTBOUND_SERVER ; ---Synonym for V_$XSTREAM_OUTBOUND_SERVER
select * from V$XSTREAM_TABLE_STATS ; ---Synonym for V_$XSTREAM_TABLE_STATS
select * from V$XSTREAM_TRANSACTION ; ---Synonym for V_$XSTREAM_TRANSACTION
select * from V$_LOCK ; ---Synonym for V_$_LOCK
select * from V$LOADISTAT ; ---Synonym for V_$LOADISTAT
select * from V$LOADPSTAT ; ---Synonym for V_$LOADPSTAT
select * from V$LOBSTAT ; ---Synonym for V_$LOBSTAT
select * from V$LOCK ; ---Synonym for V_$LOCK
select * from V$LOCKED_OBJECT ; ---Synonym for V_$LOCKED_OBJECT
select * from V$LOCKS_WITH_COLLISIONS ; ---Synonym for V_$LOCKS_WITH_COLLISIONS
select * from V$LOCK_ACTIVITY ; ---Synonym for V_$LOCK_ACTIVITY
select * from V$LOCK_ELEMENT ; ---Synonym for V_$LOCK_ELEMENT
select * from V$LOCK_TYPE ; ---Synonym for V_$LOCK_TYPE
select * from V$LOG ; ---Synonym for V_$LOG
select * from V$LOGFILE ; ---Synonym for V_$LOGFILE
select * from V$LOGHIST ; ---Synonym for V_$LOGHIST
select * from V$LOGMNR_CALLBACK ; ---Synonym for V_$LOGMNR_CALLBACK
select * from V$LOGMNR_CONTENTS ; ---Synonym for V_$LOGMNR_CONTENTS
select * from V$LOGMNR_DICTIONARY ; ---Synonym for V_$LOGMNR_DICTIONARY
select * from V$LOGMNR_DICTIONARY_LOAD ; ---Synonym for V_$LOGMNR_DICTIONARY_LOAD
select * from V$LOGMNR_LATCH ; ---Synonym for V_$LOGMNR_LATCH
select * from V$LOGMNR_LOGFILE ; ---Synonym for V_$LOGMNR_LOGFILE
select * from V$LOGMNR_LOGS ; ---Synonym for V_$LOGMNR_LOGS
select * from V$LOGMNR_PARAMETERS ; ---Synonym for V_$LOGMNR_PARAMETERS
select * from V$LOGMNR_PROCESS ; ---Synonym for V_$LOGMNR_PROCESS
select * from V$LOGMNR_REGION ; ---Synonym for V_$LOGMNR_REGION
select * from V$LOGMNR_SESSION ; ---Synonym for V_$LOGMNR_SESSION
select * from V$LOGMNR_STATS ; ---Synonym for V_$LOGMNR_STATS
select * from V$LOGMNR_TRANSACTION ; ---Synonym for V_$LOGMNR_TRANSACTION
select * from V$LOGSTDBY ; ---Synonym for V_$LOGSTDBY
select * from V$LOGSTDBY_PROCESS ; ---Synonym for V_$LOGSTDBY_PROCESS
select * from V$LOGSTDBY_PROGRESS ; ---Synonym for V_$LOGSTDBY_PROGRESS
select * from V$LOGSTDBY_STATE ; ---Synonym for V_$LOGSTDBY_STATE
select * from V$LOGSTDBY_STATS ; ---Synonym for V_$LOGSTDBY_STATS
select * from V$LOGSTDBY_TRANSACTION ; ---Synonym for V_$LOGSTDBY_TRANSACTION
select * from V$LOG_HISTORY ; ---Synonym for V_$LOG_HISTORY
select * from V$MANAGED_STANDBY ; ---Synonym for V_$MANAGED_STANDBY
select * from V$MAP_COMP_LIST ; ---Synonym for V_$MAP_COMP_LIST
select * from V$MAP_ELEMENT ; ---Synonym for V_$MAP_ELEMENT
select * from V$MAP_EXT_ELEMENT ; ---Synonym for V_$MAP_EXT_ELEMENT
select * from V$MAP_FILE ; ---Synonym for V_$MAP_FILE
select * from V$MAP_FILE_EXTENT ; ---Synonym for V_$MAP_FILE_EXTENT
select * from V$MAP_FILE_IO_STACK ; ---Synonym for V_$MAP_FILE_IO_STACK
select * from V$MAP_LIBRARY ; ---Synonym for V_$MAP_LIBRARY
select * from V$MAP_SUBELEMENT ; ---Synonym for V_$MAP_SUBELEMENT
select * from V$MAX_ACTIVE_SESS_TARGET_MTH ; ---Synonym for V_$MAX_ACTIVE_SESS_TARGET_MTH
select * from V$MEMORY_CURRENT_RESIZE_OPS ; ---Synonym for V_$MEMORY_CURRENT_RESIZE_OPS
select * from V$MEMORY_DYNAMIC_COMPONENTS ; ---Synonym for V_$MEMORY_DYNAMIC_COMPONENTS
select * from V$MEMORY_RESIZE_OPS ; ---Synonym for V_$MEMORY_RESIZE_OPS
select * from V$MEMORY_TARGET_ADVICE ; ---Synonym for V_$MEMORY_TARGET_ADVICE
select * from V$METRIC ; ---Synonym for V_$METRIC
select * from V$METRICGROUP ; ---Synonym for V_$METRICGROUP
select * from V$METRICNAME ; ---Synonym for V_$METRICNAME
select * from V$METRIC_HISTORY ; ---Synonym for V_$METRIC_HISTORY
select * from V$MTTR_TARGET_ADVICE ; ---Synonym for V_$MTTR_TARGET_ADVICE
select * from V$MUTEX_SLEEP ; ---Synonym for V_$MUTEX_SLEEP
select * from V$MUTEX_SLEEP_HISTORY ; ---Synonym for V_$MUTEX_SLEEP_HISTORY
select * from V$MVREFRESH ; ---Synonym for V_$MVREFRESH
select * from V$MYSTAT ; ---Synonym for V_$MYSTAT
select * from V$NFS_CLIENTS ; ---Synonym for V_$NFS_CLIENTS
select * from V$NFS_LOCKS ; ---Synonym for V_$NFS_LOCKS
select * from V$NFS_OPEN_FILES ; ---Synonym for V_$NFS_OPEN_FILES
select * from V$NLS_PARAMETERS ; ---Synonym for V_$NLS_PARAMETERS
select * from V$NLS_VALID_VALUES ; ---Synonym for V_$NLS_VALID_VALUES
select * from V$OBJECT_DEPENDENCY ; ---Synonym for V_$OBJECT_DEPENDENCY
select * from V$OBJECT_DML_FREQUENCIES ; ---Synonym for V_$OBJECT_DML_FREQUENCIES
select * from V$OBJECT_PRIVILEGE ; ---Synonym for V_$OBJECT_PRIVILEGE
select * from V$OBSOLETE_PARAMETER ; ---Synonym for V_$OBSOLETE_PARAMETER
select * from V$OFFLINE_RANGE ; ---Synonym for V_$OFFLINE_RANGE
select * from V$OPEN_CURSOR ; ---Synonym for V_$OPEN_CURSOR
select * from V$OPTION ; ---Synonym for V_$OPTION
select * from V$OSSTAT ; ---Synonym for V_$OSSTAT
select * from V$PARALLEL_DEGREE_LIMIT_MTH ; ---Synonym for V_$PARALLEL_DEGREE_LIMIT_MTH
select * from V$PARAMETER ; ---Synonym for V_$PARAMETER
select * from V$PARAMETER2 ; ---Synonym for V_$PARAMETER2
select * from V$PARAMETER_VALID_VALUES ; ---Synonym for V_$PARAMETER_VALID_VALUES
select * from V$PERSISTENT_PUBLISHERS ; ---Synonym for V_$PERSISTENT_PUBLISHERS
select * from V$PERSISTENT_QMN_CACHE ; ---Synonym for V_$PERSISTENT_QMN_CACHE
select * from V$PERSISTENT_QUEUES ; ---Synonym for V_$PERSISTENT_QUEUES
select * from V$PERSISTENT_SUBSCRIBERS ; ---Synonym for V_$PERSISTENT_SUBSCRIBERS
select * from V$PGASTAT ; ---Synonym for V_$PGASTAT
select * from V$PGA_TARGET_ADVICE ; ---Synonym for V_$PGA_TARGET_ADVICE
select * from V$PGA_TARGET_ADVICE_HISTOGRAM ; ---Synonym for V_$PGA_TARGET_ADVICE_HISTOGRAM
select * from V$POLICY_HISTORY ; ---Synonym for V_$POLICY_HISTORY
select * from V$PQ_SESSTAT ; ---Synonym for V_$PQ_SESSTAT
select * from V$PQ_SLAVE ; ---Synonym for V_$PQ_SLAVE
select * from V$PQ_SYSSTAT ; ---Synonym for V_$PQ_SYSSTAT
select * from V$PQ_TQSTAT ; ---Synonym for V_$PQ_TQSTAT
select * from V$PROCESS ; ---Synonym for V_$PROCESS
select * from V$PROCESS_GROUP ; ---Synonym for V_$PROCESS_GROUP
select * from V$PROCESS_MEMORY ; ---Synonym for V_$PROCESS_MEMORY
select * from V$PROCESS_MEMORY_DETAIL ; ---Synonym for V_$PROCESS_MEMORY_DETAIL
select * from V$PROCESS_MEMORY_DETAIL_PROG ; ---Synonym for V_$PROCESS_MEMORY_DETAIL_PROG
select * from V$PROPAGATION_RECEIVER ; ---Synonym for V_$PROPAGATION_RECEIVER
select * from V$PROPAGATION_SENDER ; ---Synonym for V_$PROPAGATION_SENDER
select * from V$PROXY_ARCHIVEDLOG ; ---Synonym for V_$PROXY_ARCHIVEDLOG
select * from V$PROXY_ARCHIVELOG_DETAILS ; ---Synonym for V_$PROXY_ARCHIVELOG_DETAILS
select * from V$PROXY_ARCHIVELOG_SUMMARY ; ---Synonym for V_$PROXY_ARCHIVELOG_SUMMARY
select * from V$PROXY_COPY_DETAILS ; ---Synonym for V_$PROXY_COPY_DETAILS
select * from V$PROXY_COPY_SUMMARY ; ---Synonym for V_$PROXY_COPY_SUMMARY
select * from V$PROXY_DATAFILE ; ---Synonym for V_$PROXY_DATAFILE
select * from V$PWFILE_USERS ; ---Synonym for V_$PWFILE_USERS
select * from V$PX_BUFFER_ADVICE ; ---Synonym for V_$PX_BUFFER_ADVICE
select * from V$PX_INSTANCE_GROUP ; ---Synonym for V_$PX_INSTANCE_GROUP
select * from V$PX_PROCESS ; ---Synonym for V_$PX_PROCESS
select * from V$PX_PROCESS_SYSSTAT ; ---Synonym for V_$PX_PROCESS_SYSSTAT
select * from V$PX_SESSION ; ---Synonym for V_$PX_SESSION
select * from V$PX_SESSTAT ; ---Synonym for V_$PX_SESSTAT
select * from V$QMON_COORDINATOR_STATS ; ---Synonym for V_$QMON_COORDINATOR_STATS
select * from V$QMON_SERVER_STATS ; ---Synonym for V_$QMON_SERVER_STATS
select * from V$QMON_TASKS ; ---Synonym for V_$QMON_TASKS
select * from V$QMON_TASK_STATS ; ---Synonym for V_$QMON_TASK_STATS
select * from V$QUEUE ; ---Synonym for V_$QUEUE
select * from V$QUEUEING_MTH ; ---Synonym for V_$QUEUEING_MTH
select * from V$RECOVERY_AREA_USAGE ; ---Synonym for V_$RECOVERY_AREA_USAGE
select * from V$RECOVERY_FILE_DEST ; ---Synonym for V_$RECOVERY_FILE_DEST
select * from V$RECOVERY_FILE_STATUS ; ---Synonym for V_$RECOVERY_FILE_STATUS
select * from V$RECOVERY_LOG ; ---Synonym for V_$RECOVERY_LOG
select * from V$RECOVERY_PROGRESS ; ---Synonym for V_$RECOVERY_PROGRESS
select * from V$RECOVERY_STATUS ; ---Synonym for V_$RECOVERY_STATUS
select * from V$RECOVER_FILE ; ---Synonym for V_$RECOVER_FILE
select * from V$REDO_DEST_RESP_HISTOGRAM ; ---Synonym for V_$REDO_DEST_RESP_HISTOGRAM
select * from V$REPLPROP ; ---Synonym for V_$REPLPROP
select * from V$REPLQUEUE ; ---Synonym for V_$REPLQUEUE
select * from V$REQDIST ; ---Synonym for V_$REQDIST
select * from V$RESERVED_WORDS ; ---Synonym for V_$RESERVED_WORDS
select * from V$RESOURCE ; ---Synonym for V_$RESOURCE
select * from V$RESOURCE_LIMIT ; ---Synonym for V_$RESOURCE_LIMIT
select * from V$RESTORE_POINT ; ---Synonym for V_$RESTORE_POINT
select * from V$RESULT_CACHE_DEPENDENCY ; ---Synonym for V_$RESULT_CACHE_DEPENDENCY
select * from V$RESULT_CACHE_MEMORY ; ---Synonym for V_$RESULT_CACHE_MEMORY
select * from V$RESULT_CACHE_OBJECTS ; ---Synonym for V_$RESULT_CACHE_OBJECTS
select * from V$RESULT_CACHE_STATISTICS ; ---Synonym for V_$RESULT_CACHE_STATISTICS
select * from V$RESUMABLE ; ---Synonym for V_$RESUMABLE
select * from V$RFS_THREAD ; ---Synonym for V_$RFS_THREAD
select * from GV$DATABASE ; ---Synonym for GV_$DATABASE
select * from GV$DATABASE_BLOCK_CORRUPTION ; ---Synonym for GV_$DATABASE_BLOCK_CORRUPTION
select * from GV$DATABASE_INCARNATION ; ---Synonym for GV_$DATABASE_INCARNATION
select * from GV$DATABASE_KEY_INFO ; ---Synonym for GV_$DATABASE_KEY_INFO
select * from GV$DATAFILE ; ---Synonym for GV_$DATAFILE
select * from GV$DATAFILE_COPY ; ---Synonym for GV_$DATAFILE_COPY
select * from GV$DATAFILE_HEADER ; ---Synonym for GV_$DATAFILE_HEADER
select * from GV$DATAGUARD_CONFIG ; ---Synonym for GV_$DATAGUARD_CONFIG
select * from GV$DATAGUARD_STATS ; ---Synonym for GV_$DATAGUARD_STATS
select * from GV$DATAGUARD_STATUS ; ---Synonym for GV_$DATAGUARD_STATUS
select * from GV$DATAPUMP_JOB ; ---Synonym for GV_$DATAPUMP_JOB
select * from GV$DATAPUMP_SESSION ; ---Synonym for GV_$DATAPUMP_SESSION
select * from GV$DBFILE ; ---Synonym for GV_$DBFILE
select * from GV$DBLINK ; ---Synonym for GV_$DBLINK
select * from GV$DB_CACHE_ADVICE ; ---Synonym for GV_$DB_CACHE_ADVICE
select * from GV$DB_OBJECT_CACHE ; ---Synonym for GV_$DB_OBJECT_CACHE
select * from GV$DB_PIPES ; ---Synonym for GV_$DB_PIPES
select * from GV$DB_TRANSPORTABLE_PLATFORM ; ---Synonym for GV_$DB_TRANSPORTABLE_PLATFORM
select * from GV$DELETED_OBJECT ; ---Synonym for GV_$DELETED_OBJECT
select * from GV$DETACHED_SESSION ; ---Synonym for GV_$DETACHED_SESSION
select * from GV$DIAG_INFO ; ---Synonym for GV_$DIAG_INFO
select * from GV$DISPATCHER ; ---Synonym for GV_$DISPATCHER
select * from GV$DISPATCHER_CONFIG ; ---Synonym for GV_$DISPATCHER_CONFIG
select * from GV$DISPATCHER_RATE ; ---Synonym for GV_$DISPATCHER_RATE
select * from GV$DLM_ALL_LOCKS ; ---Synonym for GV_$DLM_ALL_LOCKS
select * from GV$DLM_CONVERT_LOCAL ; ---Synonym for GV_$DLM_CONVERT_LOCAL
select * from GV$DLM_CONVERT_REMOTE ; ---Synonym for GV_$DLM_CONVERT_REMOTE
select * from GV$DLM_LATCH ; ---Synonym for GV_$DLM_LATCH
select * from GV$DLM_LOCKS ; ---Synonym for GV_$DLM_LOCKS
select * from GV$DLM_MISC ; ---Synonym for GV_$DLM_MISC
select * from GV$DLM_RESS ; ---Synonym for GV_$DLM_RESS
select * from GV$DLM_TRAFFIC_CONTROLLER ; ---Synonym for GV_$DLM_TRAFFIC_CONTROLLER
select * from GV$DNFS_CHANNELS ; ---Synonym for GV_$DNFS_CHANNELS
select * from GV$DNFS_FILES ; ---Synonym for GV_$DNFS_FILES
select * from GV$DNFS_SERVERS ; ---Synonym for GV_$DNFS_SERVERS
select * from GV$DNFS_STATS ; ---Synonym for GV_$DNFS_STATS
select * from GV$DYNAMIC_REMASTER_STATS ; ---Synonym for GV_$DYNAMIC_REMASTER_STATS
select * from GV$EMON ; ---Synonym for GV_$EMON
select * from GV$ENABLEDPRIVS ; ---Synonym for GV_$ENABLEDPRIVS
select * from GV$ENCRYPTED_TABLESPACES ; ---Synonym for GV_$ENCRYPTED_TABLESPACES
select * from GV$ENCRYPTION_WALLET ; ---Synonym for GV_$ENCRYPTION_WALLET
select * from GV$ENQUEUE_LOCK ; ---Synonym for GV_$ENQUEUE_LOCK
select * from GV$ENQUEUE_STAT ; ---Synonym for GV_$ENQUEUE_STAT
select * from GV$ENQUEUE_STATISTICS ; ---Synonym for GV_$ENQUEUE_STATISTICS
select * from GV$EVENTMETRIC ; ---Synonym for GV_$EVENTMETRIC
select * from GV$EVENT_HISTOGRAM ; ---Synonym for GV_$EVENT_HISTOGRAM
select * from GV$EVENT_NAME ; ---Synonym for GV_$EVENT_NAME
select * from GV$EXECUTION ; ---Synonym for GV_$EXECUTION
select * from GV$FAST_START_SERVERS ; ---Synonym for GV_$FAST_START_SERVERS
select * from GV$FAST_START_TRANSACTIONS ; ---Synonym for GV_$FAST_START_TRANSACTIONS
select * from GV$FILEMETRIC ; ---Synonym for GV_$FILEMETRIC
select * from GV$FILEMETRIC_HISTORY ; ---Synonym for GV_$FILEMETRIC_HISTORY
select * from GV$FILESPACE_USAGE ; ---Synonym for GV_$FILESPACE_USAGE
select * from GV$FILESTAT ; ---Synonym for GV_$FILESTAT
select * from GV$FILE_CACHE_TRANSFER ; ---Synonym for GV_$FILE_CACHE_TRANSFER
select * from GV$FILE_HISTOGRAM ; ---Synonym for GV_$FILE_HISTOGRAM
select * from GV$FILE_OPTIMIZED_HISTOGRAM ; ---Synonym for GV_$FILE_OPTIMIZED_HISTOGRAM
select * from GV$FILE_PING ; ---Synonym for GV_$FILE_PING
select * from GV$FIXED_TABLE ; ---Synonym for GV_$FIXED_TABLE
select * from GV$FIXED_VIEW_DEFINITION ; ---Synonym for GV_$FIXED_VIEW_DEFINITION
select * from GV$FLASHBACK_DATABASE_LOG ; ---Synonym for GV_$FLASHBACK_DATABASE_LOG
select * from GV$FLASHBACK_DATABASE_LOGFILE ; ---Synonym for GV_$FLASHBACK_DATABASE_LOGFILE
select * from GV$FLASHBACK_DATABASE_STAT ; ---Synonym for GV_$FLASHBACK_DATABASE_STAT
select * from GV$FOREIGN_ARCHIVED_LOG ; ---Synonym for GV_$FOREIGN_ARCHIVED_LOG
select * from GV$FS_FAILOVER_HISTOGRAM ; ---Synonym for GV_$FS_FAILOVER_HISTOGRAM
select * from GV$FS_FAILOVER_STATS ; ---Synonym for GV_$FS_FAILOVER_STATS
select * from GV$GCSHVMASTER_INFO ; ---Synonym for GV_$GCSHVMASTER_INFO
select * from GV$GCSPFMASTER_INFO ; ---Synonym for GV_$GCSPFMASTER_INFO
select * from GV$GC_ELEMENT ; ---Synonym for GV_$GC_ELEMENT
select * from GV$GC_ELEMENTS_WITH_COLLISIONS ; ---Synonym for GV_$GC_ELEMENTS_W_COLLISIONS
select * from GV$GES_BLOCKING_ENQUEUE ; ---Synonym for GV_$GES_BLOCKING_ENQUEUE
select * from GV$GES_ENQUEUE ; ---Synonym for GV_$GES_ENQUEUE
select * from GV$GLOBALCONTEXT ; ---Synonym for GV_$GLOBALCONTEXT
select * from GV$GLOBAL_BLOCKED_LOCKS ; ---Synonym for GV_$GLOBAL_BLOCKED_LOCKS
select * from GV$GLOBAL_TRANSACTION ; ---Synonym for GV_$GLOBAL_TRANSACTION
select * from GV$GOLDENGATE_CAPTURE ; ---Synonym for GV_$GOLDENGATE_CAPTURE
select * from GV$GOLDENGATE_MESSAGE_TRACKING ; ---Synonym for GV_$GOLDENGATE_MESSAGETRACKING
select * from GV$GOLDENGATE_TABLE_STATS ; ---Synonym for GV_$GOLDENGATE_TABLE_STATS
select * from GV$GOLDENGATE_TRANSACTION ; ---Synonym for GV_$GOLDENGATE_TRANSACTION
select * from GV$HANG_STATISTICS ; ---Synonym for GV_$HANG_STATISTICS
select * from GV$HM_CHECK ; ---Synonym for GV_$HM_CHECK
select * from GV$HM_CHECK_PARAM ; ---Synonym for GV_$HM_CHECK_PARAM
select * from GV$HM_FINDING ; ---Synonym for GV_$HM_FINDING
select * from GV$HM_INFO ; ---Synonym for GV_$HM_INFO
select * from GV$HM_RECOMMENDATION ; ---Synonym for GV_$HM_RECOMMENDATION
select * from GV$HM_RUN ; ---Synonym for GV_$HM_RUN
select * from GV$HS_AGENT ; ---Synonym for GV_$HS_AGENT
select * from GV$HS_PARAMETER ; ---Synonym for GV_$HS_PARAMETER
select * from GV$HS_SESSION ; ---Synonym for GV_$HS_SESSION
select * from GV$HVMASTER_INFO ; ---Synonym for GV_$HVMASTER_INFO
select * from GV$PARALLEL_DEGREE_LIMIT_MTH ; ---Synonym for GV_$PARALLEL_DEGREE_LIMIT_MTH
select * from GV$PARAMETER ; ---Synonym for GV_$PARAMETER
select * from GV$PARAMETER2 ; ---Synonym for GV_$PARAMETER2
select * from GV$PARAMETER_VALID_VALUES ; ---Synonym for GV_$PARAMETER_VALID_VALUES
select * from GV$PERSISTENT_PUBLISHERS ; ---Synonym for GV_$PERSISTENT_PUBLISHERS
select * from GV$PERSISTENT_QMN_CACHE ; ---Synonym for GV_$PERSISTENT_QMN_CACHE
select * from GV$PERSISTENT_QUEUES ; ---Synonym for GV_$PERSISTENT_QUEUES
select * from GV$PERSISTENT_SUBSCRIBERS ; ---Synonym for GV_$PERSISTENT_SUBSCRIBERS
select * from GV$PGASTAT ; ---Synonym for GV_$PGASTAT
select * from GV$PGA_TARGET_ADVICE ; ---Synonym for GV_$PGA_TARGET_ADVICE
select * from GV$PGA_TARGET_ADVICE_HISTOGRAM ; ---Synonym for GV_$PGATARGET_ADVICE_HISTOGRAM
select * from GV$POLICY_HISTORY ; ---Synonym for GV_$POLICY_HISTORY
select * from GV$PQ_SESSTAT ; ---Synonym for GV_$PQ_SESSTAT
select * from GV$PQ_SLAVE ; ---Synonym for GV_$PQ_SLAVE
select * from GV$PQ_SYSSTAT ; ---Synonym for GV_$PQ_SYSSTAT
select * from GV$PQ_TQSTAT ; ---Synonym for GV_$PQ_TQSTAT
select * from GV$PROCESS ; ---Synonym for GV_$PROCESS
select * from GV$PROCESS_GROUP ; ---Synonym for GV_$PROCESS_GROUP
select * from GV$PROCESS_MEMORY ; ---Synonym for GV_$PROCESS_MEMORY
select * from GV$PROCESS_MEMORY_DETAIL ; ---Synonym for GV_$PROCESS_MEMORY_DETAIL
select * from GV$PROCESS_MEMORY_DETAIL_PROG ; ---Synonym for GV_$PROCESS_MEMORY_DETAIL_PROG
select * from GV$PROPAGATION_RECEIVER ; ---Synonym for GV_$PROPAGATION_RECEIVER
select * from GV$PROPAGATION_SENDER ; ---Synonym for GV_$PROPAGATION_SENDER
select * from GV$PROXY_ARCHIVEDLOG ; ---Synonym for GV_$PROXY_ARCHIVEDLOG
select * from GV$PROXY_DATAFILE ; ---Synonym for GV_$PROXY_DATAFILE
select * from GV$PWFILE_USERS ; ---Synonym for GV_$PWFILE_USERS
select * from GV$PX_BUFFER_ADVICE ; ---Synonym for GV_$PX_BUFFER_ADVICE
select * from GV$PX_INSTANCE_GROUP ; ---Synonym for GV_$PX_INSTANCE_GROUP
select * from GV$PX_PROCESS ; ---Synonym for GV_$PX_PROCESS
select * from GV$PX_PROCESS_SYSSTAT ; ---Synonym for GV_$PX_PROCESS_SYSSTAT
select * from GV$PX_SESSION ; ---Synonym for GV_$PX_SESSION
select * from GV$PX_SESSTAT ; ---Synonym for GV_$PX_SESSTAT
select * from GV$QMON_COORDINATOR_STATS ; ---Synonym for GV_$QMON_COORDINATOR_STATS
select * from GV$QMON_SERVER_STATS ; ---Synonym for GV_$QMON_SERVER_STATS
select * from GV$QMON_TASKS ; ---Synonym for GV_$QMON_TASKS
select * from GV$QMON_TASK_STATS ; ---Synonym for GV_$QMON_TASK_STATS
select * from GV$QUEUE ; ---Synonym for GV_$QUEUE
select * from GV$QUEUEING_MTH ; ---Synonym for GV_$QUEUEING_MTH
select * from GV$RECOVERY_FILE_STATUS ; ---Synonym for GV_$RECOVERY_FILE_STATUS
select * from GV$RECOVERY_LOG ; ---Synonym for GV_$RECOVERY_LOG
select * from GV$RECOVERY_PROGRESS ; ---Synonym for GV_$RECOVERY_PROGRESS
select * from GV$RECOVERY_STATUS ; ---Synonym for GV_$RECOVERY_STATUS
select * from GV$RECOVER_FILE ; ---Synonym for GV_$RECOVER_FILE
select * from GV$REDO_DEST_RESP_HISTOGRAM ; ---Synonym for GV_$REDO_DEST_RESP_HISTOGRAM
select * from GV$REPLPROP ; ---Synonym for GV_$REPLPROP
select * from GV$REPLQUEUE ; ---Synonym for GV_$REPLQUEUE
select * from GV$REQDIST ; ---Synonym for GV_$REQDIST
select * from GV$RESERVED_WORDS ; ---Synonym for GV_$RESERVED_WORDS
select * from GV$RESOURCE ; ---Synonym for GV_$RESOURCE
select * from GV$RESOURCE_LIMIT ; ---Synonym for GV_$RESOURCE_LIMIT
select * from GV$RESTORE_POINT ; ---Synonym for GV_$RESTORE_POINT
select * from GV$RESULT_CACHE_DEPENDENCY ; ---Synonym for GV_$RESULT_CACHE_DEPENDENCY
select * from GV$RESULT_CACHE_MEMORY ; ---Synonym for GV_$RESULT_CACHE_MEMORY
select * from GV$RESULT_CACHE_OBJECTS ; ---Synonym for GV_$RESULT_CACHE_OBJECTS
select * from GV$RESULT_CACHE_STATISTICS ; ---Synonym for GV_$RESULT_CACHE_STATISTICS
select * from GV$RESUMABLE ; ---Synonym for GV_$RESUMABLE
select * from GV$RFS_THREAD ; ---Synonym for GV_$RFS_THREAD
select * from GV$RMAN_COMPRESSION_ALGORITHM ; ---Synonym for GV_$RMAN_COMPRESSION_ALGORITHM
select * from GV$RMAN_CONFIGURATION ; ---Synonym for GV_$RMAN_CONFIGURATION
select * from GV$RMAN_OUTPUT ; ---Synonym for GV_$RMAN_OUTPUT
select * from GV$ROLLSTAT ; ---Synonym for GV_$ROLLSTAT
select * from GV$ROWCACHE ; ---Synonym for GV_$ROWCACHE
select * from GV$ROWCACHE_PARENT ; ---Synonym for GV_$ROWCACHE_PARENT
select * from GV$ROWCACHE_SUBORDINATE ; ---Synonym for GV_$ROWCACHE_SUBORDINATE
select * from GV$RSRCMGRMETRIC ; ---Synonym for GV_$RSRCMGRMETRIC
select * from GV$RSRCMGRMETRIC_HISTORY ; ---Synonym for GV_$RSRCMGRMETRIC_HISTORY
select * from GV$RSRC_CONSUMER_GROUP ; ---Synonym for GV_$RSRC_CONSUMER_GROUP
select * from GV$RSRC_CONSUMER_GROUP_CPU_MTH ; ---Synonym for GV_$RSRC_CONSUME_GROUP_CPU_MTH
select * from GV$RSRC_CONS_GROUP_HISTORY ; ---Synonym for GV_$RSRC_CONS_GROUP_HISTORY
select * from GV$RSRC_PLAN ; ---Synonym for GV_$RSRC_PLAN
select * from GV$RSRC_PLAN_CPU_MTH ; ---Synonym for GV_$RSRC_PLAN_CPU_MTH
select * from GV$RSRC_PLAN_HISTORY ; ---Synonym for GV_$RSRC_PLAN_HISTORY
select * from GV$RSRC_SESSION_INFO ; ---Synonym for GV_$RSRC_SESSION_INFO
select * from GV$RULE ; ---Synonym for GV_$RULE
select * from GV$RULE_SET ; ---Synonym for GV_$RULE_SET
select * from GV$RULE_SET_AGGREGATE_STATS ; ---Synonym for GV_$RULE_SET_AGGREGATE_STATS
select * from GV$SCHEDULER_RUNNING_JOBS ; ---Synonym for GV_$SCHEDULER_RUNNING_JOBS
select * from GV$SECUREFILE_TIMER ; ---Synonym for GV_$SECUREFILE_TIMER
select * from GV$SEGMENT_STATISTICS ; ---Synonym for GV_$SEGMENT_STATISTICS
select * from GV$SEGSPACE_USAGE ; ---Synonym for GV_$SEGSPACE_USAGE
select * from GV$SEGSTAT ; ---Synonym for GV_$SEGSTAT
select * from GV$SEGSTAT_NAME ; ---Synonym for GV_$SEGSTAT_NAME
select * from GV$SERVICEMETRIC ; ---Synonym for GV_$SERVICEMETRIC
select * from GV$SERVICEMETRIC_HISTORY ; ---Synonym for GV_$SERVICEMETRIC_HISTORY
select * from GV$SERVICES ; ---Synonym for GV_$SERVICES
select * from GV$SERVICE_EVENT ; ---Synonym for GV_$SERVICE_EVENT
select * from GV$SERVICE_STATS ; ---Synonym for GV_$SERVICE_STATS
select * from GV$SERVICE_WAIT_CLASS ; ---Synonym for GV_$SERVICE_WAIT_CLASS
select * from GV$SERV_MOD_ACT_STATS ; ---Synonym for GV_$SERV_MOD_ACT_STATS
select * from GV$SESSION ; ---Synonym for GV_$SESSION
select * from GV$SESSION_BLOCKERS ; ---Synonym for GV_$SESSION_BLOCKERS
select * from GV$SESSION_CONNECT_INFO ; ---Synonym for GV_$SESSION_CONNECT_INFO
select * from GV$SESSION_CURSOR_CACHE ; ---Synonym for GV_$SESSION_CURSOR_CACHE
select * from GV$SESSION_EVENT ; ---Synonym for GV_$SESSION_EVENT
select * from GV$SESSION_FIX_CONTROL ; ---Synonym for GV_$SESSION_FIX_CONTROL
select * from GV$SESSION_LONGOPS ; ---Synonym for GV_$SESSION_LONGOPS
select * from GV$SESSION_OBJECT_CACHE ; ---Synonym for GV_$SESSION_OBJECT_CACHE
select * from GV$SESSION_WAIT ; ---Synonym for GV_$SESSION_WAIT
select * from GV$SESSION_WAIT_CLASS ; ---Synonym for GV_$SESSION_WAIT_CLASS
select * from GV$SESSION_WAIT_HISTORY ; ---Synonym for GV_$SESSION_WAIT_HISTORY
select * from GV$SESSMETRIC ; ---Synonym for GV_$SESSMETRIC
select * from GV$SESSTAT ; ---Synonym for GV_$SESSTAT
select * from GV$SESS_IO ; ---Synonym for GV_$SESS_IO
select * from GV$SESS_TIME_MODEL ; ---Synonym for GV_$SESS_TIME_MODEL
select * from GV$SES_OPTIMIZER_ENV ; ---Synonym for GV_$SES_OPTIMIZER_ENV
select * from GV$SGA ; ---Synonym for GV_$SGA
select * from GV$SGAINFO ; ---Synonym for GV_$SGAINFO
select * from GV$SGASTAT ; ---Synonym for GV_$SGASTAT
select * from GV$SGA_CURRENT_RESIZE_OPS ; ---Synonym for GV_$SGA_CURRENT_RESIZE_OPS
select * from GV$SGA_DYNAMIC_COMPONENTS ; ---Synonym for GV_$SGA_DYNAMIC_COMPONENTS
select * from GV$SGA_DYNAMIC_FREE_MEMORY ; ---Synonym for GV_$SGA_DYNAMIC_FREE_MEMORY
select * from GV$SGA_RESIZE_OPS ; ---Synonym for GV_$SGA_RESIZE_OPS
select * from GV$SGA_TARGET_ADVICE ; ---Synonym for GV_$SGA_TARGET_ADVICE
select * from V$RMAN_BACKUP_JOB_DETAILS ; ---Synonym for V_$RMAN_BACKUP_JOB_DETAILS
select * from V$RMAN_BACKUP_SUBJOB_DETAILS ; ---Synonym for V_$RMAN_BACKUP_SUBJOB_DETAILS
select * from V$RMAN_BACKUP_TYPE ; ---Synonym for V_$RMAN_BACKUP_TYPE
select * from V$RMAN_COMPRESSION_ALGORITHM ; ---Synonym for V_$RMAN_COMPRESSION_ALGORITHM
select * from V$RMAN_CONFIGURATION ; ---Synonym for V_$RMAN_CONFIGURATION
select * from V$RMAN_ENCRYPTION_ALGORITHMS ; ---Synonym for V_$RMAN_ENCRYPTION_ALGORITHMS
select * from V$RMAN_OUTPUT ; ---Synonym for V_$RMAN_OUTPUT
select * from V$RMAN_STATUS ; ---Synonym for V_$RMAN_STATUS
select * from V$ROLLNAME ; ---Synonym for V_$ROLLNAME
select * from V$ROLLSTAT ; ---Synonym for V_$ROLLSTAT
select * from V$ROWCACHE ; ---Synonym for V_$ROWCACHE
select * from V$ROWCACHE_PARENT ; ---Synonym for V_$ROWCACHE_PARENT
select * from V$ROWCACHE_SUBORDINATE ; ---Synonym for V_$ROWCACHE_SUBORDINATE
select * from V$RSRCMGRMETRIC ; ---Synonym for V_$RSRCMGRMETRIC
select * from V$RSRCMGRMETRIC_HISTORY ; ---Synonym for V_$RSRCMGRMETRIC_HISTORY
select * from V$RSRC_CONSUMER_GROUP ; ---Synonym for V_$RSRC_CONSUMER_GROUP
select * from V$RSRC_CONSUMER_GROUP_CPU_MTH ; ---Synonym for V_$RSRC_CONSUMER_GROUP_CPU_MTH
select * from V$RSRC_CONS_GROUP_HISTORY ; ---Synonym for V_$RSRC_CONS_GROUP_HISTORY
select * from V$RSRC_PLAN ; ---Synonym for V_$RSRC_PLAN
select * from V$RSRC_PLAN_CPU_MTH ; ---Synonym for V_$RSRC_PLAN_CPU_MTH
select * from V$RSRC_PLAN_HISTORY ; ---Synonym for V_$RSRC_PLAN_HISTORY
select * from V$RSRC_SESSION_INFO ; ---Synonym for V_$RSRC_SESSION_INFO
select * from V$RULE ; ---Synonym for V_$RULE
select * from V$RULE_SET ; ---Synonym for V_$RULE_SET
select * from V$RULE_SET_AGGREGATE_STATS ; ---Synonym for V_$RULE_SET_AGGREGATE_STATS
select * from V$SCHEDULER_RUNNING_JOBS ; ---Synonym for V_$SCHEDULER_RUNNING_JOBS
select * from V$SECUREFILE_TIMER ; ---Synonym for V_$SECUREFILE_TIMER
select * from V$SEGMENT_STATISTICS ; ---Synonym for V_$SEGMENT_STATISTICS
select * from V$SEGSPACE_USAGE ; ---Synonym for V_$SEGSPACE_USAGE
select * from V$SEGSTAT ; ---Synonym for V_$SEGSTAT
select * from V$SEGSTAT_NAME ; ---Synonym for V_$SEGSTAT_NAME
select * from V$SERVICEMETRIC ; ---Synonym for V_$SERVICEMETRIC
select * from V$SERVICEMETRIC_HISTORY ; ---Synonym for V_$SERVICEMETRIC_HISTORY
select * from V$SERVICES ; ---Synonym for V_$SERVICES
select * from V$SERVICE_EVENT ; ---Synonym for V_$SERVICE_EVENT
select * from V$SERVICE_STATS ; ---Synonym for V_$SERVICE_STATS
select * from V$SERVICE_WAIT_CLASS ; ---Synonym for V_$SERVICE_WAIT_CLASS
select * from V$SERV_MOD_ACT_STATS ; ---Synonym for V_$SERV_MOD_ACT_STATS
select * from V$SESSION ; ---Synonym for V_$SESSION
select * from V$SESSION_BLOCKERS ; ---Synonym for V_$SESSION_BLOCKERS
select * from V$SESSION_CONNECT_INFO ; ---Synonym for V_$SESSION_CONNECT_INFO
select * from V$SESSION_CURSOR_CACHE ; ---Synonym for V_$SESSION_CURSOR_CACHE
select * from V$SESSION_EVENT ; ---Synonym for V_$SESSION_EVENT
select * from V$SESSION_FIX_CONTROL ; ---Synonym for V_$SESSION_FIX_CONTROL
select * from V$SESSION_LONGOPS ; ---Synonym for V_$SESSION_LONGOPS
select * from V$SESSION_OBJECT_CACHE ; ---Synonym for V_$SESSION_OBJECT_CACHE
select * from V$SESSION_WAIT ; ---Synonym for V_$SESSION_WAIT
select * from V$SESSION_WAIT_CLASS ; ---Synonym for V_$SESSION_WAIT_CLASS
select * from V$SESSION_WAIT_HISTORY ; ---Synonym for V_$SESSION_WAIT_HISTORY
select * from V$SESSMETRIC ; ---Synonym for V_$SESSMETRIC
select * from V$SESSTAT ; ---Synonym for V_$SESSTAT
select * from V$SESS_IO ; ---Synonym for V_$SESS_IO
select * from V$SESS_TIME_MODEL ; ---Synonym for V_$SESS_TIME_MODEL
select * from V$SES_OPTIMIZER_ENV ; ---Synonym for V_$SES_OPTIMIZER_ENV
select * from V$SGA ; ---Synonym for V_$SGA
select * from V$SGAINFO ; ---Synonym for V_$SGAINFO
select * from V$SGASTAT ; ---Synonym for V_$SGASTAT
select * from V$SGA_CURRENT_RESIZE_OPS ; ---Synonym for V_$SGA_CURRENT_RESIZE_OPS
select * from V$SGA_DYNAMIC_COMPONENTS ; ---Synonym for V_$SGA_DYNAMIC_COMPONENTS
select * from V$SGA_DYNAMIC_FREE_MEMORY ; ---Synonym for V_$SGA_DYNAMIC_FREE_MEMORY
select * from V$SGA_RESIZE_OPS ; ---Synonym for V_$SGA_RESIZE_OPS
select * from V$SGA_TARGET_ADVICE ; ---Synonym for V_$SGA_TARGET_ADVICE
select * from V$SHARED_POOL_ADVICE ; ---Synonym for V_$SHARED_POOL_ADVICE
select * from V$SHARED_POOL_RESERVED ; ---Synonym for V_$SHARED_POOL_RESERVED
select * from V$SHARED_SERVER ; ---Synonym for V_$SHARED_SERVER
select * from V$SHARED_SERVER_MONITOR ; ---Synonym for V_$SHARED_SERVER_MONITOR
select * from V$SORT_SEGMENT ; ---Synonym for V_$SORT_SEGMENT
select * from V$SORT_USAGE ; ---Synonym for V_$SORT_USAGE
select * from V$SPPARAMETER ; ---Synonym for V_$SPPARAMETER
select * from V$SQL ; ---Synonym for V_$SQL
select * from V$SQLAREA ; ---Synonym for V_$SQLAREA
select * from V$SQLAREA_PLAN_HASH ; ---Synonym for V_$SQLAREA_PLAN_HASH
select * from V$SQLCOMMAND ; ---Synonym for V_$SQLCOMMAND
select * from V$SQLFN_ARG_METADATA ; ---Synonym for V_$SQLFN_ARG_METADATA
select * from V$SQLFN_METADATA ; ---Synonym for V_$SQLFN_METADATA
select * from V$SQLPA_METRIC ; ---Synonym for V_$SQLPA_METRIC
select * from V$SQLSTATS ; ---Synonym for V_$SQLSTATS
select * from V$SQLSTATS_PLAN_HASH ; ---Synonym for V_$SQLSTATS_PLAN_HASH
select * from V$SQLTEXT ; ---Synonym for V_$SQLTEXT
select * from V$SQLTEXT_WITH_NEWLINES ; ---Synonym for V_$SQLTEXT_WITH_NEWLINES
select * from V$SQL_BIND_CAPTURE ; ---Synonym for V_$SQL_BIND_CAPTURE
select * from V$SQL_BIND_DATA ; ---Synonym for V_$SQL_BIND_DATA
select * from V$SQL_BIND_METADATA ; ---Synonym for V_$SQL_BIND_METADATA
select * from V$SQL_CS_HISTOGRAM ; ---Synonym for V_$SQL_CS_HISTOGRAM
select * from V$SQL_CS_SELECTIVITY ; ---Synonym for V_$SQL_CS_SELECTIVITY
select * from V$SQL_CS_STATISTICS ; ---Synonym for V_$SQL_CS_STATISTICS
select * from V$SQL_CURSOR ; ---Synonym for V_$SQL_CURSOR
select * from V$SQL_FEATURE ; ---Synonym for V_$SQL_FEATURE
select * from V$SQL_FEATURE_DEPENDENCY ; ---Synonym for V_$SQL_FEATURE_DEPENDENCY
select * from V$SQL_FEATURE_HIERARCHY ; ---Synonym for V_$SQL_FEATURE_HIERARCHY
select * from V$SQL_HINT ; ---Synonym for V_$SQL_HINT
select * from V$SQL_JOIN_FILTER ; ---Synonym for V_$SQL_JOIN_FILTER
select * from V$SQL_MONITOR ; ---Synonym for V_$SQL_MONITOR
select * from V$SQL_OPTIMIZER_ENV ; ---Synonym for V_$SQL_OPTIMIZER_ENV
select * from V$SQL_PLAN ; ---Synonym for V_$SQL_PLAN
select * from V$SQL_PLAN_MONITOR ; ---Synonym for V_$SQL_PLAN_MONITOR
select * from V$SQL_PLAN_STATISTICS ; ---Synonym for V_$SQL_PLAN_STATISTICS
select * from V$SQL_PLAN_STATISTICS_ALL ; ---Synonym for V_$SQL_PLAN_STATISTICS_ALL
select * from V$SQL_REDIRECTION ; ---Synonym for V_$SQL_REDIRECTION
select * from V$SQL_SHARED_CURSOR ; ---Synonym for V_$SQL_SHARED_CURSOR
select * from V$SQL_SHARED_MEMORY ; ---Synonym for V_$SQL_SHARED_MEMORY
select * from V$SQL_WORKAREA ; ---Synonym for V_$SQL_WORKAREA
select * from V$SQL_WORKAREA_ACTIVE ; ---Synonym for V_$SQL_WORKAREA_ACTIVE
select * from V$SQL_WORKAREA_HISTOGRAM ; ---Synonym for V_$SQL_WORKAREA_HISTOGRAM
select * from V$SSCR_SESSIONS ; ---Synonym for V_$SSCR_SESSIONS
select * from V$STANDBY_EVENT_HISTOGRAM ; ---Synonym for V_$STANDBY_EVENT_HISTOGRAM
select * from V$STANDBY_LOG ; ---Synonym for V_$STANDBY_LOG
select * from V$STATISTICS_LEVEL ; ---Synonym for V_$STATISTICS_LEVEL
select * from V$STATNAME ; ---Synonym for V_$STATNAME
select * from V$STREAMS_APPLY_COORDINATOR ; ---Synonym for V_$STREAMS_APPLY_COORDINATOR
select * from V$STREAMS_APPLY_READER ; ---Synonym for V_$STREAMS_APPLY_READER
select * from V$STREAMS_APPLY_SERVER ; ---Synonym for V_$STREAMS_APPLY_SERVER
select * from V$STREAMS_CAPTURE ; ---Synonym for V_$STREAMS_CAPTURE
select * from V$STREAMS_MESSAGE_TRACKING ; ---Synonym for V_$STREAMS_MESSAGE_TRACKING
select * from V$STREAMS_POOL_ADVICE ; ---Synonym for V_$STREAMS_POOL_ADVICE
select * from V$STREAMS_POOL_STATISTICS ; ---Synonym for V_$STREAMS_POOL_STATISTICS
select * from V$STREAMS_TRANSACTION ; ---Synonym for V_$STREAMS_TRANSACTION
select * from V$SUBCACHE ; ---Synonym for V_$SUBCACHE
select * from V$SUBSCR_REGISTRATION_STATS ; ---Synonym for V_$SUBSCR_REGISTRATION_STATS
select * from GV$SHARED_POOL_ADVICE ; ---Synonym for GV_$SHARED_POOL_ADVICE
select * from GV$SHARED_POOL_RESERVED ; ---Synonym for GV_$SHARED_POOL_RESERVED
select * from GV$SHARED_SERVER ; ---Synonym for GV_$SHARED_SERVER
select * from GV$SHARED_SERVER_MONITOR ; ---Synonym for GV_$SHARED_SERVER_MONITOR
select * from GV$SORT_SEGMENT ; ---Synonym for GV_$SORT_SEGMENT
select * from GV$SORT_USAGE ; ---Synonym for GV_$SORT_USAGE
select * from GV$SPPARAMETER ; ---Synonym for GV_$SPPARAMETER
select * from GV$SQL ; ---Synonym for GV_$SQL
select * from GV$SQLAREA ; ---Synonym for GV_$SQLAREA
select * from GV$SQLAREA_PLAN_HASH ; ---Synonym for GV_$SQLAREA_PLAN_HASH
select * from GV$SQLCOMMAND ; ---Synonym for GV_$SQLCOMMAND
select * from GV$SQLFN_ARG_METADATA ; ---Synonym for GV_$SQLFN_ARG_METADATA
select * from GV$SQLFN_METADATA ; ---Synonym for GV_$SQLFN_METADATA
select * from GV$SQLPA_METRIC ; ---Synonym for GV_$SQLPA_METRIC
select * from GV$SQLSTATS ; ---Synonym for GV_$SQLSTATS
select * from GV$SQLSTATS_PLAN_HASH ; ---Synonym for GV_$SQLSTATS_PLAN_HASH
select * from GV$SQLTEXT ; ---Synonym for GV_$SQLTEXT
select * from GV$SQLTEXT_WITH_NEWLINES ; ---Synonym for GV_$SQLTEXT_WITH_NEWLINES
select * from GV$SQL_BIND_CAPTURE ; ---Synonym for GV_$SQL_BIND_CAPTURE
select * from GV$SQL_BIND_DATA ; ---Synonym for GV_$SQL_BIND_DATA
select * from GV$SQL_BIND_METADATA ; ---Synonym for GV_$SQL_BIND_METADATA
select * from GV$SQL_CS_HISTOGRAM ; ---Synonym for GV_$SQL_CS_HISTOGRAM
select * from GV$SQL_CS_SELECTIVITY ; ---Synonym for GV_$SQL_CS_SELECTIVITY
select * from GV$SQL_CS_STATISTICS ; ---Synonym for GV_$SQL_CS_STATISTICS
select * from GV$SQL_CURSOR ; ---Synonym for GV_$SQL_CURSOR
select * from GV$SQL_FEATURE ; ---Synonym for GV_$SQL_FEATURE
select * from GV$SQL_FEATURE_DEPENDENCY ; ---Synonym for GV_$SQL_FEATURE_DEPENDENCY
select * from GV$SQL_FEATURE_HIERARCHY ; ---Synonym for GV_$SQL_FEATURE_HIERARCHY
select * from GV$SQL_HINT ; ---Synonym for GV_$SQL_HINT
select * from GV$SQL_JOIN_FILTER ; ---Synonym for GV_$SQL_JOIN_FILTER
select * from GV$SQL_MONITOR ; ---Synonym for GV_$SQL_MONITOR
select * from GV$SQL_OPTIMIZER_ENV ; ---Synonym for GV_$SQL_OPTIMIZER_ENV
select * from GV$SQL_PLAN ; ---Synonym for GV_$SQL_PLAN
select * from GV$SQL_PLAN_MONITOR ; ---Synonym for GV_$SQL_PLAN_MONITOR
select * from GV$SQL_PLAN_STATISTICS ; ---Synonym for GV_$SQL_PLAN_STATISTICS
select * from GV$SQL_PLAN_STATISTICS_ALL ; ---Synonym for GV_$SQL_PLAN_STATISTICS_ALL
select * from GV$SQL_REDIRECTION ; ---Synonym for GV_$SQL_REDIRECTION
select * from GV$SQL_SHARED_CURSOR ; ---Synonym for GV_$SQL_SHARED_CURSOR
select * from GV$SQL_SHARED_MEMORY ; ---Synonym for GV_$SQL_SHARED_MEMORY
select * from GV$SQL_WORKAREA ; ---Synonym for GV_$SQL_WORKAREA
select * from GV$SQL_WORKAREA_ACTIVE ; ---Synonym for GV_$SQL_WORKAREA_ACTIVE
select * from GV$SQL_WORKAREA_HISTOGRAM ; ---Synonym for GV_$SQL_WORKAREA_HISTOGRAM
select * from GV$SSCR_SESSIONS ; ---Synonym for GV_$SSCR_SESSIONS
select * from GV$STANDBY_LOG ; ---Synonym for GV_$STANDBY_LOG
select * from GV$STATISTICS_LEVEL ; ---Synonym for GV_$STATISTICS_LEVEL
select * from GV$STATNAME ; ---Synonym for GV_$STATNAME
select * from GV$STREAMS_APPLY_COORDINATOR ; ---Synonym for GV_$STREAMS_APPLY_COORDINATOR
select * from GV$STREAMS_APPLY_READER ; ---Synonym for GV_$STREAMS_APPLY_READER
select * from GV$STREAMS_APPLY_SERVER ; ---Synonym for GV_$STREAMS_APPLY_SERVER
select * from GV$STREAMS_CAPTURE ; ---Synonym for GV_$STREAMS_CAPTURE
select * from GV$STREAMS_MESSAGE_TRACKING ; ---Synonym for GV_$STREAMS_MESSAGE_TRACKING
select * from GV$STREAMS_POOL_ADVICE ; ---Synonym for GV_$STREAMS_POOL_ADVICE
select * from GV$STREAMS_POOL_STATISTICS ; ---Synonym for GV_$STREAMS_POOL_STATISTICS
select * from GV$STREAMS_TRANSACTION ; ---Synonym for GV_$STREAMS_TRANSACTION
select * from GV$SUBCACHE ; ---Synonym for GV_$SUBCACHE
select * from GV$SUBSCR_REGISTRATION_STATS ; ---Synonym for GV_$SUBSCR_REGISTRATION_STATS
select * from GV$SYSAUX_OCCUPANTS ; ---Synonym for GV_$SYSAUX_OCCUPANTS
select * from GV$SYSMETRIC ; ---Synonym for GV_$SYSMETRIC
select * from GV$SYSMETRIC_HISTORY ; ---Synonym for GV_$SYSMETRIC_HISTORY
select * from GV$SYSMETRIC_SUMMARY ; ---Synonym for GV_$SYSMETRIC_SUMMARY
select * from GV$SYSSTAT ; ---Synonym for GV_$SYSSTAT
select * from GV$SYSTEM_CURSOR_CACHE ; ---Synonym for GV_$SYSTEM_CURSOR_CACHE
select * from GV$SYSTEM_EVENT ; ---Synonym for GV_$SYSTEM_EVENT
select * from GV$SYSTEM_FIX_CONTROL ; ---Synonym for GV_$SYSTEM_FIX_CONTROL
select * from GV$SYSTEM_PARAMETER ; ---Synonym for GV_$SYSTEM_PARAMETER
select * from GV$SYSTEM_PARAMETER2 ; ---Synonym for GV_$SYSTEM_PARAMETER2
select * from GV$SYSTEM_WAIT_CLASS ; ---Synonym for GV_$SYSTEM_WAIT_CLASS
select * from GV$SYS_OPTIMIZER_ENV ; ---Synonym for GV_$SYS_OPTIMIZER_ENV
select * from GV$SYS_TIME_MODEL ; ---Synonym for GV_$SYS_TIME_MODEL
select * from GV$TABLESPACE ; ---Synonym for GV_$TABLESPACE
select * from GV$TEMPFILE ; ---Synonym for GV_$TEMPFILE
select * from GV$TEMPORARY_LOBS ; ---Synonym for GV_$TEMPORARY_LOBS
select * from GV$TEMPSEG_USAGE ; ---Synonym for GV_$SORT_USAGE
select * from GV$TEMPSTAT ; ---Synonym for GV_$TEMPSTAT
select * from GV$TEMP_CACHE_TRANSFER ; ---Synonym for GV_$TEMP_CACHE_TRANSFER
select * from GV$TEMP_EXTENT_MAP ; ---Synonym for GV_$TEMP_EXTENT_MAP
select * from GV$TEMP_EXTENT_POOL ; ---Synonym for GV_$TEMP_EXTENT_POOL
select * from GV$TEMP_PING ; ---Synonym for GV_$TEMP_PING
select * from GV$TEMP_SPACE_HEADER ; ---Synonym for GV_$TEMP_SPACE_HEADER
select * from GV$THREAD ; ---Synonym for GV_$THREAD
select * from GV$THRESHOLD_TYPES ; ---Synonym for GV_$THRESHOLD_TYPES
select * from GV$TIMER ; ---Synonym for GV_$TIMER
select * from GV$TIMEZONE_FILE ; ---Synonym for GV_$TIMEZONE_FILE
select * from GV$TIMEZONE_NAMES ; ---Synonym for GV_$TIMEZONE_NAMES
select * from GV$TOPLEVELCALL ; ---Synonym for GV_$TOPLEVELCALL
select * from GV$TRANSACTION ; ---Synonym for GV_$TRANSACTION
select * from GV$TRANSACTION_ENQUEUE ; ---Synonym for GV_$TRANSACTION_ENQUEUE
select * from GV$TRANSPORTABLE_PLATFORM ; ---Synonym for GV_$TRANSPORTABLE_PLATFORM
select * from GV$TSM_SESSIONS ; ---Synonym for GV_$TSM_SESSIONS
select * from GV$TYPE_SIZE ; ---Synonym for GV_$TYPE_SIZE
select * from GV$UNDOSTAT ; ---Synonym for GV_$UNDOSTAT
select * from GV$VERSION ; ---Synonym for GV_$VERSION
select * from GV$VPD_POLICY ; ---Synonym for GV_$VPD_POLICY
select * from GV$WAITCLASSMETRIC ; ---Synonym for GV_$WAITCLASSMETRIC
select * from GV$WAITCLASSMETRIC_HISTORY ; ---Synonym for GV_$WAITCLASSMETRIC_HISTORY
select * from GV$WAITSTAT ; ---Synonym for GV_$WAITSTAT
select * from GV$WALLET ; ---Synonym for GV_$WALLET
select * from GV$WLM_PCMETRIC ; ---Synonym for GV_$WLM_PCMETRIC
select * from GV$WLM_PCMETRIC_HISTORY ; ---Synonym for GV_$WLM_PCMETRIC_HISTORY
select * from GV$WLM_PC_STATS ; ---Synonym for GV_$WLM_PC_STATS
select * from GV$WORKLOAD_REPLAY_THREAD ; ---Synonym for GV_$WORKLOAD_REPLAY_THREAD
select * from V$DLM_ALL_LOCKS ; ---Synonym for V_$DLM_ALL_LOCKS
select * from V$DLM_CONVERT_LOCAL ; ---Synonym for V_$DLM_CONVERT_LOCAL
select * from V$DLM_CONVERT_REMOTE ; ---Synonym for V_$DLM_CONVERT_REMOTE
select * from V$DLM_LATCH ; ---Synonym for V_$DLM_LATCH
select * from V$DLM_LOCKS ; ---Synonym for V_$DLM_LOCKS
select * from V$DLM_MISC ; ---Synonym for V_$DLM_MISC
select * from V$DLM_RESS ; ---Synonym for V_$DLM_RESS
select * from V$DLM_TRAFFIC_CONTROLLER ; ---Synonym for V_$DLM_TRAFFIC_CONTROLLER
select * from V$DNFS_CHANNELS ; ---Synonym for V_$DNFS_CHANNELS
select * from V$DNFS_FILES ; ---Synonym for V_$DNFS_FILES
select * from V$DNFS_SERVERS ; ---Synonym for V_$DNFS_SERVERS
select * from V$DNFS_STATS ; ---Synonym for V_$DNFS_STATS
select * from V$DYNAMIC_REMASTER_STATS ; ---Synonym for V_$DYNAMIC_REMASTER_STATS
select * from V$EMON ; ---Synonym for V_$EMON
select * from V$ENABLEDPRIVS ; ---Synonym for V_$ENABLEDPRIVS
select * from V$ENCRYPTED_TABLESPACES ; ---Synonym for V_$ENCRYPTED_TABLESPACES
select * from V$ENCRYPTION_WALLET ; ---Synonym for V_$ENCRYPTION_WALLET
select * from V$ENQUEUE_LOCK ; ---Synonym for V_$ENQUEUE_LOCK
select * from V$ENQUEUE_STAT ; ---Synonym for V_$ENQUEUE_STAT
select * from V$ENQUEUE_STATISTICS ; ---Synonym for V_$ENQUEUE_STATISTICS
select * from V$EVENTMETRIC ; ---Synonym for V_$EVENTMETRIC
select * from V$EVENT_HISTOGRAM ; ---Synonym for V_$EVENT_HISTOGRAM
select * from V$EVENT_NAME ; ---Synonym for V_$EVENT_NAME
select * from V$EXECUTION ; ---Synonym for V_$EXECUTION
select * from V$FAST_START_SERVERS ; ---Synonym for V_$FAST_START_SERVERS
select * from V$FAST_START_TRANSACTIONS ; ---Synonym for V_$FAST_START_TRANSACTIONS
select * from V$FILEMETRIC ; ---Synonym for V_$FILEMETRIC
select * from V$FILEMETRIC_HISTORY ; ---Synonym for V_$FILEMETRIC_HISTORY
select * from V$FILESPACE_USAGE ; ---Synonym for V_$FILESPACE_USAGE
select * from V$FILESTAT ; ---Synonym for V_$FILESTAT
select * from V$FILE_CACHE_TRANSFER ; ---Synonym for V_$FILE_CACHE_TRANSFER
select * from V$FILE_HISTOGRAM ; ---Synonym for V_$FILE_HISTOGRAM
select * from V$FILE_OPTIMIZED_HISTOGRAM ; ---Synonym for V_$FILE_OPTIMIZED_HISTOGRAM
select * from V$FILE_PING ; ---Synonym for V_$FILE_PING
select * from V$FIXED_TABLE ; ---Synonym for V_$FIXED_TABLE
select * from V$FIXED_VIEW_DEFINITION ; ---Synonym for V_$FIXED_VIEW_DEFINITION
select * from V$FLASHBACK_DATABASE_LOG ; ---Synonym for V_$FLASHBACK_DATABASE_LOG
select * from V$FLASHBACK_DATABASE_LOGFILE ; ---Synonym for V_$FLASHBACK_DATABASE_LOGFILE
select * from V$FLASHBACK_DATABASE_STAT ; ---Synonym for V_$FLASHBACK_DATABASE_STAT
select * from V$FLASHBACK_TXN_GRAPH ; ---Synonym for V_$FLASHBACK_TXN_GRAPH
select * from V$FLASHBACK_TXN_MODS ; ---Synonym for V_$FLASHBACK_TXN_MODS
select * from V$FLASH_RECOVERY_AREA_USAGE ; ---Synonym for V_$FLASH_RECOVERY_AREA_USAGE
select * from V$FOREIGN_ARCHIVED_LOG ; ---Synonym for V_$FOREIGN_ARCHIVED_LOG
select * from V$FS_FAILOVER_HISTOGRAM ; ---Synonym for V_$FS_FAILOVER_HISTOGRAM
select * from V$FS_FAILOVER_STATS ; ---Synonym for V_$FS_FAILOVER_STATS
select * from V$GCSHVMASTER_INFO ; ---Synonym for V_$GCSHVMASTER_INFO
select * from V$GCSPFMASTER_INFO ; ---Synonym for V_$GCSPFMASTER_INFO
select * from V$GC_ELEMENT ; ---Synonym for V_$GC_ELEMENT
select * from V$GC_ELEMENTS_WITH_COLLISIONS ; ---Synonym for V_$GC_ELEMENTS_W_COLLISIONS
select * from V$GES_BLOCKING_ENQUEUE ; ---Synonym for V_$GES_BLOCKING_ENQUEUE
select * from V$GES_ENQUEUE ; ---Synonym for V_$GES_ENQUEUE
select * from V$GLOBALCONTEXT ; ---Synonym for V_$GLOBALCONTEXT
select * from V$GLOBAL_BLOCKED_LOCKS ; ---Synonym for V_$GLOBAL_BLOCKED_LOCKS
select * from V$GLOBAL_TRANSACTION ; ---Synonym for V_$GLOBAL_TRANSACTION
select * from V$GOLDENGATE_CAPTURE ; ---Synonym for V_$GOLDENGATE_CAPTURE
select * from V$GOLDENGATE_MESSAGE_TRACKING ; ---Synonym for V_$GOLDENGATE_MESSAGE_TRACKING
select * from V$GOLDENGATE_TABLE_STATS ; ---Synonym for V_$GOLDENGATE_TABLE_STATS
select * from V$GOLDENGATE_TRANSACTION ; ---Synonym for V_$GOLDENGATE_TRANSACTION
select * from V$HANG_INFO ; ---Synonym for V_$HANG_INFO
select * from V$HANG_SESSION_INFO ; ---Synonym for V_$HANG_SESSION_INFO
select * from V$HANG_STATISTICS ; ---Synonym for V_$HANG_STATISTICS
select * from V$HM_CHECK ; ---Synonym for V_$HM_CHECK
select * from V$HM_CHECK_PARAM ; ---Synonym for V_$HM_CHECK_PARAM
select * from V$HM_FINDING ; ---Synonym for V_$HM_FINDING
select * from V$HM_INFO ; ---Synonym for V_$HM_INFO
select * from V$HM_RECOMMENDATION ; ---Synonym for V_$HM_RECOMMENDATION
select * from V$HM_RUN ; ---Synonym for V_$HM_RUN
select * from V$HS_AGENT ; ---Synonym for V_$HS_AGENT
select * from V$HS_PARAMETER ; ---Synonym for V_$HS_PARAMETER
select * from V$HS_SESSION ; ---Synonym for V_$HS_SESSION
select * from V$HVMASTER_INFO ; ---Synonym for V_$HVMASTER_INFO
select * from V$INCMETER_CONFIG ; ---Synonym for V_$INCMETER_CONFIG
select * from V$INCMETER_INFO ; ---Synonym for V_$INCMETER_INFO
select * from V$INCMETER_SUMMARY ; ---Synonym for V_$INCMETER_SUMMARY
select * from V$INDEXED_FIXED_COLUMN ; ---Synonym for V_$INDEXED_FIXED_COLUMN
select * from V$INSTANCE ; ---Synonym for V_$INSTANCE
select * from V$INSTANCE_CACHE_TRANSFER ; ---Synonym for V_$INSTANCE_CACHE_TRANSFER
select * from V$INSTANCE_LOG_GROUP ; ---Synonym for V_$INSTANCE_LOG_GROUP
select * from V$INSTANCE_RECOVERY ; ---Synonym for V_$INSTANCE_RECOVERY
select * from V$IOFUNCMETRIC ; ---Synonym for V_$IOFUNCMETRIC
select * from V$IOFUNCMETRIC_HISTORY ; ---Synonym for V_$IOFUNCMETRIC_HISTORY
select * from V$IOSTAT_CONSUMER_GROUP ; ---Synonym for V_$IOSTAT_CONSUMER_GROUP
select * from V$IOSTAT_FILE ; ---Synonym for V_$IOSTAT_FILE
select * from V$IOSTAT_FUNCTION ; ---Synonym for V_$IOSTAT_FUNCTION
select * from V$IOSTAT_FUNCTION_DETAIL ; ---Synonym for V_$IOSTAT_FUNCTION_DETAIL
select * from V$IOSTAT_NETWORK ; ---Synonym for V_$IOSTAT_NETWORK
select * from V$IO_CALIBRATION_STATUS ; ---Synonym for V_$IO_CALIBRATION_STATUS
select * from V$IR_FAILURE ; ---Synonym for V_$IR_FAILURE
select * from V$IR_FAILURE_SET ; ---Synonym for V_$IR_FAILURE_SET
select * from V$IR_MANUAL_CHECKLIST ; ---Synonym for V_$IR_MANUAL_CHECKLIST
select * from V$IR_REPAIR ; ---Synonym for V_$IR_REPAIR
select * from V$JAVAPOOL ; ---Synonym for V_$JAVAPOOL
select * from V$JAVA_LIBRARY_CACHE_MEMORY ; ---Synonym for V_$JAVA_LIBRARY_CACHE_MEMORY
select * from V$JAVA_POOL_ADVICE ; ---Synonym for V_$JAVA_POOL_ADVICE
select * from V$LATCH ; ---Synonym for V_$LATCH
select * from V$LATCHHOLDER ; ---Synonym for V_$LATCHHOLDER
select * from V$LATCHNAME ; ---Synonym for V_$LATCHNAME
select * from V$LATCH_CHILDREN ; ---Synonym for V_$LATCH_CHILDREN
select * from V$LATCH_MISSES ; ---Synonym for V_$LATCH_MISSES
select * from V$LATCH_PARENT ; ---Synonym for V_$LATCH_PARENT
select * from V$LIBCACHE_LOCKS ; ---Synonym for V_$LIBCACHE_LOCKS
select * from V$LIBRARYCACHE ; ---Synonym for V_$LIBRARYCACHE
select * from V$LIBRARY_CACHE_MEMORY ; ---Synonym for V_$LIBRARY_CACHE_MEMORY
select * from V$LICENSE ; ---Synonym for V_$LICENSE
select * from V$LISTENER_NETWORK ; ---Synonym for V_$LISTENER_NETWORK
select * from GV$INCMETER_CONFIG ; ---Synonym for GV_$INCMETER_CONFIG
select * from GV$INCMETER_INFO ; ---Synonym for GV_$INCMETER_INFO
select * from GV$INCMETER_SUMMARY ; ---Synonym for GV_$INCMETER_SUMMARY
select * from GV$INDEXED_FIXED_COLUMN ; ---Synonym for GV_$INDEXED_FIXED_COLUMN
select * from GV$INSTANCE ; ---Synonym for GV_$INSTANCE
select * from GV$INSTANCE_CACHE_TRANSFER ; ---Synonym for GV_$INSTANCE_CACHE_TRANSFER
select * from GV$INSTANCE_LOG_GROUP ; ---Synonym for GV_$INSTANCE_LOG_GROUP
select * from GV$INSTANCE_RECOVERY ; ---Synonym for GV_$INSTANCE_RECOVERY
select * from GV$IOFUNCMETRIC ; ---Synonym for GV_$IOFUNCMETRIC
select * from GV$IOFUNCMETRIC_HISTORY ; ---Synonym for GV_$IOFUNCMETRIC_HISTORY
select * from GV$IOSTAT_CONSUMER_GROUP ; ---Synonym for GV_$IOSTAT_CONSUMER_GROUP
select * from GV$IOSTAT_FILE ; ---Synonym for GV_$IOSTAT_FILE
select * from GV$IOSTAT_FUNCTION ; ---Synonym for GV_$IOSTAT_FUNCTION
select * from GV$IOSTAT_FUNCTION_DETAIL ; ---Synonym for GV_$IOSTAT_FUNCTION_DETAIL
select * from GV$IOSTAT_NETWORK ; ---Synonym for GV_$IOSTAT_NETWORK
select * from GV$IO_CALIBRATION_STATUS ; ---Synonym for GV_$IO_CALIBRATION_STATUS
select * from GV$IR_FAILURE ; ---Synonym for GV_$IR_FAILURE
select * from GV$IR_FAILURE_SET ; ---Synonym for GV_$IR_FAILURE_SET
select * from GV$IR_MANUAL_CHECKLIST ; ---Synonym for GV_$IR_MANUAL_CHECKLIST
select * from GV$IR_REPAIR ; ---Synonym for GV_$IR_REPAIR
select * from GV$JAVAPOOL ; ---Synonym for GV_$JAVAPOOL
select * from GV$JAVA_LIBRARY_CACHE_MEMORY ; ---Synonym for GV_$JAVA_LIBRARY_CACHE_MEMORY
select * from GV$JAVA_POOL_ADVICE ; ---Synonym for GV_$JAVA_POOL_ADVICE
select * from GV$LATCH ; ---Synonym for GV_$LATCH
select * from GV$LATCHHOLDER ; ---Synonym for GV_$LATCHHOLDER
select * from GV$LATCHNAME ; ---Synonym for GV_$LATCHNAME
select * from GV$LATCH_CHILDREN ; ---Synonym for GV_$LATCH_CHILDREN
select * from GV$LATCH_MISSES ; ---Synonym for GV_$LATCH_MISSES
select * from GV$LATCH_PARENT ; ---Synonym for GV_$LATCH_PARENT
select * from GV$LIBCACHE_LOCKS ; ---Synonym for GV_$LIBCACHE_LOCKS
select * from GV$LIBRARYCACHE ; ---Synonym for GV_$LIBRARYCACHE
select * from GV$LIBRARY_CACHE_MEMORY ; ---Synonym for GV_$LIBRARY_CACHE_MEMORY
select * from GV$LICENSE ; ---Synonym for GV_$LICENSE
select * from GV$LISTENER_NETWORK ; ---Synonym for GV_$LISTENER_NETWORK
select * from GV$LOADISTAT ; ---Synonym for GV_$LOADISTAT
select * from GV$LOADPSTAT ; ---Synonym for GV_$LOADPSTAT
select * from GV$LOBSTAT ; ---Synonym for GV_$LOBSTAT
select * from GV$LOCK ; ---Synonym for GV_$LOCK
select * from GV$LOCKED_OBJECT ; ---Synonym for GV_$LOCKED_OBJECT
select * from GV$LOCKS_WITH_COLLISIONS ; ---Synonym for GV_$LOCKS_WITH_COLLISIONS
select * from GV$LOCK_ACTIVITY ; ---Synonym for GV_$LOCK_ACTIVITY
select * from GV$LOCK_ELEMENT ; ---Synonym for GV_$LOCK_ELEMENT
select * from GV$LOCK_TYPE ; ---Synonym for GV_$LOCK_TYPE
select * from GV$LOG ; ---Synonym for GV_$LOG
select * from GV$LOGFILE ; ---Synonym for GV_$LOGFILE
select * from GV$LOGHIST ; ---Synonym for GV_$LOGHIST
select * from GV$LOGMNR_CALLBACK ; ---Synonym for GV_$LOGMNR_CALLBACK
select * from GV$LOGMNR_CONTENTS ; ---Synonym for GV_$LOGMNR_CONTENTS
select * from GV$LOGMNR_DICTIONARY ; ---Synonym for GV_$LOGMNR_DICTIONARY
select * from GV$LOGMNR_DICTIONARY_LOAD ; ---Synonym for GV_$LOGMNR_DICTIONARY_LOAD
select * from GV$LOGMNR_LATCH ; ---Synonym for GV_$LOGMNR_LATCH
select * from GV$LOGMNR_LOGFILE ; ---Synonym for GV_$LOGMNR_LOGFILE
select * from GV$LOGMNR_LOGS ; ---Synonym for GV_$LOGMNR_LOGS
select * from GV$LOGMNR_PARAMETERS ; ---Synonym for GV_$LOGMNR_PARAMETERS
select * from GV$LOGMNR_PROCESS ; ---Synonym for GV_$LOGMNR_PROCESS
select * from GV$LOGMNR_REGION ; ---Synonym for GV_$LOGMNR_REGION
select * from GV$LOGMNR_SESSION ; ---Synonym for GV_$LOGMNR_SESSION
select * from GV$LOGMNR_STATS ; ---Synonym for GV_$LOGMNR_STATS
select * from GV$LOGMNR_TRANSACTION ; ---Synonym for GV_$LOGMNR_TRANSACTION
select * from GV$LOGSTDBY ; ---Synonym for GV_$LOGSTDBY
select * from GV$LOGSTDBY_PROCESS ; ---Synonym for GV_$LOGSTDBY_PROCESS
select * from GV$LOGSTDBY_PROGRESS ; ---Synonym for GV_$LOGSTDBY_PROGRESS
select * from GV$LOGSTDBY_STATE ; ---Synonym for GV_$LOGSTDBY_STATE
select * from GV$LOGSTDBY_STATS ; ---Synonym for GV_$LOGSTDBY_STATS
select * from GV$LOGSTDBY_TRANSACTION ; ---Synonym for GV_$LOGSTDBY_TRANSACTION
select * from GV$LOG_HISTORY ; ---Synonym for GV_$LOG_HISTORY
select * from GV$MANAGED_STANDBY ; ---Synonym for GV_$MANAGED_STANDBY
select * from GV$MAP_COMP_LIST ; ---Synonym for GV_$MAP_COMP_LIST
select * from GV$MAP_ELEMENT ; ---Synonym for GV_$MAP_ELEMENT
select * from GV$MAP_EXT_ELEMENT ; ---Synonym for GV_$MAP_EXT_ELEMENT
select * from GV$MAP_FILE ; ---Synonym for GV_$MAP_FILE
select * from GV$MAP_FILE_EXTENT ; ---Synonym for GV_$MAP_FILE_EXTENT
select * from GV$MAP_FILE_IO_STACK ; ---Synonym for GV_$MAP_FILE_IO_STACK
select * from GV$MAP_LIBRARY ; ---Synonym for GV_$MAP_LIBRARY
select * from GV$MAP_SUBELEMENT ; ---Synonym for GV_$MAP_SUBELEMENT
select * from GV$MAX_ACTIVE_SESS_TARGET_MTH ; ---Synonym for GV_$MAX_ACTIVE_SESS_TARGET_MTH
select * from GV$MEMORY_CURRENT_RESIZE_OPS ; ---Synonym for GV_$MEMORY_CURRENT_RESIZE_OPS
select * from GV$MEMORY_DYNAMIC_COMPONENTS ; ---Synonym for GV_$MEMORY_DYNAMIC_COMPONENTS
select * from GV$MEMORY_RESIZE_OPS ; ---Synonym for GV_$MEMORY_RESIZE_OPS
select * from GV$MEMORY_TARGET_ADVICE ; ---Synonym for GV_$MEMORY_TARGET_ADVICE
select * from GV$METRIC ; ---Synonym for GV_$METRIC
select * from GV$METRICGROUP ; ---Synonym for GV_$METRICGROUP
select * from GV$METRICNAME ; ---Synonym for GV_$METRICNAME
select * from GV$METRIC_HISTORY ; ---Synonym for GV_$METRIC_HISTORY
select * from GV$MTTR_TARGET_ADVICE ; ---Synonym for GV_$MTTR_TARGET_ADVICE
select * from GV$MUTEX_SLEEP ; ---Synonym for GV_$MUTEX_SLEEP
select * from GV$MUTEX_SLEEP_HISTORY ; ---Synonym for GV_$MUTEX_SLEEP_HISTORY
select * from GV$MVREFRESH ; ---Synonym for GV_$MVREFRESH
select * from GV$MYSTAT ; ---Synonym for GV_$MYSTAT
select * from GV$NFS_CLIENTS ; ---Synonym for GV_$NFS_CLIENTS
select * from GV$NFS_LOCKS ; ---Synonym for GV_$NFS_LOCKS
select * from GV$NFS_OPEN_FILES ; ---Synonym for GV_$NFS_OPEN_FILES
select * from GV$NLS_PARAMETERS ; ---Synonym for GV_$NLS_PARAMETERS
select * from GV$NLS_VALID_VALUES ; ---Synonym for GV_$NLS_VALID_VALUES
select * from GV$OBJECT_DEPENDENCY ; ---Synonym for GV_$OBJECT_DEPENDENCY
select * from GV$OBJECT_DML_FREQUENCIES ; ---Synonym for GV_$OBJECT_DML_FREQUENCIES
select * from GV$OBSOLETE_PARAMETER ; ---Synonym for GV_$OBSOLETE_PARAMETER
select * from GV$OFFLINE_RANGE ; ---Synonym for GV_$OFFLINE_RANGE
select * from GV$OPEN_CURSOR ; ---Synonym for GV_$OPEN_CURSOR
select * from GV$OPTION ; ---Synonym for GV_$OPTION
select * from GV$OSSTAT ; ---Synonym for GV_$OSSTAT
select * from GV$ACCESS ; ---Synonym for GV_$ACCESS
select * from GV$ACTIVE_INSTANCES ; ---Synonym for GV_$ACTIVE_INSTANCES
select * from GV$ACTIVE_SERVICES ; ---Synonym for GV_$ACTIVE_SERVICES
select * from GV$ACTIVE_SESSION_HISTORY ; ---Synonym for GV_$ACTIVE_SESSION_HISTORY
select * from GV$ACTIVE_SESS_POOL_MTH ; ---Synonym for GV_$ACTIVE_SESS_POOL_MTH
select * from GV$ADVISOR_CURRENT_SQLPLAN ; ---Synonym for GV_$ADVISOR_CURRENT_SQLPLAN
select * from GV$ADVISOR_PROGRESS ; ---Synonym for GV_$ADVISOR_PROGRESS
select * from GV$ALERT_TYPES ; ---Synonym for GV_$ALERT_TYPES
select * from GV$AQ ; ---Synonym for GV_$AQ
select * from GV$AQ1 ; ---Synonym for GV_$AQ1
select * from GV$ARCHIVE ; ---Synonym for GV_$ARCHIVE
select * from GV$ARCHIVED_LOG ; ---Synonym for GV_$ARCHIVED_LOG
select * from GV$ARCHIVE_DEST ; ---Synonym for GV_$ARCHIVE_DEST
select * from GV$ARCHIVE_DEST_STATUS ; ---Synonym for GV_$ARCHIVE_DEST_STATUS
select * from GV$ARCHIVE_GAP ; ---Synonym for GV_$ARCHIVE_GAP
select * from GV$ARCHIVE_PROCESSES ; ---Synonym for GV_$ARCHIVE_PROCESSES
select * from GV$ASH_INFO ; ---Synonym for GV_$ASH_INFO
select * from GV$ASM_ACFSSNAPSHOTS ; ---Synonym for GV_$ASM_ACFSSNAPSHOTS
select * from GV$ASM_ACFSVOLUMES ; ---Synonym for GV_$ASM_ACFSVOLUMES
select * from GV$ASM_ACFS_ENCRYPTION_INFO ; ---Synonym for GV_$ASM_ACFS_ENCRYPTION_INFO
select * from GV$ASM_ACFS_SECURITY_INFO ; ---Synonym for GV_$ASM_ACFS_SECURITY_INFO
select * from GV$ASM_ALIAS ; ---Synonym for GV_$ASM_ALIAS
select * from GV$ASM_ATTRIBUTE ; ---Synonym for GV_$ASM_ATTRIBUTE
select * from GV$ASM_CLIENT ; ---Synonym for GV_$ASM_CLIENT
select * from GV$ASM_DISK ; ---Synonym for GV_$ASM_DISK
select * from GV$ASM_DISKGROUP ; ---Synonym for GV_$ASM_DISKGROUP
select * from GV$ASM_DISKGROUP_STAT ; ---Synonym for GV_$ASM_DISKGROUP_STAT
select * from GV$ASM_DISK_IOSTAT ; ---Synonym for GV_$ASM_DISK_IOSTAT
select * from GV$ASM_DISK_STAT ; ---Synonym for GV_$ASM_DISK_STAT
select * from GV$ASM_FILE ; ---Synonym for GV_$ASM_FILE
select * from GV$ASM_FILESYSTEM ; ---Synonym for GV_$ASM_FILESYSTEM
select * from GV$ASM_OPERATION ; ---Synonym for GV_$ASM_OPERATION
select * from GV$ASM_TEMPLATE ; ---Synonym for GV_$ASM_TEMPLATE
select * from GV$ASM_USER ; ---Synonym for GV_$ASM_USER
select * from GV$ASM_USERGROUP ; ---Synonym for GV_$ASM_USERGROUP
select * from GV$ASM_USERGROUP_MEMBER ; ---Synonym for GV_$ASM_USERGROUP_MEMBER
select * from GV$ASM_VOLUME ; ---Synonym for GV_$ASM_VOLUME
select * from GV$ASM_VOLUME_STAT ; ---Synonym for GV_$ASM_VOLUME_STAT
select * from GV$AW_AGGREGATE_OP ; ---Synonym for GV_$AW_AGGREGATE_OP
select * from GV$AW_ALLOCATE_OP ; ---Synonym for GV_$AW_ALLOCATE_OP
select * from GV$AW_CALC ; ---Synonym for GV_$AW_CALC
select * from GV$AW_LONGOPS ; ---Synonym for GV_$AW_LONGOPS
select * from GV$AW_OLAP ; ---Synonym for GV_$AW_OLAP
select * from GV$AW_SESSION_INFO ; ---Synonym for GV_$AW_SESSION_INFO
select * from GV$BACKUP ; ---Synonym for GV_$BACKUP
select * from GV$BACKUP_ASYNC_IO ; ---Synonym for GV_$BACKUP_ASYNC_IO
select * from GV$BACKUP_CORRUPTION ; ---Synonym for GV_$BACKUP_CORRUPTION
select * from GV$BACKUP_DATAFILE ; ---Synonym for GV_$BACKUP_DATAFILE
select * from GV$BACKUP_DEVICE ; ---Synonym for GV_$BACKUP_DEVICE
select * from GV$BACKUP_PIECE ; ---Synonym for GV_$BACKUP_PIECE
select * from GV$BACKUP_REDOLOG ; ---Synonym for GV_$BACKUP_REDOLOG
select * from GV$BACKUP_SET ; ---Synonym for GV_$BACKUP_SET
select * from GV$BACKUP_SPFILE ; ---Synonym for GV_$BACKUP_SPFILE
select * from GV$BACKUP_SYNC_IO ; ---Synonym for GV_$BACKUP_SYNC_IO
select * from GV$BGPROCESS ; ---Synonym for GV_$BGPROCESS
select * from GV$BH ; ---Synonym for GV_$BH
select * from GV$BLOCKING_QUIESCE ; ---Synonym for GV_$BLOCKING_QUIESCE
select * from GV$BSP ; ---Synonym for GV_$BSP
select * from GV$BUFFERED_PUBLISHERS ; ---Synonym for GV_$BUFFERED_PUBLISHERS
select * from GV$BUFFERED_QUEUES ; ---Synonym for GV_$BUFFERED_QUEUES
select * from GV$BUFFERED_SUBSCRIBERS ; ---Synonym for GV_$BUFFERED_SUBSCRIBERS
select * from GV$BUFFER_POOL ; ---Synonym for GV_$BUFFER_POOL
select * from GV$BUFFER_POOL_STATISTICS ; ---Synonym for GV_$BUFFER_POOL_STATISTICS
select * from GV$CALLTAG ; ---Synonym for GV_$CALLTAG
select * from GV$CELL ; ---Synonym for GV_$CELL
select * from GV$CELL_CONFIG ; ---Synonym for GV_$CELL_CONFIG
select * from GV$CELL_REQUEST_TOTALS ; ---Synonym for GV_$CELL_REQUEST_TOTALS
select * from GV$CELL_STATE ; ---Synonym for GV_$CELL_STATE
select * from GV$CELL_THREAD_HISTORY ; ---Synonym for GV_$CELL_THREAD_HISTORY
select * from GV$CIRCUIT ; ---Synonym for GV_$CIRCUIT
select * from GV$CLASS_CACHE_TRANSFER ; ---Synonym for GV_$CLASS_CACHE_TRANSFER
select * from GV$CLASS_PING ; ---Synonym for GV_$CLASS_PING
select * from GV$CLIENT_STATS ; ---Synonym for GV_$CLIENT_STATS
select * from GV$CLUSTER_INTERCONNECTS ; ---Synonym for GV_$CLUSTER_INTERCONNECTS
select * from GV$CONFIGURED_INTERCONNECTS ; ---Synonym for GV_$CONFIGURED_INTERCONNECTS
select * from GV$CONTEXT ; ---Synonym for GV_$CONTEXT
select * from GV$CONTROLFILE ; ---Synonym for GV_$CONTROLFILE
select * from GV$CONTROLFILE_RECORD_SECTION ; ---Synonym for GV_$CONTROLFILE_RECORD_SECTION
select * from GV$COPY_CORRUPTION ; ---Synonym for GV_$COPY_CORRUPTION
select * from GV$CORRUPT_XID_LIST ; ---Synonym for GV_$CORRUPT_XID_LIST
select * from GV$CPOOL_CC_INFO ; ---Synonym for GV_$CPOOL_CC_INFO
select * from GV$CPOOL_CC_STATS ; ---Synonym for GV_$CPOOL_CC_STATS
select * from GV$CPOOL_CONN_INFO ; ---Synonym for GV_$CPOOL_CONN_INFO
select * from GV$CPOOL_STATS ; ---Synonym for GV_$CPOOL_STATS
select * from GV$CR_BLOCK_SERVER ; ---Synonym for GV_$CR_BLOCK_SERVER
select * from GV$CURRENT_BLOCK_SERVER ; ---Synonym for GV_$CURRENT_BLOCK_SERVER
select * from ALL_HISTOGRAMS ; ---Synonym for ALL_TAB_HISTOGRAMS
select * from GV$XML_AUDIT_TRAIL ; ---Synonym for GV_$XML_AUDIT_TRAIL
select * from GV$XSTREAM_CAPTURE ; ---Synonym for GV_$XSTREAM_CAPTURE
select * from GV$XSTREAM_MESSAGE_TRACKING ; ---Synonym for GV_$XSTREAM_MESSAGE_TRACKING
select * from GV$XSTREAM_OUTBOUND_SERVER ; ---Synonym for GV_$XSTREAM_OUTBOUND_SERVER
select * from GV$XSTREAM_TABLE_STATS ; ---Synonym for GV_$XSTREAM_TABLE_STATS
select * from GV$XSTREAM_TRANSACTION ; ---Synonym for GV_$XSTREAM_TRANSACTION
select * from GV$_LOCK ; ---Synonym for GV_$_LOCK
select * from ALL_PUBLISHED_COLUMNS ; ---Synonym for USER_PUBLISHED_COLUMNS
select * from USER_SNAPSHOT_REFRESH_TIMES ; ---Synonym for USER_MVIEW_REFRESH_TIMES
select * from USER_SQLSET_DEFINITIONS ; ---Synonym for USER_SQLSET
select * from V$DATABASE ; ---Synonym for V_$DATABASE
select * from V$DATABASE_BLOCK_CORRUPTION ; ---Synonym for V_$DATABASE_BLOCK_CORRUPTION
select * from V$DATABASE_INCARNATION ; ---Synonym for V_$DATABASE_INCARNATION
select * from V$DATABASE_KEY_INFO ; ---Synonym for V_$DATABASE_KEY_INFO
select * from V$DATAFILE ; ---Synonym for V_$DATAFILE
select * from V$DATAFILE_COPY ; ---Synonym for V_$DATAFILE_COPY
select * from V$DATAFILE_HEADER ; ---Synonym for V_$DATAFILE_HEADER
select * from V$DATAGUARD_CONFIG ; ---Synonym for V_$DATAGUARD_CONFIG
select * from V$DATAGUARD_STATS ; ---Synonym for V_$DATAGUARD_STATS
select * from V$DATAGUARD_STATUS ; ---Synonym for V_$DATAGUARD_STATUS
select * from V$DATAPUMP_JOB ; ---Synonym for V_$DATAPUMP_JOB
select * from V$DATAPUMP_SESSION ; ---Synonym for V_$DATAPUMP_SESSION
select * from V$DBFILE ; ---Synonym for V_$DBFILE
select * from V$DBLINK ; ---Synonym for V_$DBLINK
select * from V$DB_CACHE_ADVICE ; ---Synonym for V_$DB_CACHE_ADVICE
select * from V$DB_OBJECT_CACHE ; ---Synonym for V_$DB_OBJECT_CACHE
select * from V$DB_PIPES ; ---Synonym for V_$DB_PIPES
select * from V$DB_TRANSPORTABLE_PLATFORM ; ---Synonym for V_$DB_TRANSPORTABLE_PLATFORM
select * from V$DELETED_OBJECT ; ---Synonym for V_$DELETED_OBJECT
select * from V$DETACHED_SESSION ; ---Synonym for V_$DETACHED_SESSION
select * from V$DIAG_ADR_CONTROL ; ---Synonym for V_$DIAG_ADR_CONTROL
select * from V$DIAG_ADR_INVALIDATION ; ---Synonym for V_$DIAG_ADR_INVALIDATION
select * from V$DIAG_ALERT_EXT ; ---Synonym for V_$DIAG_ALERT_EXT
select * from V$DIAG_AMS_XACTION ; ---Synonym for V_$DIAG_AMS_XACTION
select * from V$DIAG_CRITICAL_ERROR ; ---Synonym for V_$DIAG_CRITICAL_ERROR
select * from V$DIAG_DDE_USER_ACTION ; ---Synonym for V_$DIAG_DDE_USER_ACTION
select * from V$DIAG_DDE_USER_ACTION_DEF ; ---Synonym for V_$DIAG_DDE_USER_ACTION_DEF
select * from V$DIAG_DDE_USR_ACT_PARAM ; ---Synonym for V_$DIAG_DDE_USR_ACT_PARAM
select * from V$DIAG_DDE_USR_ACT_PARAM_DEF ; ---Synonym for V_$DIAG_DDE_USR_ACT_PARAM_DEF
select * from V$DIAG_DDE_USR_INC_ACT_MAP ; ---Synonym for V_$DIAG_DDE_USR_INC_ACT_MAP
select * from V$DIAG_DDE_USR_INC_TYPE ; ---Synonym for V_$DIAG_DDE_USR_INC_TYPE
select * from V$DIAG_DFW_CONFIG_CAPTURE ; ---Synonym for V_$DIAG_DFW_CONFIG_CAPTURE
select * from V$DIAG_DFW_CONFIG_ITEM ; ---Synonym for V_$DIAG_DFW_CONFIG_ITEM
select * from V$DIAG_DIAGV_INCIDENT ; ---Synonym for V_$DIAG_DIAGV_INCIDENT
select * from V$DIAG_DIR_EXT ; ---Synonym for V_$DIAG_DIR_EXT
select * from V$DIAG_EM_DIAG_JOB ; ---Synonym for V_$DIAG_EM_DIAG_JOB
select * from V$DIAG_EM_TARGET_INFO ; ---Synonym for V_$DIAG_EM_TARGET_INFO
select * from V$DIAG_EM_USER_ACTIVITY ; ---Synonym for V_$DIAG_EM_USER_ACTIVITY
select * from V$DIAG_HM_FDG_SET ; ---Synonym for V_$DIAG_HM_FDG_SET
select * from V$DIAG_HM_FINDING ; ---Synonym for V_$DIAG_HM_FINDING
select * from V$DIAG_HM_INFO ; ---Synonym for V_$DIAG_HM_INFO
select * from V$DIAG_HM_MESSAGE ; ---Synonym for V_$DIAG_HM_MESSAGE
select * from V$DIAG_HM_RECOMMENDATION ; ---Synonym for V_$DIAG_HM_RECOMMENDATION
select * from V$DIAG_HM_RUN ; ---Synonym for V_$DIAG_HM_RUN
select * from V$DIAG_INCCKEY ; ---Synonym for V_$DIAG_INCCKEY
select * from V$DIAG_INCIDENT ; ---Synonym for V_$DIAG_INCIDENT
select * from V$DIAG_INCIDENT_FILE ; ---Synonym for V_$DIAG_INCIDENT_FILE
select * from V$DIAG_INC_METER_CONFIG ; ---Synonym for V_$DIAG_INC_METER_CONFIG
select * from V$DIAG_INC_METER_IMPT_DEF ; ---Synonym for V_$DIAG_INC_METER_IMPT_DEF
select * from V$DIAG_INC_METER_INFO ; ---Synonym for V_$DIAG_INC_METER_INFO
select * from V$DIAG_INC_METER_PK_IMPTS ; ---Synonym for V_$DIAG_INC_METER_PK_IMPTS
select * from V$DIAG_INC_METER_SUMMARY ; ---Synonym for V_$DIAG_INC_METER_SUMMARY
select * from V$DIAG_INFO ; ---Synonym for V_$DIAG_INFO
select * from V$DIAG_IPS_CONFIGURATION ; ---Synonym for V_$DIAG_IPS_CONFIGURATION
select * from V$DIAG_IPS_FILE_COPY_LOG ; ---Synonym for V_$DIAG_IPS_FILE_COPY_LOG
select * from V$DIAG_IPS_FILE_METADATA ; ---Synonym for V_$DIAG_IPS_FILE_METADATA
select * from V$DIAG_IPS_PACKAGE ; ---Synonym for V_$DIAG_IPS_PACKAGE
select * from V$DIAG_IPS_PACKAGE_FILE ; ---Synonym for V_$DIAG_IPS_PACKAGE_FILE
select * from V$DIAG_IPS_PACKAGE_HISTORY ; ---Synonym for V_$DIAG_IPS_PACKAGE_HISTORY
select * from V$DIAG_IPS_PACKAGE_INCIDENT ; ---Synonym for V_$DIAG_IPS_PACKAGE_INCIDENT
select * from V$DIAG_IPS_PKG_UNPACK_HIST ; ---Synonym for V_$DIAG_IPS_PKG_UNPACK_HIST
select * from V$DIAG_IPS_PROGRESS_LOG ; ---Synonym for V_$DIAG_IPS_PROGRESS_LOG
select * from V$DIAG_IPS_REMOTE_PACKAGE ; ---Synonym for V_$DIAG_IPS_REMOTE_PACKAGE
select * from V$DIAG_PICKLEERR ; ---Synonym for V_$DIAG_PICKLEERR
select * from V$DIAG_PROBLEM ; ---Synonym for V_$DIAG_PROBLEM
select * from V$DIAG_RELMD_EXT ; ---Synonym for V_$DIAG_RELMD_EXT
select * from V$DIAG_SWEEPERR ; ---Synonym for V_$DIAG_SWEEPERR
select * from V$DIAG_VEM_USER_ACTLOG ; ---Synonym for V_$DIAG_VEM_USER_ACTLOG
select * from V$DIAG_VEM_USER_ACTLOG1 ; ---Synonym for V_$DIAG_VEM_USER_ACTLOG1
select * from V$DIAG_VHM_RUN ; ---Synonym for V_$DIAG_VHM_RUN
select * from V$DIAG_VIEW ; ---Synonym for V_$DIAG_VIEW
select * from V$DIAG_VIEWCOL ; ---Synonym for V_$DIAG_VIEWCOL
select * from V$DIAG_VINCIDENT ; ---Synonym for V_$DIAG_VINCIDENT
select * from V$DIAG_VINCIDENT_FILE ; ---Synonym for V_$DIAG_VINCIDENT_FILE
select * from V$DIAG_VINC_METER_INFO ; ---Synonym for V_$DIAG_VINC_METER_INFO
select * from V$DIAG_VIPS_FILE_COPY_LOG ; ---Synonym for V_$DIAG_VIPS_FILE_COPY_LOG
select * from V$DIAG_VIPS_FILE_METADATA ; ---Synonym for V_$DIAG_VIPS_FILE_METADATA
select * from V$DIAG_VIPS_PACKAGE_FILE ; ---Synonym for V_$DIAG_VIPS_PACKAGE_FILE
select * from V$DIAG_VIPS_PACKAGE_HISTORY ; ---Synonym for V_$DIAG_VIPS_PACKAGE_HISTORY
select * from V$DIAG_VIPS_PACKAGE_MAIN_INT ; ---Synonym for V_$DIAG_VIPS_PACKAGE_MAIN_INT
select * from V$DIAG_VIPS_PACKAGE_SIZE ; ---Synonym for V_$DIAG_VIPS_PACKAGE_SIZE
select * from V$DIAG_VIPS_PKG_FILE ; ---Synonym for V_$DIAG_VIPS_PKG_FILE
select * from V$DIAG_VIPS_PKG_INC_CAND ; ---Synonym for V_$DIAG_VIPS_PKG_INC_CAND
select * from V$DIAG_VIPS_PKG_INC_DTL ; ---Synonym for V_$DIAG_VIPS_PKG_INC_DTL
select * from V$DIAG_VIPS_PKG_INC_DTL1 ; ---Synonym for V_$DIAG_VIPS_PKG_INC_DTL1
select * from V$DIAG_VIPS_PKG_MAIN_PROBLEM ; ---Synonym for V_$DIAG_VIPS_PKG_MAIN_PROBLEM
select * from V$DIAG_VNOT_EXIST_INCIDENT ; ---Synonym for V_$DIAG_VNOT_EXIST_INCIDENT
select * from V$DIAG_VPROBLEM ; ---Synonym for V_$DIAG_VPROBLEM
select * from V$DIAG_VPROBLEM1 ; ---Synonym for V_$DIAG_VPROBLEM1
select * from V$DIAG_VPROBLEM2 ; ---Synonym for V_$DIAG_VPROBLEM2
select * from V$DIAG_VPROBLEM_BUCKET ; ---Synonym for V_$DIAG_VPROBLEM_BUCKET
select * from V$DIAG_VPROBLEM_BUCKET1 ; ---Synonym for V_$DIAG_VPROBLEM_BUCKET1
select * from V$DIAG_VPROBLEM_BUCKET_COUNT ; ---Synonym for V_$DIAG_VPROBLEM_BUCKET_COUNT
select * from V$DIAG_VPROBLEM_INT ; ---Synonym for V_$DIAG_VPROBLEM_INT
select * from V$DIAG_VPROBLEM_LASTINC ; ---Synonym for V_$DIAG_VPROBLEM_LASTINC
select * from V$DIAG_VSHOWCATVIEW ; ---Synonym for V_$DIAG_VSHOWCATVIEW
select * from V$DIAG_VSHOWINCB ; ---Synonym for V_$DIAG_VSHOWINCB
select * from V$DIAG_VSHOWINCB_I ; ---Synonym for V_$DIAG_VSHOWINCB_I
select * from V$DIAG_VTEST_EXISTS ; ---Synonym for V_$DIAG_VTEST_EXISTS
select * from V$DIAG_V_ACTINC ; ---Synonym for V_$DIAG_V_ACTINC
select * from V$DIAG_V_ACTPROB ; ---Synonym for V_$DIAG_V_ACTPROB
select * from V$DIAG_V_INCCOUNT ; ---Synonym for V_$DIAG_V_INCCOUNT
select * from V$DIAG_V_INCFCOUNT ; ---Synonym for V_$DIAG_V_INCFCOUNT
select * from V$DIAG_V_INC_METER_INFO_PROB ; ---Synonym for V_$DIAG_V_INC_METER_INFO_PROB
select * from V$DIAG_V_IPSPRBCNT ; ---Synonym for V_$DIAG_V_IPSPRBCNT
select * from V$DIAG_V_IPSPRBCNT1 ; ---Synonym for V_$DIAG_V_IPSPRBCNT1
select * from V$DIAG_V_NFCINC ; ---Synonym for V_$DIAG_V_NFCINC
select * from V$DIAG_V_SWPERRCOUNT ; ---Synonym for V_$DIAG_V_SWPERRCOUNT
select * from V$DISPATCHER ; ---Synonym for V_$DISPATCHER
select * from V$DISPATCHER_CONFIG ; ---Synonym for V_$DISPATCHER_CONFIG
select * from V$DISPATCHER_RATE ; ---Synonym for V_$DISPATCHER_RATE
select * from TABS ; ---Synonym for USER_TABLES
select * from OBJ ; ---Synonym for USER_OBJECTS
select * from DBA_SNAPSHOT_LOG_FILTER_COLS ; ---Synonym for DBA_MVIEW_LOG_FILTER_COLS
select * from DBA_SNAPSHOT_REFRESH_TIMES ; ---Synonym for DBA_MVIEW_REFRESH_TIMES
select * from DBA_SQLSET_DEFINITIONS ; ---Synonym for DBA_SQLSET
select * from DBA_APPLY_OBJECT_DEPENDENCIES ; ---Synonym for _DBA_APPLY_OBJECT_CONSTRAINTS
select * from DBA_APPLY_VALUE_DEPENDENCIES ; ---Synonym for _DBA_APPLY_CONSTRAINT_COLUMNS
select * from DBA_HISTOGRAMS ; ---Synonym for DBA_TAB_HISTOGRAMS
select * from USER_HISTOGRAMS ; ---Synonym for USER_TAB_HISTOGRAMS
select * from ALL_SNAPSHOT_REFRESH_TIMES ; ---Synonym for ALL_MVIEW_REFRESH_TIMES
select * from ALL_SOURCE_TABLES ; ---Synonym for USER_SOURCE_TABLES
select * from ALL_SUBSCRIBED_COLUMNS ; ---Synonym for USER_SUBSCRIBED_COLUMNS
select * from ALL_SUBSCRIBED_TABLES ; ---Synonym for USER_SUBSCRIBED_TABLES
select * from ALL_SUBSCRIPTIONS ; ---Synonym for USER_SUBSCRIPTIONS
select * from LOGSTDBY_UNSUPPORTED_TABLES ; ---Synonym for DBA_LOGSTDBY_UNSUPPORTED_TABLE
select * from DICT ; ---Synonym for DICTIONARY
select * from ALL_JOBS ; ---Synonym for USER_JOBS
select * from ALL_OLAP2_AWS ; ---Synonym for ALL$OLAP2_AWS
select * from RECYCLEBIN ; ---Synonym for USER_RECYCLEBIN
select * from SEQ ; ---Synonym for USER_SEQUENCES
select * from SM$VERSION ; ---Synonym for SM_$VERSION
select * from SYN ; ---Synonym for USER_SYNONYMS
select * from DBA_LOCKS ; ---Synonym for DBA_LOCK
select * from ALL_OUTLINES ; ---Synonym for USER_OUTLINES
select * from ALL_OUTLINE_HINTS ; ---Synonym for USER_OUTLINE_HINTS
select * from IND ; ---Synonym for USER_INDEXES
select * from CAT ; ---Synonym for USER_CATALOG
select * from CHANGE_PROPAGATIONS ; ---Synonym for ALL_CHANGE_PROPAGATIONS
select * from CHANGE_PROPAGATION_SETS ; ---Synonym for ALL_CHANGE_PROPAGATION_SETS
select * from CHANGE_SETS ; ---Synonym for ALL_CHANGE_SETS
select * from CHANGE_SOURCES ; ---Synonym for ALL_CHANGE_SOURCES
select * from CHANGE_TABLES ; ---Synonym for ALL_CHANGE_TABLES
select * from CLIENT_RESULT_CACHE_STATS$ ; ---Synonym for CRCSTATS_$
select * from CLU ; ---Synonym for USER_CLUSTERS
select * from COLS ; ---Synonym for USER_TAB_COLUMNS
最后修改:2021 年 11 月 28 日
如果觉得我的文章对你有用,请随意赞赏