oracle数据字典视图及其功能

-----------DBA_DBA_2PC_NEIGHBORS                包含待处理事务进入连接和退出连接信息。DBA_2PC_PENDING                 包含等待恢复的分布式事务的信息。DBA_ALL_TABLES                 显示数据库中所有表(对象表和关系表)的描述。DBA_ANALYZE_OBJECTS         列出分析对象。DBA_ASSOCIATIONS                 列出用户定义的统计信息。DBA_AUDIT_EXISTS                 列出由AUDIT NOT EXISTS(不存在审计)和AUDIT EXISTS(存在审计)产生的审计跟踪条目。DBA_AUDIT_OBJECT         包含系统中所有对象的审计跟踪记录。DBA_AUDIT_SESSION         列出关于CONNECT(连接)和DISCONNECT(断开连接)的所有审讯跟踪记录。DBA_AUDIT_STATEMENT 列出关于GRANT(授权)、REVOKE(取消)、AUDIT〔审计〕、NOAUDIT(不审计)和ALTER SYSTEM(改变系统)语句的审记跟踪记录。DBA_AUDIT_TRAIL         列出所有的审记跟踪条目。DBA_BLOCKERS         列出所有人等待一个会话持有的锁的所有会话,但并非它们自己在等待一个锁。DBA_CATALOG         列出所有数据库表、视图、同义词和序列。DBA_CLU_COLUMNS         列出表列到簇列的映射。DBA_CLUSTER_HASH_EXPRESSIONS     列出所有簇的散列(hash)函数。DBA_CLUSTERS         包含数据库中所有族的描述。DBA_COL_COMMENS        列出所有表和视图列的注解。DBA_COL_PRIVS        列出数据库中授予列的所有权限。DBA_COLL_TYPES        显示数据库中所有命名的集合类型,如VARRAY(数组)、嵌套表、对象表,等等;DBA_CONS_COLUMNS        包含在约束定义中的,可访问的列的信息DBA_CONSTRAINTS        包含所有表上的约束定义。DBA_CONTEXT        列出所有上下文名字空间的信息。DBA_DATA_FILES        包含有关数据库文件的信息DBA_DB_LINKS        列出数据库中的所有数据库链接。DBA_DDL_LOCKS        列出数据库持有的所有DDL锁,及所有对一个DDL锁的未定请求。DBA_DEPENDENCIES        列出对象之间的依赖性。在没有任何数据库链接时所创建的视图上的依赖性也是可用的。DBA_DIM_ATTRIBUTES        代表维级和功能依赖的列之间的关系。维级列所在的表,必须与所依赖列所在的表相匹配。DBA_DIM_CHILD_OF        代表在维中的一对维级之间的1:n的层次关系。DBA_DIM_HIERARCHIES        代表一个维层次。DBA_DIM_JOIN_KEY        代表两个维表之间的连接。这种连接通常在一个双亲维级列和一个子列之间指定。DBA_DIM_LEVEL_KEY        代表一个维级的列。一个级中列的位置通过KEY_POSITION来指定。DBA_DIM_LEVELS        代表一个维级。一个维级的所有列,必须来自于同一关系。DBA_DIMENSIONS        代表维对象。DBA_DIRECTORIES        提供数据库中所有目录对象的信息。DBA_DML_LOCKS        列出数据库中持有的所有DML锁,和对一个DML锁的所有未决请求。DBA_ERRORS         列出数据库中所有存储的对象的当前错误。DBA_EXP_FILES        包含导出文件的描述。DBA_EXP_OBJECTS        列出以增量方式导出的对象。DBA_EXP_VERSION        包含最后导出会话的版本号。DBA_EXTENTS        列出数据库中组成所有段的区。DBA_FREE_SPACE        列出所有表空间中的空闲分区。DBA_FREE_SPACE_COALESCED        包含表空间中合并空间的统计数据。DBA_IND_COLUMNS        包含在所有表和簇中组成索引的列的描述。DBA_IND_EXPRESSIONS        列出在所有表和簇中函数型索引的表达示。DBA_IND_PARTITIONS        为每一个索引分区,描述分区级的分区信息、分区的存储参数和由ANALYZE决定的各种分区统计数据。DBA_IND_SUBPARTITIONS                                为当前用户拥有的每一个索引子分区,描述分区级的分区信息、子分区的存储参数和由ANALYZE决定的各种分区统计数据。DBA_INDEXES        包含数据库中所有索引的描述。DBA_INDEXTYPE_OPERATORS                列出由索引类型支持的所有操作符。DBA_INDEXTYPES        列出所有的索引类型。DBA_JOBS        列出数据库中的所有作业。DBA_JOBS_RUNNING        列出数据库中当前运行的所有作业。DBA_LIBRARIES        列出数据库中所有的库。DBA_LOB_PARTITIONS        显示包含在表中的用户可访问的LOB。DBA_LOB_SUBPARTITIONS                 显示LOB数据子分区中的分区级属性。DBA_LOBS         显示包含在所有表中的LOB.DBA_LOCK_INTERNAL         包含每个被持有的锁或简易锁的一行信息,及锁或简易锁的每一个未决定请求的一行信息。DBA_LOCKS         列出数据库中持有的所有锁或简易锁,及一个锁或简易锁的所有未决请求。DBA_METHOD_PARAMS        包含数据库中类型的方法参数的描述。DBA_METHOD_RESULTS        包含数据库中所有类型的方法结果的描述。DBA_MVIEW_AGGREGATES                代表在聚集实例化视图的SELECT列表中出现的分组函数(聚集方法)。DBA_MVIEW_ANALYSIS        代表潜在地支持查询重写,并有可用于应用程序分析的附加信息的实例化视图。这种视图包括任何引用远程表或者包括如SYSDATE或USER等非静态值的实例化视图。DBA_MVIEW_DETAIL_RELATIONS                代表命名细节关系,这些关系或者在一个实例化视图的FROM列表中,或者直接通过FORM列表中的视图引用。在这个表中,没有表示实例化视图中的内嵌视图。DBA_MVIEW_JOINS        在一个实例化视图的WHERE子句中,代表两个列之间的连接。DBA_MVIEW_KEYS        代表命名细节关系,这些关系或者在一个实例化视图的FROM列表中,或者直接通过FORM列表中的视图引用。在这个表中,没有表示实例化视图中的内嵌视图。DBA_NESTED_TABLES        显示包含在所有表中的嵌套表的描述。DBA_OBJ_AUDIT_OPTS        列出一个用户所拥有的所有对象的审计选项。DBA_OBJECT_SIZE         列出各类PL/SQL对象的、用字节数表示大小。DBA_OBJECT_TABLES        显示数据库中所有对象表的描述。DBA_OBJECTS         列出数据库中所有的对象。DBA_OPANCILLARY         列出操作符连接的附加信息。DBA_OPARGUMENTS        列出操作符连接的参数信息。DBA_OPBINDINGS        列出操作符连接。DBA_OPERATORS         列出操作符。DBA_OUTLINE_HINTS         列出组成概要的提示集。DBA_OUTLINES          列出有关概要的信息。DBA_PART_COL_STATISTICS                 包含所有表分区的列统计数据和直方图信息。DBA_PART_HISTOGRAMS        包含所有表分区上直方图的直方图数据(每个直方图的端点)。DBA_PART_INDEXES        列出所有分区索引的对象级分区信息。DBA_PART_KEY_COLUMNS        描述所有分区对象的分区关键字列。DBA_PART_LOBS        描述分区LOB的表级信息,包括LOB数据分区的缺省属性。DBA_PART_TABLES         列出所有分区表的对象级分区信息。DBA_PARTIAL_DROP_TABS         描述部分删除的表。DBA_PENDING_TRANSACTIONS         提供关于未完成事务(由于故障或协调器没有提交或回滚)的信息。DBA_POLICIES         列出策略。DBA_PRIV_AUDIT_OPTS         描述通过系统和由用户审计的当前系统权限。DBA_PROFILES         显示所有启动文件及其限制DBA_QUEUE_SCHEDULES        描述当前传播信息的方案。DBA_QUEUE_TABLES        描述在数据库中建立的所有队列表中的队列的名称和类型。DBA_QUEUE        描述数据库中每一个队列的操作特征。DBA_RCHILD        列出任何刷新组中的所有子组。DBA_REFRESH        列出所有刷新组。DBA_REFRESH_CHILDREN        列出刷新组中所有对象。DBA_REFS        描述数据库中所有表的对象类型列中的REF列和REF属性。DBA_REGISTERED_SNAPSHOT_GROUPS        列出该场地的所有快照登记组。DBA_REGISTERED_SNAPSHOT                                检索本地表的远程快照的信息。DBA_REPCAT_REFRESH_TEMPLATES                与Advanced Replication(高级复制)一起使用。DBA_REPCAT_TEMPLATES_PARMS                        与Advanced Replication(高级复制)一起使用。DBA_REPCAT_TEMPLATES_SITES                        与Advanced Replication(高级复制)一起使用。DBA_REPCAT_USER_AUTHORIZATIONS                与Advanced Replication(高级复制)一起使用。DBA_REPCAT_USER_PARM_VALUES                与Advanced Replication(高级复制)一起使用。DBA_REPCATLOG                                                与Advanced Replication(高级复制)一起使用。DBA_REPCOLUMN                                                与Advanced Replication(高级复制)一起使用。DBA_REPCOLUMN_GROUP                                        与Advanced Replication(高级复制)一起使用。DBA_REPCONFLICT                                                与Advanced Replication(高级复制)一起使用。DBA_REPDDL                                                与Advanced Replication(高级复制)一起使用。DBA_REPGENERATED                                                与Advanced Replication(高级复制)一起使用。DBA_REPGENOBJECTS                                                与Advanced Replication(高级复制)一起使用。DBA_REPGROUP                                                与Advanced Replication(高级复制)一起使用。DBA_REPGROUPED_COLUMN                                与Advanced Replication(高级复制)一起使用。DBA_REPKEY_COLUMNS                                                与Advanced Replication(高级复制)一起使用。DBA_REPOBJECT                                                与Advanced Replication(高级复制)一起使用。DBA_REPPARAMETER_COLUMN                        与Advanced Replication(高级复制)一起使用。DBA_REPPRIORITY                                                与Advanced Replication(高级复制)一起使用。DBA_REPPRIORITY_GROUP                                与Advanced Replication(高级复制)一起使用。DBA_REPPROP                                                与Advanced Replication(高级复制)一起使用。DBA_REPPESOL_STATS_CONTROL                        与Advanced Replication(高级复制)一起使用。DBA_REPRESOLUTION                                                与Advanced Replication(高级复制)一起使用。DBA_REPRESOLUTION_METHOD                        与Advanced Replication(高级复制)一起使用。DBA_REPSITES                                                与Advanced Replication(高级复制)一起使用。DBA_RGROUP                                                列出所有刷新组。DBA_ROLE_PRIIVS                                                     列出授予用户和角色的角色DBA_ROLES                                                    列出数据库中存在的所有角色DBA_ROLLBACK_SEGS                                                   包含回滚段的描述DBA_RSRC_CONSUMER_GROUP_PRIVS           列出所有已授权的资源消费组、用户和角色。DBA_RSRC_CONSUMER_GROUPS                    列出数据库中存在的所有资源消费组。DBA_RSRC_MANAGER_SYSTEM_PRIVS           列出所有已授予属于资源管理员系统权限的用户和角色。DBA_RSRC_PLAN_DIRECTIVES                            列出数据库中存在的所有资源计划的指示。DBA_RSRC_PLANS                                                     列出数据库中存在的所有资源计划。DBA_RULESETS                                                     列出规则集信息。DBA_SEGMENTS                                                     包含分配级所有数据库段的存储信息。DBA_SEOUENCES                                                     包含数据库中所有序列的描述。DBA_SNAPSHOT_LOG_FILTER_COLS    列出记录在快照日志上的所有过滤列(不包括PK列)DBA_SNAPSHOT_LOGS                                    列出数据库中所有的快照日志。DBA_SNAPSHOT_REFRESH_TIMES                   列出快照刷新次数。DBA_SNAPSHOTS                                                    列出数据库中所有的快照。DBA_SOURCE                                                   包含数据库中所有存储对象的来源。DBA_STMT_AUDIT_OPTS                                   包含的信息为:描述通过系统并由用户审计的当前系统审计选项。DBA_SUBPART_COL_STATISTICS                   列出表子分区的列统计数据和直方图信息。DBA_SUBPART_HISTOGRAMS           列出表子分区中直方图的实际数据(每个直方图的端点)。DBA_SUBPART_KEY_COLUMNS   列出用Composite  Range(复合排列)或HASH方法进行分区的表(和表上的本地索引)的子分区关键字列。DBA_SYNONYMS                                   列出数据库中所有同义词DBA_SYS_PRIVS                                   列出授予用户和角色的系统权限。DBA_TAB_COL_STATISTICS                   包含在DBA_TAB_COLUMNS视图中的列统计数据和直方图信息。DBA_ TAB_COLUMNS                                   包含所有表、视图和簇的描述列的信息。DBA_TAB_COMMENTS                                  包含对数据库中所有表和视图的注解。DBA_TAB_HISTOGRAMS                   列出所有表中列的直方图。DBA_TAB_PARTITIONS                                  对每一个表分区,描述它的分区级分区信息、分区的存储参数,和由ANALYZE                        决定的各种分区统计数据。DBA_TAB_PRIVS                          列出数据库中所有授予对象的授权。DBA_TAB_SUBPARTITIONS   对每一个表的子分区,描述它的名称、表的名称和它所属的分区,以及它的存储属性。DBA_TABLES                          包含数据库中所有关系表的描述。DBA_TABLESPACES                          包含所有表空间的描述DBA_TEMP_FILES                          包含数据库临时文件的信息。DBA_TRIGGER_COLS                          列出所有触发器中列的用法。DBA_TRIGGERS                          列出数据库中所有触发器。DBA_TS_QUOTAS                          列出所有用户的表空间限额。DBA_TYPE_ATTRS                           显示数据库中类型的属性。DBA_TYPE_METHODS                          描述数据库中所有类型的方法。DBA_TYPES                           显示数据库中所有的抽象数据类型。DBA_UNUSED_COL_TABS          包含对所有具有未使用列的表的描述。DBA_UPDATABLE_COLUMNS  包含对可在一个连接视图中,由数据库管理员更新的列的描述。DBA_USERS                          列出数据库中所有用户的信息。DBA_USTATS                           包含当前用户的信息。DBA_VARRAYS                           列出用户可以访问的视图的文本。DBA_VIEWS                            包含数据库中所有视图的文本。DBA_WAITERS                           列出所有正在等待一个锁的会话,以及列出正在阻止它们获得该锁的会话。-----------$V$ACCESS           显示当前被锁定的数据库中的对象及正在访问它们的会话。V$ACTIVE_INSTANCES  为当前安装的数据库中出现的所有实例建立从实例名到实例号码的映射V$AQ                  描述当前数据库中队列的统计量。V$ARCHIVE           包含归档所需的重做日志文件中的信息。每一行提供了一个线程所需的信息。这些信息在V$LOG中也是可用的。Oracle建议你使用V$LOG.V$ARCHIVE_DEST          描述当前实例的所有归档日志目的文件及它们的当前值、模式和状态。V$ARCHIVED_LOG          显示控制文件中的归档日志信息,包括归档日志名。在联重做日志文件成功地归档或清除(如果日志被清除,名字列将为NULL)后,一条归档日志记录被插入。如果这个日志被归档两次,那么就将有两条具有相同THREAD#,SEQUENCE#,FIRST_CHANG#值的归档日志记录,但它们的名字不同。当一个归档日志从一个备份集或一个副本中被恢复时,一个归档日志记录也将被插入。V$ARCHIVE_PROCESSES   为一个实例提供关于不同ARCH进程状态的信息。V$BACKUP          显示所有联机数据文件的备份状态。V$BACKUP_ASYNC_IO   从控制文件中显示备份集的信息。在这个备份集成功完成后,一个备份集记录将被插入。V$BACKUP_CORRUPTION    从控制文件中显示数据文件备份中有关损坏的信息。注意在控制文件和归档日志备份文件中损坏是不能容忍的V$BACKUP_DATAFILE   从控制文件中显示备份数据文件和备份控制文件的信息。V$BACKUP_DEVICE                           显示关于支持备份设备的信息。如果一个设备类型不支持指名的设备,那么将为这个设备类型返回一个带有设备类型和NULL设备名的行。如果一个设备类型支持指名的设备,那么将为每一个这种类型的可用设备返回一行。特殊的设备类型DISK不会通过这个视图返回,因为它总是可用的 。V$BACKUP_PIECE  从控制文件中显示备份块的信息。每一个备份集由一个更多个备份块组成。V$BACKUP_REDOLOG          从控制文件中显示关于备份集中归档日志的信息。注意联机的重做日志文件不能够被直接备份。它们必须首先被存储到磁盘上然后再进行备份。一个归档日志备份集能包含一个或多个归档日志。V$BACKUP_SET           从控制文件中显示备份集的信息。在备份集成功完成后,一个备份集记录将被插入。V$BACKUP_SYNC_IO    从控制文件中显示备份集的信息。在备份集成功完成后,一个备份集记录将被插入。V$BGPROCESS          描述后台进程。V$BH          这是一个并行服务器视图。这个视图为系统全局区中的每一个缓冲区给出了状态和探查次数。V$BUFFER_POOL          显示关于这个实例所有可用缓冲池的信息。这个“集合数”属于LRU简易锁集的数目。V$BUFFER_POOL_STATISTICS  显示关于这个实例所有可用缓冲池的信息。这个“集合数”属于LRU简易锁集的数目。V$CACHE          这是一个并行服务器视图。这个视图包含当前实例的SGA中的每一个块的头部信息,这个实例是与一个特殊数据库对象相关联的。V$CACHE_LOCK           这是一个并行服务器的视图。除了特殊平台锁管理器标识符不同外,V$CACHE_LOCK        与V$CACHE非常相似。如果这个特殊平台锁管理器为监视当前正发生的PCM锁操作提供了工具,那么这些信息可能是有用的。V$CIRCUIT          包含关于虚电路的信息,这个虚电路是用户通过调度程序和服务器到数据库的所有连接。V$CLASS_PING          显示每一个块类中被探查块的数目。用这个视图可以比较不同类的块竞争。V$COMPATIBILITY          显示数据库实例使用中的特征,可能阻止系统性能下降到先前的版本。这是这些信息的动态(SGA)版本,它不可能反映出所用过的另外一些实例的特征,并可能包含暂时的不兼容性(如UNDO段),不过这将在数据库完全的关闭掉后不复存在。V$COMPATSEG          列出数据库使用中的永久性的特征,这些特征将会阻止数据库回到早期的版本中去。V$CONTEXT          列出当前对话的设置属性。V$CONTROLFILE           列出控制文件的名字。V$CONTROLFILE_RECORD_SECTION  显示关于控制文件记录部分的信息。V$COPY_CORRUPTION  显示关于控制文件中数据文件副本损坏的信息。V$DATABASE          包含控制文件中数据库信息。V$DATAFILE           包含控制文件中数据库文件的信息。V$DATAFILE_COPY          显示控制文件中数据文件副本的信息。V$DATAFILE_HEADER  显示数据文件头部的数据文件信息。V$DBFILE          列出组成数据库中的所有数据文件。这个视图是为历史兼容性保留的,我们建议用V$DATAFILE来代替。V$DBLINK          描述由发布对V$DBLINK查询的会话所打开的所有数据库链接(用IN_TRANSACTION=YES链接)。这些数据库链接必须在关闭前被提交或滚回。V$DB_OBJECT_CACHE  显示缓存在库高速缓存中的数据库对象。这些对象包括表、索引、簇、同义词定义、PL/SQL过程和包及触发器。V$DB_PIPES          显示当前数据库中的管道。V$DELETED_OBJECT   显示控制文件中被删除归档日志、数据文件副本和备份块的信息。这个视图的唯一目的是优化恢复目录的再同步操作。当一个归档日志、数据文件副本或备份块被删除时,相应的记录将被做上删除标志。V$DISPATCHER          提供调度进程的信息。V$ DISPATCHER_RATE  为调度进程提供速率统计量。V$DLM_ALL_LOCKS          这是一个并行服务器视图。V$DLM_ALL_LOCKS列出当前所有锁的信息,这些是锁管理器已知的被阻塞或阻塞其他对象的锁信息。V$DLM_CONVERT_LOCAL  显示本地锁转换操作所消耗的时间。V$DLM_CONVERT_REMOTE  显示远程锁转换操作所消耗的时间。V$DLM_LOCKS                 这是一个并行服务器视图。V$DLM_ALL_LOCKS 列出当前所有锁的信息,这些是锁管理器已知的被阻塞或阻塞其他对象的锁信息。V$DLM_MISC          显示多种DLM统计量。V$DLM_RESS          这是一个并行服务器的视图,它显示了当前锁管理器已知的全部资源的信息。V$ENABLEDPRIVS           显示被授予的权限。这些权限可以在SYS.SYSTEM_PRIVILEGES_MAP这个表中找到。V$ENQUEUE_LOCK           显示排队状态对象所拥有的全部锁。这个视图中的列等同于V$LOCK中的列。更多的信息参见V$LOCK.V$EVENT_NAME           包含等待事件的信息。V$EXECUTION           显示并行执行中的信息。V$FALSE_PING           这是一个并行服务器视图。这个视图显示可能得到探查失败的缓冲区,探查被同样锁保护的缓冲区10次以上,如像另一个探查10次以上的缓冲区。被鉴别为获得探查失败信息的缓冲区能够被重新映射到GC_FILES_TO_LOCKS 中以减少锁的冲突。V$FAST_START_SERVERS                  提供关于执行并行事务恢复的所有从属恢复操作的信息。V$FAST_START_TRANSACTIONS          包含关于Oracle 恢复中的事务进展信息。V$FILE_PING           显示每一个数据文件被探查的块数目。反过来,这些信息能被用来决定对一个存在的数据文件访问方式,同时也可以决定从数据文件块到PCM锁的新的映射。V$FILESTAT           包含文件关于读/写统计量的信息V$FIXED_TABLE           显示数据库中所有动态性能表、视图和导出表。一些V$表(如V$ROLLNAME)涉及到了真正的表,没有被列出来。V$FIXED_VIEW_DEFINITION    包含所有固定视图的定义(以V$开头的视图)。应谨慎地使用这个表。Oracle 总是想从版本到版本保持固定视图的行为,但是固定视图的定义能够在没有通知的情况下改变。用这些定义通过使用动态性能表中的索引列可以优化你的查询。V$GLOBAL_BLOCKED_LOCKS  显示全局块锁。V$GLOBAL_TRANSACTION            显示当前激活的全局事务的信息。V$HS_AGENT           标识当前运行在一个给定的主机上的HS代理的集合,每一个代理进程用一行表示。V$HS_SESSION          标识当前为一个Oracle 服务器打开的HS会话集。V$INDEXED_FIXED_COLUMN   显示建立索引的动态性能表中的列(X$表),X$表能够在没有通知的情况下改变。使用这个视图仅仅在写查询方面比固定视图(V$视图)的效率要高。V$INSTANCE           显示当前实例的状态。这个V$INSTANCE 版本同早期的V$INSTANCE 版本不兼容。V$INSTANCE_RECOVERY   用来监视执行用户指定恢复读次数的限制机制。V$LATCH         为非双亲简易锁列出统计表,同时为双亲简易锁列出总计统计。就是说,每一个双亲简易锁的统计量包括它的每一个子简易锁的计算值。V$LATCHHOLDER           包含当前简易锁持有者的信息。V$LATCHNAME           包含关于显示在V$LATCH中的简易锁的解码简易锁名字的信息。V$LATCHNAME        中的行与V$LATCH中的行有一一对应的关系。V$LATCH_CHILDREN   包含关于子简易锁的统计量。这个视图包括V$LATCH中的所有列和一个CHILD#列。注意如果子简易锁LATCH#列相匹配,那么它们将具有相同的双亲。V$LATCH_MISSES         包含试图获得一个简易锁失败的统计量。V$LATCH_PARENT           包含关于双亲简易锁的统计量。V$LATCH_PARENT中的列与V$LATCH中的列是相等的。V$LIBRARYCACHE          包含关于高速缓存性能和活动的统计量。V$LICENSE           包含关于许可证限制的信息。V$LOADCSTAT           包含在一个直接装载执行过程中所编译的SQL*Loader统计量。这些统计量适用于整个的加载。既然装载数据和查询不能在同一时间进行,那么,任何对这个表的SELECT操作都将会导致”no  rows  retured”(没有行返回)V$LOADTSTAT          包含在一个直接装载执行过程中所编译的SQL*Loader统计量。这些统计量适用于当前的表。既然装载数据和查询不能在同一时间进行,那么,任何对这个表的SELECT操作都将会导致”no  rows  retured”(没有行返回)V$LOCK           列出当前ORACLE服务器所持有的锁和对一个锁或简易锁的未决请求。V$LOCK_ACTIVITY    这是一个并行服务器视图。它显示当前实例的DLM锁操作活动,每一行对应着锁操作的类型。V$LOCK_ELEMENT           这是一个并行服务器视图。每一个被缓冲高速缓存使用的PCM锁在V$LOCK_ELEMENT中都有一个条目。与一个锁元素相对应的PCM锁的名字是(‘BL’,indx,class)。V$LOCKED_OBJECT                                   列出在这个系统中每一个事务所获得的全部锁。V$LOCKS_WITH_COLLISIONS   这是一个并行服务器视图。用这个视图可以查找保护多重锁缓冲区的锁,这些缓冲区的每一个至少被强制性的读或写达十次以上。那些正经历着探查失败的缓冲区,主要是由于被映射到同样的锁上。V$LOG                   包含控制文件中的日志文件信息。V$LOGFILE            包含重做日志文件的信息。V$LOGHIST            包含控制文件中的日志历史信息。这个视图是为历史兼容性保留的。这里建议使用V$LOG_HISTORY来代替它。V$LOGMNR_CONTENTS           包含日志历史信息。V$LOGMNR_DICTIONARY   包含日志历史信息。V$LOGMNR_LOGS                          包含日志信息。V$LOGMNR_PARAMETERS   包含日志信息。V$LOG_HISTORY                           包含控制文件中的日志历史信息。V$MLS_PARAMETERS           这是一个ORACLE委托服务器(Trusted Oracle Server)视图,这个视图列出ORACLE指定委托服务器的初始化参数。更多的信息,可以在你的ORACLE委托文件中查到。V$MTS           包含调节多线程的服务器的信息。V$MYSTAT        包含当前会话的统计量。V$NLS_PARAMETERS   包含当前NLS参数的值。V$NLS_VALID_VALUES    列出NLS参数所有有效的信息。V$OBJECT_DEPENDENCY   能够通过当前装戴在共享池中的包、过程或游标来决定依赖于那一个对象。例如,与V$SESSIONV和$SQL一起,它能被用来决定在SQL语句中使用哪一个正在被用户执行的表。要知道更多的信息,请见V$SESSION和V$SQLV$OBSOLETE_PARAMETER   列出陈旧的参数。只要有某一值为TRUE,你就应该检查为什么。V$OFFLINE_CURSOR    显示控制文件中数据文件的脱机信息。V$OPEN_CURSOR                   列出每一个用户会话当前打开的和解析的游标。V$OPTION            列出用ORACLE服务器安装的选项。V$PARALLEL_DEGREE_LIMIT_MTH    显示所有有效的并行度限制资源分配的方法。V$PARAMETER                   列出关于初始化参数的信息。V$PING            这是一个并行服务器视图。除了只显示至少被探查一次的块有所不同外,V$PING视图与V$CACHE视图完全是一样的,这个视图包含当前实例的SGA中每一块的块首部信息,这个实例是与一个特定的数据库对象相关联的。V$PQ_SESSTAT              列出并行查询会话的统计信息。注意:这个视图在未来的版本中将会成为过的 。V$PQ_SLAVE            列出一个实例上每个活动并行执行服务器的统计量。注意:这个视图在未来的版本中将会过时而被一个新的称做V$PX_PROCESS的视图所代替。V$PQ_SYSSTAT            列出并行查询的系统统计量。注意:这个视图在未来的版本中将会过时而被一个新的称做V$PX_PROCESS_SYSSTAT的视图所代替。V$PQ_TQSTAT            包含并行执行操作上的统计量。这些统计量是在完成了查询后编辑的,并且仅在会话期保持。它显示在执行树的每一级阶段,通过每一个并行运行服务器处理的行数。这个视图能够帮助在一个查询执行中测定不平衡的问题。注意:这个视图在未来的版本中将称做V$PX_TQSTAT视图。V$PROCESS            包含关于当前活动进程的信息。当LATCHWAIT列显示一个进程正等待什么样的简易锁时,LATCHSPIN列就显示一个进程正围绕什么样简易锁运行。在多处理器机器上,ORACLE进程在等待一个简易锁之前是围绕它运行的。V$PROXY_ARCHIVEDLOG    包含归档日志备份文件的描述信息,这些备份文件带有一个称为Proxy副本的新特征。每一个行代表一个归档日志的备份信息。V$PROXY_DATAFILE                   包含数据文件和控制文件备份的描述信息,这个备份文件带了一个称为Proxy副本的新特征。每一行代表一个数据库文件的备份信息。V$PWFILE_USERS                    列出被授予SYSDBA和SYSOPER权限的用户,这些权限就象从password文件中衍生而来一样。V$PX_PROCESS            包含正运行并行操作的会话的信息。V$PX_PROCESS_SYSSTAT   包含正运行并行操作的会话的信息。V$PX_SESSION            包含正运行并行操作的会话的信息。   ==========================实用的部分视图=================================== 9I管理的数据字典USER视图。 645. USER_ALL_TABLES   包含对用户可用的表的描述. 646. USER_ARGUMENTS   列出对用户可存取的对象中的参数. 647. USER_ASSOCIATIONS   当前用户所拥有的相关对象的用户定义的统计. 648. USER_AUDIT_OBJECT   关于对象的语句审计跟踪记录. 649. USER_AUDIT_SESSION   关于用户连接或断开的全部审计跟踪记录. 650. USER_AUDIT_STATEMENT   列出用户发出的GRANT,REVOKE,AUDIT,NOAUDIT,ALTER SYSTEM语句的审计跟踪条目. 651. USER_AUDIT_TRAIL   与用户有关的审计跟踪条目. 652. USER_BASE_TABLE_MVIEWS   当前用户拥有的所有使用物化视图日志的物化视图. 653. USER_CATALOG   用户拥有的表,视图,同义词和序列. 654. USER_CLU_COLUMNS   用户表的列到聚集列的映射. 655. USER_CLUSTER_HASH_EXPRESSIONS   用户可存取的所有聚集及哈希函数. 656. USER_CLUSTERS   用户拥有的聚集的说明. 657. USER_COL_COMMENTS   列出用户表或视图的列上的注释. 658. USER_COL_PRIVS   列出列上的授权,用户是所有者,授予者或被授予者. 659. USER_COL_PRIVS_MADE   列出用户拥有对象的列上的全部授权. 660. USER_COL_PRIVS_RECD   列出列上的授权,用户是被授予者. 661. USER_COLL_TYPES   用户的命名集合类型. 662. USER_CONS_COLUMNS   用户拥有的约束定义中的列信息. 663. USER_CONSTRAINTS   用户表上的约束定义. 664. USER_DB_LINKS   数据库链信息. 665. USER_DEPENDENCIES   因户的对象之间的依赖关系. 666. USER_DIM_ATTRIBUTES   当前用户模式下维级别和功能依赖之间的关系. 667. USER_DIM_CHILD_OF   当前用户拥有的1到N维水平的层次关系. 668. USER_DIM_HIERARCHIES   当前用户拥有的维的层次. 669. USER_DIM_JOIN_KEY   当前用户拥有的维之间的连接. 670. USER_DIM_LEVEL_KEY   当前用户拥有的一个维级的列. 671. USER_DIM_LEVELS   当前用户拥有的一个维列. 672. USER_DIMENSIONS   当前用户模式下维对象. 673. USER_ERRORS   用户的所有存储对象上的当前错误. 674. USER_EXTENTS   属于用户对象的段的范围. 675. USER_EXTERNAL_TABLES   当前用户拥有的所有的外部对象. 676. USER_FREE_SPACE   用户可存取表空间中的空闲范围. 678. USER_HISTOGRAMS   该视图是USER_HISTOGRAMS的同义词. 679. USER_IND_COLUMNS   用户索引和表上的列. 680. USER_IND_EXPRESSIONS   当前用户拥有的表上基于函数的索引的表达式. 681. USER_IND_SUBPARTITIONS   当前用户拥有的每个字分区的属性,分区级别的分区信息,子分区的存储参数,ANALYZE决定的各种分区统计. 682. USER_INDEXES    当前用户拥有的索引的说明. 683. USER_INDEXTYPE_COMMENTS   当前用户拥有的用户定义的索引类型的所有注释. 684. USER_INDEXTYPE_OPERATORS   当前用户拥有的索引类型的所有操作. 685. USER_INDEXTYPES   当前用户拥有的所有索引类型. 686. USER_INTERNAL_TRIGGERS   当前用户拥有的所有表上的内部触发器. 687. USER_JOBS   用户拥有的所有作业. 688. USER_JOIN_IND_COLUMNS   当前用户拥有的数据库中所有的连接条件. 689. USER_LIBRARIES   列出用户拥有的所有库. 690. USER_LOB_PARTITIONS   当前用户拥有的LOB数据子分区中的分区级属性. 691. USER_LOBS   显示用户表中包含的LOB. 692. USER_LOG_GROUP_COLUMNS   当前用户拥有的在日志中指定的列. 693. USER_LOG_GROUPS   数据库中当前用户拥有的所有表的日志组定义. 694. USER_METHOD_PARAMS   当前用户拥有的用户类型的方法参数. 695. USER_MVIEW_AGGREGATES   当前用户拥有的在聚集实例化视图的SELECT列表中出现的分组函数. 696. USER_MVIEW_ANALYSIS   当前用户拥有的所有的物化视图用来潜在地支持查询重写并有可用于应用程序分析的附加信息. 697. USER_MVIEW_DETAIL_RELATIONS   代表命名细节关系. 698. USER_MVIEW_JOINS   描述在一个实例化视图的WHERE子句中,两个列之间的连接. 699. USER_MVIEW_KEYS   物化视图基于当前用户模式的在SELECT列表中的列或表达式. 700. USER_MVIEW_REFRESH_TIMES   数据库中当前用户拥有的所有的物化视图的刷新时间.   701. USER_MVIEWS   数据库中当前用户拥有的所有的物化视图. 702. USER_NESTED_TABLES   当前用户拥有的表中的嵌套表. 703. USER_OBJ_AUDIT_OPTS   用户拥有的表和视图的审计选项. 704. USER_OBJECT_SIZE   用户拥有的PL/SQL对象的大小. 705. USER_OBJECT_TABLES   用户拥有的对象表.   706. USER_OBJECT   用户拥有的对象. 707. USER_OPANCILLARY   当前用户拥有的操作的辅助信息. 708. USER_OPARGUMENTS   当前用户拥有的操作的论据信息. 709. USER_OPBINDINGS   当前用户拥有的操作的绑定. 710. USER_OPERATOR_COMMENTS   当前用户拥有的用户自定义的操作的所有注释. 711. USER_OPERATORS   当前用户拥有的所有操作. 712. USER_OUTLINE_HINTS   当前用户拥有的组成概要的暗示的设置. 713. USER_OUTLINES   当前用户拥有的所有概要. 714. USER_PART_COL_STATISTICS   当前用户拥有的表分区的列统计和柱状图数据.   715. USER_PART_HISTOGRAMS   当前用户可存取的表分区上柱状图数据. 716. USER_PART_KEY_COLUMNS   当前用户拥有的分区对象的分区键列. 717. USER_PART_INDEXES   当前用户拥有的所有分区所有的对象级分区信息. 718. USER_PART_LOBS   当前用户拥有的分区大型对象的表级信息. 719. USER_PART_TABLES   当前用户拥有的分区表的对象级分区信息. 720. USER_PARTIAL_DROP_TABS   当前用户模式下有部分删除表操作的所有表. 721. USER_PASSWORD_LIMITS   分配给用户的口令参数文件. 722. USER_POLICIES   当前用户拥有的所有对象的安全策略. 723. USER_PROCEDURES   当前用户拥有的所有的函数和过错以及它们的相关属性. 724. USER_PROXIES   当前用户被允许代理的连接信息. 725. USER_PUBLISHED_COLUMNS   描述有特权的所有存在的源表列. 726. USER_QUEUE_SCHEDULES   关于队列时间表的信息. 727. USER_QUEUE_TABLES   只描述用户模式中创建的队列表中的队列. 728. USER_QUEUES   用户模式中的每个队列的所有刷新组. 729. USER_REFRESH   当前用户拥有的所有刷新组. 730. USER_REFRESH_CHILDREN   列出刷新组中的所有对象. 731. USER_REFS   用户表的对象类型列中的REF列和REF属性. 732. USER_REGISTERED_MVIEWS   当前用户拥有的所有注册的物化视图.   733. USER_REGISTERED_SNAPSHOTS   当前用户拥有的所有注册的快照. 734. USER_RESOURCE_LIMITS   当前用户的资源限制. 735. USER_RESUMABLE   列出当前用户执行的可恢复语句. 736. USER_ROLS_PRIVS   列出授予用户的角色. 737. USER_RSRC_CONSUMER_GROUP_PRIVS   列出授予用户的所有的资源消耗组. 738. USER_RSRC_MANAGER_SYSTEM_PRIVS   列出所有被授予了DBMS_RESOURCE_MANAGER包的系统特权的用户. 739. USER_SEGMENTS   列出属于用户对象的数据库段的存储分配信息. 740. USER_SEQUENCES   用户序列的说明. 741. USER_SNAPSHOT_LOGS   用户拥有的所有快照日志. 742. USER_SNAPSHOT_REFRESH_TIMES   快照刷新的次数. 743. USER_SNAPSHOTS   用户可查看的快照. 744. USER_SOURCE   属于用户的所有存储对象的文本来源. 745. USER_SORCE_TABLES   允许你查看所有有预定特权的现有的源表. 746. USER_SQLJ_TYPE_ATTRS   当前用户拥有的关于SQLJ对象的所有属性.      747. USER_SQLJ_TYPE_METHODS   当前用户拥有的类型方法.   748. USER_SQLJ_TYPES   当前用户拥有的关于SQLJ对象类型信息.   749. USER_STORED_SETTINGS   当前用户拥有的存储的PL/SQL单元的永久参数设置. 750. USER_SUBPART_COL_STATISTICS   显示当前用户拥有的子分区对象的子分区的列统计和柱状图信息.    751. USER_SUBPART_HISTOGRAMS   显示当前用户拥有的表子分区中柱状图的实际柱状图数据.   752. USER_SUBPART_KEY_COLUMNS   显示当前用户拥有的子分区对象的子分区的列统计和柱状图信息. 753. USER_SUBSCRIBED_COLUMNS   允许发行者查看所有的预定的所有发行的列.   754. USER_SUBSCRIBED_TABLES   允许发行者查看所有的预定的所有发行的表. 755. USER_SUBSCRIPTIONS   允许发行者查看所有的预定. 756. USER_SYSNONYMS   当前用户拥有的私人同义词. 757. USER_SYS_PRIVS   授予用户的系统特权. 758. USER_TAB_COL_STATISTICS   包含USER_TAB_COLUMNS视图中的列统计和柱状图信息. 759. USER_TAB_COLUMNS   用户表或视图或聚集上的列的信息. 760. USER_TAB_COMMENTS   用户拥有表或视图上的注释. 761. USER_TAB_HISTOGRAMS   用户表的列上的柱状图. 762. USER_TAB_MODIFICATIONS   用户拥有了的所有上次统计后被修改了的表. 763. USER_TAB_PARTITIONS   用户拥有的每个表子分区的名称,存储属性,其所属表和分区名. 764. USER_TAB_PRIVS   对象上的特权. 765. USER_TAB_PRIVS_MADE   用户拥有对象上的全部特权. 766. USER_TAB_PRIVS_RECD   包含对象上的特权,用户为被授予者. 767. USER_TAB_SUBPARTITIONS   用户拥有的每个子分区的名称,存储属性,其所属表和分区名. 768. USER_TABLES   用户拥有的关系表的描述. 769. USER_TABLESPACES   可存取的表空间的描述. 770. USER_TRANSFORMATIONS   特定用户拥有的转变信息. 771. USER_TRIGGER_COLS   用户触发器中列的用法. 772. USER_TRIGGERS   用户触发器的说明. 773. USER_TYPES   表中用户的类型. 774. USER_TYPE_ATTRS   用户的类型的属性. 775. USER_TS_QUOTAS   用户的表空间限额. 776. USER_METHODS   用户的方法类型. 777. USER_UNUSED_COL_TABS   包含了未用列的所有表. 778. USER_UPDATABLE_COLUMNS   在连接视图中对用户可修改的列的描述. 779. USER_USERS   当前用户的信息. 780. USER_USTATS   用户拥有的用户定义统计. 781. USER_VARRAYS   用户拥有的所有数组. 782. USER_VIEWS   用户拥有的视图的文本.   =====================全部原版===================================        select * from dictionary;                   TABLE_NAME        COMMENTS1        ALL_ALL_TABLES        Description of all object and relational tables accessible to the user2        ALL_APPLY        Details about each apply process that dequeues from the queue visible to the current user3        ALL_APPLY_CONFLICT_COLUMNS        Details about conflict resolution on tables visible to the current user4        ALL_APPLY_DML_HANDLERS        Details about the dml handler on tables visible to the current user5        ALL_APPLY_ERROR        Error transactions that were generated after dequeuing from the queue visible to the current user6        ALL_APPLY_KEY_COLUMNS        Alternative key columns for a STREAMS table visible to the current user7        ALL_APPLY_PARAMETERS        Details about parameters of each apply process that dequeues from the queue visible to the current user8        ALL_APPLY_PROGRESS        Information about the progress made by the apply process that dequeues from the queue visible to the current user9        ALL_ARGUMENTS        Arguments in object accessible to the user10        ALL_ASSOCIATIONS        All associations available to the user11        ALL_AUDIT_POLICIES        All fine grained auditing policies in the database12        ALL_BASE_TABLE_MVIEWS        All materialized views with log(s) in the database that the user can see13        ALL_CAPTURE        Details about each capture process that stores the captured changes in a queue visible to the current user14        ALL_CAPTURE_PARAMETERS        Details about parameters for each capture process that stores the captured changes in a queue visible to the current user15        ALL_CAPTURE_PREPARED_DATABASE        Is the local database prepared for instantiation?16        ALL_CAPTURE_PREPARED_SCHEMAS        All user schemas at the local database that are prepared for instantiation17        ALL_CAPTURE_PREPARED_TABLES        All tables visible to the current user that are prepared for instantiation18        ALL_CATALOG        "All tables, views, synonyms, sequences accessible to the user"19        ALL_CLUSTERS        Description of clusters accessible to the user20        ALL_CLUSTER_HASH_EXPRESSIONS        Hash functions for all accessible clusters21        ALL_COLL_TYPES        Description of named collection types accessible to the user22        ALL_COL_COMMENTS        Comments on columns of accessible tables and views23        ALL_COL_PRIVS        "Grants on columns for which the user is the grantor, grantee, owner,or an enabled role or PUBLIC is the grantee"24        ALL_COL_PRIVS_MADE        Grants on columns for which the user is owner or grantor25        ALL_COL_PRIVS_RECD        "Grants on columns for which the user, PUBLIC or enabled role is the grantee"26        ALL_CONSTRAINTS        Constraint definitions on accessible tables27        ALL_CONS_COLUMNS        Information about accessible columns in constraint definitions28        ALL_CONS_OBJ_COLUMNS        List of types an object column or attribute is constrained to in the tables accessible to the user29        ALL_CONTEXT        Description of all active context namespaces under the current session30        ALL_DB_LINKS        Database links accessible to the user31        ALL_DEF_AUDIT_OPTS        Auditing options for newly created objects32        ALL_DEPENDENCIES        Dependencies to and from objects accessible to the user33        ALL_DIMENSIONS        Description of the dimension objects accessible to the DBA34        ALL_DIM_ATTRIBUTES        "Representation of the relationship between a dimension level anda functionally dependent column"35        ALL_DIM_CHILD_OF        "Representaion of a 1:n hierarchical relationship between a pair of levels ina dimension"36        ALL_DIM_HIERARCHIES        Representation of a dimension hierarchy37        ALL_DIM_JOIN_KEY        Representation of a join between two dimension tables. 38        ALL_DIM_LEVELS        Description of dimension levels visible to DBA39        ALL_DIM_LEVEL_KEY        Representations of columns of a dimension level40        ALL_DIRECTORIES        Description of all directories accessible to the user41        ALL_ERRORS        Current errors on stored objects that user is allowed to create42        ALL_EVALUATION_CONTEXTS        rule evaluation contexts seen by user43        ALL_EVALUATION_CONTEXT_TABLES        tables in all rule evaluation contexts seen by the user44        ALL_EVALUATION_CONTEXT_VARS        variables in all rule evaluation contexts seen by the user45        ALL_EXTERNAL_LOCATIONS        Description of the external tables locations accessible to the user46        ALL_EXTERNAL_TABLES        Description of the external tables accessible to the user47        ALL_INDEXES        Descriptions of indexes on tables accessible to the user48        ALL_INDEXTYPES        All indextypes available to the user49        ALL_INDEXTYPE_COMMENTS        Comments for user-defined indextypes50        ALL_INDEXTYPE_OPERATORS        All operators available to the user51        ALL_IND_COLUMNS        COLUMNs comprising INDEXes on accessible TABLES52        ALL_IND_EXPRESSIONS        FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES53        ALL_IND_PARTITIONS        54        ALL_IND_SUBPARTITIONS        55        ALL_INTERNAL_TRIGGERS        Description of the internal triggers on the tables accessible to the user56        ALL_JOIN_IND_COLUMNS        Join Index columns comprising the join conditions57        ALL_LIBRARIES        Description of libraries accessible to the user58        ALL_LOBS        Description of LOBs contained in tables accessible to the user59        ALL_LOB_PARTITIONS        60        ALL_LOB_SUBPARTITIONS        61        ALL_LOB_TEMPLATES        62        ALL_LOG_GROUPS        Log group definitions on accessible tables63        ALL_LOG_GROUP_COLUMNS        Information about columns in log group definitions64        ALL_METHOD_PARAMS        "Description of method parameters of types accessibleto the user"65        ALL_METHOD_RESULTS        "Description of method results of types accessibleto the user"66        ALL_MVIEWS        All materialized views in the database67        ALL_MVIEW_AGGREGATES        Description of the materialized view aggregates accessible to the user68        ALL_MVIEW_ANALYSIS        Description of the materialized views accessible to the user69        ALL_MVIEW_DETAIL_RELATIONS        Description of the materialized view detail tables accessible to the user70        ALL_MVIEW_JOINS        "Description of a join between two columns in theWHERE clause of a materialized view accessible to the user"71        ALL_MVIEW_KEYS        "Description of the columns that appear in the GROUP BYlist of a materialized view accessible to the user"72        ALL_MVIEW_LOGS        All materialized view logs in the database that the user can see73        ALL_MVIEW_REFRESH_TIMES        Materialized views and their last refresh times  for each master table that the user can look at74        ALL_NESTED_TABLES        Description of nested tables in tables accessible to the user75        ALL_OBJECTS        Objects accessible to the user76        ALL_OBJECT_TABLES        Description of all object tables accessible to the user77        ALL_OBJ_COLATTRS        Description of object columns and attributes contained in the tables accessible to the user78        ALL_OPANCILLARY        All ancillary operators available to the user79        ALL_OPARGUMENTS        All arguments of the operators available to the user80        ALL_OPBINDINGS        All binding functions for operators available to the user81        ALL_OPERATORS        All operators available to the user82        ALL_OPERATOR_COMMENTS        Comments for user-defined operators83        ALL_PARTIAL_DROP_TABS        All tables with patially dropped columns accessible to the user84        ALL_PART_COL_STATISTICS        85        ALL_PART_HISTOGRAMS        86        ALL_PART_INDEXES        87        ALL_PART_KEY_COLUMNS        88        ALL_PART_LOBS        89        ALL_PART_TABLES        90        ALL_PENDING_CONV_TABLES        All tables accessible to the user which are not upgraded to the latest type version91        ALL_POLICIES        All policies for objects if the user has system privileges or owns the objects92        ALL_POLICY_CONTEXTS        "All policy driving context defined for all synonyms, tables, or views accessable to the user"93        ALL_POLICY_GROUPS        "All policy groups defined for any synonym, table or view accessable to the user"94        ALL_PROBE_OBJECTS        95        ALL_PROCEDURES        Description of all procedures available to the user96        ALL_PROPAGATION        Streams propagation seen by the user97        ALL_PUBLISHED_COLUMNS        98        ALL_QUEUES        All queues accessible to the user99        ALL_QUEUE_PUBLISHERS        100        ALL_QUEUE_TABLES        All queue tables accessible to the user101        ALL_REFRESH        All the refresh groups that the user can touch102        ALL_REFRESH_CHILDREN        "All the objects in refresh groups, where the user can touch the group"103        ALL_REFRESH_DEPENDENCIES        "Description of the detail tables that materialized views depend on forrefresh"104        ALL_REFS        Description of REF columns contained in tables accessible to the user105        ALL_REGISTERED_MVIEWS        Remote materialized views of local tables that the user can see106        ALL_REGISTERED_SNAPSHOTS        Remote snapshots of local tables that the user can see107        ALL_REGISTRY_BANNERS        108        ALL_REPAUDIT_ATTRIBUTE        Information about attributes automatically maintained for replication109        ALL_REPAUDIT_COLUMN        Information about columns in all shadow tables for replicated tables which are accessible to the user110        ALL_REPCAT        111        ALL_REPCATLOG        Information about asynchronous administration requests112        ALL_REPCOLUMN        Replicated top-level columns (table) sorted alphabetically in ascending order113        ALL_REPCOLUMN_GROUP        All column groups of replicated tables which are accessible to the user114        ALL_REPCONFLICT        All conflicts with available resolutions for user's replicated tables115        ALL_REPDDL        Arguments that do not fit in a single repcat log record116        ALL_REPFLAVORS        Flavors defined for replicated object groups117        ALL_REPFLAVOR_COLUMNS        Replicated columns in flavors118        ALL_REPFLAVOR_OBJECTS        Replicated objects in flavors119        ALL_REPGENERATED        Objects generated to support replication120        ALL_REPGENOBJECTS        Objects generated to support replication121        ALL_REPGROUP        Information about replicated object groups122        ALL_REPGROUPED_COLUMN        Columns in the all column groups of replicated tables which are accessible to the user123        ALL_REPGROUP_PRIVILEGES        Information about users who are registered for object group privileges124        ALL_REPKEY_COLUMNS        Primary columns for a table using column-level replication125        ALL_REPOBJECT        Information about replicated objects126        ALL_REPPARAMETER_COLUMN        All columns used for resolving conflicts in replicated tables which are accessible to the user127        ALL_REPPRIORITY        Values and their corresponding priorities in all priority groups which are accessible to the user128        ALL_REPPRIORITY_GROUP        Information about all priority groups which are accessible to the user129        ALL_REPPROP        Propagation information about replicated objects130        ALL_REPRESOLUTION        Description of all conflict resolutions for replicated tables which are accessible to the user131        ALL_REPRESOLUTION_METHOD        All conflict resolution methods accessible to the user132        ALL_REPRESOLUTION_STATISTICS        Statistics for conflict resolutions for replicated tables which are accessible to the user133        ALL_REPRESOL_STATS_CONTROL        Information about statistics collection for conflict resolutions for replicated tables which are accessible to the user134        ALL_REPSCHEMA        N-way replication information135        ALL_REPSITES        N-way replication information136        ALL_RULES        Rules seen by the user137        ALL_RULESETS        Rulesets seen by the user: maintained for backward compatibility138        ALL_RULE_SETS        Rule sets seen by the user139        ALL_RULE_SET_RULES        Rules in all rule sets seen by the user140        ALL_SECONDARY_OBJECTS        All secondary objects for domain indexes141        ALL_SEQUENCES        Description of SEQUENCEs accessible to the user142        ALL_SNAPSHOTS        Snapshots the user can access143        ALL_SNAPSHOT_LOGS        All snapshot logs in the database that the user can see144        ALL_SOURCE        Current source on stored objects that user is allowed to create145        ALL_SOURCE_TABLES        146        ALL_SOURCE_TAB_COLUMNS        147        ALL_SQLJ_TYPES        Description of types accessible to the user148        ALL_SQLJ_TYPE_ATTRS        Description of attributes of types accessible to the user149        ALL_SQLJ_TYPE_METHODS        Description of methods of types accessible to the user150        ALL_STORED_SETTINGS        Parameter settings for objects accessible to the user151        ALL_STREAMS_GLOBAL_RULES        Global rules created on the streams capture/apply/propagation process that interact with the queue visible to the current user152        ALL_STREAMS_SCHEMA_RULES        Rules created by streams administrative APIs on all user schemas153        ALL_STREAMS_TABLE_RULES        Rules created by streams administrative APIs on tables visible to the current user154        ALL_SUBPARTITION_TEMPLATES        155        ALL_SUBPART_COL_STATISTICS        156        ALL_SUBPART_HISTOGRAMS        157        ALL_SUBPART_KEY_COLUMNS        158        ALL_SUBSCRIBED_COLUMNS        159        ALL_SUBSCRIBED_TABLES        160        ALL_SUBSCRIPTIONS        161        ALL_SUMDELTA        Direct path load entries accessible to the user162        ALL_SUMMARIES        Description of the summaries accessible to the user163        ALL_SYNONYMS        All synonyms accessible to the user164        ALL_TABLES        Description of relational tables accessible to the user165        ALL_TAB_COLS        "Columns of user's tables, views and clusters"166        ALL_TAB_COLUMNS        "Columns of user's tables, views and clusters"167        ALL_TAB_COL_STATISTICS        "Columns of user's tables, views and clusters"168        ALL_TAB_COMMENTS        Comments on tables and views accessible to the user169        ALL_TAB_HISTOGRAMS        Histograms on columns of all tables visible to user170        ALL_TAB_MODIFICATIONS        Information regarding modifications to tables171        ALL_TAB_PARTITIONS        172        ALL_TAB_PRIVS        "Grants on objects for which the user is the grantor, grantee, owner,or an enabled role or PUBLIC is the grantee"173        ALL_TAB_PRIVS_MADE        User's grants and grants on user's objects174        ALL_TAB_PRIVS_RECD        "Grants on objects for which the user, PUBLIC or enabled role is the grantee"175        ALL_TAB_SUBPARTITIONS        176        ALL_TRIGGERS        Triggers accessible to the current user177        ALL_TRIGGER_COLS        Column usage in user's triggers or in triggers on user's tables178        ALL_TYPES        Description of types accessible to the user179        ALL_TYPE_ATTRS        Description of attributes of types accessible to the user180        ALL_TYPE_METHODS        Description of methods of types accessible to the user181        ALL_TYPE_VERSIONS        Description of each type version accessible to the user182        ALL_UNUSED_COL_TABS        All tables with unused columns accessible to the user183        ALL_UPDATABLE_COLUMNS        Description of all updatable columns184        ALL_USERS        Information about all users of the database185        ALL_USTATS        All statistics186        ALL_VARRAYS        Description of varrays in tables accessible to the user187        ALL_VIEWS        Description of views accessible to the user188        ALL_WORKSPACES        189        DBA_2PC_NEIGHBORS        information about incoming and outgoing connections for pending transactions190        DBA_2PC_PENDING        info about distributed transactions awaiting recovery191        DBA_ALL_TABLES        Description of all object and relational tables in the database192        DBA_ANALYZE_OBJECTS        193        DBA_APPLY        Details about the apply process194        DBA_APPLY_CONFLICT_COLUMNS        Details about conflict resolution195        DBA_APPLY_DML_HANDLERS        Details about the dml handler196        DBA_APPLY_ERROR        Error transactions197        DBA_APPLY_INSTANTIATED_OBJECTS        Details about objects instantiated198        DBA_APPLY_KEY_COLUMNS        alternative key columns for a table for STREAMS199        DBA_APPLY_PARAMETERS        All parameters for apply process200        DBA_APPLY_PROGRESS        Information about the progress made by apply process201        DBA_AQ_AGENTS        202        DBA_AQ_AGENT_PRIVS        203        DBA_ASSOCIATIONS        All associations204        DBA_ATTRIBUTE_TRANSFORMATIONS        205        DBA_AUDIT_EXISTS        Lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS206        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"207        DBA_AUDIT_POLICIES        All fine grained auditing policies in the database208        DBA_AUDIT_SESSION        All audit trail records concerning CONNECT and DISCONNECT209        DBA_AUDIT_STATEMENT        "Audit trail records concerning  grant, revoke, audit, noaudit and alter system"210        DBA_AUDIT_TRAIL        All audit trail entries211        DBA_AWS        Analytic Workspaces in the database212        DBA_AW_PS        Pagespaces in Analytic Workspaces owned by the user213        DBA_BASE_TABLE_MVIEWS        All materialized views with log(s) in the database214        DBA_BLOCKERS        215        DBA_CACHEABLE_NONTABLE_OBJECTS        216        DBA_CACHEABLE_OBJECTS        217        DBA_CACHEABLE_OBJECTS_BASE        218        DBA_CACHEABLE_TABLES        219        DBA_CACHEABLE_TABLES_BASE        220        DBA_CAPTURE        Details about the capture process221        DBA_CAPTURE_PARAMETERS        All parameters for capture process222        DBA_CAPTURE_PREPARED_DATABASE        Is the local database prepared for instantiation?223        DBA_CAPTURE_PREPARED_SCHEMAS        All schemas at the local database that are prepared for instantiation224        DBA_CAPTURE_PREPARED_TABLES        All tables prepared for instantiation225        DBA_CATALOG        "All database Tables, Views, Synonyms, Sequences"226        DBA_CLUSTERS        Description of all clusters in the database227        DBA_CLUSTER_HASH_EXPRESSIONS        Hash functions for all clusters228        DBA_CLU_COLUMNS        Mapping of table columns to cluster columns229        DBA_COLL_TYPES        Description of all named collection types in the database230        DBA_COL_COMMENTS        Comments on columns of all tables and views231        DBA_COL_PRIVS        All grants on columns in the database232        DBA_CONSTRAINTS        Constraint definitions on all tables233        DBA_CONS_COLUMNS        Information about accessible columns in constraint definitions234        DBA_CONS_OBJ_COLUMNS        List of types an object column or attribute is constrained to in all tables in the database235        DBA_CONTEXT        Description of all context namespace information236        DBA_DATA_FILES        Information about database data files237        DBA_DB_LINKS        All database links in the database238        DBA_DDL_LOCKS        239        DBA_DEPENDENCIES        Dependencies to and from objects240        DBA_DIMENSIONS        Description of the dimension objects accessible to the DBA241        DBA_DIM_ATTRIBUTES        "Representation of the relationship between a dimension level anda functionally dependent column"242        DBA_DIM_CHILD_OF        "Representaion of a 1:n hierarchical relationship between a pair of levels ina dimension"243        DBA_DIM_HIERARCHIES        Representation of a dimension hierarchy244        DBA_DIM_JOIN_KEY        Representation of a join between two dimension tables. 245        DBA_DIM_LEVELS        Description of dimension levels visible to DBA246        DBA_DIM_LEVEL_KEY        Representations of columns of a dimension level247        DBA_DIRECTORIES        Description of all directories248        DBA_DML_LOCKS        249        DBA_DMT_FREE_SPACE        Free extents in all dictionary managed tablespaces250        DBA_DMT_USED_EXTENTS        All extents in the dictionary managed tablespaces251        DBA_ERRORS        Current errors on all stored objects in the database252        DBA_EVALUATION_CONTEXTS        rule evaluation contexts in the database253        DBA_EVALUATION_CONTEXT_TABLES        tables in all rule evaluation contexts in the database254        DBA_EVALUATION_CONTEXT_VARS        variables in all rule evaluation contexts in the database255        DBA_EXP_FILES        Description of export files256        DBA_EXP_OBJECTS        Objects that have been incrementally exported257        DBA_EXP_VERSION        Version number of the last export session258        DBA_EXTENTS        Extents comprising all segments in the database259        DBA_EXTERNAL_LOCATIONS        Description of the external tables locations accessible to the DBA260        DBA_EXTERNAL_TABLES        Description of the external tables accessible to the DBA261        DBA_FGA_AUDIT_TRAIL        All fine grained audit event logs262        DBA_FREE_SPACE        Free extents in all tablespaces263        DBA_FREE_SPACE_COALESCED        Statistics on Coalesced Space in Tablespaces264        DBA_GLOBAL_CONTEXT        Description of all context information accessible globally265        DBA_IAS_CONSTRAINT_EXP        266        DBA_IAS_GEN_STMTS        267        DBA_IAS_GEN_STMTS_EXP        268        DBA_IAS_OBJECTS        269        DBA_IAS_OBJECTS_BASE        270        DBA_IAS_OBJECTS_EXP        271        DBA_IAS_POSTGEN_STMTS        272        DBA_IAS_PREGEN_STMTS        273        DBA_IAS_SITES        274        DBA_IAS_TEMPLATES        275        DBA_INDEXES        Description for all indexes in the database276        DBA_INDEXTYPES        All indextypes277        DBA_INDEXTYPE_COMMENTS        Comments for user-defined indextypes278        DBA_INDEXTYPE_OPERATORS        All indextype operators279        DBA_IND_COLUMNS        COLUMNs comprising INDEXes on all TABLEs and CLUSTERs280        DBA_IND_EXPRESSIONS        FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLUSTERS281        DBA_IND_PARTITIONS        282        DBA_IND_SUBPARTITIONS        283        DBA_INTERNAL_TRIGGERS        Description of the internal triggers on all tables in the database284        DBA_JOBS        All jobs in the database285        DBA_JOBS_RUNNING        "All jobs in the database which are currently running, join v$lock and job$"286        DBA_JOIN_IND_COLUMNS        Join Index columns comprising the join conditions287        DBA_KGLLOCK        288        DBA_LIBRARIES        Description of all libraries in the database289        DBA_LMT_FREE_SPACE        Free extents in all locally managed tablespaces290        DBA_LMT_USED_EXTENTS        All extents in the locally managed tablespaces291        DBA_LOBS        Description of LOBs contained in all tables292        DBA_LOB_PARTITIONS        293        DBA_LOB_SUBPARTITIONS        294        DBA_LOB_TEMPLATES        295        DBA_LOCK        296        DBA_LOCK_INTERNAL        297        DBA_LOGSTDBY_EVENTS        Information on why logical standby events298        DBA_LOGSTDBY_NOT_UNIQUE        List of all the tables with out primary or unique key not null constraints299        DBA_LOGSTDBY_PARAMETERS        Miscellaneous options and settings for Logical Standby300        DBA_LOGSTDBY_PROGRESS        List the SCN values describing read and apply progress301        DBA_LOGSTDBY_SKIP        List the skip settings choosen302        DBA_LOGSTDBY_SKIP_TRANSACTION        List the transactions to be skipped303        DBA_LOGSTDBY_UNSUPPORTED        List of all the columns that are not supported by Logical Standby304        DBA_LOG_GROUPS        Log group definitions on all tables305        DBA_LOG_GROUP_COLUMNS        Information about columns in log group definitions306        DBA_METHOD_PARAMS        Description of method parameters of all types in the database307        DBA_METHOD_RESULTS        Description of method results of all types in the database308        DBA_MVIEWS        All materialized views in the database309        DBA_MVIEW_AGGREGATES        Description of the materialized view aggregates accessible to dba310        DBA_MVIEW_ANALYSIS        Description of the materialized views accessible to dba311        DBA_MVIEW_DETAIL_RELATIONS        Description of the materialized view detail tables accessible to dba312        DBA_MVIEW_JOINS        "Description of a join between two columns in theWHERE clause of a materialized view accessible to dba"313        DBA_MVIEW_KEYS        "Description of the columns that appear in the GROUP BYlist of a materialized view accessible to dba"314        DBA_MVIEW_LOGS        All materialized view logs in the database315        DBA_MVIEW_LOG_FILTER_COLS        All filter columns (excluding PK cols) being logged in the materialized view logs316        DBA_MVIEW_REFRESH_TIMES        All fast refreshable materialized views and their last refresh times for each master table317        DBA_NESTED_TABLES        Description of nested tables contained in all tables318        DBA_OBJECTS        All objects in the database319        DBA_OBJECT_SIZE        "Sizes, in bytes, of various pl/sql objects"320        DBA_OBJECT_TABLES        Description of all object tables in the database321        DBA_OBJ_AUDIT_OPTS        Auditing options for all tables and views322        DBA_OBJ_COLATTRS        Description of object columns and attributes contained in all tables in the database323        DBA_OPANCILLARY        All ancillary operators324        DBA_OPARGUMENTS        All operator arguments325        DBA_OPBINDINGS        All operator binding functiosn or methods326        DBA_OPERATORS        All operators327        DBA_OPERATOR_COMMENTS        Comments for user-defined operators328        DBA_OUTLINES        Stored outlines329        DBA_OUTLINE_HINTS        Hints stored in outlines330        DBA_PARTIAL_DROP_TABS        All tables with partially dropped columns in the database331        DBA_PART_COL_STATISTICS        332        DBA_PART_HISTOGRAMS        333        DBA_PART_INDEXES        334        DBA_PART_KEY_COLUMNS        335        DBA_PART_LOBS        336        DBA_PART_TABLES        337        DBA_PENDING_CONV_TABLES        All tables which are not upgraded to the latest type version in the database338        DBA_PENDING_TRANSACTIONS        information about unresolved global transactions339        DBA_POLICIES        All row level security policies in the database340        DBA_POLICY_CONTEXTS        "All policy driving context defined for any synonym, table, or view in the database"341        DBA_POLICY_GROUPS        "All policy groups defined for any synonym, table, view in the database"342        DBA_PRIV_AUDIT_OPTS        Describes current system privileges being audited across the system and by user343        DBA_PROCEDURES        Description of all procedures344        DBA_PROFILES        Display all profiles and their limits345        DBA_PROPAGATION        Streams propagation in the database346        DBA_PROXIES        Information about all proxy connections347        DBA_PUBLISHED_COLUMNS        348        DBA_QUEUES        All database queues349        DBA_QUEUE_PUBLISHERS        350        DBA_QUEUE_SCHEDULES        351        DBA_QUEUE_TABLES        All queue tables created in the database352        DBA_RCHILD        All the children in any refresh group.  This view is not a join.353        DBA_REFRESH        All the refresh groups354        DBA_REFRESH_CHILDREN        All the objects in refresh groups355        DBA_REFS        Description of REF columns contained in all tables356        DBA_REGISTERED_MVIEWS        Remote materialized views of local tables357        DBA_REGISTERED_MVIEW_GROUPS        Materialized view repgroup registration information358        DBA_REGISTERED_SNAPSHOTS        Remote snapshots of local tables359        DBA_REGISTERED_SNAPSHOT_GROUPS        Snapshot repgroup registration information360        DBA_REGISTRY        361        DBA_REGISTRY_HIERARCHY        362        DBA_REPAUDIT_ATTRIBUTE        Information about attributes automatically maintained for replication363        DBA_REPAUDIT_COLUMN        Information about columns in all shadow tables for all replicated tables in the database364        DBA_REPCAT        365        DBA_REPCATLOG        Information about asynchronous administration requests366        DBA_REPCAT_EXCEPTIONS        Repcat processing exceptions table.367        DBA_REPCOLUMN        Replicated top-level columns (table) sorted alphabetically in ascending order368        DBA_REPCOLUMN_GROUP        All column groups of replicated tables in the database369        DBA_REPCONFLICT        All conflicts for which users have specified resolutions in the database370        DBA_REPDDL        Arguments that do not fit in a single repcat log record371        DBA_REPEXTENSIONS        Information about replication extension requests372        DBA_REPFLAVORS        Flavors defined for replicated object groups373        DBA_REPFLAVOR_COLUMNS        Replicated columns in flavors374        DBA_REPFLAVOR_OBJECTS        Replicated objects in flavors375        DBA_REPGENERATED        Objects generated to support replication376        DBA_REPGENOBJECTS        Objects generated to support replication377        DBA_REPGROUP        Information about all replicated object groups378        DBA_REPGROUPED_COLUMN        Columns in the all column groups of replicated tables in the database379        DBA_REPGROUP_PRIVILEGES        Information about users who are registered for object group privileges380        DBA_REPKEY_COLUMNS        Primary columns for a table using column-level replication381        DBA_REPOBJECT        Information about replicated objects382        DBA_REPPARAMETER_COLUMN        All columns used for resolving conflicts in the database383        DBA_REPPRIORITY        Values and their corresponding priorities in all priority groups in the database384        DBA_REPPRIORITY_GROUP        Information about all priority groups in the database385        DBA_REPPROP        Propagation information about replicated objects386        DBA_REPRESOLUTION        Description of all conflict resolutions in the database387        DBA_REPRESOLUTION_METHOD        All conflict resolution methods in the database388        DBA_REPRESOLUTION_STATISTICS        Statistics for conflict resolutions for all replicated tables in the database389        DBA_REPRESOL_STATS_CONTROL        Information about statistics collection for conflict resolutions for all replicated tables in the database390        DBA_REPSCHEMA        N-way replication information391        DBA_REPSITES        N-way replication information392        DBA_REPSITES_NEW        Information about new masters for replication extension393        DBA_RESUMABLE        Resumable session information in the system394        DBA_RGROUP        All refresh groups.  This view is not a join.395        DBA_ROLES        All Roles which exist in the database396        DBA_ROLE_PRIVS        Roles granted to users and roles397        DBA_ROLLBACK_SEGS        Description of rollback segments398        DBA_RSRC_CONSUMER_GROUPS        all the resource consumer groups399        DBA_RSRC_CONSUMER_GROUP_PRIVS        Switch privileges for consumer groups400        DBA_RSRC_MANAGER_SYSTEM_PRIVS        system privileges for the resource manager401        DBA_RSRC_PLANS        All the resource plans402        DBA_RSRC_PLAN_DIRECTIVES        all the resource plan directives403        DBA_RULES        Rules in the databse404        DBA_RULESETS        Rulesets in the database: maintained for backward compatibility405        DBA_RULE_SETS        Rule sets in the database406        DBA_RULE_SET_RULES        Rules in all rule sets in the database407        DBA_SECONDARY_OBJECTS        All secondary objects for domain indexes408        DBA_SEGMENTS        Storage allocated for all database segments409        DBA_SEQUENCES        Description of all SEQUENCEs in the database410        DBA_SNAPSHOTS        All snapshots in the database411        DBA_SNAPSHOT_LOGS        All snapshot logs in the database412        DBA_SOURCE        Source of all stored objects in the database413        DBA_SOURCE_TABLES        414        DBA_SOURCE_TAB_COLUMNS        415        DBA_SQLJ_TYPES        Description of all types in the database416        DBA_SQLJ_TYPE_ATTRS        Description of attributes of all types in the database417        DBA_SQLJ_TYPE_METHODS        Description of methods of all types in the database418        DBA_STMT_AUDIT_OPTS        Describes current system auditing options across the system and by user419        DBA_STORED_SETTINGS        Parameter settings for all objects420        DBA_STREAMS_GLOBAL_RULES        Global rules created by streams administrative APIs421        DBA_STREAMS_SCHEMA_RULES        Schema rules created by streams administrative APIs422        DBA_STREAMS_TABLE_RULES        Table rules created by streams administrative APIs423        DBA_SUBPARTITION_TEMPLATES        424        DBA_SUBPART_COL_STATISTICS        425        DBA_SUBPART_HISTOGRAMS        426        DBA_SUBPART_KEY_COLUMNS        427        DBA_SUBSCRIBED_COLUMNS        428        DBA_SUBSCRIBED_TABLES        429        DBA_SUBSCRIPTIONS        430        DBA_SUMMARIES        Description of the summaries accessible to dba431        DBA_SYNONYMS        All synonyms in the database432        DBA_SYS_PRIVS        System privileges granted to users and roles433        DBA_TABLES        Description of all relational tables in the database434        DBA_TABLESPACES        Description of all tablespaces435        DBA_TAB_COLS        "Columns of user's tables, views and clusters"436        DBA_TAB_COLUMNS        "Columns of user's tables, views and clusters"437        DBA_TAB_COL_STATISTICS        "Columns of user's tables, views and clusters"438        DBA_TAB_COMMENTS        Comments on all tables and views in the database439        DBA_TAB_HISTOGRAMS        Histograms on columns of all tables440        DBA_TAB_MODIFICATIONS        Information regarding modifications to tables441        DBA_TAB_PARTITIONS        442        DBA_TAB_PRIVS        All grants on objects in the database443        DBA_TAB_SUBPARTITIONS        444        DBA_TEMPLATE_REFGROUPS        Table for maintaining refresh group information for template.445        DBA_TEMPLATE_TARGETS        Internal table for tracking potential target databases for templates.446        DBA_TEMP_FILES        Information about database temp files447        DBA_TRANSFORMATIONS        448        DBA_TRIGGERS        All triggers in the database449        DBA_TRIGGER_COLS        Column usage in all triggers450        DBA_TS_QUOTAS        Tablespace quotas for all users451        DBA_TYPES        Description of all types in the database452        DBA_TYPE_ATTRS        Description of attributes of all types in the database453        DBA_TYPE_METHODS        Description of methods of all types in the database454        DBA_TYPE_VERSIONS        Description of each type version in the database455        DBA_UNDO_EXTENTS        Extents comprising all segments in the system managed undo tablespaces456        DBA_UNUSED_COL_TABS        All tables with unused columns in the database457        DBA_UPDATABLE_COLUMNS        Description of dba updatable columns458        DBA_USERS        Information about all users of the database459        DBA_USTATS        All statistics collected on either tables or indexes460        DBA_VARRAYS        Description of varrays in tables accessible to the user461        DBA_VIEWS        Description of all views in the database462        DBA_WAITERS        463        DBA_WORKSPACES        464        DBA_WORKSPACE_SESSIONS        465        USER_ALL_TABLES        Description of all object and relational tables owned by the user's466        USER_AQ_AGENT_PRIVS        467        USER_ARGUMENTS        Arguments in object accessible to the user468        USER_ASSOCIATIONS        All assocations defined by the user469        USER_ATTRIBUTE_TRANSFORMATIONS        470        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"471        USER_AUDIT_POLICIES        All fine grained auditing policies for objects in user schema472        USER_AUDIT_SESSION        All audit trail records concerning CONNECT and DISCONNECT473        USER_AUDIT_STATEMENT        "Audit trail records concerning  grant, revoke, audit, noaudit and alter system"474        USER_AUDIT_TRAIL        Audit trail entries relevant to the user475        USER_AWS        Analytic Workspaces owned by the user476        USER_AW_PS        Pagespaces in Analytic Workspaces owned by the user477        USER_BASE_TABLE_MVIEWS        All materialized views with log(s) owned by the user in the database478        USER_CATALOG        "Tables, Views, Synonyms and Sequences owned by the user"479        USER_CLUSTERS        Descriptions of user's own clusters480        USER_CLUSTER_HASH_EXPRESSIONS        Hash functions for the user's hash clusters481        USER_CLU_COLUMNS        Mapping of table columns to cluster columns482        USER_COLL_TYPES        Description of the user's own named collection types483        USER_COL_COMMENTS        Comments on columns of user's tables and views484        USER_COL_PRIVS        "Grants on columns for which the user is the owner, grantor or grantee"485        USER_COL_PRIVS_MADE        All grants on columns of objects owned by the user486        USER_COL_PRIVS_RECD        Grants on columns for which the user is the grantee487        USER_CONSTRAINTS        Constraint definitions on user's own tables488        USER_CONS_COLUMNS        Information about accessible columns in constraint definitions489        USER_CONS_OBJ_COLUMNS        List of types an object column or attribute is constrained to in the tables owned by the user490        USER_DB_LINKS        Database links owned by the user491        USER_DEPENDENCIES        Dependencies to and from a users objects492        USER_DIMENSIONS        Description of the dimension objects accessible to the DBA493        USER_DIM_ATTRIBUTES        "Representation of the relationship between a dimension level anda functionally dependent column"494        USER_DIM_CHILD_OF        "Representaion of a 1:n hierarchical relationship between a pair of levels ina dimension"495        USER_DIM_HIERARCHIES        Representation of a dimension hierarchy496        USER_DIM_JOIN_KEY        Representation of a join between two dimension tables. 497        USER_DIM_LEVELS        Description of dimension levels visible to DBA498        USER_DIM_LEVEL_KEY        Representations of columns of a dimension level499        USER_ERRORS        Current errors on stored objects owned by the user500        USER_EVALUATION_CONTEXTS        rule evaluation contexts owned by user501        USER_EVALUATION_CONTEXT_TABLES        tables in user rule evaluation contexts502        USER_EVALUATION_CONTEXT_VARS        variables in user rule evaluation contexts503        USER_EXTENTS        Extents comprising segments owned by the user504        USER_EXTERNAL_LOCATIONS        Description of the user's external tables locations505        USER_EXTERNAL_TABLES        Description of the user's own external tables506        USER_FREE_SPACE        Free extents in tablespaces accessible to the user507        USER_INDEXES        Description of the user's own indexes508        USER_INDEXTYPES        All user indextypes509        USER_INDEXTYPE_COMMENTS        Comments for user-defined indextypes510        USER_INDEXTYPE_OPERATORS        All user indextype operators511        USER_IND_COLUMNS        COLUMNs comprising user's INDEXes and INDEXes on user's TABLES512        USER_IND_EXPRESSIONS        Functional index expressions in user's indexes and indexes on user's tables513        USER_IND_PARTITIONS        514        USER_IND_SUBPARTITIONS        515        USER_INTERNAL_TRIGGERS        Description of the internal triggers on the user's own tables516        USER_JOBS        All jobs owned by this user517        USER_JOIN_IND_COLUMNS        Join Index columns comprising the join conditions518        USER_LIBRARIES        Description of the user's own libraries519        USER_LOBS        Description of the user's own LOBs contained in the user's own tables520        USER_LOB_PARTITIONS        521        USER_LOB_SUBPARTITIONS        522        USER_LOB_TEMPLATES        523        USER_LOG_GROUPS        Log group definitions on user's own tables524        USER_LOG_GROUP_COLUMNS        Information about columns in log group definitions525        USER_METHOD_PARAMS        Description of method parameters of the user's own types526        USER_METHOD_RESULTS        Description of method results of the user's own types527        USER_MVIEWS        All materialized views in the database528        USER_MVIEW_AGGREGATES        Description of the materialized view aggregates created by the user529        USER_MVIEW_ANALYSIS        Description of the materialized views created by the user530        USER_MVIEW_DETAIL_RELATIONS        "Description of the materialized view detail tables of the materializedviews created by the user"531        USER_MVIEW_JOINS        "Description of a join between two columns in theWHERE clause of a materialized view created by the user"532        USER_MVIEW_KEYS        "Description of the columns that appear in the GROUP BYlist of a materialized view  created by the user"533        USER_MVIEW_LOGS        All materialized view logs owned by the user534        USER_MVIEW_REFRESH_TIMES        Materialized views and their last refresh times for each master table that the user can look at535        USER_NESTED_TABLES        Description of nested tables contained in the user's own tables536        USER_OBJECTS        Objects owned by the user537        USER_OBJECT_SIZE        "Sizes, in bytes, of various pl/sql objects"538        USER_OBJECT_TABLES        Description of the user's own object tables539        USER_OBJ_AUDIT_OPTS        Auditing options for user's own tables and views540        USER_OBJ_COLATTRS        Description of object columns and attributes contained in tables owned by the user541        USER_OPANCILLARY        All ancillary opertors defined by user542        USER_OPARGUMENTS        All operator arguments of operators defined by user543        USER_OPBINDINGS        All binding functions or methods on operators defined by the user544        USER_OPERATORS        All user operators545        USER_OPERATOR_COMMENTS        Comments for user-defined operators546        USER_OUTLINES        Stored outlines owned by the user547        USER_OUTLINE_HINTS        Hints stored in outlines owned by the user548        USER_PARTIAL_DROP_TABS        User tables with unused columns549        USER_PART_COL_STATISTICS        550        USER_PART_HISTOGRAMS        551        USER_PART_INDEXES        552        USER_PART_KEY_COLUMNS        553        USER_PART_LOBS        554        USER_PART_TABLES        555        USER_PASSWORD_LIMITS        Display password limits of the user556        USER_PENDING_CONV_TABLES        All user's tables which are not upgraded to the latest type version557        USER_POLICIES        "All row level security policies for synonyms, tables, or views owned by the user"558        USER_POLICY_CONTEXTS        "All policy driving context defined for synonyms, tables, or views in current schema"559        USER_POLICY_GROUPS        "All policy groups defined for any synonym, table, or view"560        USER_PROCEDURES        Description of the users own procedures561        USER_PROXIES        Description of connections the user is allowed to proxy562        USER_PUBLISHED_COLUMNS        563        USER_QUEUES        All queues owned by the user564        USER_QUEUE_PUBLISHERS        565        USER_QUEUE_SCHEDULES        566        USER_QUEUE_TABLES        All queue tables created by the user567        USER_REFRESH        All the refresh groups568        USER_REFRESH_CHILDREN        "All the objects in refresh groups, where the user owns the refresh group"569        USER_REFS        Description of the user's own REF columns contained in the user's own tables570        USER_REGISTERED_MVIEWS        Remote materialized views of local tables currently using logs owned by the user571        USER_REGISTERED_SNAPSHOTS        Remote snapshots of local tables currently using logs owned by the user572        USER_REGISTRY        573        USER_REPAUDIT_ATTRIBUTE        Information about attributes automatically maintained for replication574        USER_REPAUDIT_COLUMN        Information about columns in all shadow tables for user's replicated tables575        USER_REPCAT        576        USER_REPCATLOG        Information about the current user's asynchronous administration requests577        USER_REPCOLUMN        Replicated columns for the current user's table in ascending order578        USER_REPCOLUMN_GROUP        All column groups of user's replicated tables579        USER_REPCONFLICT        580        USER_REPDDL        Arguments that do not fit in a single repcat log record581        USER_REPFLAVORS        Flavors current user created for replicated object groups582        USER_REPFLAVOR_COLUMNS        Replicated columns from current user's tables in flavors583        USER_REPFLAVOR_OBJECTS        Replicated user objects in flavors584        USER_REPGENERATED        Objects generated for the current user to support replication585        USER_REPGENOBJECTS        Objects generated for the current user to support replication586        USER_REPGROUP        Replication information about the current user587        USER_REPGROUPED_COLUMN        Columns in the all column groups of user's replicated tables588        USER_REPGROUP_PRIVILEGES        Information about users who are registered for object group privileges589        USER_REPKEY_COLUMNS        Primary columns for a table using column-level replication590        USER_REPOBJECT        Replication information about the current user's objects591        USER_REPPARAMETER_COLUMN        All columns used for resolving conflicts in user's replicated tables592        USER_REPPRIORITY        Values and their corresponding priorities in user's priority groups593        USER_REPPRIORITY_GROUP        Information about user's priority groups594        USER_REPPROP        Propagation information about the current user's objects595        USER_REPRESOLUTION        Description of all conflict resolutions for user's replicated tables596        USER_REPRESOLUTION_METHOD        All conflict resolution methods accessible to the user597        USER_REPRESOLUTION_STATISTICS        Statistics for conflict resolutions for user's replicated tables598        USER_REPRESOL_STATS_CONTROL        Information about statistics collection for conflict resolutions for user's replicated tables599        USER_REPSCHEMA        N-way replication information about the current user600        USER_REPSITES        N-way replication information about the current user601        USER_RESOURCE_LIMITS        Display resource limit of the user602        USER_RESUMABLE        Resumable session information for current user603        USER_ROLE_PRIVS        Roles granted to current user604        USER_RSRC_CONSUMER_GROUP_PRIVS        Switch privileges for consumer groups for the user605        USER_RSRC_MANAGER_SYSTEM_PRIVS        system privileges for the resource manager for the user606        USER_RULES        Rules owned by the user607        USER_RULESETS        Rulesets owned by the user: maintained for backward compatibility608        USER_RULE_SETS        Rule sets owned by the user609        USER_RULE_SET_RULES        Rules in user rule sets610        USER_SECONDARY_OBJECTS        All secondary objects for domain indexes611        USER_SEGMENTS        Storage allocated for all database segments612        USER_SEQUENCES        Description of the user's own SEQUENCEs613        USER_SNAPSHOTS        Snapshots the user can look at614        USER_SNAPSHOT_LOGS        All snapshot logs owned by the user615        USER_SOURCE        Source of stored objects accessible to the user616        USER_SOURCE_TABLES        617        USER_SOURCE_TAB_COLUMNS        618        USER_SQLJ_TYPES        Description of the user's own types619        USER_SQLJ_TYPE_ATTRS        Description of attributes of the user's own types620        USER_SQLJ_TYPE_METHODS        Description of methods of the user's own types621        USER_STORED_SETTINGS        Parameter settings for objects owned by the user622        USER_SUBPARTITION_TEMPLATES        623        USER_SUBPART_COL_STATISTICS        624        USER_SUBPART_HISTOGRAMS        625        USER_SUBPART_KEY_COLUMNS        626        USER_SUBSCRIBED_COLUMNS        627        USER_SUBSCRIBED_TABLES        628        USER_SUBSCRIPTIONS        629        USER_SUMMARIES        Description of the summaries created by the user630        USER_SYNONYMS        The user's private synonyms631        USER_SYS_PRIVS        System privileges granted to current user632        USER_TABLES        Description of the user's own relational tables633        USER_TABLESPACES        Description of accessible tablespaces634        USER_TAB_COLS        "Columns of user's tables, views and clusters"635        USER_TAB_COLUMNS        "Columns of user's tables, views and clusters"636        USER_TAB_COL_STATISTICS        "Columns of user's tables, views and clusters"637        USER_TAB_COMMENTS        Comments on the tables and views owned by the user638        USER_TAB_HISTOGRAMS        Histograms on columns of user's tables639        USER_TAB_MODIFICATIONS        Information regarding modifications to tables640        USER_TAB_PARTITIONS        641        USER_TAB_PRIVS        "Grants on objects for which the user is the owner, grantor or grantee"642        USER_TAB_PRIVS_MADE        All grants on objects owned by the user643        USER_TAB_PRIVS_RECD        Grants on objects for which the user is the grantee644        USER_TAB_SUBPARTITIONS        645        USER_TRANSFORMATIONS        646        USER_TRIGGERS        Triggers owned by the user647        USER_TRIGGER_COLS        Column usage in user's triggers648        USER_TS_QUOTAS        Tablespace quotas for the user649        USER_TYPES        Description of the user's own types650        USER_TYPE_ATTRS        Description of attributes of the user's own types651        USER_TYPE_METHODS        Description of methods of the user's own types652        USER_TYPE_VERSIONS        Description of each version of the user's types653        USER_UNUSED_COL_TABS        User tables with unused columns654        USER_UPDATABLE_COLUMNS        Description of updatable columns655        USER_USERS        Information about the current user656        USER_USTATS        All statistics on tables or indexes owned by the user657        USER_VARRAYS        Description of varrays contained in the user's own tables658        USER_VIEWS        Description of the user's own views659        USER_WORKSPACES        660        AUDIT_ACTIONS        Description table for audit trail action type codes.  Maps action type numbers to action type names661        COLUMN_PRIVILEGES        "Grants on columns for which the user is the grantor, grantee, owner, oran enabled role or PUBLIC is the grantee"662        DATABASE_COMPATIBLE_LEVEL        Database compatible parameter set via init.ora663        DBMS_ALERT_INFO        664        DBMS_LOCK_ALLOCATED        665        DICTIONARY        Description of data dictionary tables and views666        DICT_COLUMNS        Description of columns in data dictionary tables and views667        DUAL        668        GLOBAL_NAME        global database name669        INDEX_HISTOGRAM        statistics on keys with repeat count670        INDEX_STATS        statistics on the b-tree671        NLS_DATABASE_PARAMETERS        Permanent NLS parameters of the database672        NLS_INSTANCE_PARAMETERS        NLS parameters of the instance673        NLS_SESSION_PARAMETERS        NLS parameters of the user session674        RESOURCE_COST        Cost for each resource675        ROLE_ROLE_PRIVS        Roles which are granted to roles676        ROLE_SYS_PRIVS        System privileges granted to roles677        ROLE_TAB_PRIVS        Table privileges granted to roles678        SESSION_PRIVS        Privileges which the user currently has set679        SESSION_ROLES        Roles which the user currently has enabled.680        TABLE_PRIVILEGES        "Grants on objects for which the user is the grantor, grantee, owner,or an enabled role or PUBLIC is the grantee"681        ALL_HISTOGRAMS        Synonym for ALL_TAB_HISTOGRAMS682        ALL_JOBS        Synonym for USER_JOBS683        ALL_OUTLINES        Synonym for USER_OUTLINES684        ALL_OUTLINE_HINTS        Synonym for USER_OUTLINE_HINTS685        ALL_SNAPSHOT_REFRESH_TIMES        Synonym for ALL_MVIEW_REFRESH_TIMES686        CAT        Synonym for USER_CATALOG687        CLU        Synonym for USER_CLUSTERS688        COLS        Synonym for USER_TAB_COLUMNS689        DBA_HISTOGRAMS        Synonym for DBA_TAB_HISTOGRAMS690        DBA_LOCKS        Synonym for DBA_LOCK691        DBA_SNAPSHOT_LOG_FILTER_COLS        Synonym for DBA_MVIEW_LOG_FILTER_COLS692        DBA_SNAPSHOT_REFRESH_TIMES        Synonym for DBA_MVIEW_REFRESH_TIMES693        DICT        Synonym for DICTIONARY694        GV$ACCESS        Synonym for GV_$ACCESS695        GV$ACTIVE_INSTANCES        Synonym for GV_$ACTIVE_INSTANCES696        GV$ACTIVE_SESS_POOL_MTH        Synonym for GV_$ACTIVE_SESS_POOL_MTH697        GV$AQ        Synonym for GV_$AQ698        GV$AQ1        Synonym for GV_$AQ1699        GV$ARCHIVE        Synonym for GV_$ARCHIVE700        GV$ARCHIVED_LOG        Synonym for GV_$ARCHIVED_LOG701        GV$ARCHIVE_DEST        Synonym for GV_$ARCHIVE_DEST702        GV$ARCHIVE_DEST_STATUS        Synonym for GV_$ARCHIVE_DEST_STATUS703        GV$ARCHIVE_GAP        Synonym for GV_$ARCHIVE_GAP704        GV$ARCHIVE_PROCESSES        Synonym for GV_$ARCHIVE_PROCESSES705        GV$AW_CALC        Synonym for GV_$AW_CALC706        GV$AW_OLAP        Synonym for GV_$AW_OLAP707        GV$AW_SESSION_INFO        Synonym for GV_$AW_SESSION_INFO708        GV$BACKUP        Synonym for GV_$BACKUP709        GV$BACKUP_ASYNC_IO        Synonym for GV_$BACKUP_ASYNC_IO710        GV$BACKUP_CORRUPTION        Synonym for GV_$BACKUP_CORRUPTION711        GV$BACKUP_DATAFILE        Synonym for GV_$BACKUP_DATAFILE712        GV$BACKUP_DEVICE        Synonym for GV_$BACKUP_DEVICE713        GV$BACKUP_PIECE        Synonym for GV_$BACKUP_PIECE714        GV$BACKUP_REDOLOG        Synonym for GV_$BACKUP_REDOLOG715        GV$BACKUP_SET        Synonym for GV_$BACKUP_SET716        GV$BACKUP_SPFILE        Synonym for GV_$BACKUP_SPFILE717        GV$BACKUP_SYNC_IO        Synonym for GV_$BACKUP_SYNC_IO718        GV$BGPROCESS        Synonym for GV_$BGPROCESS719        GV$BH        Synonym for GV_$BH720        GV$BSP        Synonym for GV_$BSP721        GV$BUFFER_POOL        Synonym for GV_$BUFFER_POOL722        GV$BUFFER_POOL_STATISTICS        Synonym for GV_$BUFFER_POOL_STATISTICS723        GV$CIRCUIT        Synonym for GV_$CIRCUIT724        GV$CLASS_CACHE_TRANSFER        Synonym for GV_$CLASS_CACHE_TRANSFER725        GV$CLASS_PING        Synonym for GV_$CLASS_PING726        GV$COMPATIBILITY        Synonym for GV_$COMPATIBILITY727        GV$COMPATSEG        Synonym for GV_$COMPATSEG728        GV$CONTEXT        Synonym for GV_$CONTEXT729        GV$CONTROLFILE        Synonym for GV_$CONTROLFILE730        GV$CONTROLFILE_RECORD_SECTION        Synonym for GV_$CONTROLFILE_RECORD_SECTION731        GV$COPY_CORRUPTION        Synonym for GV_$COPY_CORRUPTION732        GV$CR_BLOCK_SERVER        Synonym for GV_$CR_BLOCK_SERVER733        GV$DATABASE        Synonym for GV_$DATABASE734        GV$DATABASE_BLOCK_CORRUPTION        Synonym for GV_$DATABASE_BLOCK_CORRUPTION735        GV$DATABASE_INCARNATION        Synonym for GV_$DATABASE_INCARNATION736        GV$DATAFILE        Synonym for GV_$DATAFILE737        GV$DATAFILE_COPY        Synonym for GV_$DATAFILE_COPY738        GV$DATAFILE_HEADER        Synonym for GV_$DATAFILE_HEADER739        GV$DATAGUARD_STATUS        Synonym for GV_$DATAGUARD_STATUS740        GV$DBFILE        Synonym for GV_$DBFILE741        GV$DBLINK        Synonym for GV_$DBLINK742        GV$DB_CACHE_ADVICE        Synonym for GV_$DB_CACHE_ADVICE743        GV$DB_OBJECT_CACHE        Synonym for GV_$DB_OBJECT_CACHE744        GV$DB_PIPES        Synonym for GV_$DB_PIPES745        GV$DELETED_OBJECT        Synonym for GV_$DELETED_OBJECT746        GV$DISPATCHER        Synonym for GV_$DISPATCHER747        GV$DISPATCHER_RATE        Synonym for GV_$DISPATCHER_RATE748        GV$DLM_ALL_LOCKS        Synonym for GV_$DLM_ALL_LOCKS749        GV$DLM_CONVERT_LOCAL        Synonym for GV_$DLM_CONVERT_LOCAL750        GV$DLM_CONVERT_REMOTE        Synonym for GV_$DLM_CONVERT_REMOTE751        GV$DLM_LATCH        Synonym for GV_$DLM_LATCH752        GV$DLM_LOCKS        Synonym for GV_$DLM_LOCKS753        GV$DLM_MISC        Synonym for GV_$DLM_MISC754        GV$DLM_RESS        Synonym for GV_$DLM_RESS755        GV$DLM_TRAFFIC_CONTROLLER        Synonym for GV_$DLM_TRAFFIC_CONTROLLER756        GV$ENABLEDPRIVS        Synonym for GV_$ENABLEDPRIVS757        GV$ENQUEUE_LOCK        Synonym for GV_$ENQUEUE_LOCK758        GV$ENQUEUE_STAT        Synonym for GV_$ENQUEUE_STAT759        GV$EVENT_NAME        Synonym for GV_$EVENT_NAME760        GV$EXECUTION        Synonym for GV_$EXECUTION761        GV$FAST_START_SERVERS        Synonym for GV_$FAST_START_SERVERS762        GV$FAST_START_TRANSACTIONS        Synonym for GV_$FAST_START_TRANSACTIONS763        GV$FILESTAT        Synonym for GV_$FILESTAT764        GV$FILE_CACHE_TRANSFER        Synonym for GV_$FILE_CACHE_TRANSFER765        GV$FILE_PING        Synonym for GV_$FILE_PING766        GV$FIXED_TABLE        Synonym for GV_$FIXED_TABLE767        GV$FIXED_VIEW_DEFINITION        Synonym for GV_$FIXED_VIEW_DEFINITION768        GV$GCSHVMASTER_INFO        Synonym for GV_$GCSHVMASTER_INFO769        GV$GCSPFMASTER_INFO        Synonym for GV_$GCSPFMASTER_INFO770        GV$GC_ELEMENT        Synonym for GV_$GC_ELEMENT771        GV$GC_ELEMENTS_WITH_COLLISIONS        Synonym for GV_$GC_ELEMENTS_W_COLLISIONS772        GV$GES_BLOCKING_ENQUEUE        Synonym for GV_$GES_BLOCKING_ENQUEUE773        GV$GES_ENQUEUE        Synonym for GV_$GES_ENQUEUE774        GV$GLOBALCONTEXT        Synonym for GV_$GLOBALCONTEXT775        GV$GLOBAL_BLOCKED_LOCKS        Synonym for GV_$GLOBAL_BLOCKED_LOCKS776        GV$GLOBAL_TRANSACTION        Synonym for GV_$GLOBAL_TRANSACTION777        GV$HS_AGENT        Synonym for GV_$HS_AGENT778        GV$HS_PARAMETER        Synonym for GV_$HS_PARAMETER779        GV$HS_SESSION        Synonym for GV_$HS_SESSION780        GV$HVMASTER_INFO        Synonym for GV_$HVMASTER_INFO781        GV$INDEXED_FIXED_COLUMN        Synonym for GV_$INDEXED_FIXED_COLUMN782        GV$INSTANCE        Synonym for GV_$INSTANCE783        GV$INSTANCE_RECOVERY        Synonym for GV_$INSTANCE_RECOVERY784        GV$LATCH        Synonym for GV_$LATCH785        GV$LATCHHOLDER        Synonym for GV_$LATCHHOLDER786        GV$LATCHNAME        Synonym for GV_$LATCHNAME787        GV$LATCH_CHILDREN        Synonym for GV_$LATCH_CHILDREN788        GV$LATCH_MISSES        Synonym for GV_$LATCH_MISSES789        GV$LATCH_PARENT        Synonym for GV_$LATCH_PARENT790        GV$LIBRARYCACHE        Synonym for GV_$LIBRARYCACHE791        GV$LIBRARY_CACHE_MEMORY        Synonym for GV_$LIBRARY_CACHE_MEMORY792        GV$LICENSE        Synonym for GV_$LICENSE793        GV$LOADISTAT        Synonym for GV_$LOADISTAT794        GV$LOADPSTAT        Synonym for GV_$LOADPSTAT795        GV$LOCK        Synonym for GV_$LOCK796        GV$LOCKED_OBJECT        Synonym for GV_$LOCKED_OBJECT797        GV$LOCKS_WITH_COLLISIONS        Synonym for GV_$LOCKS_WITH_COLLISIONS798        GV$LOCK_ACTIVITY        Synonym for GV_$LOCK_ACTIVITY799        GV$LOCK_ELEMENT        Synonym for GV_$LOCK_ELEMENT800        GV$LOG        Synonym for GV_$LOG801        GV$LOGFILE        Synonym for GV_$LOGFILE802        GV$LOGHIST        Synonym for GV_$LOGHIST803        GV$LOGMNR_CALLBACK        Synonym for GV_$LOGMNR_CALLBACK804        GV$LOGMNR_CONTENTS        Synonym for GV_$LOGMNR_CONTENTS805        GV$LOGMNR_DICTIONARY        Synonym for GV_$LOGMNR_DICTIONARY806        GV$LOGMNR_LOGFILE        Synonym for GV_$LOGMNR_LOGFILE807        GV$LOGMNR_LOGS        Synonym for GV_$LOGMNR_LOGS808        GV$LOGMNR_PARAMETERS        Synonym for GV_$LOGMNR_PARAMETERS809        GV$LOGMNR_PROCESS        Synonym for GV_$LOGMNR_PROCESS810        GV$LOGMNR_REGION        Synonym for GV_$LOGMNR_REGION811        GV$LOGMNR_SESSION        Synonym for GV_$LOGMNR_SESSION812        GV$LOGMNR_STATS        Synonym for GV_$LOGMNR_STATS813        GV$LOGMNR_TRANSACTION        Synonym for GV_$LOGMNR_TRANSACTION814        GV$LOGSTDBY        Synonym for GV_$LOGSTDBY815        GV$LOGSTDBY_STATS        Synonym for GV_$LOGSTDBY_STATS816        GV$LOG_HISTORY        Synonym for GV_$LOG_HISTORY817        GV$MANAGED_STANDBY        Synonym for GV_$MANAGED_STANDBY818        GV$MAP_COMP_LIST        Synonym for GV_$MAP_COMP_LIST819        GV$MAP_ELEMENT        Synonym for GV_$MAP_ELEMENT820        GV$MAP_EXT_ELEMENT        Synonym for GV_$MAP_EXT_ELEMENT821        GV$MAP_FILE        Synonym for GV_$MAP_FILE822        GV$MAP_FILE_EXTENT        Synonym for GV_$MAP_FILE_EXTENT823        GV$MAP_FILE_IO_STACK        Synonym for GV_$MAP_FILE_IO_STACK824        GV$MAP_LIBRARY        Synonym for GV_$MAP_LIBRARY825        GV$MAP_SUBELEMENT        Synonym for GV_$MAP_SUBELEMENT826        GV$MAX_ACTIVE_SESS_TARGET_MTH        Synonym for GV_$MAX_ACTIVE_SESS_TARGET_MTH827        GV$MLS_PARAMETERS        Synonym for GV_$MLS_PARAMETERS828        GV$MTS        Synonym for GV_$MTS829        GV$MTTR_TARGET_ADVICE        Synonym for GV_$MTTR_TARGET_ADVICE830        GV$MVREFRESH        Synonym for GV_$MVREFRESH831        GV$MYSTAT        Synonym for GV_$MYSTAT832        GV$NLS_PARAMETERS        Synonym for GV_$NLS_PARAMETERS833        GV$NLS_VALID_VALUES        Synonym for GV_$NLS_VALID_VALUES834        GV$OBJECT_DEPENDENCY        Synonym for GV_$OBJECT_DEPENDENCY835        GV$OBSOLETE_PARAMETER        Synonym for GV_$OBSOLETE_PARAMETER836        GV$OFFLINE_RANGE        Synonym for GV_$OFFLINE_RANGE837        GV$OPEN_CURSOR        Synonym for GV_$OPEN_CURSOR838        GV$OPTION        Synonym for GV_$OPTION839        GV$PARALLEL_DEGREE_LIMIT_MTH        Synonym for GV_$PARALLEL_DEGREE_LIMIT_MTH840        GV$PARAMETER        Synonym for GV_$PARAMETER841        GV$PARAMETER2        Synonym for GV_$PARAMETER2842        GV$PGASTAT        Synonym for GV_$PGASTAT843        GV$PGA_TARGET_ADVICE        Synonym for GV_$PGA_TARGET_ADVICE844        GV$PGA_TARGET_ADVICE_HISTOGRAM        Synonym for GV_$PGATARGET_ADVICE_HISTOGRAM845        GV$PQ_SESSTAT        Synonym for GV_$PQ_SESSTAT846        GV$PQ_SLAVE        Synonym for GV_$PQ_SLAVE847        GV$PQ_SYSSTAT        Synonym for GV_$PQ_SYSSTAT848        GV$PQ_TQSTAT        Synonym for GV_$PQ_TQSTAT849        GV$PROCESS        Synonym for GV_$PROCESS850        GV$PROXY_ARCHIVEDLOG        Synonym for GV_$PROXY_ARCHIVEDLOG851        GV$PROXY_DATAFILE        Synonym for GV_$PROXY_DATAFILE852        GV$PWFILE_USERS        Synonym for GV_$PWFILE_USERS853        GV$PX_PROCESS        Synonym for GV_$PX_PROCESS854        GV$PX_PROCESS_SYSSTAT        Synonym for GV_$PX_PROCESS_SYSSTAT855        GV$PX_SESSION        Synonym for GV_$PX_SESSION856        GV$PX_SESSTAT        Synonym for GV_$PX_SESSTAT857        GV$QUEUE        Synonym for GV_$QUEUE858        GV$QUEUEING_MTH        Synonym for GV_$QUEUEING_MTH859        GV$RECOVERY_FILE_STATUS        Synonym for GV_$RECOVERY_FILE_STATUS860        GV$RECOVERY_LOG        Synonym for GV_$RECOVERY_LOG861        GV$RECOVERY_PROGRESS        Synonym for GV_$RECOVERY_PROGRESS862        GV$RECOVERY_STATUS        Synonym for GV_$RECOVERY_STATUS863        GV$RECOVER_FILE        Synonym for GV_$RECOVER_FILE864        GV$REPLPROP        Synonym for GV_$REPLPROP865        GV$REPLQUEUE        Synonym for GV_$REPLQUEUE866        GV$REQDIST        Synonym for GV_$REQDIST867        GV$RESERVED_WORDS        Synonym for GV_$RESERVED_WORDS868        GV$RESOURCE        Synonym for GV_$RESOURCE869        GV$RESOURCE_LIMIT        Synonym for GV_$RESOURCE_LIMIT870        GV$RESUMABLE        Synonym for GV_$RESUMABLE871        GV$RMAN_CONFIGURATION        Synonym for GV_$RMAN_CONFIGURATION872        GV$ROLLSTAT        Synonym for GV_$ROLLSTAT873        GV$ROWCACHE        Synonym for GV_$ROWCACHE874        GV$ROWCACHE_PARENT        Synonym for GV_$ROWCACHE_PARENT875        GV$ROWCACHE_SUBORDINATE        Synonym for GV_$ROWCACHE_SUBORDINATE876        GV$RSRC_CONSUMER_GROUP        Synonym for GV_$RSRC_CONSUMER_GROUP877        GV$RSRC_CONSUMER_GROUP_CPU_MTH        Synonym for GV_$RSRC_CONSUME_GROUP_CPU_MTH878        GV$RSRC_PLAN        Synonym for GV_$RSRC_PLAN879        GV$RSRC_PLAN_CPU_MTH        Synonym for GV_$RSRC_PLAN_CPU_MTH880        GV$SEGMENT_STATISTICS        Synonym for GV_$SEGMENT_STATISTICS881        GV$SEGSTAT        Synonym for GV_$SEGSTAT882        GV$SEGSTAT_NAME        Synonym for GV_$SEGSTAT_NAME883        GV$SESSION        Synonym for GV_$SESSION884        GV$SESSION_CONNECT_INFO        Synonym for GV_$SESSION_CONNECT_INFO885        GV$SESSION_CURSOR_CACHE        Synonym for GV_$SESSION_CURSOR_CACHE886        GV$SESSION_EVENT        Synonym for GV_$SESSION_EVENT887        GV$SESSION_LONGOPS        Synonym for GV_$SESSION_LONGOPS888        GV$SESSION_OBJECT_CACHE        Synonym for GV_$SESSION_OBJECT_CACHE889        GV$SESSION_WAIT        Synonym for GV_$SESSION_WAIT890        GV$SESSTAT        Synonym for GV_$SESSTAT891        GV$SESS_IO        Synonym for GV_$SESS_IO892        GV$SGA        Synonym for GV_$SGA893        GV$SGASTAT        Synonym for GV_$SGASTAT894        GV$SGA_CURRENT_RESIZE_OPS        Synonym for GV_$SGA_CURRENT_RESIZE_OPS895        GV$SGA_DYNAMIC_COMPONENTS        Synonym for GV_$SGA_DYNAMIC_COMPONENTS896        GV$SGA_DYNAMIC_FREE_MEMORY        Synonym for GV_$SGA_DYNAMIC_FREE_MEMORY897        GV$SGA_RESIZE_OPS        Synonym for GV_$SGA_RESIZE_OPS898        GV$SHARED_POOL_ADVICE        Synonym for GV_$SHARED_POOL_ADVICE899        GV$SHARED_POOL_RESERVED        Synonym for GV_$SHARED_POOL_RESERVED900        GV$SHARED_SERVER        Synonym for GV_$SHARED_SERVER901        GV$SHARED_SERVER_MONITOR        Synonym for GV_$SHARED_SERVER_MONITOR902        GV$SORT_SEGMENT        Synonym for GV_$SORT_SEGMENT903        GV$SORT_USAGE        Synonym for GV_$SORT_USAGE904        GV$SPPARAMETER        Synonym for GV_$SPPARAMETER905        GV$SQL        Synonym for GV_$SQL906        GV$SQLAREA        Synonym for GV_$SQLAREA907        GV$SQLTEXT        Synonym for GV_$SQLTEXT908        GV$SQLTEXT_WITH_NEWLINES        Synonym for GV_$SQLTEXT_WITH_NEWLINES909        GV$SQL_BIND_DATA        Synonym for GV_$SQL_BIND_DATA910        GV$SQL_BIND_METADATA        Synonym for GV_$SQL_BIND_METADATA911        GV$SQL_CURSOR        Synonym for GV_$SQL_CURSOR912        GV$SQL_PLAN        Synonym for GV_$SQL_PLAN913        GV$SQL_PLAN_STATISTICS        Synonym for GV_$SQL_PLAN_STATISTICS914        GV$SQL_PLAN_STATISTICS_ALL        Synonym for GV_$SQL_PLAN_STATISTICS_ALL915        GV$SQL_REDIRECTION        Synonym for GV_$SQL_REDIRECTION916        GV$SQL_SHARED_CURSOR        Synonym for GV_$SQL_SHARED_CURSOR917        GV$SQL_SHARED_MEMORY        Synonym for GV_$SQL_SHARED_MEMORY918        GV$SQL_WORKAREA        Synonym for GV_$SQL_WORKAREA919        GV$SQL_WORKAREA_ACTIVE        Synonym for GV_$SQL_WORKAREA_ACTIVE920        GV$SQL_WORKAREA_HISTOGRAM        Synonym for GV_$SQL_WORKAREA_HISTOGRAM921        GV$STANDBY_LOG        Synonym for GV_$STANDBY_LOG922        GV$STATISTICS_LEVEL        Synonym for GV_$STATISTICS_LEVEL923        GV$STATNAME        Synonym for GV_$STATNAME924        GV$STREAMS_APPLY_COORDINATOR        Synonym for GV_$STREAMS_APPLY_COORDINATOR925        GV$STREAMS_APPLY_READER        Synonym for GV_$STREAMS_APPLY_READER926        GV$STREAMS_APPLY_SERVER        Synonym for GV_$STREAMS_APPLY_SERVER927        GV$STREAMS_CAPTURE        Synonym for GV_$STREAMS_CAPTURE928        GV$SUBCACHE        Synonym for GV_$SUBCACHE929        GV$SYSSTAT        Synonym for GV_$SYSSTAT930        GV$SYSTEM_CURSOR_CACHE        Synonym for GV_$SYSTEM_CURSOR_CACHE931        GV$SYSTEM_EVENT        Synonym for GV_$SYSTEM_EVENT932        GV$SYSTEM_PARAMETER        Synonym for GV_$SYSTEM_PARAMETER933        GV$SYSTEM_PARAMETER2        Synonym for GV_$SYSTEM_PARAMETER2934        GV$TABLESPACE        Synonym for GV_$TABLESPACE935        GV$TEMPFILE        Synonym for GV_$TEMPFILE936        GV$TEMPORARY_LOBS        Synonym for GV_$TEMPORARY_LOBS937        GV$TEMPSEG_USAGE        Synonym for GV_$SORT_USAGE938        GV$TEMPSTAT        Synonym for GV_$TEMPSTAT939        GV$TEMP_CACHE_TRANSFER        Synonym for GV_$TEMP_CACHE_TRANSFER940        GV$TEMP_EXTENT_MAP        Synonym for GV_$TEMP_EXTENT_MAP941        GV$TEMP_EXTENT_POOL        Synonym for GV_$TEMP_EXTENT_POOL942        GV$TEMP_PING        Synonym for GV_$TEMP_PING943        GV$TEMP_SPACE_HEADER        Synonym for GV_$TEMP_SPACE_HEADER944        GV$THREAD        Synonym for GV_$THREAD945        GV$TIMER        Synonym for GV_$TIMER946        GV$TIMEZONE_NAMES        Synonym for GV_$TIMEZONE_NAMES947        GV$TRANSACTION        Synonym for GV_$TRANSACTION948        GV$TRANSACTION_ENQUEUE        Synonym for GV_$TRANSACTION_ENQUEUE949        GV$TYPE_SIZE        Synonym for GV_$TYPE_SIZE950        GV$UNDOSTAT        Synonym for GV_$UNDOSTAT951        GV$VERSION        Synonym for GV_$VERSION952        GV$VPD_POLICY        Synonym for GV_$VPD_POLICY953        GV$WAITSTAT        Synonym for GV_$WAITSTAT954        GV$_LOCK        Synonym for GV_$_LOCK955        IND        Synonym for USER_INDEXES956        OBJ        Synonym for USER_OBJECTS957        SEQ        Synonym for USER_SEQUENCES958        SM$VERSION        Synonym for SM_$VERSION959        SYN        Synonym for USER_SYNONYMS960        TABS        Synonym for USER_TABLES961        USER_HISTOGRAMS        Synonym for USER_TAB_HISTOGRAMS962        USER_SNAPSHOT_REFRESH_TIMES        Synonym for USER_MVIEW_REFRESH_TIMES963        V$ACCESS        Synonym for V_$ACCESS964        V$ACTIVE_INSTANCES        Synonym for V_$ACTIVE_INSTANCES965        V$ACTIVE_SESS_POOL_MTH        Synonym for V_$ACTIVE_SESS_POOL_MTH966        V$AQ        Synonym for V_$AQ967        V$AQ1        Synonym for V_$AQ1968        V$ARCHIVE        Synonym for V_$ARCHIVE969        V$ARCHIVED_LOG        Synonym for V_$ARCHIVED_LOG970        V$ARCHIVE_DEST        Synonym for V_$ARCHIVE_DEST971        V$ARCHIVE_DEST_STATUS        Synonym for V_$ARCHIVE_DEST_STATUS972        V$ARCHIVE_GAP        Synonym for V_$ARCHIVE_GAP973        V$ARCHIVE_PROCESSES        Synonym for V_$ARCHIVE_PROCESSES974        V$AW_CALC        Synonym for V_$AW_CALC975        V$AW_OLAP        Synonym for V_$AW_OLAP976        V$AW_SESSION_INFO        Synonym for V_$AW_SESSION_INFO977        V$BACKUP        Synonym for V_$BACKUP978        V$BACKUP_ASYNC_IO        Synonym for V_$BACKUP_ASYNC_IO979        V$BACKUP_CORRUPTION        Synonym for V_$BACKUP_CORRUPTION980        V$BACKUP_DATAFILE        Synonym for V_$BACKUP_DATAFILE981        V$BACKUP_DEVICE        Synonym for V_$BACKUP_DEVICE982        V$BACKUP_PIECE        Synonym for V_$BACKUP_PIECE983        V$BACKUP_REDOLOG        Synonym for V_$BACKUP_REDOLOG984        V$BACKUP_SET        Synonym for V_$BACKUP_SET985        V$BACKUP_SPFILE        Synonym for V_$BACKUP_SPFILE986        V$BACKUP_SYNC_IO        Synonym for V_$BACKUP_SYNC_IO987        V$BGPROCESS        Synonym for V_$BGPROCESS988        V$BH        Synonym for V_$BH989        V$BSP        Synonym for V_$BSP990        V$BUFFER_POOL        Synonym for V_$BUFFER_POOL991        V$BUFFER_POOL_STATISTICS        Synonym for V_$BUFFER_POOL_STATISTICS992        V$CIRCUIT        Synonym for V_$CIRCUIT993        V$CLASS_CACHE_TRANSFER        Synonym for V_$CLASS_CACHE_TRANSFER994        V$CLASS_PING        Synonym for V_$CLASS_PING995        V$COMPATIBILITY        Synonym for V_$COMPATIBILITY996        V$COMPATSEG        Synonym for V_$COMPATSEG997        V$CONTEXT        Synonym for V_$CONTEXT998        V$CONTROLFILE        Synonym for V_$CONTROLFILE999        V$CONTROLFILE_RECORD_SECTION        Synonym for V_$CONTROLFILE_RECORD_SECTION1000        V$COPY_CORRUPTION        Synonym for V_$COPY_CORRUPTION1001        V$CR_BLOCK_SERVER        Synonym for V_$CR_BLOCK_SERVER1002        V$DATABASE        Synonym for V_$DATABASE1003        V$DATABASE_BLOCK_CORRUPTION        Synonym for V_$DATABASE_BLOCK_CORRUPTION1004        V$DATABASE_INCARNATION        Synonym for V_$DATABASE_INCARNATION1005        V$DATAFILE        Synonym for V_$DATAFILE1006        V$DATAFILE_COPY        Synonym for V_$DATAFILE_COPY1007        V$DATAFILE_HEADER        Synonym for V_$DATAFILE_HEADER1008        V$DATAGUARD_STATUS        Synonym for V_$DATAGUARD_STATUS1009        V$DBFILE        Synonym for V_$DBFILE1010        V$DBLINK        Synonym for V_$DBLINK1011        V$DB_CACHE_ADVICE        Synonym for V_$DB_CACHE_ADVICE1012        V$DB_OBJECT_CACHE        Synonym for V_$DB_OBJECT_CACHE1013        V$DB_PIPES        Synonym for V_$DB_PIPES1014        V$DELETED_OBJECT        Synonym for V_$DELETED_OBJECT1015        V$DISPATCHER        Synonym for V_$DISPATCHER1016        V$DISPATCHER_RATE        Synonym for V_$DISPATCHER_RATE1017        V$DLM_ALL_LOCKS        Synonym for V_$DLM_ALL_LOCKS1018        V$DLM_CONVERT_LOCAL        Synonym for V_$DLM_CONVERT_LOCAL1019        V$DLM_CONVERT_REMOTE        Synonym for V_$DLM_CONVERT_REMOTE1020        V$DLM_LATCH        Synonym for V_$DLM_LATCH1021        V$DLM_LOCKS        Synonym for V_$DLM_LOCKS1022        V$DLM_MISC        Synonym for V_$DLM_MISC1023        V$DLM_RESS        Synonym for V_$DLM_RESS1024        V$DLM_TRAFFIC_CONTROLLER        Synonym for V_$DLM_TRAFFIC_CONTROLLER1025        V$ENABLEDPRIVS        Synonym for V_$ENABLEDPRIVS1026        V$ENQUEUE_LOCK        Synonym for V_$ENQUEUE_LOCK1027        V$ENQUEUE_STAT        Synonym for V_$ENQUEUE_STAT1028        V$EVENT_NAME        Synonym for V_$EVENT_NAME1029        V$EXECUTION        Synonym for V_$EXECUTION1030        V$FAST_START_SERVERS        Synonym for V_$FAST_START_SERVERS1031        V$FAST_START_TRANSACTIONS        Synonym for V_$FAST_START_TRANSACTIONS1032        V$FILESTAT        Synonym for V_$FILESTAT1033        V$FILESTATXS        Synonym for V_$FILESTATXS1034        V$FILE_CACHE_TRANSFER        Synonym for V_$FILE_CACHE_TRANSFER1035        V$FILE_PING        Synonym for V_$FILE_PING1036        V$FIXED_TABLE        Synonym for V_$FIXED_TABLE1037        V$FIXED_VIEW_DEFINITION        Synonym for V_$FIXED_VIEW_DEFINITION1038        V$GCSHVMASTER_INFO        Synonym for V_$GCSHVMASTER_INFO1039        V$GCSPFMASTER_INFO        Synonym for V_$GCSPFMASTER_INFO1040        V$GC_ELEMENT        Synonym for V_$GC_ELEMENT1041        V$GC_ELEMENTS_WITH_COLLISIONS        Synonym for V_$GC_ELEMENTS_W_COLLISIONS1042        V$GES_BLOCKING_ENQUEUE        Synonym for V_$GES_BLOCKING_ENQUEUE1043        V$GES_ENQUEUE        Synonym for V_$GES_ENQUEUE1044        V$GLOBALCONTEXT        Synonym for V_$GLOBALCONTEXT1045        V$GLOBAL_BLOCKED_LOCKS        Synonym for V_$GLOBAL_BLOCKED_LOCKS1046        V$GLOBAL_TRANSACTION        Synonym for V_$GLOBAL_TRANSACTION1047        V$HS_AGENT        Synonym for V_$HS_AGENT1048        V$HS_PARAMETER        Synonym for V_$HS_PARAMETER1049        V$HS_SESSION        Synonym for V_$HS_SESSION1050        V$HVMASTER_INFO        Synonym for V_$HVMASTER_INFO1051        V$INDEXED_FIXED_COLUMN        Synonym for V_$INDEXED_FIXED_COLUMN1052        V$INSTANCE        Synonym for V_$INSTANCE1053        V$INSTANCE_RECOVERY        Synonym for V_$INSTANCE_RECOVERY1054        V$LATCH        Synonym for V_$LATCH1055        V$LATCHHOLDER        Synonym for V_$LATCHHOLDER1056        V$LATCHNAME        Synonym for V_$LATCHNAME1057        V$LATCH_CHILDREN        Synonym for V_$LATCH_CHILDREN1058        V$LATCH_MISSES        Synonym for V_$LATCH_MISSES1059        V$LATCH_PARENT        Synonym for V_$LATCH_PARENT1060        V$LIBRARYCACHE        Synonym for V_$LIBRARYCACHE1061        V$LIBRARY_CACHE
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值