-----------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
oracle数据字典视图及其功能
最新推荐文章于 2023-09-11 15:05:26 发布