zl程序教程

您现在的位置是:首页 >  数据库

当前栏目

Oracle 所有字典

Oracle 所有 字典
2023-09-27 14:21:40 时间



  1 select * from DBA_CONS_COLUMNS ; ---Information about accessible columns in constraint definitions
  2 select * from DBA_LOG_GROUP_COLUMNS ; ---Information about columns in log group definitions
  3 select * from DBA_LOBS ; ---Description of LOBs contained in all tables
  4 select * from DBA_CATALOG ; ---All database Tables, Views, Synonyms, Sequences
  5 select * from DBA_CLUSTERS ; ---Description of all clusters in the database
  6 select * from DBA_CLU_COLUMNS ; ---Mapping of table columns to cluster columns
  7 select * from DBA_COL_COMMENTS ; ---Comments on columns of all tables and views
  8 select * from DBA_COL_PRIVS ; ---All grants on columns in the database
  9 select * from DBA_ENCRYPTED_COLUMNS ; ---Encryption information on columns in the database
 10 select * from DBA_INDEXES ; ---Description for all indexes in the database
 11 select * from DBA_IND_COLUMNS ; ---COLUMNs comprising INDEXes on all TABLEs and CLUSTERs
 12 select * from DBA_IND_EXPRESSIONS ; ---FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLUSTERS
 13 select * from DBA_JOIN_IND_COLUMNS ; ---Join Index columns comprising the join conditions
 14 select * from DBA_OBJECTS ; ---All objects in the database
 15 select * from DBA_OBJECTS_AE ; ---All objects in the database
 16 select * from DBA_ROLLBACK_SEGS ; ---Description of rollback segments
 17 select * from DBA_ROLE_PRIVS ; ---Roles granted to users and roles
 18 select * from DBA_SEQUENCES ; ---Description of all SEQUENCEs in the database
 19 select * from DBA_SYNONYMS ; ---All synonyms in the database
 20 select * from DBA_TABLES ; ---Description of all relational tables in the database
 21 select * from DBA_OBJECT_TABLES ; ---Description of all object tables in the database
 22 select * from DBA_ALL_TABLES ; ---Description of all object and relational tables in the database
 23 select * from DBA_TAB_COLS ; ---Columns of user's tables, views and clusters
 24 select * from DBA_TAB_COLUMNS ; ---Columns of user's tables, views and clusters
 25 select * from DBA_TAB_COMMENTS ; ---Comments on all tables and views in the database
 26 select * from DBA_TAB_PRIVS ; ---All grants on objects in the database
 27 select * from DBA_VIEWS ; ---Description of all views in the database
 28 select * from DBA_VIEWS_AE ; ---Description of all views in the database
 29 select * from DBA_CONSTRAINTS ; ---Constraint definitions on all tables
 30 select * from DBA_LOG_GROUPS ; ---Log group definitions on all tables
 31 select * from DBA_CLUSTER_HASH_EXPRESSIONS ; ---Hash functions for all clusters
 32 select * from DBA_UPDATABLE_COLUMNS ; ---Description of dba updatable columns
 33 select * from DBA_UNUSED_COL_TABS ; ---All tables with unused columns in the database
 34 select * from DBA_PARTIAL_DROP_TABS ; ---All tables with partially dropped columns in the database
 35 select * from DBA_RESUMABLE ; ---Resumable session information in the system
 36 select * from DBA_EDITIONING_VIEWS ; ---Description of all Editioning Views in the database
 37 select * from DBA_EDITIONING_VIEWS_AE ; ---Description of all Editioning Views in the database
 38 select * from DBA_EDITIONING_VIEW_COLS ; ---Relationship between columns of all Editioning Views in the database and the table columns to which they map
 39 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
 40 select * from DBA_EDITIONS ; ---Describes all editions in the database
 41 select * from DBA_EDITION_COMMENTS ; ---Describes comments on all editions in the database
 42 select * from DBA_LIBRARIES ; ---Description of all libraries in the database
 43 select * from DBA_PROCEDURES ; ---Description of the dba functions/procedures/packages/types/triggers
 44 select * from DBA_STORED_SETTINGS ; ---Parameter settings for all objects
 45 select * from DBA_PLSQL_OBJECT_SETTINGS ; ---Compiler settings of all objects in the database
 46 select * from DBA_ARGUMENTS ; ---All arguments for objects in the database
 47 select * from DBA_ASSEMBLIES ; ---Description of all assemblies in the database
 48 select * from DBA_IDENTIFIERS ; ---Identifiers in stored objects accessible to sys
 49 select * from DBA_DB_LINKS ; ---All database links in the database
 50 select * from DBA_RECYCLEBIN ; ---Description of the Recyclebin view accessible to the user
 51 select * from DBA_2PC_PENDING ; ---info about distributed transactions awaiting recovery
 52 select * from DBA_2PC_NEIGHBORS ; ---information about incoming and outgoing connections for pending transactions
 53 select * from DBA_PROFILES ; ---Display all profiles and their limits
 54 select * from DBA_USERS ; ---Information about all users of the database
 55 select * from DBA_OBJ_AUDIT_OPTS ; ---Auditing options for all tables and views with atleast one option set
 56 select * from DBA_STMT_AUDIT_OPTS ; ---Describes current system auditing options across the system and by user
 57 select * from DBA_PRIV_AUDIT_OPTS ; ---Describes current system privileges being audited across the system and by user
 58 select * from DBA_AUDIT_TRAIL ; ---All audit trail entries
 59 select * from DBA_AUDIT_SESSION ; ---All audit trail records concerning CONNECT and DISCONNECT
 60 select * from DBA_AUDIT_STATEMENT ; ---Audit trail records concerning  grant, revoke, audit, noaudit and alter system
 61 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
 62 select * from DBA_AUDIT_EXISTS ; ---Lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS
 63 select * from DBA_ROLES ; ---All Roles which exist in the database
 64 select * from DBA_SYS_PRIVS ; ---System privileges granted to users and roles
 65 select * from DBA_PROXIES ; ---Information about all proxy connections
 66 select * from DBA_CONNECT_ROLE_GRANTEES ; ---Information regarding which users are granted CONNECT
 67 select * from DBA_TYPES ; ---Description of all types in the database
 68 select * from DBA_COLL_TYPES ; ---Description of all named collection types in the database
 69 select * from DBA_TYPE_ATTRS ; ---Description of attributes of all types in the database
 70 select * from DBA_TYPE_METHODS ; ---Description of methods of all types in the database
 71 select * from DBA_METHOD_PARAMS ; ---Description of method parameters of all types in the database
 72 select * from DBA_METHOD_RESULTS ; ---Description of method results of all types in the database
 73 select * from DBA_SQLJ_TYPES ; ---Description of all types in the database
 74 select * from DBA_TYPE_VERSIONS ; ---Description of each type version in the database
 75 select * from DBA_PENDING_CONV_TABLES ; ---All tables which are not upgraded to the latest type version in the database
 76 select * from DBA_SQLJ_TYPE_ATTRS ; ---Description of attributes of all types in the database
 77 select * from DBA_SQLJ_TYPE_METHODS ; ---Description of methods of all types in the database
 78 select * from DBA_OLDIMAGE_COLUMNS ; ---Gives all object tables and columns in old (8.0) image format
 79 select * from DBA_NESTED_TABLE_COLS ; ---Columns of nested tables
 80 select * from DBA_DIRECTORIES ; ---Description of all directories
 81 select * from DBA_REFS ; ---Description of REF columns contained in all tables
 82 select * from DBA_NESTED_TABLES ; ---Description of nested tables contained in all tables
 83 select * from DBA_VARRAYS ; ---Description of varrays in tables accessible to the user
 84 select * from DBA_OBJ_COLATTRS ; ---Description of object columns and attributes contained in all tables in the database
 85 select * from DBA_CONS_OBJ_COLUMNS ; ---List of types an object column or attribute is constrained to in all tables in the database
 86 select * from DBA_OPERATORS ; ---All operators
 87 select * from DBA_OPBINDINGS ; ---All operator binding functiosn or methods
 88 select * from DBA_OPANCILLARY ; ---All ancillary operators
 89 select * from DBA_OPARGUMENTS ; ---All operator arguments
 90 select * from DBA_OPERATOR_COMMENTS ; ---Comments for user-defined operators
 91 select * from DBA_INDEXTYPES ; ---All indextypes
 92 select * from DBA_INDEXTYPE_COMMENTS ; ---Comments for user-defined indextypes
 93 select * from DBA_INDEXTYPE_ARRAYTYPES ; ---All array types specified by the indextype
 94 select * from DBA_INDEXTYPE_OPERATORS ; ---All indextype operators
 95 select * from DBA_SECONDARY_OBJECTS ; ---All secondary objects for domain indexes
 96 select * from DBA_SOURCE_TABLES ; ---Source tables available for Change Data Capture
 97 select * from DBA_PUBLISHED_COLUMNS ; ---Source columns available for Change Data Capture
 98 select * from DBA_SUBSCRIPTIONS ; ---Change Data Capture subscriptions
 99 select * from DBA_SUBSCRIBED_TABLES ; ---Change Data Capture subscribed tables
100 select * from DBA_SUBSCRIBED_COLUMNS ; ---Change Data Capture subscribed columns
101 select * from DBA_EXP_OBJECTS ; ---Objects that have been incrementally exported
102 select * from DBA_EXP_VERSION ; ---Version number of the last export session
103 select * from DBA_EXP_FILES ; ---Description of export files
104 select * from DBA_EXTERNAL_TABLES ; ---Description of the external tables accessible to the DBA
105 select * from DBA_EXTERNAL_LOCATIONS ; ---Description of the external tables locations accessible to the DBA
106 select * from DBA_MINING_MODELS ; ---Description of all the models in the database
107 select * from DBA_MINING_MODEL_ATTRIBUTES ; ---Description of all the model attributes in the database
108 select * from DBA_MINING_MODEL_SETTINGS ; ---Description of all the model settings in the database
109 select * from DBA_MINING_MODEL_TABLES ; ---Description of all the mining model tables in the system
110 select * from DBA_TAB_COL_STATISTICS ; ---Columns of user's tables, views and clusters
111 select * from DBA_TAB_HISTOGRAMS ; ---Histograms on columns of all tables
112 select * from DBA_ASSOCIATIONS ; ---All associations
113 select * from DBA_USTATS ; ---All statistics collected on either tables or indexes
114 select * from DBA_TAB_MODIFICATIONS ; ---Information regarding modifications to tables
115 select * from DBA_OPTSTAT_OPERATIONS ; ---History of statistics operations performed
116 select * from DBA_TAB_STATS_HISTORY ; ---History of table statistics modifications
117 select * from DBA_TAB_STAT_PREFS ; ---Statistics preferences for tables
118 select * from DBA_TAB_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
119 select * from DBA_IND_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
120 select * from DBA_COL_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
121 select * from DBA_TAB_HISTGRM_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
122 select * from DBA_DIMENSIONS ; ---Description of the dimension objects accessible to the DBA
123 select * from DBA_DIM_LEVELS ; ---Description of dimension levels visible to DBA
124 select * from DBA_DIM_LEVEL_KEY ; ---Representations of columns of a dimension level
125 "select * from DBA_DIM_ATTRIBUTES ; ---Representation of the relationship between a dimension level and
126  a functionally dependent column"
127 select * from DBA_DIM_HIERARCHIES ; ---Representation of a dimension hierarchy
128 "select * from DBA_DIM_CHILD_OF ; ---Representaion of a 1:n hierarchical relationship between a pair of levels in
129  a dimension"
130 select * from DBA_DIM_JOIN_KEY ; ---Representation of a join between two dimension tables. 
131 select * from DBA_SUMMARIES ; ---Description of the summaries accessible to dba
132 select * from DBA_MVIEW_ANALYSIS ; ---Description of the materialized views accessible to dba
133 select * from DBA_MVIEW_AGGREGATES ; ---Description of the materialized view aggregates accessible to dba
134 select * from DBA_MVIEW_DETAIL_RELATIONS ; ---Description of the materialized view detail tables accessible to dba
135 "select * from DBA_MVIEW_KEYS ; ---Description of the columns that appear in the GROUP BY
136 list of a materialized view accessible to dba"
137 "select * from DBA_MVIEW_JOINS ; ---Description of a join between two columns in the
138 WHERE clause of a materialized view accessible to dba"
139 select * from DBA_MVIEW_COMMENTS ; ---Comments on all materialized views in the database
140 select * from DBA_REWRITE_EQUIVALENCES ; ---Description of rewrite equivalence accessible to DBA
141 select * from DBA_MVIEW_DETAIL_PARTITION ; ---Freshness information of all PCT materialized views in the database
142 select * from DBA_MVIEW_DETAIL_SUBPARTITION ; ---Freshness information of all PCT materialized views in the database
143 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
144 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
145 select * from DBA_ERRORS ; ---Current errors on all stored objects in the database
146 select * from DBA_ERRORS_AE ; ---Current errors on all stored objects in the database
147 select * from DBA_SOURCE_AE ; ---Source of all stored objects in the database
148 select * from DBA_SOURCE ; ---Source of all stored objects in the database
149 select * from DBA_TRIGGERS ; ---All triggers in the database
150 select * from DBA_INTERNAL_TRIGGERS ; ---Description of the internal triggers on all tables in the database
151 select * from DBA_TRIGGER_COLS ; ---Column usage in all triggers
152 select * from DBA_DEPENDENCIES ; ---Dependencies to and from objects
153 select * from DBA_OBJECT_SIZE ; ---Sizes, in bytes, of various pl/sql objects
154 select * from DBA_TRIGGER_ORDERING ; ---All triggers having FOLLOWS or PRECEDES ordering in the database
155 select * from DBA_JOBS_RUNNING ; ---All jobs in the database which are currently running, join v$lock and job$
156 select * from DBA_JOBS ; ---All jobs in the database
157 select * from DBA_SEGMENTS ; ---Storage allocated for all database segments
158 select * from DBA_SEGMENTS_OLD ; ---Storage allocated for all database segments
159 select * from DBA_EXTENTS ; ---Extents comprising all segments in the database
160 select * from DBA_UNDO_EXTENTS ; ---Extents comprising all segments in the system managed undo tablespaces
161 select * from DBA_LMT_USED_EXTENTS ; ---All extents in the locally managed tablespaces
162 select * from DBA_DMT_USED_EXTENTS ; ---All extents in the dictionary managed tablespaces
163 select * from DBA_FREE_SPACE ; ---Free extents in all tablespaces
164 select * from DBA_LMT_FREE_SPACE ; ---Free extents in all locally managed tablespaces
165 select * from DBA_DMT_FREE_SPACE ; ---Free extents in all dictionary managed tablespaces
166 select * from DBA_FREE_SPACE_COALESCED ; ---Statistics on Coalesced Space in Tablespaces
167 select * from DBA_DATA_FILES ; ---Information about database data files
168 select * from DBA_TABLESPACES ; ---Description of all tablespaces
169 select * from DBA_TEMP_FILES ; ---Information about database temp files
170 select * from DBA_TABLESPACE_GROUPS ; ---Description of all tablespace groups
171 select * from DBA_TABLESPACE_USAGE_METRICS ; ---Description of all tablespace space usage metrics
172 select * from DBA_TS_QUOTAS ; ---Tablespace quotas for all users
173 select * from DBA_TEMP_FREE_SPACE ; ---Summary of temporary space usage
174 select * from DBA_CONTEXT ; ---Description of all context namespace information
175 select * from DBA_GLOBAL_CONTEXT ; ---Description of all context information accessible globally
176 select * from DBA_RULE_SETS ; ---Rule sets in the database
177 select * from DBA_RULESETS ; ---Rulesets in the database: maintained for backward compatibility
178 select * from DBA_RULES ; ---Rules in the databse
179 select * from DBA_RULE_SET_RULES ; ---Rules in all rule sets in the database
180 select * from DBA_EVALUATION_CONTEXTS ; ---rule evaluation contexts in the database
181 select * from DBA_EVALUATION_CONTEXT_TABLES ; ---tables in all rule evaluation contexts in the database
182 select * from DBA_EVALUATION_CONTEXT_VARS ; ---variables in all rule evaluation contexts in the database
183 select * from DBA_SNAPSHOTS ; ---All snapshots in the database
184 select * from DBA_SNAPSHOT_LOGS ; ---All snapshot logs in the database
185 select * from DBA_RCHILD ; ---All the children in any refresh group.  This view is not a join.
186 select * from DBA_RGROUP ; ---All refresh groups.  This view is not a join.
187 select * from DBA_REFRESH ; ---All the refresh groups
188 select * from DBA_REFRESH_CHILDREN ; ---All the objects in refresh groups
189 select * from DBA_REGISTERED_SNAPSHOTS ; ---Remote snapshots of local tables
190 select * from DBA_MVIEWS ; ---All materialized views in the database
191 select * from DBA_MVIEW_REFRESH_TIMES ; ---All fast refreshable materialized views and their last refresh times for each master table
192 select * from DBA_MVIEW_LOGS ; ---All materialized view logs in the database
193 select * from DBA_BASE_TABLE_MVIEWS ; ---All materialized views with log(s) in the database
194 select * from DBA_REGISTERED_MVIEWS ; ---Remote materialized views of local tables
195 select * from DBA_MVIEW_LOG_FILTER_COLS ; ---All filter columns (excluding PK cols) being logged in the materialized view logs
196 select * from DBA_POLICIES ; ---All row level security policies in the database
197 select * from DBA_POLICY_GROUPS ; ---All policy groups defined for any synonym, table, view in the database
198 select * from DBA_POLICY_CONTEXTS ; ---All policy driving context defined for any synonym, table, or view in the database
199 select * from DBA_SEC_RELEVANT_COLS ; ---Security Relevant columns of all VPD policies in the database
200 select * from DBA_AUDIT_POLICIES ; ---Fine grained auditing policies in the database
201 select * from DBA_AUDIT_POLICY_COLUMNS ; ---All fine grained auditing policy columns in the database
202 select * from DBA_FGA_AUDIT_TRAIL ; ---All fine grained audit event logs
203 select * from DBA_COMMON_AUDIT_TRAIL ; ---Combined Standard and Fine Grained audit trail entries
204 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
205 select * from DBA_AUDIT_MGMT_LAST_ARCH_TS ; ---The Last Archive Timestamps set for the Audit Trail Clean up
206 select * from DBA_AUDIT_MGMT_CLEANUP_JOBS ; ---The view displays the currently configured audit trail purge jobs
207 select * from DBA_AUDIT_MGMT_CLEAN_EVENTS ; ---The history of cleanup events
208 select * from DBA_TSM_SOURCE ; ---Transparent session migration source session statistics
209 select * from DBA_TSM_DESTINATION ; ---Transparent session migration source session statistics
210 select * from DBA_TSM_HISTORY ; ---Transparent session migration statistics
211 select * from DBA_CHANGE_NOTIFICATION_REGS ; ---Description of the registrations for change notification
212 select * from DBA_CQ_NOTIFICATION_QUERIES ; ---Description of registered queries for CQ notification
213 select * from DBA_CPOOL_INFO ; ---Connection pool info
214 select * from DBA_SSCR_CAPTURE ; ---Session state capture statistics
215 select * from DBA_SSCR_RESTORE ; ---Session state restore statistics
216 select * from DBA_SUBSCR_REGISTRATIONS ; ---All subscription registrations created in the database
217 select * from DBA_QUEUE_TABLES ; ---All queue tables created in the database
218 select * from DBA_QUEUES ; ---All database queues
219 select * from DBA_RESOURCE_INCARNATIONS ; ---Resource incarnations that are running or eligible for HA status notification
220 select * from DBA_RSRC_PLANS ; ---All the resource plans
221 select * from DBA_RSRC_CONSUMER_GROUPS ; ---all the resource consumer groups
222 select * from DBA_RSRC_CATEGORIES ; ---All resource consumer group categories
223 select * from DBA_RSRC_PLAN_DIRECTIVES ; ---all the resource plan directives
224 select * from DBA_RSRC_CONSUMER_GROUP_PRIVS ; ---Switch privileges for consumer groups
225 select * from DBA_RSRC_MANAGER_SYSTEM_PRIVS ; ---system privileges for the resource manager
226 select * from DBA_RSRC_GROUP_MAPPINGS ; ---all the consumer group mappings
227 select * from DBA_RSRC_MAPPING_PRIORITY ; ---the consumer group mapping attribute priorities
228 select * from DBA_RSRC_STORAGE_POOL_MAPPING ; ---resource manager rules for mapping files to storage pools
229 "select * from DBA_RSRC_CAPABILITY ; ---settings for database resources that are capable of being managed by the
230 Resource Manager"
231 "select * from DBA_RSRC_INSTANCE_CAPABILITY ; ---per-instance settings for database resources that are capable of being
232 managed by the Resource Manager"
233 select * from DBA_RSRC_IO_CALIBRATE ; ---Results of the most recent I/O calibration
234 select * from DBA_OUTLINES ; ---Stored outlines
235 select * from DBA_OUTLINE_HINTS ; ---Hints stored in outlines
236 select * from DBA_DATAPUMP_JOBS ; ---Datapump jobs
237 select * from DBA_DATAPUMP_SESSIONS ; ---Datapump sessions attached to a job
238 select * from DBA_FEATURE_USAGE_STATISTICS ; ---Database Feature Usage Statistics
239 select * from DBA_HIGH_WATER_MARK_STATISTICS ; ---Database High Water Mark Statistics
240 select * from DBA_CPU_USAGE_STATISTICS ; ---Database CPU Usage Statistics
241 select * from DBA_ALERT_ARGUMENTS ; ---Message Id and arguments of outstanding alerts
242 select * from DBA_ENABLED_TRACES ; ---Information about enabled SQL traces
243 select * from DBA_ENABLED_AGGREGATIONS ; ---Information about enabled on-demand statistic aggregation
244 select * from DBA_HIST_DATABASE_INSTANCE ; ---Database Instance Information
245 select * from DBA_HIST_SNAPSHOT ; ---Snapshot Information
246 select * from DBA_HIST_SNAP_ERROR ; ---Snapshot Error Information
247 select * from DBA_HIST_COLORED_SQL ; ---Marked SQLs for snapshots
248 select * from DBA_HIST_BASELINE_METADATA ; ---Baseline Metadata Information
249 select * from DBA_HIST_BASELINE_TEMPLATE ; ---Baseline Template Information
250 select * from DBA_HIST_WR_CONTROL ; ---Workload Repository Control Information
251 select * from DBA_HIST_TABLESPACE ; ---Tablespace Static Information
252 select * from DBA_HIST_DATAFILE ; ---Names of Datafiles
253 select * from DBA_HIST_FILESTATXS ; ---Datafile Historical Statistics Information
254 select * from DBA_HIST_TEMPFILE ; ---Names of Temporary Datafiles
255 select * from DBA_HIST_TEMPSTATXS ; ---Temporary Datafile Historical Statistics Information
256 select * from DBA_HIST_COMP_IOSTAT ; ---I/O stats aggregated on component level
257 select * from DBA_HIST_SQLSTAT ; ---SQL Historical Statistics Information
258 select * from DBA_HIST_SQLTEXT ; ---SQL Text
259 select * from DBA_HIST_SQL_SUMMARY ; ---Summary of SQL Statistics
260 select * from DBA_HIST_SQL_PLAN ; ---SQL Plan Information
261 select * from DBA_HIST_SQL_BIND_METADATA ; ---SQL Bind Metadata Information
262 select * from DBA_HIST_OPTIMIZER_ENV ; ---Optimizer Environment Information
263 select * from DBA_HIST_EVENT_NAME ; ---Event Names
264 select * from DBA_HIST_SYSTEM_EVENT ; ---System Event Historical Statistics Information
265 select * from DBA_HIST_BG_EVENT_SUMMARY ; ---Summary of Background Event Historical Statistics Information
266 select * from DBA_HIST_WAITSTAT ; ---Wait Historical Statistics Information
267 select * from DBA_HIST_ENQUEUE_STAT ; ---Enqueue Historical Statistics Information
268 select * from DBA_HIST_LATCH_NAME ; ---Latch Names
269 select * from DBA_HIST_LATCH ; ---Latch Historical Statistics Information
270 select * from DBA_HIST_LATCH_CHILDREN ; ---Latch Children Historical Statistics Information
271 select * from DBA_HIST_LATCH_PARENT ; ---Latch Parent Historical Historical Statistics Information
272 select * from DBA_HIST_LATCH_MISSES_SUMMARY ; ---Latch Misses Summary Historical Statistics Information
273 select * from DBA_HIST_EVENT_HISTOGRAM ; ---Event Histogram Historical Statistics Information
274 select * from DBA_HIST_MUTEX_SLEEP ; ---Mutex Sleep Summary Historical Statistics Information
275 select * from DBA_HIST_LIBRARYCACHE ; ---Library Cache Historical Statistics Information
276 select * from DBA_HIST_DB_CACHE_ADVICE ; ---DB Cache Advice History Information
277 select * from DBA_HIST_BUFFER_POOL_STAT ; ---Buffer Pool Historical Statistics Information
278 select * from DBA_HIST_ROWCACHE_SUMMARY ; ---Row Cache Historical Statistics Information Summary
279 select * from DBA_HIST_SGA ; ---SGA Historical Statistics Information
280 select * from DBA_HIST_SGASTAT ; ---SGA Pool Historical Statistics Information
281 select * from DBA_HIST_PGASTAT ; ---PGA Historical Statistics Information
282 select * from DBA_HIST_PROCESS_MEM_SUMMARY ; ---Process Memory Historical Summary Information
283 select * from DBA_HIST_RESOURCE_LIMIT ; ---Resource Limit Historical Statistics Information
284 select * from DBA_HIST_SHARED_POOL_ADVICE ; ---Shared Pool Advice History
285 select * from DBA_HIST_STREAMS_POOL_ADVICE ; ---Streams Pool Advice History
286 select * from DBA_HIST_SQL_WORKAREA_HSTGRM ; ---SQL Workarea Histogram History
287 select * from DBA_HIST_PGA_TARGET_ADVICE ; ---PGA Target Advice History
288 select * from DBA_HIST_SGA_TARGET_ADVICE ; ---SGA Target Advice History
289 select * from DBA_HIST_MEMORY_TARGET_ADVICE ; ---Memory Target Advice History
290 select * from DBA_HIST_MEMORY_RESIZE_OPS ; ---Memory Resize Operations History
291 select * from DBA_HIST_INSTANCE_RECOVERY ; ---Instance Recovery Historical Statistics Information
292 select * from DBA_HIST_JAVA_POOL_ADVICE ; ---Java Pool Advice History
293 select * from DBA_HIST_THREAD ; ---Thread Historical Statistics Information
294 select * from DBA_HIST_STAT_NAME ; ---Statistic Names
295 select * from DBA_HIST_SYSSTAT ; ---System Historical Statistics Information
296 select * from DBA_HIST_SYS_TIME_MODEL ; ---System Time Model Historical Statistics Information
297 select * from DBA_HIST_OSSTAT_NAME ; ---Operating System Statistic Names
298 select * from DBA_HIST_OSSTAT ; ---Operating System Historical Statistics Information
299 select * from DBA_HIST_PARAMETER_NAME ; ---Parameter Names
300 select * from DBA_HIST_PARAMETER ; ---Parameter Historical Statistics Information
301 select * from DBA_HIST_MVPARAMETER ; ---Multi-valued Parameter Historical Statistics Information
302 select * from DBA_HIST_UNDOSTAT ; ---Undo Historical Statistics Information
303 select * from DBA_HIST_SEG_STAT ; --- Historical Statistics Information
304 select * from DBA_HIST_SEG_STAT_OBJ ; ---Segment Names
305 select * from DBA_HIST_METRIC_NAME ; ---Segment Names
306 select * from DBA_HIST_SYSMETRIC_HISTORY ; ---System Metrics History
307 select * from DBA_HIST_SYSMETRIC_SUMMARY ; ---System Metrics History
308 select * from DBA_HIST_SESSMETRIC_HISTORY ; ---System Metrics History
309 select * from DBA_HIST_FILEMETRIC_HISTORY ; ---File Metrics History
310 select * from DBA_HIST_WAITCLASSMET_HISTORY ; ---Wait Class Metric History
311 select * from DBA_HIST_DLM_MISC ; ---Distributed Lock Manager Miscellaneous Historical Statistics Information
312 select * from DBA_HIST_CR_BLOCK_SERVER ; ---Consistent Read Block Server Historical Statistics
313 select * from DBA_HIST_CURRENT_BLOCK_SERVER ; ---Current Block Server Historical Statistics
314 select * from DBA_HIST_INST_CACHE_TRANSFER ; ---Instance Cache Transfer Historical Statistics
315 select * from DBA_HIST_PLAN_OPERATION_NAME ; ---Optimizer Explain Plan Operation Names
316 select * from DBA_HIST_PLAN_OPTION_NAME ; ---Optimizer Explain Plan Option Names
317 select * from DBA_HIST_SQLCOMMAND_NAME ; ---Sql command types
318 select * from DBA_HIST_TOPLEVELCALL_NAME ; ---Oracle top level call type
319 select * from DBA_HIST_ACTIVE_SESS_HISTORY ; ---Active Session Historical Statistics Information
320 select * from DBA_HIST_TABLESPACE_STAT ; ---Tablespace Historical Statistics Information
321 select * from DBA_HIST_LOG ; ---Log Historical Statistics Information
322 select * from DBA_HIST_MTTR_TARGET_ADVICE ; ---Mean-Time-To-Recover Target Advice History
323 select * from DBA_HIST_TBSPC_SPACE_USAGE ; ---Tablespace Usage Historical Statistics Information
324 select * from DBA_HIST_SERVICE_NAME ; ---Service Names
325 select * from DBA_HIST_SERVICE_STAT ; ---Historical Service Statistics
326 select * from DBA_HIST_SERVICE_WAIT_CLASS ; ---Historical Service Wait Class Statistics
327 select * from DBA_HIST_SESS_TIME_STATS ; ---CPU and I/O time for interesting (STREAMS) sessions
328 select * from DBA_HIST_STREAMS_CAPTURE ; ---STREAMS Capture Historical Statistics Information
329 select * from DBA_HIST_STREAMS_APPLY_SUM ; ---STREAMS Apply Historical Statistics Information
330 select * from DBA_HIST_BUFFERED_QUEUES ; ---STREAMS Buffered Queues Historical Statistics Information
331 select * from DBA_HIST_BUFFERED_SUBSCRIBERS ; ---STREAMS Buffered Queue Subscribers Historical Statistics Information
332 select * from DBA_HIST_RULE_SET ; ---Rule sets historical statistics information
333 select * from DBA_HIST_PERSISTENT_QUEUES ; ---STREAMS AQ Persistent Queues Historical Statistics Information
334 select * from DBA_HIST_PERSISTENT_SUBS ; ---STREAMS AQ Persistent Queue Subscribers Historical Statistics Information
335 select * from DBA_HIST_IOSTAT_FUNCTION ; ---Historical I/O statistics by function
336 select * from DBA_HIST_IOSTAT_FUNCTION_NAME ; ---Function names for historical I/O statistics
337 select * from DBA_HIST_IOSTAT_FILETYPE ; ---Historical I/O statistics by file type
338 select * from DBA_HIST_IOSTAT_FILETYPE_NAME ; ---File type names for historical I/O statistics
339 select * from DBA_HIST_IOSTAT_DETAIL ; ---Historical I/O statistics by function and filetype
340 select * from DBA_HIST_RSRC_CONSUMER_GROUP ; ---Historical resource consumer group statistics
341 select * from DBA_HIST_RSRC_PLAN ; ---Historical resource plan statistics
342 select * from DBA_HIST_CLUSTER_INTERCON ; ---Cluster Interconnect Historical Stats
343 select * from DBA_HIST_MEM_DYNAMIC_COMP ; ---Historical memory component sizes
344 select * from DBA_HIST_IC_CLIENT_STATS ; ---Historical interconnect client statistics
345 select * from DBA_HIST_IC_DEVICE_STATS ; ---Historical interconnect device statistics
346 select * from DBA_HIST_INTERCONNECT_PINGS ; ---Instance to instance ping stats
347 select * from DBA_HIST_DISPATCHER ; ---Dispatcher statistics
348 select * from DBA_HIST_SHARED_SERVER_SUMMARY ; ---Shared Server summary statistics
349 select * from DBA_HIST_DYN_REMASTER_STATS ; ---Dynamic remastering statistics
350 select * from DBA_HIST_PERSISTENT_QMN_CACHE ; ---STREAMS AQ Persistent QMN Cache Historical Statistics Information
351 select * from DBA_SQL_PROFILES ; ---set of sql profiles
352 select * from DBA_SQL_PLAN_BASELINES ; ---set of plan baselines
353 select * from DBA_SQL_PATCHES ; ---set of sql patches
354 select * from DBA_REGISTERED_SNAPSHOT_GROUPS ; ---Snapshot repgroup registration information
355 select * from DBA_REGISTERED_MVIEW_GROUPS ; ---Materialized view repgroup registration information
356 select * from DBA_REPGROUP_PRIVILEGES ; ---Information about users who are registered for object group privileges
357 select * from DBA_REPGROUP ; ---Information about all replicated object groups
358 select * from DBA_REPSITES ; ---N-way replication information
359 select * from DBA_REPSCHEMA ; ---N-way replication information
360 select * from DBA_REPOBJECT ; ---Information about replicated objects
361 select * from DBA_REPCOLUMN ; ---Replicated top-level columns (table) sorted alphabetically in ascending order
362 select * from DBA_REPPROP ; ---Propagation information about replicated objects
363 select * from DBA_REPKEY_COLUMNS ; ---Primary columns for a table using column-level replication
364 select * from DBA_REPGENOBJECTS ; ---Objects generated to support replication
365 select * from DBA_REPGENERATED ; ---Objects generated to support replication
366 select * from DBA_REPCATLOG ; ---Information about asynchronous administration requests
367 select * from DBA_REPDDL ; ---Arguments that do not fit in a single repcat log record
368 select * from DBA_REPPRIORITY_GROUP ; ---Information about all priority groups in the database
369 select * from DBA_REPPRIORITY ; ---Values and their corresponding priorities in all priority groups in the database
370 select * from DBA_REPCOLUMN_GROUP ; ---All column groups of replicated tables in the database
371 select * from DBA_REPGROUPED_COLUMN ; ---Columns in the all column groups of replicated tables in the database
372 select * from DBA_REPCONFLICT ; ---All conflicts for which users have specified resolutions in the database
373 select * from DBA_REPRESOLUTION_METHOD ; ---All conflict resolution methods in the database
374 select * from DBA_REPRESOLUTION ; ---Description of all conflict resolutions in the database
375 select * from DBA_REPRESOLUTION_STATISTICS ; ---Statistics for conflict resolutions for all replicated tables in the database
376 select * from DBA_REPRESOL_STATS_CONTROL ; ---Information about statistics collection for conflict resolutions for all replicated tables in the database
377 select * from DBA_REPPARAMETER_COLUMN ; ---All columns used for resolving conflicts in the database
378 select * from DBA_REPAUDIT_ATTRIBUTE ; ---Information about attributes automatically maintained for replication
379 select * from DBA_REPAUDIT_COLUMN ; ---Information about columns in all shadow tables for all replicated tables in the database
380 select * from DBA_REPFLAVORS ; ---Flavors defined for replicated object groups
381 select * from DBA_REPFLAVOR_OBJECTS ; ---Replicated objects in flavors
382 select * from DBA_REPFLAVOR_COLUMNS ; ---Replicated columns in flavors
383 select * from DBA_TEMPLATE_REFGROUPS ; ---Table for maintaining refresh group information for template.
384 select * from DBA_TEMPLATE_TARGETS ; ---Internal table for tracking potential target databases for templates.
385 select * from DBA_REPCAT_EXCEPTIONS ; ---Repcat processing exceptions table.
386 select * from DBA_REPEXTENSIONS ; ---Information about replication extension requests
387 select * from DBA_REPSITES_NEW ; ---Information about new masters for replication extension
388 select * from DBA_USERS_WITH_DEFPWD ; ---Users that are still using their default passwords
389 select * from DBA_WARNING_SETTINGS ; ---warning settings for all objects
390 select * from DBA_STAT_EXTENSIONS ; ---Optimizer statistics extensions
391 select * from DBA_TAB_STATISTICS ; ---Optimizer statistics for all tables in the database
392 select * from DBA_IND_STATISTICS ; ---Optimizer statistics for all indexes in the database
393 select * from DBA_PENDING_TRANSACTIONS ; ---information about unresolved global transactions
394 select * from DBA_AWS ; ---Analytic Workspaces in the database
395 select * from DBA_AW_PS ; ---Pagespaces in Analytic Workspaces owned by the user
396 select * from DBA_CUBES ; ---OLAP Cubes in the database
397 select * from DBA_CUBE_DIMENSIONALITY ; ---OLAP Cube Dimensionality in the database
398 select * from DBA_CUBE_MEASURES ; ---OLAP Measures in the database
399 select * from DBA_CUBE_DIMENSIONS ; ---OLAP Cube Dimensions in the database
400 select * from DBA_CUBE_HIERARCHIES ; ---OLAP Hierarchies in the database
401 select * from DBA_CUBE_HIER_LEVELS ; ---OLAP Hierarchy Levels in the database
402 select * from DBA_CUBE_DIM_LEVELS ; ---OLAP Dimension Levels in the database
403 select * from DBA_CUBE_ATTRIBUTES ; ---OLAP Attributes in the database
404 select * from DBA_CUBE_ATTR_VISIBILITY ; ---OLAP Attributes visible for Dimensions, Hierarchies, and Levels
405 select * from DBA_CUBE_DIM_MODELS ; ---OLAP Dimension Models in the database
406 select * from DBA_CUBE_CALCULATED_MEMBERS ; ---OLAP Calculated Members in the database
407 select * from DBA_CUBE_VIEWS ; ---OLAP Cube Views in the database
408 select * from DBA_CUBE_VIEW_COLUMNS ; ---OLAP Cube View Columns in the database
409 select * from DBA_CUBE_DIM_VIEWS ; ---OLAP Dimension Views in the database
410 select * from DBA_CUBE_DIM_VIEW_COLUMNS ; ---OLAP Dimesion View Columns in the database
411 select * from DBA_CUBE_HIER_VIEWS ; ---OLAP Hierarchy Views in the database
412 select * from DBA_CUBE_HIER_VIEW_COLUMNS ; ---OLAP Hierarchy View Columns in the database
413 select * from DBA_MEASURE_FOLDERS ; ---OLAP Measure Folders in the database
414 select * from DBA_MEASURE_FOLDER_CONTENTS ; ---OLAP Measure Folder Contents in the database
415 select * from DBA_CUBE_BUILD_PROCESSES ; ---OLAP Build Processes in the database
416 select * from DBA_QUEUE_SUBSCRIBERS ; ---queue subscribers in the database
417 select * from DBA_SCHEDULER_PROGRAMS ; ---All scheduler programs in the database
418 select * from DBA_SCHEDULER_DESTS ; ---All possible destination objects for jobs in the database
419 select * from DBA_SCHEDULER_EXTERNAL_DESTS ; ---All destination objects in the database pointing to remote agents
420 select * from DBA_SCHEDULER_DB_DESTS ; ---All destination objects in the database pointing to remote databases
421 select * from DBA_SCHEDULER_JOB_DESTS ; ---State of all jobs at each of their destinations
422 select * from DBA_SCHEDULER_JOBS ; ---All scheduler jobs in the database
423 select * from DBA_SCHEDULER_JOB_ROLES ; ---All scheduler jobs in the database by database role
424 select * from DBA_SCHEDULER_JOB_CLASSES ; ---All scheduler classes in the database
425 select * from DBA_SCHEDULER_WINDOWS ; ---All scheduler windows in the database
426 select * from DBA_SCHEDULER_PROGRAM_ARGS ; ---All arguments of all scheduler programs in the database
427 select * from DBA_SCHEDULER_JOB_ARGS ; ---All arguments with set values of all scheduler jobs in the database
428 select * from DBA_SCHEDULER_JOB_LOG ; ---Logged information for all scheduler jobs
429 select * from DBA_SCHEDULER_JOB_RUN_DETAILS ; ---The details of a job run
430 select * from DBA_SCHEDULER_WINDOW_LOG ; ---Logged information for all scheduler windows
431 select * from DBA_SCHEDULER_WINDOW_DETAILS ; ---The details of a window
432 select * from DBA_SCHEDULER_WINDOW_GROUPS ; ---All scheduler window groups in the database
433 select * from DBA_SCHEDULER_WINGROUP_MEMBERS ; ---Members of all scheduler window groups in the database
434 select * from DBA_SCHEDULER_GROUP_MEMBERS ; ---Members of all scheduler object groups in the database
435 select * from DBA_SCHEDULER_GROUPS ; ---All scheduler object groups in the database
436 select * from DBA_SCHEDULER_SCHEDULES ; ---All schedules in the database
437 select * from DBA_SCHEDULER_REMOTE_DATABASES ; ---List of registered remote databases for jobs
438 select * from DBA_SCHEDULER_REMOTE_JOBSTATE ; ---Remote state of all jobs originating from this database
439 select * from DBA_SCHEDULER_GLOBAL_ATTRIBUTE ; ---All scheduler global attributes
440 select * from DBA_SCHEDULER_CHAINS ; ---All scheduler chains in the database
441 select * from DBA_SCHEDULER_CHAIN_RULES ; ---All rules from scheduler chains in the database
442 select * from DBA_SCHEDULER_CHAIN_STEPS ; ---All steps of scheduler chains in the database
443 select * from DBA_SCHEDULER_RUNNING_CHAINS ; ---All steps of all running chains in the database
444 select * from DBA_SCHEDULER_CREDENTIALS ; ---All scheduler credentials in the database
445 select * from DBA_SCHEDULER_FILE_WATCHERS ; ---All scheduler file watch requests in the database
446 select * from DBA_SCHEDULER_NOTIFICATIONS ; ---All job e-mail notifications in the database
447 select * from DBA_EXPORT_OBJECTS ; ---Export INCLUDE and EXCLUDE object type names
448 select * from DBA_LOGSTDBY_UNSUPPORTED_TABLE ; ---List of all the data tables that are not supported by Logical Standby
449 select * from DBA_LOGSTDBY_UNSUPPORTED ; ---List of all the columns that are not supported by Logical Standby
450 select * from DBA_LOGSTDBY_NOT_UNIQUE ; ---List of all the tables with out primary or unique key not null constraints
451 select * from DBA_LOGSTDBY_PARAMETERS ; ---Miscellaneous options and settings for Logical Standby
452 select * from DBA_LOGSTDBY_PROGRESS ; ---List the SCN values describing read and apply progress
453 select * from DBA_LOGSTDBY_LOG ; ---List the information about received logs from the primary
454 select * from DBA_LOGSTDBY_SKIP_TRANSACTION ; ---List the transactions to be skipped
455 select * from DBA_LOGSTDBY_SKIP ; ---List the skip settings choosen
456 select * from DBA_LOGSTDBY_EVENTS ; ---Information on why logical standby events
457 select * from DBA_LOGSTDBY_HISTORY ; ---Information on processed, active, and pending log streams
458 select * from DBA_LOGSTDBY_EDS_TABLES ; ---List of all tables that have EDS-based replication for Logical Standby
459 select * from DBA_LOGSTDBY_EDS_SUPPORTED ; ---List of all tables that could have EDS-based replication for Logical Standby
460 select * from DBA_OUTSTANDING_ALERTS ; ---Description of all outstanding alerts
461 select * from DBA_ALERT_HISTORY ; ---Description on alert history
462 select * from DBA_THRESHOLDS ; ---Desription of all thresholds
463 select * from DBA_TABLESPACE_THRESHOLDS ; ---Space Utilization Threshold settings for all tablespaces
464 select * from DBA_AUTOTASK_OPERATION ; ---Automated Maintenance Task Operation Configuration
465 select * from DBA_AUTOTASK_TASK ; ---Information about current and past autmated maintenance tasks
466 select * from DBA_AUTOTASK_SCHEDULE ; ---Schedule of Maintenance Windows for the next 32 days
467 select * from DBA_AUTOTASK_CLIENT_JOB ; ---Current automated maintenance jobs
468 select * from DBA_AUTOTASK_WINDOW_CLIENTS ; ---Description of per-mainteance window activity
469 select * from DBA_AUTOTASK_WINDOW_HISTORY ; ---Automated Maintenance view of window history
470 select * from DBA_AUTOTASK_CLIENT_HISTORY ; ---Automated Maintenance Jobs history
471 select * from DBA_AUTOTASK_JOB_HISTORY ; ---Automated Maintenance Jobs history
472 select * from DBA_AUTOTASK_CLIENT ; ---Autotask Client Summary Information
473 select * from DBA_HIST_BASELINE ; ---Baseline Metadata Information
474 select * from DBA_HIST_BASELINE_DETAILS ; ---Baseline Stats on per Instance Level
475 select * from DBA_HIST_SQLBIND ; ---SQL Bind Information
476 select * from DBA_TUNE_MVIEW ; ---Catalog View to show the result after executing TUNE_MVIEW() API
477 select * from DBA_FLASHBACK_ARCHIVE ; ---Description of the flashback archives available in the system
478 select * from DBA_FLASHBACK_ARCHIVE_TS ; ---Description of tablespaces in the flashback archives available in the system
479 select * from DBA_FLASHBACK_ARCHIVE_TABLES ; ---Information about the tables that are enabled for Flashback Archive
480 select * from DBA_CAPTURE ; ---Details about the capture process
481 select * from DBA_STREAMS_SPLIT_MERGE ; ---view of details of split/merge jobs/status about streams
482 select * from DBA_STREAMS_SPLIT_MERGE_HIST ; ---history view of details of split/merge jobs/status about streams
483 select * from DBA_CAPTURE_PARAMETERS ; ---All parameters for capture process
484 select * from DBA_CAPTURE_PREPARED_DATABASE ; ---Is the local database prepared for instantiation?
485 select * from DBA_CAPTURE_PREPARED_SCHEMAS ; ---All schemas at the local database that are prepared for instantiation
486 select * from DBA_CAPTURE_PREPARED_TABLES ; ---All tables prepared for instantiation
487 select * from DBA_SYNC_CAPTURE_PREPARED_TABS ; ---All tables prepared for synchronous capture instantiation
488 select * from DBA_CAPTURE_EXTRA_ATTRIBUTES ; ---Extra attributes for a capture process
489 select * from DBA_REGISTERED_ARCHIVED_LOG ; ---Details about the registered log files
490 select * from DBA_SYNC_CAPTURE ; ---Details about the sync capture process
491 select * from DBA_APPLY ; ---Details about the apply process
492 select * from DBA_APPLY_PARAMETERS ; ---All parameters for apply process
493 select * from DBA_APPLY_INSTANTIATED_OBJECTS ; ---Details about objects instantiated
494 select * from DBA_APPLY_INSTANTIATED_SCHEMAS ; ---Details about schemas instantiated
495 select * from DBA_APPLY_INSTANTIATED_GLOBAL ; ---Details about database instantiated
496 select * from DBA_APPLY_KEY_COLUMNS ; ---alternative key columns for a table for STREAMS
497 select * from DBA_APPLY_CONFLICT_COLUMNS ; ---Details about conflict resolution
498 select * from DBA_APPLY_TABLE_COLUMNS ; ---Details about the destination table columns
499 select * from DBA_APPLY_DML_HANDLERS ; ---Details about the dml handler
500 select * from DBA_APPLY_PROGRESS ; ---Information about the progress made by apply process
501 select * from DBA_APPLY_ERROR ; ---Error transactions
502 select * from DBA_APPLY_ERROR_MESSAGES ; ---Details about individual messages in an error transaction
503 select * from DBA_APPLY_ENQUEUE ; ---Details about the apply enqueue action
504 select * from DBA_APPLY_EXECUTE ; ---Details about the apply execute action
505 select * from DBA_APPLY_SPILL_TXN ; ---Streams apply spilled transactions info
506 select * from DBA_XSTREAM_OUTBOUND ; ---Details about the XStream outbound server
507 select * from DBA_XSTREAM_INBOUND ; ---Details about the XStream inbound server
508 select * from DBA_APPLY_CHANGE_HANDLERS ; ---Details about apply change handler
509 select * from DBA_APPLY_DML_CONF_HANDLERS ; ---Details about DML conflict handlers
510 select * from DBA_APPLY_DML_CONF_COLUMNS ; ---Details about DML conflict handler column groups
511 select * from DBA_APPLY_HANDLE_COLLISIONS ; ---Details about apply collision handlers
512 select * from DBA_APPLY_REPERROR_HANDLERS ; ---Details about apply reperror handlers
513 select * from DBA_PROPAGATION ; ---Streams propagation in the database
514 select * from DBA_FILE_GROUPS ; ---Details about file groups
515 select * from DBA_FILE_GROUP_VERSIONS ; ---Details about file group versions
516 select * from DBA_FILE_GROUP_EXPORT_INFO ; ---Details about export information of file group versions
517 select * from DBA_FILE_GROUP_FILES ; ---Details about file group files
518 select * from DBA_FILE_GROUP_TABLESPACES ; ---Details about the transportable tablespaces in the file group repository
519 select * from DBA_FILE_GROUP_TABLES ; ---Details about the tables in the file group repository
520 select * from DBA_STREAMS_TP_DATABASE ; ---DBA Streams Database
521 select * from DBA_STREAMS_TP_COMPONENT ; ---DBA Streams Component
522 select * from DBA_STREAMS_TP_COMPONENT_LINK ; ---DBA Streams Component Link (Streams Topology Links)
523 select * from DBA_STREAMS_TP_COMPONENT_STAT ; ---DBA Streams Component Statistics
524 select * from DBA_STREAMS_TP_PATH_STAT ; ---DBA Streams Path Statistics
525 select * from DBA_STREAMS_TP_PATH_BOTTLENECK ; ---DBA Streams Path Bottleneck
526 select * from DBA_STREAMS_MESSAGE_CONSUMERS ; ---Streams messaging consumers
527 select * from DBA_STREAMS_GLOBAL_RULES ; ---Global rules created by streams administrative APIs
528 select * from DBA_STREAMS_SCHEMA_RULES ; ---Schema rules created by streams administrative APIs
529 select * from DBA_STREAMS_TABLE_RULES ; ---Table rules created by streams administrative APIs
530 select * from DBA_STREAMS_MESSAGE_RULES ; ---Rules for Streams messaging
531 select * from DBA_STREAMS_RULES ; ---Rules used by Streams processes
532 select * from DBA_SYNC_CAPTURE_TABLES ; ---All tables that are captured by synchronous streams captures.
533 select * from DBA_XSTREAM_RULES ; ---Details about the XStream server rules
534 select * from DBA_STREAMS_TRANSFORM_FUNCTION ; ---Rules-based transform functions used by Streams
535 select * from DBA_STREAMS_ADMINISTRATOR ; ---Users granted the privileges to be a streams administrator
536 select * from DBA_XSTREAM_ADMINISTRATOR ; ---Users granted the privileges to be a XStream administrator
537 select * from DBA_STREAMS_TRANSFORMATIONS ; ---Transformations defined on rules
538 select * from DBA_STREAMS_RENAME_SCHEMA ; ---Rename schema transformations
539 select * from DBA_STREAMS_RENAME_TABLE ; ---Rename table transformations
540 select * from DBA_STREAMS_DELETE_COLUMN ; ---Delete column transformations
541 select * from DBA_STREAMS_KEEP_COLUMNS ; ---Keep columns transformations
542 select * from DBA_STREAMS_RENAME_COLUMN ; ---Rename column transformations
543 select * from DBA_STREAMS_ADD_COLUMN ; ---Add column transformations
544 select * from DBA_RECOVERABLE_SCRIPT ; ---Details about recoverable operations
545 select * from DBA_RECOVERABLE_SCRIPT_HIST ; ---Details about executed or purged recoverable operations
546 select * from DBA_RECOVERABLE_SCRIPT_PARAMS ; ---Details about the recoverable operation parameters
547 select * from DBA_RECOVERABLE_SCRIPT_BLOCKS ; ---Details about the recoverable script blocks
548 select * from DBA_RECOVERABLE_SCRIPT_ERRORS ; ---Details showing errors during script execution
549 select * from DBA_GOLDENGATE_PRIVILEGES ; ---Details about goldengate privileges
550 select * from DBA_COMPARISON ; ---Details about the comparison object
551 select * from DBA_COMPARISON_COLUMNS ; ---Details about the comparison object's columns
552 select * from DBA_COMPARISON_SCAN ; ---Details about a comparison scan
553 select * from DBA_COMPARISON_SCAN_SUMMARY ; ---Details about a comparison scan
554 select * from DBA_COMPARISON_SCAN_VALUES ; ---Details about a comparison scan's values
555 select * from DBA_COMPARISON_ROW_DIF ; ---Details about the differing rows in a comparison scan
556 select * from DBA_STREAMS_COLUMNS ; ---Supportability info about streams columns
557 select * from DBA_STREAMS_UNSUPPORTED ; ---List of all the tables that are not supported by Streams in this release
558 select * from DBA_STREAMS_NEWLY_SUPPORTED ; ---List of tables that are newly supported by Streams capture
559 select * from DBA_XSTREAM_OUT_SUPPORT_MODE ; ---List of support mode for objects by XStream Out
560 select * from DBA_JAVA_POLICY ; ---java security Permissions for all users
561 select * from DBA_JAVA_CLASSES ; ---class level information of all stored java classes
562 select * from DBA_JAVA_LAYOUTS ; ---class layout information about stored java class
563 select * from DBA_JAVA_IMPLEMENTS ; ---interfaces implemented by the stored java class
564 select * from DBA_JAVA_INNERS ; ---list of inner classes refered by the stored java class
565 select * from DBA_JAVA_FIELDS ; ---field information of all stored java class
566 select * from DBA_JAVA_METHODS ; ---method information of all stored java class
567 select * from DBA_JAVA_ARGUMENTS ; ---argument information of all stored java class
568 select * from DBA_JAVA_THROWS ; ---list of exceptions thrown from a method of a class owned by user
569 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
570 select * from DBA_JAVA_RESOLVERS ; ---resolver of java class owned by user
571 select * from DBA_JAVA_COMPILER_OPTIONS ; ---all native-compiler options
572 select * from DBA_EPG_DAD_AUTHORIZATION ; ---DADs authorized to use different user's privileges
573 select * from DBA_XML_TABLES ; ---Description of all XML tables in the database
574 select * from DBA_XML_TAB_COLS ; ---Description of all XML tables in the database
575 select * from DBA_XML_VIEWS ; ---Description of all XML views in the database
576 select * from DBA_XML_VIEW_COLS ; ---Description of all XML views in the database
577 select * from DBA_XML_SCHEMAS ; ---Description of all the XML Schemas registered
578 select * from DBA_XML_INDEXES ; ---Description of all XML indexes in the database
579 select * from DBA_XML_SCHEMA_IMPORTS ; ---Description of all XML schema first level dependencies on imported XML schemas
580 select * from DBA_XML_SCHEMA_INCLUDES ; ---Description of all XML schema first level dependencies on included XML schemas
581 select * from DBA_XML_SCHEMA_DEPENDENCY ; ---Description of all XML schema first level dependencies on imported and included XML schemas
582 select * from DBA_NETWORK_ACL_PRIVILEGES ; ---Privileges defined in network access control lists
583 select * from DBA_WALLET_ACLS ; ---Access control lists assigned to restrict access to wallets through PL/SQL network utility packages
584 select * from DBA_XDS_OBJECTS ; ---All XDS enabled objects in the database
585 select * from DBA_NETWORK_ACLS ; ---Access control lists assigned to restrict access to network hosts through PL/SQL network utility packages
586 select * from DBA_XDS_INSTANCE_SETS ; ---All instance sets in the database
587 select * from DBA_XDS_ATTRIBUTE_SECS ; ---All XDS column security defined in the database
588 select * from DBA_AW_PROP ; ---Object properties in Analytic Workspaces in the database
589 select * from DBA_AW_OBJ ; ---Objects in Analytic Workspaces in the database
590 select * from DBA_REGISTRY_DEPENDENCIES ; ---
591 select * from DBA_PARALLEL_EXECUTE_CHUNKS ; ---
592 select * from DBA_SQLSET_PLANS ; ---
593 select * from DBA_DBFS_HS ; ---
594 select * from DBA_ADVISOR_DEFINITIONS ; ---
595 select * from DBA_WORKLOAD_REPLAY_DIVERGENCE ; ---
596 select * from DBA_WORKLOAD_FILTERS ; ---
597 select * from DBA_SQLSET_STATEMENTS ; ---
598 select * from DBA_IAS_OBJECTS_BASE ; ---
599 select * from DBA_ADVISOR_EXECUTIONS ; ---
600 select * from DBA_PART_TABLES ; ---
601 select * from DBA_PART_INDEXES ; ---
602 select * from DBA_QUEUE_PUBLISHERS ; ---
603 select * from DBA_ADVISOR_COMMANDS ; ---
604 select * from DBA_ADVISOR_SQLPLANS ; ---
605 select * from DBA_ADVISOR_SQLW_PARAMETERS ; ---
606 select * from DBA_REPCAT ; ---
607 select * from DBA_BLOCKERS ; ---
608 select * from DBA_IAS_TEMPLATES ; ---
609 select * from DBA_EXPORT_PATHS ; ---
610 select * from DBA_ADDM_SYSTEM_DIRECTIVES ; ---
611 select * from DBA_PARALLEL_EXECUTE_TASKS ; ---
612 select * from DBA_ADVISOR_OBJECT_TYPES ; ---
613 select * from DBA_SQLSET_BINDS ; ---
614 select * from DBA_TYPE_XMLSCHEMA_DEP ; ---
615 select * from DBA_ADVISOR_OBJECTS ; ---
616 select * from DBA_WORKLOAD_CONNECTION_MAP ; ---
617 select * from DBA_ADVISOR_DIR_INSTANCES ; ---
618 select * from DBA_IAS_GEN_STMTS ; ---
619 select * from DBA_LOB_PARTITIONS ; ---
620 select * from DBA_ADVISOR_TASKS ; ---
621 select * from DBA_SQLSET ; ---
622 select * from DBA_ADVISOR_DEF_PARAMETERS ; ---
623 select * from DBA_LOCK ; ---
624 select * from DBA_IAS_OBJECTS ; ---
625 select * from DBA_PART_KEY_COLUMNS ; ---
626 select * from DBA_ADVISOR_FDG_BREAKDOWN ; ---
627 select * from DBA_ADVISOR_SQLA_TABVOL ; ---
628 select * from DBA_SQLTUNE_STATISTICS ; ---
629 select * from DBA_ADVISOR_SQLA_COLVOL ; ---
630 select * from DBA_ADVISOR_PARAMETERS ; ---
631 select * from DBA_LOGMNR_LOG ; ---
632 select * from DBA_TRANSFORMATIONS ; ---
633 select * from DBA_PART_HISTOGRAMS ; ---
634 select * from DBA_IAS_PREGEN_STMTS ; ---
635 select * from DBA_ADVISOR_SQLA_WK_STMTS ; ---
636 select * from DBA_ADVISOR_USAGE ; ---
637 select * from DBA_ADVISOR_SQLW_STMTS ; ---
638 select * from DBA_ADDM_FDG_BREAKDOWN ; ---
639 select * from DBA_QUEUE_SCHEDULES ; ---
640 select * from DBA_DBFS_HS_COMMANDS ; ---
641 select * from DBA_AQ_AGENTS ; ---
642 select * from DBA_SUBPARTITION_TEMPLATES ; ---
643 select * from DBA_SUBPART_KEY_COLUMNS ; ---
644 select * from DBA_SUBPART_HISTOGRAMS ; ---
645 select * from DBA_AQ_AGENT_PRIVS ; ---
646 select * from DBA_ADVISOR_TEMPLATES ; ---
647 select * from DBA_ADDM_FINDINGS ; ---
648 select * from DBA_PART_LOBS ; ---
649 select * from DBA_LOB_TEMPLATES ; ---
650 select * from DBA_JAVA_NCOMPS ; ---
651 select * from DBA_REGISTRY_HIERARCHY ; ---
652 select * from DBA_SQLTUNE_BINDS ; ---
653 select * from DBA_IAS_GEN_STMTS_EXP ; ---
654 select * from DBA_REGISTRY_PROGRESS ; ---
655 select * from DBA_ADVISOR_DIR_DEFINITIONS ; ---
656 select * from DBA_ADVISOR_JOURNAL ; ---
657 select * from DBA_SQLSET_REFERENCES ; ---
658 select * from DBA_SERVER_REGISTRY ; ---
659 select * from DBA_ADVISOR_FINDING_NAMES ; ---
660 select * from DBA_ADVISOR_RECOMMENDATIONS ; ---
661 select * from DBA_KGLLOCK ; ---
662 select * from DBA_DDL_LOCKS ; ---
663 select * from DBA_ADVISOR_LOG ; ---
664 select * from DBA_IAS_CONSTRAINT_EXP ; ---
665 select * from DBA_SQL_MONITOR_USAGE ; ---
666 select * from DBA_ADVISOR_SQLA_TABLES ; ---
667 select * from DBA_ADVISOR_SQLSTATS ; ---
668 select * from DBA_TAB_SUBPARTITIONS ; ---
669 select * from DBA_ADVISOR_ACTIONS ; ---
670 select * from DBA_FLASHBACK_TXN_REPORT ; ---
671 select * from DBA_SQLTUNE_PLANS ; ---
672 select * from DBA_ADDM_INSTANCES ; ---
673 select * from DBA_ADVISOR_SQLW_SUM ; ---
674 select * from DBA_ADVISOR_SQLW_COLVOL ; ---
675 select * from DBA_WAITERS ; ---
676 select * from DBA_ADVISOR_EXECUTION_TYPES ; ---
677 select * from DBA_ADVISOR_SQLA_WK_SUM ; ---
678 select * from DBA_IAS_SITES ; ---
679 select * from DBA_ADVISOR_SQLW_JOURNAL ; ---
680 select * from DBA_REGISTRY ; ---
681 select * from DBA_ADVISOR_SQLW_TEMPLATES ; ---
682 select * from DBA_DBFS_HS_FIXED_PROPERTIES ; ---
683 select * from DBA_WORKLOAD_REPLAY_FILTER_SET ; ---
684 select * from DBA_LOCK_INTERNAL ; ---
685 select * from DBA_KEEPSIZES ; ---
686 select * from DBA_ADVISOR_DIR_TASK_INST ; ---
687 select * from DBA_ADVISOR_RATIONALE ; ---
688 select * from DBA_FLASHBACK_TXN_STATE ; ---
689 select * from DBA_ADVISOR_SQLW_TABLES ; ---
690 select * from DBA_IND_SUBPARTITIONS ; ---
691 select * from DBA_PART_COL_STATISTICS ; ---
692 select * from DBA_TAB_PARTITIONS ; ---
693 select * from DBA_DML_LOCKS ; ---
694 select * from DBA_XMLSCHEMA_LEVEL_VIEW ; ---
695 select * from DBA_IAS_POSTGEN_STMTS ; ---
696 select * from DBA_LOGMNR_SESSION ; ---
697 select * from DBA_ADVISOR_EXEC_PARAMETERS ; ---
698 select * from DBA_INVALID_OBJECTS ; ---
699 select * from DBA_XMLSCHEMA_LEVEL_VIEW_DUP ; ---
700 select * from DBA_REGISTRY_HISTORY ; ---
701 select * from DBA_REGISTRY_LOG ; ---
702 select * from DBA_SUBPART_COL_STATISTICS ; ---
703 select * from DBA_ATTRIBUTE_TRANSFORMATIONS ; ---
704 select * from DBA_ADDM_TASK_DIRECTIVES ; ---
705 select * from DBA_LOB_SUBPARTITIONS ; ---
706 select * from DBA_ANALYZE_OBJECTS ; ---
707 select * from DBA_WORKLOAD_CAPTURES ; ---
708 select * from DBA_ADVISOR_PARAMETERS_PROJ ; ---
709 select * from DBA_WORKLOAD_REPLAYS ; ---
710 select * from DBA_ADVISOR_SQLA_REC_SUM ; ---
711 select * from DBA_LOGMNR_PURGED_LOG ; ---
712 select * from DBA_ADVISOR_FINDINGS ; ---
713 select * from DBA_SQLTUNE_RATIONALE_PLAN ; ---
714 select * from DBA_IND_PARTITIONS ; ---
715 select * from DBA_DBFS_HS_PROPERTIES ; ---
716 select * from DBA_HIST_ASH_SNAPSHOT ; ---
717 select * from DBA_ADDM_TASKS ; ---
718 select * from DBA_REGISTRY_DATABASE ; ---
719 select * from DBA_ADVISOR_SQLA_WK_MAP ; ---
720 select * from DBA_IAS_OBJECTS_EXP ; ---
721 select * from DBA_ADVISOR_SQLW_TABVOL ; ---
722 select * from USER_CONS_COLUMNS ; ---Information about accessible columns in constraint definitions
723 select * from USER_LOG_GROUP_COLUMNS ; ---Information about columns in log group definitions
724 select * from USER_LOBS ; ---Description of the user's own LOBs contained in the user's own tables
725 select * from USER_CATALOG ; ---Tables, Views, Synonyms and Sequences owned by the user
726 select * from USER_CLUSTERS ; ---Descriptions of user's own clusters
727 select * from USER_CLU_COLUMNS ; ---Mapping of table columns to cluster columns
728 select * from USER_COL_COMMENTS ; ---Comments on columns of user's tables and views
729 select * from USER_COL_PRIVS ; ---Grants on columns for which the user is the owner, grantor or grantee
730 select * from USER_COL_PRIVS_MADE ; ---All grants on columns of objects owned by the user
731 select * from USER_COL_PRIVS_RECD ; ---Grants on columns for which the user is the grantee
732 select * from USER_ENCRYPTED_COLUMNS ; ---Encryption information on columns of tables owned by the user
733 select * from USER_INDEXES ; ---Description of the user's own indexes
734 select * from USER_IND_COLUMNS ; ---COLUMNs comprising user's INDEXes and INDEXes on user's TABLES
735 select * from USER_IND_EXPRESSIONS ; ---Functional index expressions in user's indexes and indexes on user's tables
736 select * from USER_JOIN_IND_COLUMNS ; ---Join Index columns comprising the join conditions
737 select * from USER_OBJECTS ; ---Objects owned by the user
738 select * from USER_OBJECTS_AE ; ---Objects owned by the user
739 select * from USER_ROLE_PRIVS ; ---Roles granted to current user
740 select * from USER_SEQUENCES ; ---Description of the user's own SEQUENCEs
741 select * from USER_SYNONYMS ; ---The user's private synonyms
742 select * from USER_TABLES ; ---Description of the user's own relational tables
743 select * from USER_OBJECT_TABLES ; ---Description of the user's own object tables
744 select * from USER_ALL_TABLES ; ---Description of all object and relational tables owned by the user's
745 select * from USER_TAB_COLS ; ---Columns of user's tables, views and clusters
746 select * from USER_TAB_COLUMNS ; ---Columns of user's tables, views and clusters
747 select * from USER_TAB_COMMENTS ; ---Comments on the tables and views owned by the user
748 select * from USER_TAB_PRIVS ; ---Grants on objects for which the user is the owner, grantor or grantee
749 select * from USER_TAB_PRIVS_MADE ; ---All grants on objects owned by the user
750 select * from USER_TAB_PRIVS_RECD ; ---Grants on objects for which the user is the grantee
751 select * from USER_VIEWS ; ---Description of the user's own views
752 select * from USER_VIEWS_AE ; ---Description of the user's own views
753 select * from USER_CONSTRAINTS ; ---Constraint definitions on user's own tables
754 select * from USER_LOG_GROUPS ; ---Log group definitions on user's own tables
755 select * from USER_CLUSTER_HASH_EXPRESSIONS ; ---Hash functions for the user's hash clusters
756 select * from USER_UPDATABLE_COLUMNS ; ---Description of updatable columns
757 select * from USER_UNUSED_COL_TABS ; ---User tables with unused columns
758 select * from USER_PARTIAL_DROP_TABS ; ---User tables with unused columns
759 select * from USER_RESUMABLE ; ---Resumable session information for current user
760 select * from USER_EDITIONING_VIEWS ; ---Descriptions of the user's own Editioning Views
761 select * from USER_EDITIONING_VIEWS_AE ; ---Descriptions of the user's own Editioning Views
762 select * from USER_EDITIONING_VIEW_COLS ; ---Relationship between columns of user's Editioning Views and the table columns to which they map
763 select * from USER_EDITIONING_VIEW_COLS_AE ; ---Relationship between columns of user's Editioning Views and the table columns to which they map
764 select * from USER_LIBRARIES ; ---Description of the user's own libraries
765 select * from USER_PROCEDURES ; ---Description of the user functions/procedures/packages/types/triggers
766 select * from USER_STORED_SETTINGS ; ---Parameter settings for objects owned by the user
767 select * from USER_PLSQL_OBJECT_SETTINGS ; ---Compiler settings of stored objects owned by the user
768 select * from USER_ARGUMENTS ; ---Arguments in object accessible to the user
769 select * from USER_ASSEMBLIES ; ---Description of the user's own assemblies
770 select * from USER_IDENTIFIERS ; ---Identifiers in stored objects accessible to the user
771 select * from USER_DB_LINKS ; ---Database links owned by the user
772 select * from USER_RECYCLEBIN ; ---User view of his recyclebin
773 select * from USER_RESOURCE_LIMITS ; ---Display resource limit of the user
774 select * from USER_PASSWORD_LIMITS ; ---Display password limits of the user
775 select * from USER_USERS ; ---Information about the current user
776 select * from USER_OBJ_AUDIT_OPTS ; ---Auditing options for user's own tables and views with atleast one option set
777 select * from USER_AUDIT_TRAIL ; ---Audit trail entries relevant to the user
778 select * from USER_AUDIT_SESSION ; ---All audit trail records concerning CONNECT and DISCONNECT
779 select * from USER_AUDIT_STATEMENT ; ---Audit trail records concerning  grant, revoke, audit, noaudit and alter system
780 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
781 select * from USER_SYS_PRIVS ; ---System privileges granted to current user
782 select * from USER_PROXIES ; ---Description of connections the user is allowed to proxy
783 select * from USER_TYPES ; ---Description of the user's own types
784 select * from USER_COLL_TYPES ; ---Description of the user's own named collection types
785 select * from USER_TYPE_ATTRS ; ---Description of attributes of the user's own types
786 select * from USER_TYPE_METHODS ; ---Description of methods of the user's own types
787 select * from USER_METHOD_PARAMS ; ---Description of method parameters of the user's own types
788 select * from USER_METHOD_RESULTS ; ---Description of method results of the user's own types
789 select * from USER_SQLJ_TYPES ; ---Description of the user's own types
790 select * from USER_TYPE_VERSIONS ; ---Description of each version of the user's types
791 select * from USER_PENDING_CONV_TABLES ; ---All user's tables which are not upgraded to the latest type version
792 select * from USER_SQLJ_TYPE_ATTRS ; ---Description of attributes of the user's own types
793 select * from USER_SQLJ_TYPE_METHODS ; ---Description of methods of the user's own types
794 select * from USER_OLDIMAGE_COLUMNS ; ---Gives all object tables and columns in old (8.0) image format
795 select * from USER_NESTED_TABLE_COLS ; ---Columns of nested tables
796 select * from USER_REFS ; ---Description of the user's own REF columns contained in the user's own tables
797 select * from USER_NESTED_TABLES ; ---Description of nested tables contained in the user's own tables
798 select * from USER_VARRAYS ; ---Description of varrays contained in the user's own tables
799 select * from USER_OBJ_COLATTRS ; ---Description of object columns and attributes contained in tables owned by the user
800 select * from USER_CONS_OBJ_COLUMNS ; ---List of types an object column or attribute is constrained to in the tables owned by the user
801 select * from USER_OPERATORS ; ---All user operators
802 select * from USER_OPBINDINGS ; ---All binding functions or methods on operators defined by the user
803 select * from USER_OPANCILLARY ; ---All ancillary opertors defined by user
804 select * from USER_OPARGUMENTS ; ---All operator arguments of operators defined by user
805 select * from USER_OPERATOR_COMMENTS ; ---Comments for user-defined operators
806 select * from USER_INDEXTYPES ; ---All user indextypes
807 select * from USER_INDEXTYPE_COMMENTS ; ---Comments for user-defined indextypes
808 select * from USER_INDEXTYPE_ARRAYTYPES ; ---All array types specified by the indextype
809 select * from USER_INDEXTYPE_OPERATORS ; ---All user indextype operators
810 select * from USER_SECONDARY_OBJECTS ; ---All secondary objects for domain indexes
811 select * from USER_SOURCE_TABLES ; ---Source tables available for Change Data Capture
812 select * from USER_PUBLISHED_COLUMNS ; ---Source columns available for Change Data Capture
813 select * from USER_SUBSCRIPTIONS ; ---Change Data Capture subscriptions
814 select * from USER_SUBSCRIBED_TABLES ; ---Change Data Capture subscribed tables
815 select * from USER_SUBSCRIBED_COLUMNS ; ---Change Data Capture subscribed columns
816 select * from USER_EXTERNAL_TABLES ; ---Description of the user's own external tables
817 select * from USER_EXTERNAL_LOCATIONS ; ---Description of the user's external tables locations
818 select * from USER_MINING_MODELS ; ---Description of the user's own models
819 select * from USER_MINING_MODEL_ATTRIBUTES ; ---Description of the user's own model attributes
820 select * from USER_MINING_MODEL_SETTINGS ; ---Description of the user's own model settings
821 select * from USER_TAB_COL_STATISTICS ; ---Columns of user's tables, views and clusters
822 select * from USER_TAB_HISTOGRAMS ; ---Histograms on columns of user's tables
823 select * from USER_ASSOCIATIONS ; ---All assocations defined by the user
824 select * from USER_USTATS ; ---All statistics on tables or indexes owned by the user
825 select * from USER_TAB_MODIFICATIONS ; ---Information regarding modifications to tables
826 select * from USER_TAB_STATS_HISTORY ; ---History of table statistics modifications
827 select * from USER_TAB_STAT_PREFS ; ---Statistics preferences for tables
828 select * from USER_TAB_PENDING_STATS ; ---History of table statistics modifications
829 select * from USER_IND_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
830 select * from USER_COL_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
831 select * from USER_TAB_HISTGRM_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
832 select * from USER_DIMENSIONS ; ---Description of the dimension objects accessible to the DBA
833 select * from USER_DIM_LEVELS ; ---Description of dimension levels visible to DBA
834 select * from USER_DIM_LEVEL_KEY ; ---Representations of columns of a dimension level
835 "select * from USER_DIM_ATTRIBUTES ; ---Representation of the relationship between a dimension level and
836  a functionally dependent column"
837 select * from USER_DIM_HIERARCHIES ; ---Representation of a dimension hierarchy
838 "select * from USER_DIM_CHILD_OF ; ---Representaion of a 1:n hierarchical relationship between a pair of levels in
839  a dimension"
840 select * from USER_DIM_JOIN_KEY ; ---Representation of a join between two dimension tables. 
841 select * from USER_SUMMARIES ; ---Description of the summaries created by the user
842 select * from USER_MVIEW_ANALYSIS ; ---Description of the materialized views created by the user
843 select * from USER_MVIEW_AGGREGATES ; ---Description of the materialized view aggregates created by the user
844 "select * from USER_MVIEW_DETAIL_RELATIONS ; ---Description of the materialized view detail tables of the materialized
845 views created by the user"
846 "select * from USER_MVIEW_KEYS ; ---Description of the columns that appear in the GROUP BY
847 list of a materialized view  created by the user"
848 "select * from USER_MVIEW_JOINS ; ---Description of a join between two columns in the
849 WHERE clause of a materialized view created by the user"
850 select * from USER_MVIEW_COMMENTS ; ---Comments on materialized views owned by the user
851 select * from USER_REWRITE_EQUIVALENCES ; ---Description of all rewrite equivalence owned by the user
852 select * from USER_MVIEW_DETAIL_PARTITION ; ---Freshness information of all PCT materialized views in the database
853 select * from USER_MVIEW_DETAIL_SUBPARTITION ; ---Freshness information of all PCT materialized views in the database
854 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
855 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
856 select * from USER_ERRORS ; ---Current errors on stored objects owned by the user
857 select * from USER_ERRORS_AE ; ---Current errors on stored objects owned by the user
858 select * from USER_SOURCE_AE ; ---Source of stored objects accessible to the user
859 select * from USER_SOURCE ; ---Source of stored objects accessible to the user
860 select * from USER_TRIGGERS ; ---Triggers having FOLLOWS or PRECEDES ordering owned by the user
861 select * from USER_INTERNAL_TRIGGERS ; ---Description of the internal triggers on the user's own tables
862 select * from USER_TRIGGER_COLS ; ---Column usage in user's triggers
863 select * from USER_DEPENDENCIES ; ---Dependencies to and from a users objects
864 select * from USER_OBJECT_SIZE ; ---Sizes, in bytes, of various pl/sql objects
865 select * from USER_JOBS ; ---All jobs owned by this user
866 select * from USER_SEGMENTS ; ---Storage allocated for all database segments
867 select * from USER_EXTENTS ; ---Extents comprising segments owned by the user
868 select * from USER_FREE_SPACE ; ---Free extents in tablespaces accessible to the user
869 select * from USER_TABLESPACES ; ---Description of accessible tablespaces
870 select * from USER_TS_QUOTAS ; ---Tablespace quotas for the user
871 select * from USER_RULE_SETS ; ---Rule sets owned by the user
872 select * from USER_RULESETS ; ---Rulesets owned by the user: maintained for backward compatibility
873 select * from USER_RULES ; ---Rules owned by the user
874 select * from USER_RULE_SET_RULES ; ---Rules in user rule sets
875 select * from USER_EVALUATION_CONTEXTS ; ---rule evaluation contexts owned by user
876 select * from USER_EVALUATION_CONTEXT_TABLES ; ---tables in user rule evaluation contexts
877 select * from USER_EVALUATION_CONTEXT_VARS ; ---variables in user rule evaluation contexts
878 select * from USER_SNAPSHOTS ; ---Snapshots the user can look at
879 select * from USER_SNAPSHOT_LOGS ; ---All snapshot logs owned by the user
880 select * from USER_REFRESH ; ---All the refresh groups
881 select * from USER_REFRESH_CHILDREN ; ---All the objects in refresh groups, where the user owns the refresh group
882 select * from USER_REGISTERED_SNAPSHOTS ; ---Remote snapshots of local tables currently using logs owned by the user
883 select * from USER_MVIEWS ; ---All materialized views in the database
884 select * from USER_MVIEW_REFRESH_TIMES ; ---Materialized views and their last refresh times for each master table that the user can look at
885 select * from USER_MVIEW_LOGS ; ---All materialized view logs owned by the user
886 select * from USER_BASE_TABLE_MVIEWS ; ---All materialized views with log(s) owned by the user in the database
887 select * from USER_REGISTERED_MVIEWS ; ---Remote materialized views of local tables currently using logs owned by the user
888 select * from USER_POLICIES ; ---All row level security policies for synonyms, tables, or views owned by the user
889 select * from USER_POLICY_GROUPS ; ---All policy groups defined for any synonym, table, or view
890 select * from USER_POLICY_CONTEXTS ; ---All policy driving context defined for synonyms, tables, or views in current schema
891 select * from USER_SEC_RELEVANT_COLS ; ---Security Relevant columns of VPD policies for tables or views owned by the user
892 select * from USER_AUDIT_POLICIES ; ---All fine grained auditing policies for objects in user schema
893 select * from USER_AUDIT_POLICY_COLUMNS ; ---Users fine grained auditing policy columns in the database
894 select * from USER_CHANGE_NOTIFICATION_REGS ; ---change notification registrations for current user
895 select * from USER_CQ_NOTIFICATION_QUERIES ; ---Description of registered queries for CQ notification
896 select * from USER_SUBSCR_REGISTRATIONS ; ---All subscription registrations created by the user
897 select * from USER_QUEUE_TABLES ; ---All queue tables created by the user
898 select * from USER_QUEUES ; ---All queues owned by the user
899 select * from USER_RSRC_CONSUMER_GROUP_PRIVS ; ---Switch privileges for consumer groups for the user
900 select * from USER_RSRC_MANAGER_SYSTEM_PRIVS ; ---system privileges for the resource manager for the user
901 select * from USER_OUTLINES ; ---Stored outlines owned by the user
902 select * from USER_OUTLINE_HINTS ; ---Hints stored in outlines owned by the user
903 select * from USER_DATAPUMP_JOBS ; ---Datapump jobs for current user
904 select * from USER_REPGROUP_PRIVILEGES ; ---Information about users who are registered for object group privileges
905 select * from USER_REPGROUP ; ---Replication information about the current user
906 select * from USER_REPSITES ; ---N-way replication information about the current user
907 select * from USER_REPSCHEMA ; ---N-way replication information about the current user
908 select * from USER_REPOBJECT ; ---Replication information about the current user's objects
909 select * from USER_REPCOLUMN ; ---Replicated columns for the current user's table in ascending order
910 select * from USER_REPPROP ; ---Propagation information about the current user's objects
911 select * from USER_REPKEY_COLUMNS ; ---Primary columns for a table using column-level replication
912 select * from USER_REPGENOBJECTS ; ---Objects generated for the current user to support replication
913 select * from USER_REPGENERATED ; ---Objects generated for the current user to support replication
914 select * from USER_REPCATLOG ; ---Information about the current user's asynchronous administration requests
915 select * from USER_REPDDL ; ---Arguments that do not fit in a single repcat log record
916 select * from USER_REPPRIORITY_GROUP ; ---Information about user's priority groups
917 select * from USER_REPPRIORITY ; ---Values and their corresponding priorities in user's priority groups
918 select * from USER_REPCOLUMN_GROUP ; ---All column groups of user's replicated tables
919 select * from USER_REPGROUPED_COLUMN ; ---Columns in the all column groups of user's replicated tables
920 select * from USER_REPRESOLUTION_METHOD ; ---All conflict resolution methods accessible to the user
921 select * from USER_REPRESOLUTION ; ---Description of all conflict resolutions for user's replicated tables
922 select * from USER_REPRESOLUTION_STATISTICS ; ---Statistics for conflict resolutions for user's replicated tables
923 select * from USER_REPRESOL_STATS_CONTROL ; ---Information about statistics collection for conflict resolutions for user's replicated tables
924 select * from USER_REPPARAMETER_COLUMN ; ---All columns used for resolving conflicts in user's replicated tables
925 select * from USER_REPAUDIT_ATTRIBUTE ; ---Information about attributes automatically maintained for replication
926 select * from USER_REPAUDIT_COLUMN ; ---Information about columns in all shadow tables for user's replicated tables
927 select * from USER_REPFLAVORS ; ---Flavors current user created for replicated object groups
928 select * from USER_REPFLAVOR_OBJECTS ; ---Replicated user objects in flavors
929 select * from USER_REPFLAVOR_COLUMNS ; ---Replicated columns from current user's tables in flavors
930 select * from USER_WARNING_SETTINGS ; ---Warning Parameter settings for objects owned by the user
931 select * from USER_STAT_EXTENSIONS ; ---Optimizer statistics extensions
932 select * from USER_TAB_STATISTICS ; ---Optimizer statistics of the user's own tables
933 select * from USER_IND_STATISTICS ; ---Optimizer statistics for user's own indexes
934 select * from USER_AWS ; ---Analytic Workspaces owned by the user
935 select * from USER_AW_PS ; ---Pagespaces in Analytic Workspaces owned by the user
936 select * from USER_CUBES ; ---OLAP Cubes owned by the user in the database
937 select * from USER_CUBE_DIMENSIONALITY ; ---OLAP Cube Dimensionality owned by the user in the database
938 select * from USER_CUBE_MEASURES ; ---OLAP Measures owned by the user in the database
939 select * from USER_CUBE_DIMENSIONS ; ---OLAP Cube Dimensions owned by the user in the database
940 select * from USER_CUBE_HIERARCHIES ; ---OLAP Hierarchies owned by the user in the database
941 select * from USER_CUBE_HIER_LEVELS ; ---OLAP Hierarchy Levels owned by the user in the database
942 select * from USER_CUBE_DIM_LEVELS ; ---OLAP Dimension Levels owned by the user in the database
943 select * from USER_CUBE_ATTRIBUTES ; ---OLAP Attributes owned by the user in the database
944 select * from USER_CUBE_ATTR_VISIBILITY ; ---OLAP Attributes visible for Dimensions, Hierarchies, and Levels
945 select * from USER_CUBE_DIM_MODELS ; ---OLAP Dimension Models in the database accessible to the user
946 select * from USER_CUBE_CALCULATED_MEMBERS ; ---OLAP Calculated Members in the database accessible to the user
947 select * from USER_CUBE_VIEWS ; ---OLAP Cube Views owned by the user in the database
948 select * from USER_CUBE_VIEW_COLUMNS ; ---OLAP Cube View Columns owned by the user in the database
949 select * from USER_CUBE_DIM_VIEWS ; ---OLAP Dimension Views owned by the user in the database
950 select * from USER_CUBE_DIM_VIEW_COLUMNS ; ---OLAP Dimesion View Columns in the database accessible to the user
951 select * from USER_CUBE_HIER_VIEWS ; ---OLAP Hierarchy Views owner by the user in the database
952 select * from USER_CUBE_HIER_VIEW_COLUMNS ; ---OLAP Hierarchy View Columns owned by the user in the database
953 select * from USER_MEASURE_FOLDERS ; ---OLAP Measure Folders owned by the user in the database
954 select * from USER_MEASURE_FOLDER_CONTENTS ; ---OLAP Measure Folder Contents owned by the user in the database
955 select * from USER_CUBE_BUILD_PROCESSES ; ---OLAP Build Processes owned by the user in the database
956 select * from USER_QUEUE_SUBSCRIBERS ; ---queue subscribers under a user'schema
957 select * from USER_SCHEDULER_PROGRAMS ; ---Scheduler programs owned by the current user
958 select * from USER_SCHEDULER_DESTS ; ---Destination objects for jobs in the database owned by current user
959 select * from USER_SCHEDULER_DB_DESTS ; ---User-owned destination objects in the database pointing to remote databases
960 select * from USER_SCHEDULER_JOB_DESTS ; ---State of all jobs owned by current user at each of their destinations
961 select * from USER_SCHEDULER_JOBS ; ---All scheduler jobs in the database
962 select * from USER_SCHEDULER_PROGRAM_ARGS ; ---All arguments of all scheduler programs in the database
963 select * from USER_SCHEDULER_JOB_ARGS ; ---All arguments with set values of all scheduler jobs in the database
964 select * from USER_SCHEDULER_JOB_LOG ; ---Logged information for all scheduler jobs
965 select * from USER_SCHEDULER_JOB_RUN_DETAILS ; ---The details of a job run
966 select * from USER_SCHEDULER_GROUP_MEMBERS ; ---Members of all scheduler object groups owned by current user
967 select * from USER_SCHEDULER_GROUPS ; ---All scheduler object groups owned by current user
968 select * from USER_SCHEDULER_SCHEDULES ; ---Schedules belonging to the current user
969 select * from USER_SCHEDULER_REMOTE_JOBSTATE ; ---Remote state of all jobs originating from this database owned by current user
970 select * from USER_SCHEDULER_CHAINS ; ---All scheduler chains owned by the current user
971 select * from USER_SCHEDULER_CHAIN_RULES ; ---All rules from scheduler chains owned by the current user
972 select * from USER_SCHEDULER_CHAIN_STEPS ; ---All steps of scheduler chains owned by the current user
973 select * from USER_SCHEDULER_RUNNING_CHAINS ; ---All steps of chains being run by jobs owned by the current user
974 select * from USER_SCHEDULER_CREDENTIALS ; ---Scheduler credentials owned by the current user
975 select * from USER_SCHEDULER_FILE_WATCHERS ; ---Scheduler file watch requests owned by the current user
976 select * from USER_SCHEDULER_NOTIFICATIONS ; ---All e-mail notifications for jobs owned by the current user
977 select * from USER_TUNE_MVIEW ; ---tune_mview catalog view owned by the user
978 select * from USER_FLASHBACK_ARCHIVE ; ---Description of the flashback archives available to the user
979 select * from USER_FLASHBACK_ARCHIVE_TABLES ; ---Information about the user tables that are enabled for Flashback Archive
980 select * from USER_APPLY_ERROR ; ---Error transactions owned by an apply visible to the current user
981 select * from USER_FILE_GROUPS ; ---Details about file groups
982 select * from USER_FILE_GROUP_VERSIONS ; ---Details about file group versions
983 select * from USER_FILE_GROUP_EXPORT_INFO ; ---Details about export information of file group versions
984 select * from USER_FILE_GROUP_FILES ; ---Details about file group files
985 select * from USER_FILE_GROUP_TABLESPACES ; ---Details about the transportable tablespaces in the file group repository
986 select * from USER_FILE_GROUP_TABLES ; ---Details about the tables in the file group repository
987 select * from USER_GOLDENGATE_PRIVILEGES ; ---Details about goldengate privileges
988 select * from USER_COMPARISON ; ---Details about the user's comparison objects
989 select * from USER_COMPARISON_COLUMNS ; ---Details about the comparison object's columns
990 select * from USER_COMPARISON_SCAN ; ---Details about a comparison scan
991 select * from USER_COMPARISON_SCAN_SUMMARY ; ---Details about a comparison scan
992 select * from USER_COMPARISON_SCAN_VALUES ; ---Details about a comparison scan's values
993 select * from USER_COMPARISON_ROW_DIF ; ---Details about the differing rows in a comparison scan
994 select * from USER_JAVA_POLICY ; ---java security Permissions for current user
995 select * from USER_JAVA_CLASSES ; ---class level information of stored java class owned by the user
996 select * from USER_JAVA_LAYOUTS ; ---class layout information about stored java class owned by the user
997 select * from USER_JAVA_IMPLEMENTS ; ---interfaces implemented by the stored java class owned by user
998 select * from USER_JAVA_INNERS ; ---list of inner classes refered by the stored java class owned by user
999 select * from USER_JAVA_FIELDS ; ---field information of stored java class owned by the user
1000 select * from USER_JAVA_METHODS ; ---method information of stored java class owned by the user
1001 select * from USER_JAVA_ARGUMENTS ; ---argument information of stored java class owned by the user
1002 select * from USER_JAVA_THROWS ; ---list of exceptions thrown from a method of a class owned by user
1003 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
1004 select * from USER_JAVA_RESOLVERS ; ---resolver of java class owned by user
1005 select * from USER_JAVA_NCOMPS ; ---ncomp related information of java classes owned by user
1006 select * from USER_JAVA_COMPILER_OPTIONS ; ---native compiler options provided by the user
1007 select * from USER_EPG_DAD_AUTHORIZATION ; ---DADs authorized to use the user's privileges
1008 select * from USER_XML_TABLES ; ---Description of the user's own XMLType tables
1009 select * from USER_XML_TAB_COLS ; ---Description of the user's own XMLType tables
1010 select * from USER_XML_VIEWS ; ---Description of the user's own XMLType views
1011 select * from USER_XML_VIEW_COLS ; ---Description of the user's own XMLType views
1012 select * from USER_XML_SCHEMAS ; ---Description of XML Schemas registered by the user
1013 select * from USER_XML_INDEXES ; ---Description of the user's own XMLType indexes
1014 select * from USER_XDS_OBJECTS ; ---All XDS enabled objects owned by the user
1015 select * from USER_XDS_INSTANCE_SETS ; ---All instance sets for objects owned by the user
1016 select * from USER_XDS_ATTRIBUTE_SECS ; ---All objects with column security and owned by the user
1017 select * from USER_NETWORK_ACL_PRIVILEGES ; ---User privileges to access network hosts through PL/SQL network utility packages
1018 select * from USER_AW_PROP ; ---Object properties in Analytic Workspaces owned by the user
1019 select * from USER_AW_OBJ ; ---Objects in Analytic Workspaces owned by the user
1020 select * from USER_ATTRIBUTE_TRANSFORMATIONS ; ---
1021 select * from USER_ADVISOR_SQLSTATS ; ---
1022 select * from USER_PARALLEL_EXECUTE_TASKS ; ---
1023 select * from USER_ADVISOR_SQLW_STMTS ; ---
1024 select * from USER_LOB_SUBPARTITIONS ; ---
1025 select * from USER_REGISTRY ; ---
1026 select * from USER_SQLSET_BINDS ; ---
1027 select * from USER_ADVISOR_LOG ; ---
1028 select * from USER_ADVISOR_DIR_TASK_INST ; ---
1029 select * from USER_ADVISOR_SQLA_WK_MAP ; ---
1030 select * from USER_ADVISOR_OBJECTS ; ---
1031 select * from USER_ADDM_FINDINGS ; ---
1032 select * from USER_ADVISOR_SQLW_PARAMETERS ; ---
1033 select * from USER_ADVISOR_EXEC_PARAMETERS ; ---
1034 select * from USER_ADVISOR_SQLA_TABLES ; ---
1035 select * from USER_ADVISOR_SQLA_COLVOL ; ---
1036 select * from USER_ADVISOR_FINDINGS ; ---
1037 select * from USER_FLASHBACK_TXN_REPORT ; ---
1038 select * from USER_SUBPART_HISTOGRAMS ; ---
1039 select * from USER_TRANSFORMATIONS ; ---
1040 select * from USER_DBFS_HS_COMMANDS ; ---
1041 select * from USER_PART_TABLES ; ---
1042 select * from USER_ADVISOR_TEMPLATES ; ---
1043 select * from USER_SQLTUNE_PLANS ; ---
1044 select * from USER_ADVISOR_RECOMMENDATIONS ; ---
1045 select * from USER_SUBPART_COL_STATISTICS ; ---
1046 select * from USER_TS ; ---
1047 select * from USER_SQLSET_PLANS ; ---
1048 select * from USER_ADVISOR_EXECUTIONS ; ---
1049 select * from USER_PART_INDEXES ; ---
1050 select * from USER_SQLTUNE_STATISTICS ; ---
1051 select * from USER_TAB_PARTITIONS ; ---
1052 select * from USER_LOB_TEMPLATES ; ---
1053 select * from USER_ADVISOR_SQLA_WK_STMTS ; ---
1054 select * from USER_IND_SUBPARTITIONS ; ---
1055 select * from USER_ADVISOR_SQLW_COLVOL ; ---
1056 select * from USER_ADVISOR_JOURNAL ; ---
1057 select * from USER_DBFS_HS ; ---
1058 select * from USER_ADVISOR_SQLW_TEMPLATES ; ---
1059 select * from USER_PART_LOBS ; ---
1060 select * from USER_TAB_SUBPARTITIONS ; ---
1061 select * from USER_ADVISOR_TASKS ; ---
1062 select * from USER_REPCONFLICT ; ---
1063 select * from USER_PART_HISTOGRAMS ; ---
1064 select * from USER_DBFS_HS_FILES ; ---
1065 select * from USER_ADVISOR_SQLW_TABVOL ; ---
1066 select * from USER_SUBPART_KEY_COLUMNS ; ---
1067 select * from USER_ADDM_INSTANCES ; ---
1068 select * from USER_SUBPARTITION_TEMPLATES ; ---
1069 select * from USER_SQLSET ; ---
1070 select * from USER_ADVISOR_SQLA_WK_SUM ; ---
1071 select * from USER_ADDM_TASKS ; ---
1072 select * from USER_SQLSET_REFERENCES ; ---
1073 select * from USER_ADVISOR_SQLW_TABLES ; ---
1074 select * from USER_ADVISOR_SQLW_JOURNAL ; ---
1075 select * from USER_PART_COL_STATISTICS ; ---
1076 select * from USER_ADVISOR_SQLPLANS ; ---
1077 select * from USER_REPCAT ; ---
1078 select * from USER_AQ_AGENT_PRIVS ; ---
1079 select * from USER_SQLTUNE_RATIONALE_PLAN ; ---
1080 select * from USER_DBFS_HS_PROPERTIES ; ---
1081 select * from USER_FLASHBACK_TXN_STATE ; ---
1082 select * from USER_ADDM_TASK_DIRECTIVES ; ---
1083 select * from USER_IND_PARTITIONS ; ---
1084 select * from USER_DBFS_HS_FIXED_PROPERTIES ; ---
1085 select * from USER_XML_COLUMN_NAMES ; ---
1086 select * from USER_ADDM_FDG_BREAKDOWN ; ---
1087 select * from USER_ADVISOR_RATIONALE ; ---
1088 select * from USER_SQLTUNE_BINDS ; ---
1089 select * from USER_ADVISOR_SQLA_TABVOL ; ---
1090 select * from USER_ADVISOR_SQLA_REC_SUM ; ---
1091 select * from USER_PART_KEY_COLUMNS ; ---
1092 select * from USER_ADVISOR_ACTIONS ; ---
1093 select * from USER_ADVISOR_FDG_BREAKDOWN ; ---
1094 select * from USER_QUEUE_SCHEDULES ; ---
1095 select * from USER_SQLSET_STATEMENTS ; ---
1096 select * from USER_ADVISOR_PARAMETERS ; ---
1097 select * from USER_QUEUE_PUBLISHERS ; ---
1098 select * from USER_PARALLEL_EXECUTE_CHUNKS ; ---
1099 select * from USER_LOB_PARTITIONS ; ---
1100 select * from USER_ADVISOR_SQLW_SUM ; ---
1101 select * from ALL_CONS_COLUMNS ; ---Information about accessible columns in constraint definitions
1102 select * from ALL_LOG_GROUP_COLUMNS ; ---Information about columns in log group definitions
1103 select * from ALL_LOBS ; ---Description of LOBs contained in tables accessible to the user
1104 select * from ALL_CATALOG ; ---All tables, views, synonyms, sequences accessible to the user
1105 select * from ALL_CLUSTERS ; ---Description of clusters accessible to the user
1106 select * from ALL_COL_COMMENTS ; ---Comments on columns of accessible tables and views
1107 "select * from ALL_COL_PRIVS ; ---Grants on columns for which the user is the grantor, grantee, owner,
1108  or an enabled role or PUBLIC is the grantee"
1109 select * from ALL_COL_PRIVS_MADE ; ---Grants on columns for which the user is owner or grantor
1110 select * from ALL_COL_PRIVS_RECD ; ---Grants on columns for which the user, PUBLIC or enabled role is the grantee
1111 select * from ALL_ENCRYPTED_COLUMNS ; ---Encryption information on all accessible columns
1112 select * from ALL_INDEXES ; ---Descriptions of indexes on tables accessible to the user
1113 select * from ALL_IND_COLUMNS ; ---COLUMNs comprising INDEXes on accessible TABLES
1114 select * from ALL_IND_EXPRESSIONS ; ---FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES
1115 select * from ALL_JOIN_IND_COLUMNS ; ---Join Index columns comprising the join conditions
1116 select * from ALL_OBJECTS ; ---Objects accessible to the user
1117 select * from ALL_OBJECTS_AE ; ---Objects accessible to the user
1118 select * from ALL_SEQUENCES ; ---Description of SEQUENCEs accessible to the user
1119 select * from ALL_SYNONYMS ; ---All synonyms for base objects accessible to the user and session
1120 select * from ALL_TABLES ; ---Description of relational tables accessible to the user
1121 select * from ALL_OBJECT_TABLES ; ---Description of all object tables accessible to the user
1122 select * from ALL_ALL_TABLES ; ---Description of all object and relational tables accessible to the user
1123 select * from ALL_TAB_COLS ; ---Columns of user's tables, views and clusters
1124 select * from ALL_TAB_COLUMNS ; ---Columns of user's tables, views and clusters
1125 select * from ALL_TAB_COMMENTS ; ---Comments on tables and views accessible to the user
1126 "select * from ALL_TAB_PRIVS ; ---Grants on objects for which the user is the grantor, grantee, owner,
1127  or an enabled role or PUBLIC is the grantee"
1128 select * from ALL_TAB_PRIVS_MADE ; ---User's grants and grants on user's objects
1129 select * from ALL_TAB_PRIVS_RECD ; ---Grants on objects for which the user, PUBLIC or enabled role is the grantee
1130 select * from ALL_VIEWS ; ---Description of views accessible to the user
1131 select * from ALL_VIEWS_AE ; ---Description of views accessible to the user
1132 select * from ALL_CONSTRAINTS ; ---Constraint definitions on accessible tables
1133 select * from ALL_LOG_GROUPS ; ---Log group definitions on accessible tables
1134 select * from ALL_CLUSTER_HASH_EXPRESSIONS ; ---Hash functions for all accessible clusters
1135 select * from ALL_UPDATABLE_COLUMNS ; ---Description of all updatable columns
1136 select * from ALL_UNUSED_COL_TABS ; ---All tables with unused columns accessible to the user
1137 select * from ALL_PARTIAL_DROP_TABS ; ---All tables with patially dropped columns accessible to the user
1138 select * from ALL_EDITIONING_VIEWS ; ---Description of Editioning Views accessible to the user
1139 select * from ALL_EDITIONING_VIEWS_AE ; ---Description of Editioning Views accessible to the user
1140 select * from ALL_EDITIONING_VIEW_COLS ; ---Relationship between columns of Editioning Views accessible to the user and the table columns to which they map
1141 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
1142 select * from ALL_EDITIONS ; ---Describes all editions in the database
1143 select * from ALL_EDITION_COMMENTS ; ---Describes comments on all editions in the database
1144 select * from ALL_LIBRARIES ; ---Description of libraries accessible to the user
1145 select * from ALL_PROCEDURES ; ---Functions/procedures/packages/types/triggers available to the user
1146 select * from ALL_STORED_SETTINGS ; ---Parameter settings for objects accessible to the user
1147 select * from ALL_PLSQL_OBJECT_SETTINGS ; ---Compiler settings of stored objects accessible to the user
1148 select * from ALL_ARGUMENTS ; ---Arguments in object accessible to the user
1149 select * from ALL_ASSEMBLIES ; ---Description of assemblies accessible to the user
1150 select * from ALL_IDENTIFIERS ; ---All identifiers in stored objects accessible to the user
1151 select * from ALL_DB_LINKS ; ---Database links accessible to the user
1152 select * from ALL_USERS ; ---Information about all users of the database
1153 select * from ALL_DEF_AUDIT_OPTS ; ---Auditing options for newly created objects
1154 select * from ALL_TYPES ; ---Description of types accessible to the user
1155 select * from ALL_COLL_TYPES ; ---Description of named collection types accessible to the user
1156 select * from ALL_TYPE_ATTRS ; ---Description of attributes of types accessible to the user
1157 select * from ALL_TYPE_METHODS ; ---Description of methods of types accessible to the user
1158 "select * from ALL_METHOD_PARAMS ; ---Description of method parameters of types accessible
1159 to the user"
1160 "select * from ALL_METHOD_RESULTS ; ---Description of method results of types accessible
1161 to the user"
1162 select * from ALL_SQLJ_TYPES ; ---Description of types accessible to the user
1163 select * from ALL_TYPE_VERSIONS ; ---Description of each type version accessible to the user
1164 select * from ALL_PENDING_CONV_TABLES ; ---All tables accessible to the user which are not upgraded to the latest type version
1165 select * from ALL_SQLJ_TYPE_ATTRS ; ---Description of attributes of types accessible to the user
1166 select * from ALL_SQLJ_TYPE_METHODS ; ---Description of methods of types accessible to the user
1167 select * from ALL_NESTED_TABLE_COLS ; ---Columns of nested tables
1168 select * from ALL_DIRECTORIES ; ---Description of all directories accessible to the user
1169 select * from ALL_REFS ; ---Description of REF columns contained in tables accessible to the user
1170 select * from ALL_NESTED_TABLES ; ---Description of nested tables in tables accessible to the user
1171 select * from ALL_VARRAYS ; ---Description of varrays in tables accessible to the user
1172 select * from ALL_OBJ_COLATTRS ; ---Description of object columns and attributes contained in the tables accessible to the user
1173 select * from ALL_CONS_OBJ_COLUMNS ; ---List of types an object column or attribute is constrained to in the tables accessible to the user
1174 select * from ALL_OPERATORS ; ---All operators available to the user
1175 select * from ALL_OPBINDINGS ; ---All binding functions for operators available to the user
1176 select * from ALL_OPANCILLARY ; ---All ancillary operators available to the user
1177 select * from ALL_OPARGUMENTS ; ---All arguments of the operators available to the user
1178 select * from ALL_OPERATOR_COMMENTS ; ---Comments for user-defined operators
1179 select * from ALL_INDEXTYPES ; ---All indextypes available to the user
1180 select * from ALL_INDEXTYPE_COMMENTS ; ---Comments for user-defined indextypes
1181 select * from ALL_INDEXTYPE_ARRAYTYPES ; ---All array types specified by the indextype
1182 select * from ALL_INDEXTYPE_OPERATORS ; ---All operators available to the user
1183 select * from ALL_SECONDARY_OBJECTS ; ---All secondary objects for domain indexes
1184 select * from ALL_CHANGE_SOURCES ; ---Change Data Capture change sources
1185 select * from ALL_CHANGE_SETS ; ---Change Data Capture change sets
1186 select * from ALL_CHANGE_TABLES ; ---Change Data Capture change tables
1187 select * from ALL_CHANGE_PROPAGATIONS ; ---Change Data Capture propagations 
1188 select * from ALL_CHANGE_PROPAGATION_SETS ; ---Change Data Capture propagated change set
1189 select * from ALL_SUMDELTA ; ---Direct path load entries accessible to the user
1190 select * from ALL_SUMMAP ; ---mapping entries of transaction ID and commit SCN accessible to the user
1191 select * from ALL_EXTERNAL_TABLES ; ---Description of the external tables accessible to the user
1192 select * from ALL_EXTERNAL_LOCATIONS ; ---Description of the external tables locations accessible to the user
1193 select * from ALL_MINING_MODELS ; ---Description of the models accessible to the user
1194 select * from ALL_MINING_MODEL_ATTRIBUTES ; ---Description of all the model attributes accessible to the user
1195 select * from ALL_MINING_MODEL_SETTINGS ; ---Description of all the settings accessible to the user
1196 select * from ALL_TAB_COL_STATISTICS ; ---Columns of user's tables, views and clusters
1197 select * from ALL_TAB_HISTOGRAMS ; ---Histograms on columns of all tables visible to user
1198 select * from ALL_ASSOCIATIONS ; ---All associations available to the user
1199 select * from ALL_USTATS ; ---All statistics
1200 select * from ALL_TAB_MODIFICATIONS ; ---Information regarding modifications to tables
1201 select * from ALL_TAB_STATS_HISTORY ; ---History of table statistics modifications
1202 select * from ALL_TAB_STAT_PREFS ; ---Statistics preferences for tables
1203 select * from ALL_TAB_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
1204 select * from ALL_IND_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
1205 select * from ALL_COL_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
1206 select * from ALL_TAB_HISTGRM_PENDING_STATS ; ---Pending statistics of tables, partitions, and subpartitions
1207 select * from ALL_DIMENSIONS ; ---Description of the dimension objects accessible to the DBA
1208 select * from ALL_DIM_LEVELS ; ---Description of dimension levels visible to DBA
1209 select * from ALL_DIM_LEVEL_KEY ; ---Representations of columns of a dimension level
1210 "select * from ALL_DIM_ATTRIBUTES ; ---Representation of the relationship between a dimension level and
1211  a functionally dependent column"
1212 select * from ALL_DIM_HIERARCHIES ; ---Representation of a dimension hierarchy
1213 "select * from ALL_DIM_CHILD_OF ; ---Representaion of a 1:n hierarchical relationship between a pair of levels in
1214  a dimension"
1215 select * from ALL_DIM_JOIN_KEY ; ---Representation of a join between two dimension tables. 
1216 select * from ALL_SUMMARIES ; ---Description of the summaries accessible to the user
1217 select * from ALL_MVIEW_ANALYSIS ; ---Description of the materialized views accessible to the user
1218 select * from ALL_MVIEW_AGGREGATES ; ---Description of the materialized view aggregates accessible to the user
1219 select * from ALL_MVIEW_DETAIL_RELATIONS ; ---Description of the materialized view detail tables accessible to the user
1220 "select * from ALL_MVIEW_KEYS ; ---Description of the columns that appear in the GROUP BY
1221 list of a materialized view accessible to the user"
1222 "select * from ALL_MVIEW_JOINS ; ---Description of a join between two columns in the
1223 WHERE clause of a materialized view accessible to the user"
1224 select * from ALL_MVIEW_COMMENTS ; ---Comments on materialized views accessible to the user
1225 "select * from ALL_REFRESH_DEPENDENCIES ; ---Description of the detail tables that materialized views depend on for
1226 refresh"
1227 select * from ALL_REWRITE_EQUIVALENCES ; ---Description of all rewrite equivalence accessible to the user
1228 select * from ALL_MVIEW_DETAIL_PARTITION ; ---Freshness information of all PCT materialized views in the database
1229 select * from ALL_MVIEW_DETAIL_SUBPARTITION ; ---Freshness information of all PCT materialized views in the database
1230 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
1231 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
1232 select * from ALL_ERRORS ; ---Current errors on stored objects that user is allowed to create
1233 select * from ALL_ERRORS_AE ; ---Current errors on stored objects that user is allowed to create
1234 select * from ALL_SOURCE_AE ; ---Current source on stored objects that user is allowed to create
1235 select * from ALL_SOURCE ; ---Current source on stored objects that user is allowed to create
1236 select * from ALL_TRIGGERS ; ---Triggers accessible to the current user
1237 select * from ALL_INTERNAL_TRIGGERS ; ---Description of the internal triggers on the tables accessible to the user
1238 select * from ALL_TRIGGER_COLS ; ---Column usage in user's triggers or in triggers on user's tables
1239 select * from ALL_DEPENDENCIES ; ---Dependencies to and from objects accessible to the user
1240 select * from ALL_TRIGGER_ORDERING ; ---Triggers having FOLLOWS or PRECEDES ordering accessible to the current user
1241 select * from ALL_CONTEXT ; ---Description of all active context namespaces under the current session
1242 select * from ALL_RULE_SETS ; ---Rule sets seen by the user
1243 select * from ALL_RULESETS ; ---Rulesets seen by the user: maintained for backward compatibility
1244 select * from ALL_RULES ; ---Rules seen by the user
1245 select * from ALL_RULE_SET_RULES ; ---Rules in all rule sets seen by the user
1246 select * from ALL_EVALUATION_CONTEXTS ; ---rule evaluation contexts seen by user
1247 select * from ALL_EVALUATION_CONTEXT_TABLES ; ---tables in all rule evaluation contexts seen by the user
1248 select * from ALL_EVALUATION_CONTEXT_VARS ; ---variables in all rule evaluation contexts seen by the user
1249 select * from ALL_SNAPSHOTS ; ---Snapshots the user can access
1250 select * from ALL_SNAPSHOT_LOGS ; ---All snapshot logs in the database that the user can see
1251 select * from ALL_REFRESH ; ---All the refresh groups that the user can touch
1252 select * from ALL_REFRESH_CHILDREN ; ---All the objects in refresh groups, where the user can touch the group
1253 select * from ALL_REGISTERED_SNAPSHOTS ; ---Remote snapshots of local tables that the user can see
1254 select * from ALL_MVIEWS ; ---All materialized views in the database
1255 select * from ALL_MVIEW_REFRESH_TIMES ; ---Materialized views and their last refresh times  for each master table that the user can look at
1256 select * from ALL_MVIEW_LOGS ; ---All materialized view logs in the database that the user can see
1257 select * from ALL_BASE_TABLE_MVIEWS ; ---All materialized views with log(s) in the database that the user can see
1258 select * from ALL_REGISTERED_MVIEWS ; ---Remote materialized views of local tables that the user can see
1259 select * from ALL_POLICIES ; ---All policies for objects if the user has system privileges or owns the objects
1260 select * from ALL_POLICY_GROUPS ; ---All policy groups defined for any synonym, table or view accessable to the user
1261 select * from ALL_POLICY_CONTEXTS ; ---All policy driving context defined for all synonyms, tables, or views accessable to the user
1262 select * from ALL_SEC_RELEVANT_COLS ; ---Security Relevant columns of all VPD policies for tables or views which the user has access
1263 select * from ALL_AUDIT_POLICIES ; ---All fine grained auditing policies in the database
1264 select * from ALL_AUDIT_POLICY_COLUMNS ; ---All fine grained auditing policy columns in the database
1265 select * from ALL_QUEUE_TABLES ; ---All queue tables accessible to the user
1266 select * from ALL_QUEUES ; ---All queues accessible to the user
1267 select * from ALL_DEQUEUE_QUEUES ; ---All queues accessible to the user
1268 select * from ALL_INT_DEQUEUE_QUEUES ; ---All queues accessible to the user
1269 select * from ALL_REPGROUP_PRIVILEGES ; ---Information about users who are registered for object group privileges
1270 select * from ALL_REPGROUP ; ---Information about replicated object groups
1271 select * from ALL_REPSITES ; ---N-way replication information
1272 select * from ALL_REPSCHEMA ; ---N-way replication information
1273 select * from ALL_REPOBJECT ; ---Information about replicated objects
1274 select * from ALL_REPCOLUMN ; ---Replicated top-level columns (table) sorted alphabetically in ascending order
1275 select * from ALL_REPPROP ; ---Propagation information about replicated objects
1276 select * from ALL_REPKEY_COLUMNS ; ---Primary columns for a table using column-level replication
1277 select * from ALL_REPGENOBJECTS ; ---Objects generated to support replication
1278 select * from ALL_REPGENERATED ; ---Objects generated to support replication
1279 select * from ALL_REPCATLOG ; ---Information about asynchronous administration requests
1280 select * from ALL_REPDDL ; ---Arguments that do not fit in a single repcat log record
1281 select * from ALL_REPPRIORITY_GROUP ; ---Information about all priority groups which are accessible to the user
1282 select * from ALL_REPPRIORITY ; ---Values and their corresponding priorities in all priority groups which are accessible to the user
1283 select * from ALL_REPCOLUMN_GROUP ; ---All column groups of replicated tables which are accessible to the user
1284 select * from ALL_REPGROUPED_COLUMN ; ---Columns in the all column groups of replicated tables which are accessible to the user
1285 select * from ALL_REPCONFLICT ; ---All conflicts with available resolutions for user's replicated tables
1286 select * from ALL_REPRESOLUTION_METHOD ; ---All conflict resolution methods accessible to the user
1287 select * from ALL_REPRESOLUTION ; ---Description of all conflict resolutions for replicated tables which are accessible to the user
1288 select * from ALL_REPRESOLUTION_STATISTICS ; ---Statistics for conflict resolutions for replicated tables which are accessible to the user
1289 select * from ALL_REPRESOL_STATS_CONTROL ; ---Information about statistics collection for conflict resolutions for replicated tables which are accessible to the user
1290 select * from ALL_REPPARAMETER_COLUMN ; ---All columns used for resolving conflicts in replicated tables which are accessible to the user
1291 select * from ALL_REPAUDIT_ATTRIBUTE ; ---Information about attributes automatically maintained for replication
1292 select * from ALL_REPAUDIT_COLUMN ; ---Information about columns in all shadow tables for replicated tables which are accessible to the user
1293 select * from ALL_REPFLAVORS ; ---Flavors defined for replicated object groups
1294 select * from ALL_REPFLAVOR_OBJECTS ; ---Replicated objects in flavors
1295 select * from ALL_REPFLAVOR_COLUMNS ; ---Replicated columns in flavors
1296 select * from ALL_WARNING_SETTINGS ; ---Warnings ettings for objects accessible to the user
1297 select * from ALL_STAT_EXTENSIONS ; ---Optimizer statistics extensions
1298 select * from ALL_TAB_STATISTICS ; ---Optimizer statistics for all tables accessible to the user
1299 select * from ALL_IND_STATISTICS ; ---Optimizer statistics for all indexes on tables accessible to the user
1300 select * from ALL_AWS ; ---Analytic Workspaces accessible to the user
1301 select * from ALL_AW_PS ; ---Pagespaces in Analytic Workspaces accessible to the user
1302 select * from ALL_CUBES ; ---OLAP Cubes in the database accessible to the user
1303 select * from ALL_CUBE_DIMENSIONALITY ; ---OLAP Cube Dimensionality in the database accessible to the user
1304 select * from ALL_CUBE_MEASURES ; ---OLAP Measures in the database accessible to the user
1305 select * from ALL_CUBE_DIMENSIONS ; ---OLAP Cube Dimensions in the database accessible by the user
1306 select * from ALL_CUBE_HIERARCHIES ; ---OLAP Hierarchies in the database accessible by the user
1307 select * from ALL_CUBE_HIER_LEVELS ; ---OLAP Hierarchy Levels in the database accessible to the user
1308 select * from ALL_CUBE_DIM_LEVELS ; ---OLAP Dimension Levels in the database accessible by the user
1309 select * from ALL_CUBE_ATTRIBUTES ; ---OLAP Attributes in the database accessible by the user
1310 select * from ALL_CUBE_ATTR_VISIBILITY ; ---OLAP Attributes visible for Dimensions, Hierarchies, and Levels
1311 select * from ALL_CUBE_DIM_MODELS ; ---OLAP Dimension Models in the database accessible to the user
1312 select * from ALL_CUBE_CALCULATED_MEMBERS ; ---OLAP Calculated Members in the database accessible to the user
1313 select * from ALL_CUBE_VIEWS ; ---OLAP Cube Views in the database accessible by the user
1314 select * from ALL_CUBE_VIEW_COLUMNS ; ---OLAP Cube View Columns in the database accessible by the user
1315 select * from ALL_CUBE_DIM_VIEWS ; ---OLAP Dimension Views in the database accessible by the user
1316 select * from ALL_CUBE_DIM_VIEW_COLUMNS ; ---OLAP Dimesion View Columns in the database accessible to the user
1317 select * from ALL_CUBE_HIER_VIEWS ; ---OLAP Hierarchy Views in the database accessible to the user
1318 select * from ALL_CUBE_HIER_VIEW_COLUMNS ; ---OLAP Hierarchy View Columns in the database accessible to the user
1319 select * from ALL_MEASURE_FOLDERS ; ---OLAP Measure Folders in the database accessible to the user
1320 select * from ALL_MEASURE_FOLDER_CONTENTS ; ---OLAP Measure Folder Contents in the database accessible by the user
1321 select * from ALL_CUBE_BUILD_PROCESSES ; ---OLAP Build Processes in the database accessible to the user
1322 select * from ALL_QUEUE_SUBSCRIBERS ; ---All queue subscribers accessible to user
1323 select * from ALL_SCHEDULER_PROGRAMS ; ---All scheduler programs visible to the user
1324 select * from ALL_SCHEDULER_DESTS ; ---All destination objects for jobs in the database visible to current user
1325 select * from ALL_SCHEDULER_EXTERNAL_DESTS ; ---User-visible destination objects in the database pointing to remote agents
1326 select * from ALL_SCHEDULER_DB_DESTS ; ---User-visible destination objects in the database pointing to remote databases
1327 select * from ALL_SCHEDULER_JOB_DESTS ; ---State of all jobs visible to current user at each of their destinations
1328 select * from ALL_SCHEDULER_JOBS ; ---All scheduler jobs visible to the user
1329 select * from ALL_SCHEDULER_JOB_CLASSES ; ---All scheduler classes visible to the user
1330 select * from ALL_SCHEDULER_WINDOWS ; ---All scheduler windows in the database
1331 select * from ALL_SCHEDULER_PROGRAM_ARGS ; ---All arguments of all scheduler programs visible to the user
1332 select * from ALL_SCHEDULER_JOB_ARGS ; ---All arguments with set values of all scheduler jobs in the database
1333 select * from ALL_SCHEDULER_JOB_LOG ; ---Logged information for all scheduler jobs
1334 select * from ALL_SCHEDULER_JOB_RUN_DETAILS ; ---The details of a job run
1335 select * from ALL_SCHEDULER_WINDOW_LOG ; ---Logged information for all scheduler windows
1336 select * from ALL_SCHEDULER_WINDOW_DETAILS ; ---The details of a window
1337 select * from ALL_SCHEDULER_WINDOW_GROUPS ; ---All scheduler window groups in the database
1338 select * from ALL_SCHEDULER_WINGROUP_MEMBERS ; ---Members of all scheduler window groups in the database
1339 select * from ALL_SCHEDULER_GROUP_MEMBERS ; ---Members of all scheduler object groups visible to current user
1340 select * from ALL_SCHEDULER_GROUPS ; ---All scheduler object groups visible to current user
1341 select * from ALL_SCHEDULER_SCHEDULES ; ---All schedules in the database
1342 select * from ALL_SCHEDULER_REMOTE_JOBSTATE ; ---Remote state of all jobs originating from this database visible to current user
1343 select * from ALL_SCHEDULER_GLOBAL_ATTRIBUTE ; ---All scheduler global attributes
1344 select * from ALL_SCHEDULER_CHAINS ; ---All scheduler chains in the database visible to current user
1345 select * from ALL_SCHEDULER_CHAIN_RULES ; ---All rules from scheduler chains visible to the current user
1346 select * from ALL_SCHEDULER_CHAIN_STEPS ; ---All steps of scheduler chains visible to the current user
1347 select * from ALL_SCHEDULER_RUNNING_CHAINS ; ---All job steps of running job chains visible to the user
1348 select * from ALL_SCHEDULER_CREDENTIALS ; ---All scheduler credentials visible to the user
1349 select * from ALL_SCHEDULER_FILE_WATCHERS ; ---Scheduler file watch requests visible to the current user
1350 select * from ALL_SCHEDULER_NOTIFICATIONS ; ---All job e-mail notifications visible to the current user
1351 select * from ALL_CAPTURE ; ---Details about each capture process that stores the captured changes in a queue visible to the current user
1352 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
1353 select * from ALL_CAPTURE_PREPARED_DATABASE ; ---Is the local database prepared for instantiation?
1354 select * from ALL_CAPTURE_PREPARED_SCHEMAS ; ---All user schemas at the local database that are prepared for instantiation
1355 select * from ALL_CAPTURE_PREPARED_TABLES ; ---All tables visible to the current user that are prepared for instantiation
1356 select * from ALL_SYNC_CAPTURE_PREPARED_TABS ; ---All tables prepared for synchronous capture instantiation
1357 select * from ALL_CAPTURE_EXTRA_ATTRIBUTES ; ---Extra attributes for a capture process that is visible to the current user
1358 select * from ALL_SYNC_CAPTURE ; ---Details about each sync capture process that stores the captured changes in a queue visible to the current user
1359 select * from ALL_APPLY ; ---Details about each apply process that dequeues from the queue visible to the current user
1360 select * from ALL_APPLY_PARAMETERS ; ---Details about parameters of each apply process that dequeues from the queue visible to the current user
1361 select * from ALL_APPLY_INSTANTIATED_OBJECTS ; ---Details about objects instantiated for the user
1362 select * from ALL_APPLY_INSTANTIATED_SCHEMAS ; ---Details about schemas instantiated for the user
1363 select * from ALL_APPLY_INSTANTIATED_GLOBAL ; ---Details about database instantiated for the user
1364 select * from ALL_APPLY_KEY_COLUMNS ; ---Alternative key columns for a STREAMS table visible to the current user
1365 select * from ALL_APPLY_CONFLICT_COLUMNS ; ---Details about conflict resolution on tables visible to the current user
1366 select * from ALL_APPLY_TABLE_COLUMNS ; ---Details about the columns of destination table object visible to the user
1367 select * from ALL_APPLY_DML_HANDLERS ; ---Details about the dml handler on tables visible to the current user
1368 select * from ALL_APPLY_PROGRESS ; ---Information about the progress made by the apply process that dequeues from the queue visible to the current user
1369 select * from ALL_APPLY_ERROR ; ---Error transactions that were generated after dequeuing from the queue visible to the current user
1370 select * from ALL_APPLY_ERROR_MESSAGES ; ---Details about individual messages in an error transaction
1371 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
1372 select * from ALL_APPLY_EXECUTE ; ---Details about the apply execute action for all rules visible to the user
1373 select * from ALL_APPLY_SPILL_TXN ; ---Streams apply spilled transactions info to the user
1374 select * from ALL_XSTREAM_OUTBOUND ; ---Details about the XStream outbound server visible to user
1375 select * from ALL_XSTREAM_INBOUND ; ---Details about the XStream inbound server visible to user
1376 select * from ALL_APPLY_CHANGE_HANDLERS ; ---Details about apply change handler
1377 select * from ALL_APPLY_DML_CONF_HANDLERS ; ---Details about dml conflict handlers on objects visible to the current user
1378 select * from ALL_APPLY_DML_CONF_COLUMNS ; ---Details about dml conflict handler column groups on objects visible to the current user
1379 select * from ALL_APPLY_HANDLE_COLLISIONS ; ---Details about apply collision handlers on objects visible to the user
1380 select * from ALL_APPLY_REPERROR_HANDLERS ; ---Details about apply reperror handlers on objects visible to the user
1381 select * from ALL_PROPAGATION ; ---Streams propagation seen by the user
1382 select * from ALL_FILE_GROUPS ; ---Details about file groups
1383 select * from ALL_FILE_GROUP_VERSIONS ; ---Details about file group versions
1384 select * from ALL_FILE_GROUP_EXPORT_INFO ; ---Details about export information of file group versions
1385 select * from ALL_FILE_GROUP_FILES ; ---Details about file group files
1386 select * from ALL_FILE_GROUP_TABLESPACES ; ---Details about the transportable tablespaces in the file group repository
1387 select * from ALL_FILE_GROUP_TABLES ; ---Details about the tables in the file group repository
1388 select * from ALL_STREAMS_MESSAGE_CONSUMERS ; ---Streams messaging consumers visible to the current user
1389 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
1390 select * from ALL_STREAMS_SCHEMA_RULES ; ---Rules created by streams administrative APIs on all user schemas
1391 select * from ALL_STREAMS_TABLE_RULES ; ---Rules created by streams administrative APIs on tables visible to the current user
1392 select * from ALL_STREAMS_MESSAGE_RULES ; ---Rules for Streams messaging visible to the current user
1393 select * from ALL_STREAMS_RULES ; ---Rules used by streams processes
1394 select * from ALL_SYNC_CAPTURE_TABLES ; ---All tables that are captured by synchronous streams captures.
1395 select * from ALL_XSTREAM_RULES ; ---Details about the XStream server rules visible to user
1396 select * from ALL_STREAMS_TRANSFORM_FUNCTION ; ---Rules-based transform functions used by Streams
1397 select * from ALL_XSTREAM_ADMINISTRATOR ; ---Users granted the privileges to be a XStream administrator for the user
1398 select * from ALL_STREAMS_TRANSFORMATIONS ; ---Transformations defined on rules for the user
1399 select * from ALL_STREAMS_KEEP_COLUMNS ; ---Keep columns transformations for the user
1400 select * from ALL_GOLDENGATE_PRIVILEGES ; ---Details about goldengate privileges for the user
1401 select * from ALL_COMPARISON_SCAN_SUMMARY ; ---Details about a comparison scan for the user
1402 select * from ALL_STREAMS_COLUMNS ; ---Streams unsupported columns
1403 select * from ALL_STREAMS_UNSUPPORTED ; ---List of all the tables that are not supported by Streams in this release
1404 select * from ALL_STREAMS_NEWLY_SUPPORTED ; ---List of objects that are newly supported by Streams
1405 select * from ALL_XSTREAM_OUT_SUPPORT_MODE ; ---List of support mode for objects by XStream Out
1406 select * from ALL_JAVA_CLASSES ; ---class level information of stored java class accessible to the user
1407 select * from ALL_JAVA_LAYOUTS ; ---class layout information about stored java class accessible to the user
1408 select * from ALL_JAVA_IMPLEMENTS ; ---interfaces implemented by the stored java class accessible to the user
1409 select * from ALL_JAVA_INNERS ; ---list of inner classes refered by the stored java class accessible to user
1410 select * from ALL_JAVA_FIELDS ; ---field information of stored java class accessible to user
1411 select * from ALL_JAVA_METHODS ; ---method information of stored java class accessible to user
1412 select * from ALL_JAVA_ARGUMENTS ; ---argument information of stored java class accessible to the user
1413 select * from ALL_JAVA_THROWS ; ---list of exceptions thrown from a method of a class accessible to user
1414 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
1415 select * from ALL_JAVA_RESOLVERS ; ---resolver of java class owned by user
1416 select * from ALL_JAVA_NCOMPS ; ---ncomp related information of all java classes
1417 select * from ALL_JAVA_COMPILER_OPTIONS ; ---native-compiler options applicable to user
1418 select * from ALL_XML_TABLES ; ---Description of the all XMLType tables that the user has privileges on
1419 select * from ALL_XML_TAB_COLS ; ---Description of the all XMLType tables that the user has privileges on
1420 select * from ALL_XML_VIEWS ; ---Description of the all XMLType views that the user has privileges on
1421 select * from ALL_XML_VIEW_COLS ; ---Description of the all XMLType views that the user has privileges on
1422 select * from ALL_XML_SCHEMAS ; ---Description of all XML Schemas that user has privilege to reference
1423 select * from ALL_XML_SCHEMAS2 ; ---Dummy version of ALL_XML_SCHEMAS that does not have an XMLTYPE column
1424 select * from ALL_XML_INDEXES ; ---Description of the all XMLType indexes that the user has privileges on
1425 select * from ALL_XDS_OBJECTS ; ---All XDS enabled objects accessible to the user
1426 select * from ALL_XDS_INSTANCE_SETS ; ---All instance sets for objects accessible to the user in the database
1427 select * from ALL_XDS_ATTRIBUTE_SECS ; ---All objects with XDS column security and accessible to the user
1428 select * from ALL_XSC_SECURITY_CLASS ; ---All security class definitions in the database
1429 select * from ALL_XSC_SECURITY_CLASS_STATUS ; ---Security class "enable" and "mutable" status
1430 select * from ALL_XSC_SECURITY_CLASS_DEP ; ---All security class dependencies in the database
1431 select * from ALL_XSC_PRIVILEGE ; ---All mappings of privileges to security classes in the database
1432 select * from ALL_XSC_AGGREGATE_PRIVILEGE ; ---All privileges that make up an aggregate privilege in the database
1433 select * from ALL_AW_PROP ; ---Object properties in Analytic Workspaces accessible to the user
1434 select * from ALL_AW_OBJ ; ---Objects in Analytic Workspaces accessible to the user
1435 select * from ALL_AW_PROP_NAME ; ---Analytic Workspace property names accessible to the user
1436 select * from ALL_AW_AC ; ---Active Catalog Analytic Workspaces accessible to the user
1437 select * from ALL_PART_LOBS ; ---
1438 select * from ALL_IND_PARTITIONS ; ---
1439 select * from ALL_QUEUE_SCHEDULES ; ---
1440 select * from ALL_PROBE_OBJECTS ; ---
1441 select * from ALL_PART_KEY_COLUMNS ; ---
1442 select * from ALL_SUBPARTITION_TEMPLATES ; ---
1443 select * from ALL_REPCAT ; ---
1444 select * from ALL_PART_INDEXES ; ---
1445 select * from ALL_SUBPART_KEY_COLUMNS ; ---
1446 select * from ALL_QUEUE_PUBLISHERS ; ---
1447 select * from ALL_AW_AC_10G ; ---
1448 select * from ALL_SUBPART_HISTOGRAMS ; ---
1449 select * from ALL_LOB_PARTITIONS ; ---
1450 select * from ALL_SUBPART_COL_STATISTICS ; ---
1451 select * from ALL_SQLSET_PLANS ; ---
1452 select * from ALL_SQLSET_REFERENCES ; ---
1453 select * from ALL_PART_HISTOGRAMS ; ---
1454 select * from ALL_LOB_TEMPLATES ; ---
1455 select * from ALL_TAB_SUBPARTITIONS ; ---
1456 select * from ALL_TRANSFORMATIONS ; ---
1457 select * from ALL_SCHEDULER_REMOTE_DATABASES ; ---
1458 select * from ALL$OLAP2_AWS ; ---
1459 select * from ALL_SQLSET_BINDS ; ---
1460 select * from ALL_TAB_PARTITIONS ; ---
1461 select * from ALL_PART_TABLES ; ---
1462 select * from ALL_PART_COL_STATISTICS ; ---
1463 select * from ALL_SQLSET_STATEMENTS ; ---
1464 select * from ALL_REGISTRY_BANNERS ; ---
1465 select * from ALL_LOB_SUBPARTITIONS ; ---
1466 select * from ALL_IND_SUBPARTITIONS ; ---
1467 select * from ALL_SQLSET ; ---
1468 select * from ALL_SERVICES ; ---
1469 select * from ALL_ATTRIBUTE_TRANSFORMATIONS ; ---
1470 select * from AUDIT_ACTIONS ; ---Description table for audit trail action type codes.  Maps action type numbers to action type names
1471 "select * from COLUMN_PRIVILEGES ; ---Grants on columns for which the user is the grantor, grantee, owner, or
1472  an enabled role or PUBLIC is the grantee"
1473 select * from DATABASE_COMPATIBLE_LEVEL ; ---Database compatible parameter set via init.ora
1474 select * from DBMS_ALERT_INFO ; ---
1475 select * from DBMS_LOCK_ALLOCATED ; ---
1476 select * from DICTIONARY ; ---Description of data dictionary tables and views
1477 select * from DICT_COLUMNS ; ---Description of columns in data dictionary tables and views
1478 select * from DUAL ; ---
1479 select * from GLOBAL_NAME ; ---global database name
1480 select * from INDEX_HISTOGRAM ; ---statistics on keys with repeat count
1481 select * from INDEX_STATS ; ---statistics on the b-tree
1482 select * from NLS_DATABASE_PARAMETERS ; ---Permanent NLS parameters of the database
1483 select * from NLS_INSTANCE_PARAMETERS ; ---NLS parameters of the instance
1484 select * from NLS_SESSION_PARAMETERS ; ---NLS parameters of the user session
1485 select * from RESOURCE_COST ; ---Cost for each resource
1486 select * from ROLE_ROLE_PRIVS ; ---Roles which are granted to roles
1487 select * from ROLE_SYS_PRIVS ; ---System privileges granted to roles
1488 select * from ROLE_TAB_PRIVS ; ---Table privileges granted to roles
1489 select * from SESSION_PRIVS ; ---Privileges which the user currently has set
1490 select * from SESSION_ROLES ; ---Roles which the user currently has enabled.
1491 "select * from TABLE_PRIVILEGES ; ---Grants on objects for which the user is the grantor, grantee, owner,
1492  or an enabled role or PUBLIC is the grantee"
1493 select * from V$ACCESS ; ---Synonym for V_$ACCESS
1494 select * from V$ACTIVE_INSTANCES ; ---Synonym for V_$ACTIVE_INSTANCES
1495 select * from V$ACTIVE_SERVICES ; ---Synonym for V_$ACTIVE_SERVICES
1496 select * from V$ACTIVE_SESSION_HISTORY ; ---Synonym for V_$ACTIVE_SESSION_HISTORY
1497 select * from V$ACTIVE_SESS_POOL_MTH ; ---Synonym for V_$ACTIVE_SESS_POOL_MTH
1498 select * from V$ADVISOR_CURRENT_SQLPLAN ; ---Synonym for V_$ADVISOR_CURRENT_SQLPLAN
1499 select * from V$ADVISOR_PROGRESS ; ---Synonym for V_$ADVISOR_PROGRESS
1500 select * from V$ALERT_TYPES ; ---Synonym for V_$ALERT_TYPES
1501 select * from V$AQ ; ---Synonym for V_$AQ
1502 select * from V$AQ1 ; ---Synonym for V_$AQ1
1503 select * from V$ARCHIVE ; ---Synonym for V_$ARCHIVE
1504 select * from V$ARCHIVED_LOG ; ---Synonym for V_$ARCHIVED_LOG
1505 select * from V$ARCHIVE_DEST ; ---Synonym for V_$ARCHIVE_DEST
1506 select * from V$ARCHIVE_DEST_STATUS ; ---Synonym for V_$ARCHIVE_DEST_STATUS
1507 select * from V$ARCHIVE_GAP ; ---Synonym for V_$ARCHIVE_GAP
1508 select * from V$ARCHIVE_PROCESSES ; ---Synonym for V_$ARCHIVE_PROCESSES
1509 select * from V$ASH_INFO ; ---Synonym for V_$ASH_INFO
1510 select * from V$ASM_ACFSSNAPSHOTS ; ---Synonym for V_$ASM_ACFSSNAPSHOTS
1511 select * from V$ASM_ACFSVOLUMES ; ---Synonym for V_$ASM_ACFSVOLUMES
1512 select * from V$ASM_ACFS_ENCRYPTION_INFO ; ---Synonym for V_$ASM_ACFS_ENCRYPTION_INFO
1513 select * from V$ASM_ACFS_SECURITY_INFO ; ---Synonym for V_$ASM_ACFS_SECURITY_INFO
1514 select * from V$ASM_ALIAS ; ---Synonym for V_$ASM_ALIAS
1515 select * from V$ASM_ATTRIBUTE ; ---Synonym for V_$ASM_ATTRIBUTE
1516 select * from V$ASM_CLIENT ; ---Synonym for V_$ASM_CLIENT
1517 select * from V$ASM_DISK ; ---Synonym for V_$ASM_DISK
1518 select * from V$ASM_DISKGROUP ; ---Synonym for V_$ASM_DISKGROUP
1519 select * from V$ASM_DISKGROUP_STAT ; ---Synonym for V_$ASM_DISKGROUP_STAT
1520 select * from V$ASM_DISK_IOSTAT ; ---Synonym for V_$ASM_DISK_IOSTAT
1521 select * from V$ASM_DISK_STAT ; ---Synonym for V_$ASM_DISK_STAT
1522 select * from V$ASM_FILE ; ---Synonym for V_$ASM_FILE
1523 select * from V$ASM_FILESYSTEM ; ---Synonym for V_$ASM_FILESYSTEM
1524 select * from V$ASM_OPERATION ; ---Synonym for V_$ASM_OPERATION
1525 select * from V$ASM_TEMPLATE ; ---Synonym for V_$ASM_TEMPLATE
1526 select * from V$ASM_USER ; ---Synonym for V_$ASM_USER
1527 select * from V$ASM_USERGROUP ; ---Synonym for V_$ASM_USERGROUP
1528 select * from V$ASM_USERGROUP_MEMBER ; ---Synonym for V_$ASM_USERGROUP_MEMBER
1529 select * from V$ASM_VOLUME ; ---Synonym for V_$ASM_VOLUME
1530 select * from V$ASM_VOLUME_STAT ; ---Synonym for V_$ASM_VOLUME_STAT
1531 select * from V$AW_AGGREGATE_OP ; ---Synonym for V_$AW_AGGREGATE_OP
1532 select * from V$AW_ALLOCATE_OP ; ---Synonym for V_$AW_ALLOCATE_OP
1533 select * from V$AW_CALC ; ---Synonym for V_$AW_CALC
1534 select * from V$AW_LONGOPS ; ---Synonym for V_$AW_LONGOPS
1535 select * from V$AW_OLAP ; ---Synonym for V_$AW_OLAP
1536 select * from V$AW_SESSION_INFO ; ---Synonym for V_$AW_SESSION_INFO
1537 select * from V$BACKUP ; ---Synonym for V_$BACKUP
1538 select * from V$BACKUP_ARCHIVELOG_DETAILS ; ---Synonym for V_$BACKUP_ARCHIVELOG_DETAILS
1539 select * from V$BACKUP_ARCHIVELOG_SUMMARY ; ---Synonym for V_$BACKUP_ARCHIVELOG_SUMMARY
1540 select * from V$BACKUP_ASYNC_IO ; ---Synonym for V_$BACKUP_ASYNC_IO
1541 select * from V$BACKUP_CONTROLFILE_DETAILS ; ---Synonym for V_$BACKUP_CONTROLFILE_DETAILS
1542 select * from V$BACKUP_CONTROLFILE_SUMMARY ; ---Synonym for V_$BACKUP_CONTROLFILE_SUMMARY
1543 select * from V$BACKUP_COPY_DETAILS ; ---Synonym for V_$BACKUP_COPY_DETAILS
1544 select * from V$BACKUP_COPY_SUMMARY ; ---Synonym for V_$BACKUP_COPY_SUMMARY
1545 select * from V$BACKUP_CORRUPTION ; ---Synonym for V_$BACKUP_CORRUPTION
1546 select * from V$BACKUP_DATAFILE ; ---Synonym for V_$BACKUP_DATAFILE
1547 select * from V$BACKUP_DATAFILE_DETAILS ; ---Synonym for V_$BACKUP_DATAFILE_DETAILS
1548 select * from V$BACKUP_DATAFILE_SUMMARY ; ---Synonym for V_$BACKUP_DATAFILE_SUMMARY
1549 select * from V$BACKUP_DEVICE ; ---Synonym for V_$BACKUP_DEVICE
1550 select * from V$BACKUP_FILES ; ---Synonym for V_$BACKUP_FILES
1551 select * from V$BACKUP_PIECE ; ---Synonym for V_$BACKUP_PIECE
1552 select * from V$BACKUP_PIECE_DETAILS ; ---Synonym for V_$BACKUP_PIECE_DETAILS
1553 select * from V$BACKUP_REDOLOG ; ---Synonym for V_$BACKUP_REDOLOG
1554 select * from V$BACKUP_SET ; ---Synonym for V_$BACKUP_SET
1555 select * from V$BACKUP_SET_DETAILS ; ---Synonym for V_$BACKUP_SET_DETAILS
1556 select * from V$BACKUP_SET_SUMMARY ; ---Synonym for V_$BACKUP_SET_SUMMARY
1557 select * from V$BACKUP_SPFILE ; ---Synonym for V_$BACKUP_SPFILE
1558 select * from V$BACKUP_SPFILE_DETAILS ; ---Synonym for V_$BACKUP_SPFILE_DETAILS
1559 select * from V$BACKUP_SPFILE_SUMMARY ; ---Synonym for V_$BACKUP_SPFILE_SUMMARY
1560 select * from V$BACKUP_SYNC_IO ; ---Synonym for V_$BACKUP_SYNC_IO
1561 select * from V$BGPROCESS ; ---Synonym for V_$BGPROCESS
1562 select * from V$BH ; ---Synonym for V_$BH
1563 select * from V$BLOCKING_QUIESCE ; ---Synonym for V_$BLOCKING_QUIESCE
1564 select * from V$BLOCK_CHANGE_TRACKING ; ---Synonym for V_$BLOCK_CHANGE_TRACKING
1565 select * from V$BSP ; ---Synonym for V_$BSP
1566 select * from V$BUFFERED_PUBLISHERS ; ---Synonym for V_$BUFFERED_PUBLISHERS
1567 select * from V$BUFFERED_QUEUES ; ---Synonym for V_$BUFFERED_QUEUES
1568 select * from V$BUFFERED_SUBSCRIBERS ; ---Synonym for V_$BUFFERED_SUBSCRIBERS
1569 select * from V$BUFFER_POOL ; ---Synonym for V_$BUFFER_POOL
1570 select * from V$BUFFER_POOL_STATISTICS ; ---Synonym for V_$BUFFER_POOL_STATISTICS
1571 select * from V$CALLTAG ; ---Synonym for V_$CALLTAG
1572 select * from V$CELL ; ---Synonym for V_$CELL
1573 select * from V$CELL_CONFIG ; ---Synonym for V_$CELL_CONFIG
1574 select * from V$CELL_REQUEST_TOTALS ; ---Synonym for V_$CELL_REQUEST_TOTALS
1575 select * from V$CELL_STATE ; ---Synonym for V_$CELL_STATE
1576 select * from V$CELL_THREAD_HISTORY ; ---Synonym for V_$CELL_THREAD_HISTORY
1577 select * from V$CIRCUIT ; ---Synonym for V_$CIRCUIT
1578 select * from V$CLASS_CACHE_TRANSFER ; ---Synonym for V_$CLASS_CACHE_TRANSFER
1579 select * from V$CLASS_PING ; ---Synonym for V_$CLASS_PING
1580 select * from V$CLIENT_STATS ; ---Synonym for V_$CLIENT_STATS
1581 select * from V$CLUSTER_INTERCONNECTS ; ---Synonym for V_$CLUSTER_INTERCONNECTS
1582 select * from V$CONFIGURED_INTERCONNECTS ; ---Synonym for V_$CONFIGURED_INTERCONNECTS
1583 select * from V$CONTEXT ; ---Synonym for V_$CONTEXT
1584 select * from V$CONTROLFILE ; ---Synonym for V_$CONTROLFILE
1585 select * from V$CONTROLFILE_RECORD_SECTION ; ---Synonym for V_$CONTROLFILE_RECORD_SECTION
1586 select * from V$COPY_CORRUPTION ; ---Synonym for V_$COPY_CORRUPTION
1587 select * from V$CORRUPT_XID_LIST ; ---Synonym for V_$CORRUPT_XID_LIST
1588 select * from V$CPOOL_CC_INFO ; ---Synonym for V_$CPOOL_CC_INFO
1589 select * from V$CPOOL_CC_STATS ; ---Synonym for V_$CPOOL_CC_STATS
1590 select * from V$CPOOL_CONN_INFO ; ---Synonym for V_$CPOOL_CONN_INFO
1591 select * from V$CPOOL_STATS ; ---Synonym for V_$CPOOL_STATS
1592 select * from V$CR_BLOCK_SERVER ; ---Synonym for V_$CR_BLOCK_SERVER
1593 select * from V$CURRENT_BLOCK_SERVER ; ---Synonym for V_$CURRENT_BLOCK_SERVER
1594 select * from V$SYSAUX_OCCUPANTS ; ---Synonym for V_$SYSAUX_OCCUPANTS
1595 select * from V$SYSMETRIC ; ---Synonym for V_$SYSMETRIC
1596 select * from V$SYSMETRIC_HISTORY ; ---Synonym for V_$SYSMETRIC_HISTORY
1597 select * from V$SYSMETRIC_SUMMARY ; ---Synonym for V_$SYSMETRIC_SUMMARY
1598 select * from V$SYSSTAT ; ---Synonym for V_$SYSSTAT
1599 select * from V$SYSTEM_CURSOR_CACHE ; ---Synonym for V_$SYSTEM_CURSOR_CACHE
1600 select * from V$SYSTEM_EVENT ; ---Synonym for V_$SYSTEM_EVENT
1601 select * from V$SYSTEM_FIX_CONTROL ; ---Synonym for V_$SYSTEM_FIX_CONTROL
1602 select * from V$SYSTEM_PARAMETER ; ---Synonym for V_$SYSTEM_PARAMETER
1603 select * from V$SYSTEM_PARAMETER2 ; ---Synonym for V_$SYSTEM_PARAMETER2
1604 select * from V$SYSTEM_WAIT_CLASS ; ---Synonym for V_$SYSTEM_WAIT_CLASS
1605 select * from V$SYS_OPTIMIZER_ENV ; ---Synonym for V_$SYS_OPTIMIZER_ENV
1606 select * from V$SYS_TIME_MODEL ; ---Synonym for V_$SYS_TIME_MODEL
1607 select * from V$TABLESPACE ; ---Synonym for V_$TABLESPACE
1608 select * from V$TEMPFILE ; ---Synonym for V_$TEMPFILE
1609 select * from V$TEMPORARY_LOBS ; ---Synonym for V_$TEMPORARY_LOBS
1610 select * from V$TEMPSEG_USAGE ; ---Synonym for V_$SORT_USAGE
1611 select * from V$TEMPSTAT ; ---Synonym for V_$TEMPSTAT
1612 select * from V$TEMP_CACHE_TRANSFER ; ---Synonym for V_$TEMP_CACHE_TRANSFER
1613 select * from V$TEMP_EXTENT_MAP ; ---Synonym for V_$TEMP_EXTENT_MAP
1614 select * from V$TEMP_EXTENT_POOL ; ---Synonym for V_$TEMP_EXTENT_POOL
1615 select * from V$TEMP_PING ; ---Synonym for V_$TEMP_PING
1616 select * from V$TEMP_SPACE_HEADER ; ---Synonym for V_$TEMP_SPACE_HEADER
1617 select * from V$THREAD ; ---Synonym for V_$THREAD
1618 select * from V$THRESHOLD_TYPES ; ---Synonym for V_$THRESHOLD_TYPES
1619 select * from V$TIMER ; ---Synonym for V_$TIMER
1620 select * from V$TIMEZONE_FILE ; ---Synonym for V_$TIMEZONE_FILE
1621 select * from V$TIMEZONE_NAMES ; ---Synonym for V_$TIMEZONE_NAMES
1622 select * from V$TOPLEVELCALL ; ---Synonym for V_$TOPLEVELCALL
1623 select * from V$TRANSACTION ; ---Synonym for V_$TRANSACTION
1624 select * from V$TRANSACTION_ENQUEUE ; ---Synonym for V_$TRANSACTION_ENQUEUE
1625 select * from V$TRANSPORTABLE_PLATFORM ; ---Synonym for V_$TRANSPORTABLE_PLATFORM
1626 select * from V$TSM_SESSIONS ; ---Synonym for V_$TSM_SESSIONS
1627 select * from V$TYPE_SIZE ; ---Synonym for V_$TYPE_SIZE
1628 select * from V$UNDOSTAT ; ---Synonym for V_$UNDOSTAT
1629 select * from V$UNUSABLE_BACKUPFILE_DETAILS ; ---Synonym for V_$UNUSABLE_BACKUPFILE_DETAILS
1630 select * from V$VERSION ; ---Synonym for V_$VERSION
1631 select * from V$VPD_POLICY ; ---Synonym for V_$VPD_POLICY
1632 select * from V$WAITCLASSMETRIC ; ---Synonym for V_$WAITCLASSMETRIC
1633 select * from V$WAITCLASSMETRIC_HISTORY ; ---Synonym for V_$WAITCLASSMETRIC_HISTORY
1634 select * from V$WAITSTAT ; ---Synonym for V_$WAITSTAT
1635 select * from V$WAIT_CHAINS ; ---Synonym for V_$WAIT_CHAINS
1636 select * from V$WALLET ; ---Synonym for V_$WALLET
1637 select * from V$WLM_PCMETRIC ; ---Synonym for V_$WLM_PCMETRIC
1638 select * from V$WLM_PCMETRIC_HISTORY ; ---Synonym for V_$WLM_PCMETRIC_HISTORY
1639 select * from V$WLM_PC_STATS ; ---Synonym for V_$WLM_PC_STATS
1640 select * from V$WORKLOAD_REPLAY_THREAD ; ---Synonym for V_$WORKLOAD_REPLAY_THREAD
1641 select * from V$XML_AUDIT_TRAIL ; ---Synonym for V_$XML_AUDIT_TRAIL
1642 select * from V$XSTREAM_CAPTURE ; ---Synonym for V_$XSTREAM_CAPTURE
1643 select * from V$XSTREAM_MESSAGE_TRACKING ; ---Synonym for V_$XSTREAM_MESSAGE_TRACKING
1644 select * from V$XSTREAM_OUTBOUND_SERVER ; ---Synonym for V_$XSTREAM_OUTBOUND_SERVER
1645 select * from V$XSTREAM_TABLE_STATS ; ---Synonym for V_$XSTREAM_TABLE_STATS
1646 select * from V$XSTREAM_TRANSACTION ; ---Synonym for V_$XSTREAM_TRANSACTION
1647 select * from V$_LOCK ; ---Synonym for V_$_LOCK
1648 select * from V$LOADISTAT ; ---Synonym for V_$LOADISTAT
1649 select * from V$LOADPSTAT ; ---Synonym for V_$LOADPSTAT
1650 select * from V$LOBSTAT ; ---Synonym for V_$LOBSTAT
1651 select * from V$LOCK ; ---Synonym for V_$LOCK
1652 select * from V$LOCKED_OBJECT ; ---Synonym for V_$LOCKED_OBJECT
1653 select * from V$LOCKS_WITH_COLLISIONS ; ---Synonym for V_$LOCKS_WITH_COLLISIONS
1654 select * from V$LOCK_ACTIVITY ; ---Synonym for V_$LOCK_ACTIVITY
1655 select * from V$LOCK_ELEMENT ; ---Synonym for V_$LOCK_ELEMENT
1656 select * from V$LOCK_TYPE ; ---Synonym for V_$LOCK_TYPE
1657 select * from V$LOG ; ---Synonym for V_$LOG
1658 select * from V$LOGFILE ; ---Synonym for V_$LOGFILE
1659 select * from V$LOGHIST ; ---Synonym for V_$LOGHIST
1660