!前面的为部分翻译,中间为比较实用的部分视图, 后面为具体的全部原版
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$SQL
V$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 COMMENTS
1 ALL_ALL_TABLES Description of all object and relational tables accessible to the user
2 ALL_APPLY Details about each apply process that dequeues from the queue visible to the current user
3 ALL_APPLY_CONFLICT_COLUMNS Details about conflict resolution on tables visible to the current user
4 ALL_APPLY_DML_HANDLERS Details about the dml handler on tables visible to the current user
5 ALL_APPLY_ERROR Error transactions that were generated after dequeuing from the queue visible to the current user
6 ALL_APPLY_KEY_COLUMNS Alternative key columns for a STREAMS table visible to the current user
7 ALL_APPLY_PARAMETERS Details about parameters of each apply process that dequeues from the queue visible to the current user
8 ALL_APPLY_PROGRESS Information about the progress made by the apply process that dequeues from the queue visible to the current user
9 ALL_ARGUMENTS Arguments in object accessible to the user
10 ALL_ASSOCIATIONS All associations available to the user
11 ALL_AUDIT_POLICIES All fine grained auditing policies in the database
12 ALL_BASE_TABLE_MVIEWS All materialized views with log(s) in the database that the user can see
13 ALL_CAPTURE Details about each capture process that stores the captured changes in a queue visible to the current user
14 ALL_CAPTURE_PARAMETERS Details about parameters for each capture process that stores the captured changes in a queue visible to the current user
15 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 instantiation
17 ALL_CAPTURE_PREPARED_TABLES All tables visible to the current user that are prepared for instantiation
18 ALL_CATALOG "All tables, views, synonyms, sequences accessible to the user"
19 ALL_CLUSTERS Description of clusters accessible to the user
20 ALL_CLUSTER_HASH_EXPRESSIONS Hash functions for all accessible clusters
21 ALL_COLL_TYPES Description of named collection types accessible to the user
22 ALL_COL_COMMENTS Comments on columns of accessible tables and views
23 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 grantor
25 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 tables
27 ALL_CONS_COLUMNS Information about accessible columns in constraint definitions
28 ALL_CONS_OBJ_COLUMNS List of types an object column or attribute is constrained to in the tables accessible to the user
29 ALL_CONTEXT Description of all active context namespaces under the current session
30 ALL_DB_LINKS Database links accessible to the user
31 ALL_DEF_AUDIT_OPTS Auditing options for newly created objects
32 ALL_DEPENDENCIES Dependencies to and from objects accessible to the user
33 ALL_DIMENSIONS Description of the dimension objects accessible to the DBA
34 ALL_DIM_ATTRIBUTES "Representation of the relationship between a dimension level and
a functionally dependent column"
35 ALL_DIM_CHILD_OF "Representaion of a 1:n hierarchical relationship between a pair of levels in
a dimension"
36 ALL_DIM_HIERARCHIES Representation of a dimension hierarchy
37 ALL_DIM_JOIN_KEY Representation of a join between two dimension tables.
38 ALL_DIM_LEVELS Description of dimension levels visible to DBA
39 ALL_DIM_LEVEL_KEY Representations of columns of a dimension level
40 ALL_DIRECTORIES Description of all directories accessible to the user
41 ALL_ERRORS Current errors on stored objects that user is allowed to create
42 ALL_EVALUATION_CONTEXTS rule evaluation contexts seen by user
43 ALL_EVALUATION_CONTEXT_TABLES tables in all rule evaluation contexts seen by the user
44 ALL_EVALUATION_CONTEXT_VARS variables in all rule evaluation contexts seen by the user
45 ALL_EXTERNAL_LOCATIONS Description of the external tables locations accessible to the user
46 ALL_EXTERNAL_TABLES Description of the external tables accessible to the user
47 ALL_INDEXES Descriptions of indexes on tables accessible to the user
48 ALL_INDEXTYPES All indextypes available to the user
49 ALL_INDEXTYPE_COMMENTS Comments for user-defined indextypes
50 ALL_INDEXTYPE_OPERATORS All operators available to the user
51 ALL_IND_COLUMNS COLUMNs comprising INDEXes on accessible TABLES
52 ALL_IND_EXPRESSIONS FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES
53 ALL_IND_PARTITIONS
54 ALL_IND_SUBPARTITIONS
55 ALL_INTERNAL_TRIGGERS Description of the internal triggers on the tables accessible to the user
56 ALL_JOIN_IND_COLUMNS Join Index columns comprising the join conditions
57 ALL_LIBRARIES Description of libraries accessible to the user
58 ALL_LOBS Description of LOBs contained in tables accessible to the user
59 ALL_LOB_PARTITIONS
60 ALL_LOB_SUBPARTITIONS
61 ALL_LOB_TEMPLATES
62 ALL_LOG_GROUPS Log group definitions on accessible tables
63 ALL_LOG_GROUP_COLUMNS Information about columns in log group definitions
64 ALL_METHOD_PARAMS "Description of method parameters of types accessible
to the user"
65 ALL_METHOD_RESULTS "Description of method results of types accessible
to the user"
66 ALL_MVIEWS All materialized views in the database
67 ALL_MVIEW_AGGREGATES Description of the materialized view aggregates accessible to the user
68 ALL_MVIEW_ANALYSIS Description of the materialized views accessible to the user
69 ALL_MVIEW_DETAIL_RELATIONS Description of the materialized view detail tables accessible to the user
70 ALL_MVIEW_JOINS "Description of a join between two columns in the
WHERE clause of a materialized view accessible to the user"
71 ALL_MVIEW_KEYS "Description of the columns that appear in the GROUP BY
list of a materialized view accessible to the user"
72 ALL_MVIEW_LOGS All materialized view logs in the database that the user can see
73 ALL_MVIEW_REFRESH_TIMES Materialized views and their last refresh times for each master table that the user can look at
74 ALL_NESTED_TABLES Description of nested tables in tables accessible to the user
75 ALL_OBJECTS Objects accessible to the user
76 ALL_OBJECT_TABLES Description of all object tables accessible to the user
77 ALL_OBJ_COLATTRS Description of object columns and attributes contained in the tables accessible to the user
78 ALL_OPANCILLARY All ancillary operators available to the user
79 ALL_OPARGUMENTS All arguments of the operators available to the user
80 ALL_OPBINDINGS All binding functions for operators available to the user
81 ALL_OPERATORS All operators available to the user
82 ALL_OPERATOR_COMMENTS Comments for user-defined operators
83 ALL_PARTIAL_DROP_TABS All tables with patially dropped columns accessible to the user
84 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 version
91 ALL_POLICIES All policies for objects if the user has system privileges or owns the objects
92 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 user
96 ALL_PROPAGATION Streams propagation seen by the user
97 ALL_PUBLISHED_COLUMNS
98 ALL_QUEUES All queues accessible to the user
99 ALL_QUEUE_PUBLISHERS
100 ALL_QUEUE_TABLES All queue tables accessible to the user
101 ALL_REFRESH All the refresh groups that the user can touch
102 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 for
refresh"
104 ALL_REFS Description of REF columns contained in tables accessible to the user
105 ALL_REGISTERED_MVIEWS Remote materialized views of local tables that the user can see
106 ALL_REGISTERED_SNAPSHOTS Remote snapshots of local tables that the user can see
107 ALL_REGISTRY_BANNERS
108 ALL_REPAUDIT_ATTRIBUTE Information about attributes automatically maintained for replication
109 ALL_REPAUDIT_COLUMN Information about columns in all shadow tables for replicated tables which are accessible to the user
110 ALL_REPCAT
111 ALL_REPCATLOG Information about asynchronous administration requests
112 ALL_REPCOLUMN Replicated top-level columns (table) sorted alphabetically in ascending order
113 ALL_REPCOLUMN_GROUP All column groups of replicated tables which are accessible to the user
114 ALL_REPCONFLICT All conflicts with available resolutions for user's replicated tables
115 ALL_REPDDL Arguments that do not fit in a single repcat log record
116 ALL_REPFLAVORS Flavors defined for replicated object groups
117 ALL_REPFLAVOR_COLUMNS Replicated columns in flavors
118 ALL_REPFLAVOR_OBJECTS Replicated objects in flavors
119 ALL_REPGENERATED Objects generated to support replication
120 ALL_REPGENOBJECTS Objects generated to support replication
121 ALL_REPGROUP Information about replicated object groups
122 ALL_REPGROUPED_COLUMN Columns in the all column groups of replicated tables which are accessible to the user
123 ALL_REPGROUP_PRIVILEGES Information about users who are registered for object group privileges
124 ALL_REPKEY_COLUMNS Primary columns for a table using column-level replication
125 ALL_REPOBJECT Information about replicated objects
126 ALL_REPPARAMETER_COLUMN All columns used for resolving conflicts in replicated tables which are accessible to the user
127 ALL_REPPRIORITY Values and their corresponding priorities in all priority groups which are accessible to the user
128 ALL_REPPRIORITY_GROUP Information about all priority groups which are accessible to the user
129 ALL_REPPROP Propagation information about replicated objects
130 ALL_REPRESOLUTION Description of all conflict resolutions for replicated tables which are accessible to the user
131 ALL_REPRESOLUTION_METHOD All conflict resolution methods accessible to the user
132 ALL_REPRESOLUTION_STATISTICS Statistics for conflict resolutions for replicated tables which are accessible to the user
133 ALL_REPRESOL_STATS_CONTROL Information about statistics collection for conflict resolutions for replicated tables which are accessible to the user
134 ALL_REPSCHEMA N-way replication information
135 ALL_REPSITES N-way replication information
136 ALL_RULES Rules seen by the user
137 ALL_RULESETS Rulesets seen by the user: maintained for backward compatibility
138 ALL_RULE_SETS Rule sets seen by the user
139 ALL_RULE_SET_RULES Rules in all rule sets seen by the user
140 ALL_SECONDARY_OBJECTS All secondary objects for domain indexes
141 ALL_SEQUENCES Description of SEQUENCEs accessible to the user
142 ALL_SNAPSHOTS Snapshots the user can access
143 ALL_SNAPSHOT_LOGS All snapshot logs in the database that the user can see
144 ALL_SOURCE Current source on stored objects that user is allowed to create
145 ALL_SOURCE_TABLES
146 ALL_SOURCE_TAB_COLUMNS
147 ALL_SQLJ_TYPES Description of types accessible to the user
148 ALL_SQLJ_TYPE_ATTRS Description of attributes of types accessible to the user
149 ALL_SQLJ_TYPE_METHODS Description of methods of types accessible to the user
150 ALL_STORED_SETTINGS Parameter settings for objects accessible to the user
151 ALL_STREAMS_GLOBAL_RULES Global rules created on the streams capture/apply/propagation process that interact with the queue visible to the current user
152 ALL_STREAMS_SCHEMA_RULES Rules created by streams administrative APIs on all user schemas
153 ALL_STREAMS_TABLE_RULES Rules created by streams administrative APIs on tables visible to the current user
154 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 user
162 ALL_SUMMARIES Description of the summaries accessible to the user
163 ALL_SYNONYMS All synonyms accessible to the user
164 ALL_TABLES Description of relational tables accessible to the user
165 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 user
169 ALL_TAB_HISTOGRAMS Histograms on columns of all tables visible to user
170 ALL_TAB_MODIFICATIONS Information regarding modifications to tables
171 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 objects
174 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 user
177 ALL_TRIGGER_COLS Column usage in user's triggers or in triggers on user's tables
178 ALL_TYPES Description of types accessible to the user
179 ALL_TYPE_ATTRS Description of attributes of types accessible to the user
180 ALL_TYPE_METHODS Description of methods of types accessible to the user
181 ALL_TYPE_VERSIONS Description of each type version accessible to the user
182 ALL_UNUSED_COL_TABS All tables with unused columns accessible to the user
183 ALL_UPDATABLE_COLUMNS Description of all updatable columns
184 ALL_USERS Information about all users of the database
185 ALL_USTATS All statistics
186 ALL_VARRAYS Description of varrays in tables accessible to the user
187 ALL_VIEWS Description of views accessible to the user
188 ALL_WORKSPACES
189 DBA_2PC_NEIGHBORS information about incoming and outgoing connections for pending transactions
190 DBA_2PC_PENDING info about distributed transactions awaiting recovery
191 DBA_ALL_TABLES Description of all object and relational tables in the database
192 DBA_ANALYZE_OBJECTS
193 DBA_APPLY Details about the apply process
194 DBA_APPLY_CONFLICT_COLUMNS Details about conflict resolution
195 DBA_APPLY_DML_HANDLERS Details about the dml handler
196 DBA_APPLY_ERROR Error transactions
197 DBA_APPLY_INSTANTIATED_OBJECTS Details about objects instantiated
198 DBA_APPLY_KEY_COLUMNS alternative key columns for a table for STREAMS
199 DBA_APPLY_PARAMETERS All parameters for apply process
200 DBA_APPLY_PROGRESS Information about the progress made by apply process
201 DBA_AQ_AGENTS
202 DBA_AQ_AGENT_PRIVS
203 DBA_ASSOCIATIONS All associations
204 DBA_ATTRIBUTE_TRANSFORMATIONS
205 DBA_AUDIT_EXISTS Lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS
206 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 database
208 DBA_AUDIT_SESSION All audit trail records concerning CONNECT and DISCONNECT
209 DBA_AUDIT_STATEMENT "Audit trail records concerning grant, revoke, audit, noaudit and alter system"
210 DBA_AUDIT_TRAIL All audit trail entries
211 DBA_AWS Analytic Workspaces in the database
212 DBA_AW_PS Pagespaces in Analytic Workspaces owned by the user
213 DBA_BASE_TABLE_MVIEWS All materialized views with log(s) in the database
214 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 process
221 DBA_CAPTURE_PARAMETERS All parameters for capture process
222 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 instantiation
224 DBA_CAPTURE_PREPARED_TABLES All tables prepared for instantiation
225 DBA_CATALOG "All database Tables, Views, Synonyms, Sequences"
226 DBA_CLUSTERS Description of all clusters in the database
227 DBA_CLUSTER_HASH_EXPRESSIONS Hash functions for all clusters
228 DBA_CLU_COLUMNS Mapping of table columns to cluster columns
229 DBA_COLL_TYPES Description of all named collection types in the database
230 DBA_COL_COMMENTS Comments on columns of all tables and views
231 DBA_COL_PRIVS All grants on columns in the database
232 DBA_CONSTRAINTS Constraint definitions on all tables
233 DBA_CONS_COLUMNS Information about accessible columns in constraint definitions
234 DBA_CONS_OBJ_COLUMNS List of types an object column or attribute is constrained to in all tables in the database
235 DBA_CONTEXT Description of all context namespace information
236 DBA_DATA_FILES Information about database data files
237 DBA_DB_LINKS All database links in the database
238 DBA_DDL_LOCKS
239 DBA_DEPENDENCIES Dependencies to and from objects
240 DBA_DIMENSIONS Description of the dimension objects accessible to the DBA
241 DBA_DIM_ATTRIBUTES "Representation of the relationship between a dimension level and
a functionally dependent column"
242 DBA_DIM_CHILD_OF "Representaion of a 1:n hierarchical relationship between a pair of levels in
a dimension"
243 DBA_DIM_HIERARCHIES Representation of a dimension hierarchy
244 DBA_DIM_JOIN_KEY Representation of a join between two dimension tables.
245 DBA_DIM_LEVELS Description of dimension levels visible to DBA
246 DBA_DIM_LEVEL_KEY Representations of columns of a dimension level
247 DBA_DIRECTORIES Description of all directories
248 DBA_DML_LOCKS
249 DBA_DMT_FREE_SPACE Free extents in all dictionary managed tablespaces
250 DBA_DMT_USED_EXTENTS All extents in the dictionary managed tablespaces
251 DBA_ERRORS Current errors on all stored objects in the database
252 DBA_EVALUATION_CONTEXTS rule evaluation contexts in the database
253 DBA_EVALUATION_CONTEXT_TABLES tables in all rule evaluation contexts in the database
254 DBA_EVALUATION_CONTEXT_VARS variables in all rule evaluation contexts in the database
255 DBA_EXP_FILES Description of export files
256 DBA_EXP_OBJECTS Objects that have been incrementally exported
257 DBA_EXP_VERSION Version number of the last export session
258 DBA_EXTENTS Extents comprising all segments in the database
259 DBA_EXTERNAL_LOCATIONS Description of the external tables locations accessible to the DBA
260 DBA_EXTERNAL_TABLES Description of the external tables accessible to the DBA
261 DBA_FGA_AUDIT_TRAIL All fine grained audit event logs
262 DBA_FREE_SPACE Free extents in all tablespaces
263 DBA_FREE_SPACE_COALESCED Statistics on Coalesced Space in Tablespaces
264 DBA_GLOBAL_CONTEXT Description of all context information accessible globally
265 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 database
276 DBA_INDEXTYPES All indextypes
277 DBA_INDEXTYPE_COMMENTS Comments for user-defined indextypes
278 DBA_INDEXTYPE_OPERATORS All indextype operators
279 DBA_IND_COLUMNS COLUMNs comprising INDEXes on all TABLEs and CLUSTERs
280 DBA_IND_EXPRESSIONS FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLUSTERS
281 DBA_IND_PARTITIONS
282 DBA_IND_SUBPARTITIONS
283 DBA_INTERNAL_TRIGGERS Description of the internal triggers on all tables in the database
284 DBA_JOBS All jobs in the database
285 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 conditions
287 DBA_KGLLOCK
288 DBA_LIBRARIES Description of all libraries in the database
289 DBA_LMT_FREE_SPACE Free extents in all locally managed tablespaces
290 DBA_LMT_USED_EXTENTS All extents in the locally managed tablespaces
291 DBA_LOBS Description of LOBs contained in all tables
292 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 events
298 DBA_LOGSTDBY_NOT_UNIQUE List of all the tables with out primary or unique key not null constraints
299 DBA_LOGSTDBY_PARAMETERS Miscellaneous options and settings for Logical Standby
300 DBA_LOGSTDBY_PROGRESS List the SCN values describing read and apply progress
301 DBA_LOGSTDBY_SKIP List the skip settings choosen
302 DBA_LOGSTDBY_SKIP_TRANSACTION List the transactions to be skipped
303 DBA_LOGSTDBY_UNSUPPORTED List of all the columns that are not supported by Logical Standby
304 DBA_LOG_GROUPS Log group definitions on all tables
305 DBA_LOG_GROUP_COLUMNS Information about columns in log group definitions
306 DBA_METHOD_PARAMS Description of method parameters of all types in the database
307 DBA_METHOD_RESULTS Description of method results of all types in the database
308 DBA_MVIEWS All materialized views in the database
309 DBA_MVIEW_AGGREGATES Description of the materialized view aggregates accessible to dba
310 DBA_MVIEW_ANALYSIS Description of the materialized views accessible to dba
311 DBA_MVIEW_DETAIL_RELATIONS Description of the materialized view detail tables accessible to dba
312 DBA_MVIEW_JOINS "Description of a join between two columns in the
WHERE clause of a materialized view accessible to dba"
313 DBA_MVIEW_KEYS "Description of the columns that appear in the GROUP BY
list of a materialized view accessible to dba"
314 DBA_MVIEW_LOGS All materialized view logs in the database
315 DBA_MVIEW_LOG_FILTER_COLS All filter columns (excluding PK cols) being logged in the materialized view logs
316 DBA_MVIEW_REFRESH_TIMES All fast refreshable materialized views and their last refresh times for each master table
317 DBA_NESTED_TABLES Description of nested tables contained in all tables
318 DBA_OBJECTS All objects in the database
319 DBA_OBJECT_SIZE "Sizes, in bytes, of various pl/sql objects"
320 DBA_OBJECT_TABLES Description of all object tables in the database
321 DBA_OBJ_AUDIT_OPTS Auditing options for all tables and views
322 DBA_OBJ_COLATTRS Description of object columns and attributes contained in all tables in the database
323 DBA_OPANCILLARY All ancillary operators
324 DBA_OPARGUMENTS All operator arguments
325 DBA_OPBINDINGS All operator binding functiosn or methods
326 DBA_OPERATORS All operators
327 DBA_OPERATOR_COMMENTS Comments for user-defined operators
328 DBA_OUTLINES Stored outlines
329 DBA_OUTLINE_HINTS Hints stored in outlines
330 DBA_PARTIAL_DROP_TABS All tables with partially dropped columns in the database
331 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 database
338 DBA_PENDING_TRANSACTIONS information about unresolved global transactions
339 DBA_POLICIES All row level security policies in the database
340 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 user
343 DBA_PROCEDURES Description of all procedures
344 DBA_PROFILES Display all profiles and their limits
345 DBA_PROPAGATION Streams propagation in the database
346 DBA_PROXIES Information about all proxy connections
347 DBA_PUBLISHED_COLUMNS
348 DBA_QUEUES All database queues
349 DBA_QUEUE_PUBLISHERS
350 DBA_QUEUE_SCHEDULES
351 DBA_QUEUE_TABLES All queue tables created in the database
352 DBA_RCHILD All the children in any refresh group. This view is not a join.
353 DBA_REFRESH All the refresh groups
354 DBA_REFRESH_CHILDREN All the objects in refresh groups
355 DBA_REFS Description of REF columns contained in all tables
356 DBA_REGISTERED_MVIEWS Remote materialized views of local tables
357 DBA_REGISTERED_MVIEW_GROUPS Materialized view repgroup registration information
358 DBA_REGISTERED_SNAPSHOTS Remote snapshots of local tables
359 DBA_REGISTERED_SNAPSHOT_GROUPS Snapshot repgroup registration information
360 DBA_REGISTRY
361 DBA_REGISTRY_HIERARCHY
362 DBA_REPAUDIT_ATTRIBUTE Information about attributes automatically maintained for replication
363 DBA_REPAUDIT_COLUMN Information about columns in all shadow tables for all replicated tables in the database
364 DBA_REPCAT
365 DBA_REPCATLOG Information about asynchronous administration requests
366 DBA_REPCAT_EXCEPTIONS Repcat processing exceptions table.
367 DBA_REPCOLUMN Replicated top-level columns (table) sorted alphabetically in ascending order
368 DBA_REPCOLUMN_GROUP All column groups of replicated tables in the database
369 DBA_REPCONFLICT All conflicts for which users have specified resolutions in the database
370 DBA_REPDDL Arguments that do not fit in a single repcat log record
371 DBA_REPEXTENSIONS Information about replication extension requests
372 DBA_REPFLAVORS Flavors defined for replicated object groups
373 DBA_REPFLAVOR_COLUMNS Replicated columns in flavors
374 DBA_REPFLAVOR_OBJECTS Replicated objects in flavors
375 DBA_REPGENERATED Objects generated to support replication
376 DBA_REPGENOBJECTS Objects generated to support replication
377 DBA_REPGROUP Information about all replicated object groups
378 DBA_REPGROUPED_COLUMN Columns in the all column groups of replicated tables in the database
379 DBA_REPGROUP_PRIVILEGES Information about users who are registered for object group privileges
380 DBA_REPKEY_COLUMNS Primary columns for a table using column-level replication
381 DBA_REPOBJECT Information about replicated objects
382 DBA_REPPARAMETER_COLUMN All columns used for resolving conflicts in the database
383 DBA_REPPRIORITY Values and their corresponding priorities in all priority groups in the database
384 DBA_REPPRIORITY_GROUP Information about all priority groups in the database
385 DBA_REPPROP Propagation information about replicated objects
386 DBA_REPRESOLUTION Description of all conflict resolutions in the database
387 DBA_REPRESOLUTION_METHOD All conflict resolution methods in the database
388 DBA_REPRESOLUTION_STATISTICS Statistics for conflict resolutions for all replicated tables in the database
389 DBA_REPRESOL_STATS_CONTROL Information about statistics collection for conflict resolutions for all replicated tables in the database
390 DBA_REPSCHEMA N-way replication information
391 DBA_REPSITES N-way replication information
392 DBA_REPSITES_NEW Information about new masters for replication extension
393 DBA_RESUMABLE Resumable session information in the system
394 DBA_RGROUP All refresh groups. This view is not a join.
395 DBA_ROLES All Roles which exist in the database
396 DBA_ROLE_PRIVS Roles granted to users and roles
397 DBA_ROLLBACK_SEGS Description of rollback segments
398 DBA_RSRC_CONSUMER_GROUPS all the resource consumer groups
399 DBA_RSRC_CONSUMER_GROUP_PRIVS Switch privileges for consumer groups
400 DBA_RSRC_MANAGER_SYSTEM_PRIVS system privileges for the resource manager
401 DBA_RSRC_PLANS All the resource plans
402 DBA_RSRC_PLAN_DIRECTIVES all the resource plan directives
403 DBA_RULES Rules in the databse
404 DBA_RULESETS Rulesets in the database: maintained for backward compatibility
405 DBA_RULE_SETS Rule sets in the database
406 DBA_RULE_SET_RULES Rules in all rule sets in the database
407 DBA_SECONDARY_OBJECTS All secondary objects for domain indexes
408 DBA_SEGMENTS Storage allocated for all database segments
409 DBA_SEQUENCES Description of all SEQUENCEs in the database
410 DBA_SNAPSHOTS All snapshots in the database
411 DBA_SNAPSHOT_LOGS All snapshot logs in the database
412 DBA_SOURCE Source of all stored objects in the database
413 DBA_SOURCE_TABLES
414 DBA_SOURCE_TAB_COLUMNS
415 DBA_SQLJ_TYPES Description of all types in the database
416 DBA_SQLJ_TYPE_ATTRS Description of attributes of all types in the database
417 DBA_SQLJ_TYPE_METHODS Description of methods of all types in the database
418 DBA_STMT_AUDIT_OPTS Describes current system auditing options across the system and by user
419 DBA_STORED_SETTINGS Parameter settings for all objects
420 DBA_STREAMS_GLOBAL_RULES Global rules created by streams administrative APIs
421 DBA_STREAMS_SCHEMA_RULES Schema rules created by streams administrative APIs
422 DBA_STREAMS_TABLE_RULES Table rules created by streams administrative APIs
423 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 dba
431 DBA_SYNONYMS All synonyms in the database
432 DBA_SYS_PRIVS System privileges granted to users and roles
433 DBA_TABLES Description of all relational tables in the database
434 DBA_TABLESPACES Description of all tablespaces
435 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 database
439 DBA_TAB_HISTOGRAMS Histograms on columns of all tables
440 DBA_TAB_MODIFICATIONS Information regarding modifications to tables
441 DBA_TAB_PARTITIONS
442 DBA_TAB_PRIVS All grants on objects in the database
443 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 files
447 DBA_TRANSFORMATIONS
448 DBA_TRIGGERS All triggers in the database
449 DBA_TRIGGER_COLS Column usage in all triggers
450 DBA_TS_QUOTAS Tablespace quotas for all users
451 DBA_TYPES Description of all types in the database
452 DBA_TYPE_ATTRS Description of attributes of all types in the database
453 DBA_TYPE_METHODS Description of methods of all types in the database
454 DBA_TYPE_VERSIONS Description of each type version in the database
455 DBA_UNDO_EXTENTS Extents comprising all segments in the system managed undo tablespaces
456 DBA_UNUSED_COL_TABS All tables with unused columns in the database
457 DBA_UPDATABLE_COLUMNS Description of dba updatable columns
458 DBA_USERS Information about all users of the database
459 DBA_USTATS All statistics collected on either tables or indexes
460 DBA_VARRAYS Description of varrays in tables accessible to the user
461 DBA_VIEWS Description of all views in the database
462 DBA_WAITERS
463 DBA_WORKSPACES
464 DBA_WORKSPACE_SESSIONS
465 USER_ALL_TABLES Description of all object and relational tables owned by the user's
466 USER_AQ_AGENT_PRIVS
467 USER_ARGUMENTS Arguments in object accessible to the user
468 USER_ASSOCIATIONS All assocations defined by the user
469 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 schema
472 USER_AUDIT_SESSION All audit trail records concerning CONNECT and DISCONNECT
473 USER_AUDIT_STATEMENT "Audit trail records concerning grant, revoke, audit, noaudit and alter system"
474 USER_AUDIT_TRAIL Audit trail entries relevant to the user
475 USER_AWS Analytic Workspaces owned by the user
476 USER_AW_PS Pagespaces in Analytic Workspaces owned by the user
477 USER_BASE_TABLE_MVIEWS All materialized views with log(s) owned by the user in the database
478 USER_CATALOG "Tables, Views, Synonyms and Sequences owned by the user"
479 USER_CLUSTERS Descriptions of user's own clusters
480 USER_CLUSTER_HASH_EXPRESSIONS Hash functions for the user's hash clusters
481 USER_CLU_COLUMNS Mapping of table columns to cluster columns
482 USER_COLL_TYPES Description of the user's own named collection types
483 USER_COL_COMMENTS Comments on columns of user's tables and views
484 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 user
486 USER_COL_PRIVS_RECD Grants on columns for which the user is the grantee
487 USER_CONSTRAINTS Constraint definitions on user's own tables
488 USER_CONS_COLUMNS Information about accessible columns in constraint definitions
489 USER_CONS_OBJ_COLUMNS List of types an object column or attribute is constrained to in the tables owned by the user
490 USER_DB_LINKS Database links owned by the user
491 USER_DEPENDENCIES Dependencies to and from a users objects
492 USER_DIMENSIONS Description of the dimension objects accessible to the DBA
493 USER_DIM_ATTRIBUTES "Representation of the relationship between a dimension level and
a functionally dependent column"
494 USER_DIM_CHILD_OF "Representaion of a 1:n hierarchical relationship between a pair of levels in
a dimension"
495 USER_DIM_HIERARCHIES Representation of a dimension hierarchy
496 USER_DIM_JOIN_KEY Representation of a join between two dimension tables.
497 USER_DIM_LEVELS Description of dimension levels visible to DBA
498 USER_DIM_LEVEL_KEY Representations of columns of a dimension level
499 USER_ERRORS Current errors on stored objects owned by the user
500 USER_EVALUATION_CONTEXTS rule evaluation contexts owned by user
501 USER_EVALUATION_CONTEXT_TABLES tables in user rule evaluation contexts
502 USER_EVALUATION_CONTEXT_VARS variables in user rule evaluation contexts
503 USER_EXTENTS Extents comprising segments owned by the user
504 USER_EXTERNAL_LOCATIONS Description of the user's external tables locations
505 USER_EXTERNAL_TABLES Description of the user's own external tables
506 USER_FREE_SPACE Free extents in tablespaces accessible to the user
507 USER_INDEXES Description of the user's own indexes
508 USER_INDEXTYPES All user indextypes
509 USER_INDEXTYPE_COMMENTS Comments for user-defined indextypes
510 USER_INDEXTYPE_OPERATORS All user indextype operators
511 USER_IND_COLUMNS COLUMNs comprising user's INDEXes and INDEXes on user's TABLES
512 USER_IND_EXPRESSIONS Functional index expressions in user's indexes and indexes on user's tables
513 USER_IND_PARTITIONS
514 USER_IND_SUBPARTITIONS
515 USER_INTERNAL_TRIGGERS Description of the internal triggers on the user's own tables
516 USER_JOBS All jobs owned by this user
517 USER_JOIN_IND_COLUMNS Join Index columns comprising the join conditions
518 USER_LIBRARIES Description of the user's own libraries
519 USER_LOBS Description of the user's own LOBs contained in the user's own tables
520 USER_LOB_PARTITIONS
521 USER_LOB_SUBPARTITIONS
522 USER_LOB_TEMPLATES
523 USER_LOG_GROUPS Log group definitions on user's own tables
524 USER_LOG_GROUP_COLUMNS Information about columns in log group definitions
525 USER_METHOD_PARAMS Description of method parameters of the user's own types
526 USER_METHOD_RESULTS Description of method results of the user's own types
527 USER_MVIEWS All materialized views in the database
528 USER_MVIEW_AGGREGATES Description of the materialized view aggregates created by the user
529 USER_MVIEW_ANALYSIS Description of the materialized views created by the user
530 USER_MVIEW_DETAIL_RELATIONS "Description of the materialized view detail tables of the materialized
views created by the user"
531 USER_MVIEW_JOINS "Description of a join between two columns in the
WHERE clause of a materialized view created by the user"
532 USER_MVIEW_KEYS "Description of the columns that appear in the GROUP BY
list of a materialized view created by the user"
533 USER_MVIEW_LOGS All materialized view logs owned by the user
534 USER_MVIEW_REFRESH_TIMES Materialized views and their last refresh times for each master table that the user can look at
535 USER_NESTED_TABLES Description of nested tables contained in the user's own tables
536 USER_OBJECTS Objects owned by the user
537 USER_OBJECT_SIZE "Sizes, in bytes, of various pl/sql objects"
538 USER_OBJECT_TABLES Description of the user's own object tables
539 USER_OBJ_AUDIT_OPTS Auditing options for user's own tables and views
540 USER_OBJ_COLATTRS Description of object columns and attributes contained in tables owned by the user
541 USER_OPANCILLARY All ancillary opertors defined by user
542 USER_OPARGUMENTS All operator arguments of operators defined by user
543 USER_OPBINDINGS All binding functions or methods on operators defined by the user
544 USER_OPERATORS All user operators
545 USER_OPERATOR_COMMENTS Comments for user-defined operators
546 USER_OUTLINES Stored outlines owned by the user
547 USER_OUTLINE_HINTS Hints stored in outlines owned by the user
548 USER_PARTIAL_DROP_TABS User tables with unused columns
549 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 user
556 USER_PENDING_CONV_TABLES All user's tables which are not upgraded to the latest type version
557 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 procedures
561 USER_PROXIES Description of connections the user is allowed to proxy
562 USER_PUBLISHED_COLUMNS
563 USER_QUEUES All queues owned by the user
564 USER_QUEUE_PUBLISHERS
565 USER_QUEUE_SCHEDULES
566 USER_QUEUE_TABLES All queue tables created by the user
567 USER_REFRESH All the refresh groups
568 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 tables
570 USER_REGISTERED_MVIEWS Remote materialized views of local tables currently using logs owned by the user
571 USER_REGISTERED_SNAPSHOTS Remote snapshots of local tables currently using logs owned by the user
572 USER_REGISTRY
573 USER_REPAUDIT_ATTRIBUTE Information about attributes automatically maintained for replication
574 USER_REPAUDIT_COLUMN Information about columns in all shadow tables for user's replicated tables
575 USER_REPCAT
576 USER_REPCATLOG Information about the current user's asynchronous administration requests
577 USER_REPCOLUMN Replicated columns for the current user's table in ascending order
578 USER_REPCOLUMN_GROUP All column groups of user's replicated tables
579 USER_REPCONFLICT
580 USER_REPDDL Arguments that do not fit in a single repcat log record
581 USER_REPFLAVORS Flavors current user created for replicated object groups
582 USER_REPFLAVOR_COLUMNS Replicated columns from current user's tables in flavors
583 USER_REPFLAVOR_OBJECTS Replicated user objects in flavors
584 USER_REPGENERATED Objects generated for the current user to support replication
585 USER_REPGENOBJECTS Objects generated for the current user to support replication
586 USER_REPGROUP Replication information about the current user
587 USER_REPGROUPED_COLUMN Columns in the all column groups of user's replicated tables
588 USER_REPGROUP_PRIVILEGES Information about users who are registered for object group privileges
589 USER_REPKEY_COLUMNS Primary columns for a table using column-level replication
590 USER_REPOBJECT Replication information about the current user's objects
591 USER_REPPARAMETER_COLUMN All columns used for resolving conflicts in user's replicated tables
592 USER_REPPRIORITY Values and their corresponding priorities in user's priority groups
593 USER_REPPRIORITY_GROUP Information about user's priority groups
594 USER_REPPROP Propagation information about the current user's objects
595 USER_REPRESOLUTION Description of all conflict resolutions for user's replicated tables
596 USER_REPRESOLUTION_METHOD All conflict resolution methods accessible to the user
597 USER_REPRESOLUTION_STATISTICS Statistics for conflict resolutions for user's replicated tables
598 USER_REPRESOL_STATS_CONTROL Information about statistics collection for conflict resolutions for user's replicated tables
599 USER_REPSCHEMA N-way replication information about the current user
600 USER_REPSITES N-way replication information about the current user
601 USER_RESOURCE_LIMITS Display resource limit of the user
602 USER_RESUMABLE Resumable session information for current user
603 USER_ROLE_PRIVS Roles granted to current user
604 USER_RSRC_CONSUMER_GROUP_PRIVS Switch privileges for consumer groups for the user
605 USER_RSRC_MANAGER_SYSTEM_PRIVS system privileges for the resource manager for the user
606 USER_RULES Rules owned by the user
607 USER_RULESETS Rulesets owned by the user: maintained for backward compatibility
608 USER_RULE_SETS Rule sets owned by the user
609 USER_RULE_SET_RULES Rules in user rule sets
610 USER_SECONDARY_OBJECTS All secondary objects for domain indexes
611 USER_SEGMENTS Storage allocated for all database segments
612 USER_SEQUENCES Description of the user's own SEQUENCEs
613 USER_SNAPSHOTS Snapshots the user can look at
614 USER_SNAPSHOT_LOGS All snapshot logs owned by the user
615 USER_SOURCE Source of stored objects accessible to the user
616 USER_SOURCE_TABLES
617 USER_SOURCE_TAB_COLUMNS
618 USER_SQLJ_TYPES Description of the user's own types
619 USER_SQLJ_TYPE_ATTRS Description of attributes of the user's own types
620 USER_SQLJ_TYPE_METHODS Description of methods of the user's own types
621 USER_STORED_SETTINGS Parameter settings for objects owned by the user
622 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 user
630 USER_SYNONYMS The user's private synonyms
631 USER_SYS_PRIVS System privileges granted to current user
632 USER_TABLES Description of the user's own relational tables
633 USER_TABLESPACES Description of accessible tablespaces
634 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 user
638 USER_TAB_HISTOGRAMS Histograms on columns of user's tables
639 USER_TAB_MODIFICATIONS Information regarding modifications to tables
640 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 user
643 USER_TAB_PRIVS_RECD Grants on objects for which the user is the grantee
644 USER_TAB_SUBPARTITIONS
645 USER_TRANSFORMATIONS
646 USER_TRIGGERS Triggers owned by the user
647 USER_TRIGGER_COLS Column usage in user's triggers
648 USER_TS_QUOTAS Tablespace quotas for the user
649 USER_TYPES Description of the user's own types
650 USER_TYPE_ATTRS Description of attributes of the user's own types
651 USER_TYPE_METHODS Description of methods of the user's own types
652 USER_TYPE_VERSIONS Description of each version of the user's types
653 USER_UNUSED_COL_TABS User tables with unused columns
654 USER_UPDATABLE_COLUMNS Description of updatable columns
655 USER_USERS Information about the current user
656 USER_USTATS All statistics on tables or indexes owned by the user
657 USER_VARRAYS Description of varrays contained in the user's own tables
658 USER_VIEWS Description of the user's own views
659 USER_WORKSPACES
660 AUDIT_ACTIONS Description table for audit trail action type codes. Maps action type numbers to action type names
661 COLUMN_PRIVILEGES "Grants on columns for which the user is the grantor, grantee, owner, or
an enabled role or PUBLIC is the grantee"
662 DATABASE_COMPATIBLE_LEVEL Database compatible parameter set via init.ora
663 DBMS_ALERT_INFO
664 DBMS_LOCK_ALLOCATED
665 DICTIONARY Description of data dictionary tables and views
666 DICT_COLUMNS Description of columns in data dictionary tables and views
667 DUAL
668 GLOBAL_NAME global database name
669 INDEX_HISTOGRAM statistics on keys with repeat count
670 INDEX_STATS statistics on the b-tree
671 NLS_DATABASE_PARAMETERS Permanent NLS parameters of the database
672 NLS_INSTANCE_PARAMETERS NLS parameters of the instance
673 NLS_SESSION_PARAMETERS NLS parameters of the user session
674 RESOURCE_COST Cost for each resource
675 ROLE_ROLE_PRIVS Roles which are granted to roles
676 ROLE_SYS_PRIVS System privileges granted to roles
677 ROLE_TAB_PRIVS Table privileges granted to roles
678 SESSION_PRIVS Privileges which the user currently has set
679 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_HISTOGRAMS
682 ALL_JOBS Synonym for USER_JOBS
683 ALL_OUTLINES Synonym for USER_OUTLINES
684 ALL_OUTLINE_HINTS Synonym for USER_OUTLINE_HINTS
685 ALL_SNAPSHOT_REFRESH_TIMES Synonym for ALL_MVIEW_REFRESH_TIMES
686 CAT Synonym for USER_CATALOG
687 CLU Synonym for USER_CLUSTERS
688 COLS Synonym for USER_TAB_COLUMNS
689 DBA_HISTOGRAMS Synonym for DBA_TAB_HISTOGRAMS
690 DBA_LOCKS Synonym for DBA_LOCK
691 DBA_SNAPSHOT_LOG_FILTER_COLS Synonym for DBA_MVIEW_LOG_FILTER_COLS
692 DBA_SNAPSHOT_REFRESH_TIMES Synonym for DBA_MVIEW_REFRESH_TIMES
693 DICT Synonym for DICTIONARY
694 GV$ACCESS Synonym for GV_$ACCESS
695 GV$ACTIVE_INSTANCES Synonym for GV_$ACTIVE_INSTANCES
696 GV$ACTIVE_SESS_POOL_MTH Synonym for GV_$ACTIVE_SESS_POOL_MTH
697 GV$AQ Synonym for GV_$AQ
698 GV$AQ1 Synonym for GV_$AQ1
699 GV$ARCHIVE Synonym for GV_$ARCHIVE
700 GV$ARCHIVED_LOG Synonym for GV_$ARCHIVED_LOG
701 GV$ARCHIVE_DEST Synonym for GV_$ARCHIVE_DEST
702 GV$ARCHIVE_DEST_STATUS Synonym for GV_$ARCHIVE_DEST_STATUS
703 GV$ARCHIVE_GAP Synonym for GV_$ARCHIVE_GAP
704 GV$ARCHIVE_PROCESSES Synonym for GV_$ARCHIVE_PROCESSES
705 GV$AW_CALC Synonym for GV_$AW_CALC
706 GV$AW_OLAP Synonym for GV_$AW_OLAP
707 GV$AW_SESSION_INFO Synonym for GV_$AW_SESSION_INFO
708 GV$BACKUP Synonym for GV_$BACKUP
709 GV$BACKUP_ASYNC_IO Synonym for GV_$BACKUP_ASYNC_IO
710 GV$BACKUP_CORRUPTION Synonym for GV_$BACKUP_CORRUPTION
711 GV$BACKUP_DATAFILE Synonym for GV_$BACKUP_DATAFILE
712 GV$BACKUP_DEVICE Synonym for GV_$BACKUP_DEVICE
713 GV$BACKUP_PIECE Synonym for GV_$BACKUP_PIECE
714 GV$BACKUP_REDOLOG Synonym for GV_$BACKUP_REDOLOG
715 GV$BACKUP_SET Synonym for GV_$BACKUP_SET
716 GV$BACKUP_SPFILE Synonym for GV_$BACKUP_SPFILE
717 GV$BACKUP_SYNC_IO Synonym for GV_$BACKUP_SYNC_IO
718 GV$BGPROCESS Synonym for GV_$BGPROCESS
719 GV$BH Synonym for GV_$BH
720 GV$BSP Synonym for GV_$BSP
721 GV$BUFFER_POOL Synonym for GV_$BUFFER_POOL
722 GV$BUFFER_POOL_STATISTICS Synonym for GV_$BUFFER_POOL_STATISTICS
723 GV$CIRCUIT Synonym for GV_$CIRCUIT
724 GV$CLASS_CACHE_TRANSFER Synonym for GV_$CLASS_CACHE_TRANSFER
725 GV$CLASS_PING Synonym for GV_$CLASS_PING
726 GV$COMPATIBILITY Synonym for GV_$COMPATIBILITY
727 GV$COMPATSEG Synonym for GV_$COMPATSEG
728 GV$CONTEXT Synonym for GV_$CONTEXT
729 GV$CONTROLFILE Synonym for GV_$CONTROLFILE
730 GV$CONTROLFILE_RECORD_SECTION Synonym for GV_$CONTROLFILE_RECORD_SECTION
731 GV$COPY_CORRUPTION Synonym for GV_$COPY_CORRUPTION
732 GV$CR_BLOCK_SERVER Synonym for GV_$CR_BLOCK_SERVER
733 GV$DATABASE Synonym for GV_$DATABASE
734 GV$DATABASE_BLOCK_CORRUPTION Synonym for GV_$DATABASE_BLOCK_CORRUPTION
735 GV$DATABASE_INCARNATION Synonym for GV_$DATABASE_INCARNATION
736 GV$DATAFILE Synonym for GV_$DATAFILE
737 GV$DATAFILE_COPY Synonym for GV_$DATAFILE_COPY
738 GV$DATAFILE_HEADER Synonym for GV_$DATAFILE_HEADER
739 GV$DATAGUARD_STATUS Synonym for GV_$DATAGUARD_STATUS
740 GV$DBFILE Synonym for GV_$DBFILE
741 GV$DBLINK Synonym for GV_$DBLINK
742 GV$DB_CACHE_ADVICE Synonym for GV_$DB_CACHE_ADVICE
743 GV$DB_OBJECT_CACHE Synonym for GV_$DB_OBJECT_CACHE
744 GV$DB_PIPES Synonym for GV_$DB_PIPES
745 GV$DELETED_OBJECT Synonym for GV_$DELETED_OBJECT
746 GV$DISPATCHER Synonym for GV_$DISPATCHER
747 GV$DISPATCHER_RATE Synonym for GV_$DISPATCHER_RATE
748 GV$DLM_ALL_LOCKS Synonym for GV_$DLM_ALL_LOCKS
749 GV$DLM_CONVERT_LOCAL Synonym for GV_$DLM_CONVERT_LOCAL
750 GV$DLM_CONVERT_REMOTE Synonym for GV_$DLM_CONVERT_REMOTE
751 GV$DLM_LATCH Synonym for GV_$DLM_LATCH
752 GV$DLM_LOCKS Synonym for GV_$DLM_LOCKS
753 GV$DLM_MISC Synonym for GV_$DLM_MISC
754 GV$DLM_RESS Synonym for GV_$DLM_RESS
755 GV$DLM_TRAFFIC_CONTROLLER Synonym for GV_$DLM_TRAFFIC_CONTROLLER
756 GV$ENABLEDPRIVS Synonym for GV_$ENABLEDPRIVS
757 GV$ENQUEUE_LOCK Synonym for GV_$ENQUEUE_LOCK
758 GV$ENQUEUE_STAT Synonym for GV_$ENQUEUE_STAT
759 GV$EVENT_NAME Synonym for GV_$EVENT_NAME
760 GV$EXECUTION Synonym for GV_$EXECUTION
761 GV$FAST_START_SERVERS Synonym for GV_$FAST_START_SERVERS
762 GV$FAST_START_TRANSACTIONS Synonym for GV_$FAST_START_TRANSACTIONS
763 GV$FILESTAT Synonym for GV_$FILESTAT
764 GV$FILE_CACHE_TRANSFER Synonym for GV_$FILE_CACHE_TRANSFER
765 GV$FILE_PING Synonym for GV_$FILE_PING
766 GV$FIXED_TABLE Synonym for GV_$FIXED_TABLE
767 GV$FIXED_VIEW_DEFINITION Synonym for GV_$FIXED_VIEW_DEFINITION
768 GV$GCSHVMASTER_INFO Synonym for GV_$GCSHVMASTER_INFO
769 GV$GCSPFMASTER_INFO Synonym for GV_$GCSPFMASTER_INFO
770 GV$GC_ELEMENT Synonym for GV_$GC_ELEMENT
771 GV$GC_ELEMENTS_WITH_COLLISIONS Synonym for GV_$GC_ELEMENTS_W_COLLISIONS
772 GV$GES_BLOCKING_ENQUEUE Synonym for GV_$GES_BLOCKING_ENQUEUE
773 GV$GES_ENQUEUE Synonym for GV_$GES_ENQUEUE
774 GV$GLOBALCONTEXT Synonym for GV_$GLOBALCONTEXT
775 GV$GLOBAL_BLOCKED_LOCKS Synonym for GV_$GLOBAL_BLOCKED_LOCKS
776 GV$GLOBAL_TRANSACTION Synonym for GV_$GLOBAL_TRANSACTION
777 GV$HS_AGENT Synonym for GV_$HS_AGENT
778 GV$HS_PARAMETER Synonym for GV_$HS_PARAMETER
779 GV$HS_SESSION Synonym for GV_$HS_SESSION
780 GV$HVMASTER_INFO Synonym for GV_$HVMASTER_INFO
781 GV$INDEXED_FIXED_COLUMN Synonym for GV_$INDEXED_FIXED_COLUMN
782 GV$INSTANCE Synonym for GV_$INSTANCE
783 GV$INSTANCE_RECOVERY Synonym for GV_$INSTANCE_RECOVERY
784 GV$LATCH Synonym for GV_$LATCH
785 GV$LATCHHOLDER Synonym for GV_$LATCHHOLDER
786 GV$LATCHNAME Synonym for GV_$LATCHNAME
787 GV$LATCH_CHILDREN Synonym for GV_$LATCH_CHILDREN
788 GV$LATCH_MISSES Synonym for GV_$LATCH_MISSES
789 GV$LATCH_PARENT Synonym for GV_$LATCH_PARENT
790 GV$LIBRARYCACHE Synonym for GV_$LIBRARYCACHE
791 GV$LIBRARY_CACHE_MEMORY Synonym for GV_$LIBRARY_CACHE_MEMORY
792 GV$LICENSE Synonym for GV_$LICENSE
793 GV$LOADISTAT Synonym for GV_$LOADISTAT
794 GV$LOADPSTAT Synonym for GV_$LOADPSTAT
795 GV$LOCK Synonym for GV_$LOCK
796 GV$LOCKED_OBJECT Synonym for GV_$LOCKED_OBJECT
797 GV$LOCKS_WITH_COLLISIONS Synonym for GV_$LOCKS_WITH_COLLISIONS
798 GV$LOCK_ACTIVITY Synonym for GV_$LOCK_ACTIVITY
799 GV$LOCK_ELEMENT Synonym for GV_$LOCK_ELEMENT
800 GV$LOG Synonym for GV_$LOG
801 GV$LOGFILE Synonym for GV_$LOGFILE
802 GV$LOGHIST Synonym for GV_$LOGHIST
803 GV$LOGMNR_CALLBACK Synonym for GV_$LOGMNR_CALLBACK
804 GV$LOGMNR_CONTENTS Synonym for GV_$LOGMNR_CONTENTS
805 GV$LOGMNR_DICTIONARY Synonym for GV_$LOGMNR_DICTIONARY
806 GV$LOGMNR_LOGFILE Synonym for GV_$LOGMNR_LOGFILE
807 GV$LOGMNR_LOGS Synonym for GV_$LOGMNR_LOGS
808 GV$LOGMNR_PARAMETERS Synonym for GV_$LOGMNR_PARAMETERS
809 GV$LOGMNR_PROCESS Synonym for GV_$LOGMNR_PROCESS
810 GV$LOGMNR_REGION Synonym for GV_$LOGMNR_REGION
811 GV$LOGMNR_SESSION Synonym for GV_$LOGMNR_SESSION
812 GV$LOGMNR_STATS Synonym for GV_$LOGMNR_STATS
813 GV$LOGMNR_TRANSACTION Synonym for GV_$LOGMNR_TRANSACTION
814 GV$LOGSTDBY Synonym for GV_$LOGSTDBY
815 GV$LOGSTDBY_STATS Synonym for GV_$LOGSTDBY_STATS
816 GV$LOG_HISTORY Synonym for GV_$LOG_HISTORY
817 GV$MANAGED_STANDBY Synonym for GV_$MANAGED_STANDBY
818 GV$MAP_COMP_LIST Synonym for GV_$MAP_COMP_LIST
819 GV$MAP_ELEMENT Synonym for GV_$MAP_ELEMENT
820 GV$MAP_EXT_ELEMENT Synonym for GV_$MAP_EXT_ELEMENT
821 GV$MAP_FILE Synonym for GV_$MAP_FILE
822 GV$MAP_FILE_EXTENT Synonym for GV_$MAP_FILE_EXTENT
823 GV$MAP_FILE_IO_STACK Synonym for GV_$MAP_FILE_IO_STACK
824 GV$MAP_LIBRARY Synonym for GV_$MAP_LIBRARY
825 GV$MAP_SUBELEMENT Synonym for GV_$MAP_SUBELEMENT
826 GV$MAX_ACTIVE_SESS_TARGET_MTH Synonym for GV_$MAX_ACTIVE_SESS_TARGET_MTH
827 GV$MLS_PARAMETERS Synonym for GV_$MLS_PARAMETERS
828 GV$MTS Synonym for GV_$MTS
829 GV$MTTR_TARGET_ADVICE Synonym for GV_$MTTR_TARGET_ADVICE
830 GV$MVREFRESH Synonym for GV_$MVREFRESH
831 GV$MYSTAT Synonym for GV_$MYSTAT
832 GV$NLS_PARAMETERS Synonym for GV_$NLS_PARAMETERS
833 GV$NLS_VALID_VALUES Synonym for GV_$NLS_VALID_VALUES
834 GV$OBJECT_DEPENDENCY Synonym for GV_$OBJECT_DEPENDENCY
835 GV$OBSOLETE_PARAMETER Synonym for GV_$OBSOLETE_PARAMETER
836 GV$OFFLINE_RANGE Synonym for GV_$OFFLINE_RANGE
837 GV$OPEN_CURSOR Synonym for GV_$OPEN_CURSOR
838 GV$OPTION Synonym for GV_$OPTION
839 GV$PARALLEL_DEGREE_LIMIT_MTH Synonym for GV_$PARALLEL_DEGREE_LIMIT_MTH
840 GV$PARAMETER Synonym for GV_$PARAMETER
841 GV$PARAMETER2 Synonym for GV_$PARAMETER2
842 GV$PGASTAT Synonym for GV_$PGASTAT
843 GV$PGA_TARGET_ADVICE Synonym for GV_$PGA_TARGET_ADVICE
844 GV$PGA_TARGET_ADVICE_HISTOGRAM Synonym for GV_$PGATARGET_ADVICE_HISTOGRAM
845 GV$PQ_SESSTAT Synonym for GV_$PQ_SESSTAT
846 GV$PQ_SLAVE Synonym for GV_$PQ_SLAVE
847 GV$PQ_SYSSTAT Synonym for GV_$PQ_SYSSTAT
848 GV$PQ_TQSTAT Synonym for GV_$PQ_TQSTAT
849 GV$PROCESS Synonym for GV_$PROCESS
850 GV$PROXY_ARCHIVEDLOG Synonym for GV_$PROXY_ARCHIVEDLOG
851 GV$PROXY_DATAFILE Synonym for GV_$PROXY_DATAFILE
852 GV$PWFILE_USERS Synonym for GV_$PWFILE_USERS
853 GV$PX_PROCESS Synonym for GV_$PX_PROCESS
854 GV$PX_PROCESS_SYSSTAT Synonym for GV_$PX_PROCESS_SYSSTAT
855 GV$PX_SESSION Synonym for GV_$PX_SESSION
856 GV$PX_SESSTAT Synonym for GV_$PX_SESSTAT
857 GV$QUEUE Synonym for GV_$QUEUE
858 GV$QUEUEING_MTH Synonym for GV_$QUEUEING_MTH
859 GV$RECOVERY_FILE_STATUS Synonym for GV_$RECOVERY_FILE_STATUS
860 GV$RECOVERY_LOG Synonym for GV_$RECOVERY_LOG
861 GV$RECOVERY_PROGRESS Synonym for GV_$RECOVERY_PROGRESS
862 GV$RECOVERY_STATUS Synonym for GV_$RECOVERY_STATUS
863 GV$RECOVER_FILE Synonym for GV_$RECOVER_FILE
864 GV$REPLPROP Synonym for GV_$REPLPROP
865 GV$REPLQUEUE Synonym for GV_$REPLQUEUE
866 GV$REQDIST Synonym for GV_$REQDIST
867 GV$RESERVED_WORDS Synonym for GV_$RESERVED_WORDS
868 GV$RESOURCE Synonym for GV_$RESOURCE
869 GV$RESOURCE_LIMIT Synonym for GV_$RESOURCE_LIMIT
870 GV$RESUMABLE Synonym for GV_$RESUMABLE
871 GV$RMAN_CONFIGURATION Synonym for GV_$RMAN_CONFIGURATION
872 GV$ROLLSTAT Synonym for GV_$ROLLSTAT
873 GV$ROWCACHE Synonym for GV_$ROWCACHE
874 GV$ROWCACHE_PARENT Synonym for GV_$ROWCACHE_PARENT
875 GV$ROWCACHE_SUBORDINATE Synonym for GV_$ROWCACHE_SUBORDINATE
876 GV$RSRC_CONSUMER_GROUP Synonym for GV_$RSRC_CONSUMER_GROUP
877 GV$RSRC_CONSUMER_GROUP_CPU_MTH Synonym for GV_$RSRC_CONSUME_GROUP_CPU_MTH
878 GV$RSRC_PLAN Synonym for GV_$RSRC_PLAN
879 GV$RSRC_PLAN_CPU_MTH Synonym for GV_$RSRC_PLAN_CPU_MTH
880 GV$SEGMENT_STATISTICS Synonym for GV_$SEGMENT_STATISTICS
881 GV$SEGSTAT Synonym for GV_$SEGSTAT
882 GV$SEGSTAT_NAME Synonym for GV_$SEGSTAT_NAME
883 GV$SESSION Synonym for GV_$SESSION
884 GV$SESSION_CONNECT_INFO Synonym for GV_$SESSION_CONNECT_INFO
885 GV$SESSION_CURSOR_CACHE Synonym for GV_$SESSION_CURSOR_CACHE
886 GV$SESSION_EVENT Synonym for GV_$SESSION_EVENT
887 GV$SESSION_LONGOPS Synonym for GV_$SESSION_LONGOPS
888 GV$SESSION_OBJECT_CACHE Synonym for GV_$SESSION_OBJECT_CACHE
889 GV$SESSION_WAIT Synonym for GV_$SESSION_WAIT
890 GV$SESSTAT Synonym for GV_$SESSTAT
891 GV$SESS_IO Synonym for GV_$SESS_IO
892 GV$SGA Synonym for GV_$SGA
893 GV$SGASTAT Synonym for GV_$SGASTAT
894 GV$SGA_CURRENT_RESIZE_OPS Synonym for GV_$SGA_CURRENT_RESIZE_OPS
895 GV$SGA_DYNAMIC_COMPONENTS Synonym for GV_$SGA_DYNAMIC_COMPONENTS
896 GV$SGA_DYNAMIC_FREE_MEMORY Synonym for GV_$SGA_DYNAMIC_FREE_MEMORY
897 GV$SGA_RESIZE_OPS Synonym for GV_$SGA_RESIZE_OPS
898 GV$SHARED_POOL_ADVICE Synonym for GV_$SHARED_POOL_ADVICE
899 GV$SHARED_POOL_RESERVED Synonym for GV_$SHARED_POOL_RESERVED
900 GV$SHARED_SERVER Synonym for GV_$SHARED_SERVER
901 GV$SHARED_SERVER_MONITOR Synonym for GV_$SHARED_SERVER_MONITOR
902 GV$SORT_SEGMENT Synonym for GV_$SORT_SEGMENT
903 GV$SORT_USAGE Synonym for GV_$SORT_USAGE
904 GV$SPPARAMETER Synonym for GV_$SPPARAMETER
905 GV$SQL Synonym for GV_$SQL
906 GV$SQLAREA Synonym for GV_$SQLAREA
907 GV$SQLTEXT Synonym for GV_$SQLTEXT
908 GV$SQLTEXT_WITH_NEWLINES Synonym for GV_$SQLTEXT_WITH_NEWLINES
909 GV$SQL_BIND_DATA Synonym for GV_$SQL_BIND_DATA
910 GV$SQL_BIND_METADATA Synonym for GV_$SQL_BIND_METADATA
911 GV$SQL_CURSOR Synonym for GV_$SQL_CURSOR
912 GV$SQL_PLAN Synonym for GV_$SQL_PLAN
913 GV$SQL_PLAN_STATISTICS Synonym for GV_$SQL_PLAN_STATISTICS
914 GV$SQL_PLAN_STATISTICS_ALL Synonym for GV_$SQL_PLAN_STATISTICS_ALL
915 GV$SQL_REDIRECTION Synonym for GV_$SQL_REDIRECTION
916 GV$SQL_SHARED_CURSOR Synonym for GV_$SQL_SHARED_CURSOR
917 GV$SQL_SHARED_MEMORY Synonym for GV_$SQL_SHARED_MEMORY
918 GV$SQL_WORKAREA Synonym for GV_$SQL_WORKAREA
919 GV$SQL_WORKAREA_ACTIVE Synonym for GV_$SQL_WORKAREA_ACTIVE
920 GV$SQL_WORKAREA_HISTOGRAM Synonym for GV_$SQL_WORKAREA_HISTOGRAM
921 GV$STANDBY_LOG Synonym for GV_$STANDBY_LOG
922 GV$STATISTICS_LEVEL Synonym for GV_$STATISTICS_LEVEL
923 GV$STATNAME Synonym for GV_$STATNAME
924 GV$STREAMS_APPLY_COORDINATOR Synonym for GV_$STREAMS_APPLY_COORDINATOR
925 GV$STREAMS_APPLY_READER Synonym for GV_$STREAMS_APPLY_READER
926 GV$STREAMS_APPLY_SERVER Synonym for GV_$STREAMS_APPLY_SERVER
927 GV$STREAMS_CAPTURE Synonym for GV_$STREAMS_CAPTURE
928 GV$SUBCACHE Synonym for GV_$SUBCACHE
929 GV$SYSSTAT Synonym for GV_$SYSSTAT
930 GV$SYSTEM_CURSOR_CACHE Synonym for GV_$SYSTEM_CURSOR_CACHE
931 GV$SYSTEM_EVENT Synonym for GV_$SYSTEM_EVENT
932 GV$SYSTEM_PARAMETER Synonym for GV_$SYSTEM_PARAMETER
933 GV$SYSTEM_PARAMETER2 Synonym for GV_$SYSTEM_PARAMETER2
934 GV$TABLESPACE Synonym for GV_$TABLESPACE
935 GV$TEMPFILE Synonym for GV_$TEMPFILE
936 GV$TEMPORARY_LOBS Synonym for GV_$TEMPORARY_LOBS
937 GV$TEMPSEG_USAGE Synonym for GV_$SORT_USAGE
938 GV$TEMPSTAT Synonym for GV_$TEMPSTAT
939 GV$TEMP_CACHE_TRANSFER Synonym for GV_$TEMP_CACHE_TRANSFER
940 GV$TEMP_EXTENT_MAP Synonym for GV_$TEMP_EXTENT_MAP
941 GV$TEMP_EXTENT_POOL Synonym for GV_$TEMP_EXTENT_POOL
942 GV$TEMP_PING Synonym for GV_$TEMP_PING
943 GV$TEMP_SPACE_HEADER Synonym for GV_$TEMP_SPACE_HEADER
944 GV$THREAD Synonym for GV_$THREAD
945 GV$TIMER Synonym for GV_$TIMER
946 GV$TIMEZONE_NAMES Synonym for GV_$TIMEZONE_NAMES
947 GV$TRANSACTION Synonym for GV_$TRANSACTION
948 GV$TRANSACTION_ENQUEUE Synonym for GV_$TRANSACTION_ENQUEUE
949 GV$TYPE_SIZE Synonym for GV_$TYPE_SIZE
950 GV$UNDOSTAT Synonym for GV_$UNDOSTAT
951 GV$VERSION Synonym for GV_$VERSION
952 GV$VPD_POLICY Synonym for GV_$VPD_POLICY
953 GV$WAITSTAT Synonym for GV_$WAITSTAT
954 GV$_LOCK Synonym for GV_$_LOCK
955 IND Synonym for USER_INDEXES
956 OBJ Synonym for USER_OBJECTS
957 SEQ Synonym for USER_SEQUENCES
958 SM$VERSION Synonym for SM_$VERSION
959 SYN Synonym for USER_SYNONYMS
960 TABS Synonym for USER_TABLES
961 USER_HISTOGRAMS Synonym for USER_TAB_HISTOGRAMS
962 USER_SNAPSHOT_REFRESH_TIMES Synonym for USER_MVIEW_REFRESH_TIMES
963 V$ACCESS Synonym for V_$ACCESS
964 V$ACTIVE_INSTANCES Synonym for V_$ACTIVE_INSTANCES
965 V$ACTIVE_SESS_POOL_MTH Synonym for V_$ACTIVE_SESS_POOL_MTH
966 V$AQ Synonym for V_$AQ
967 V$AQ1 Synonym for V_$AQ1
968 V$ARCHIVE Synonym for V_$ARCHIVE
969 V$ARCHIVED_LOG Synonym for V_$ARCHIVED_LOG
970 V$ARCHIVE_DEST Synonym for V_$ARCHIVE_DEST
971 V$ARCHIVE_DEST_STATUS Synonym for V_$ARCHIVE_DEST_STATUS
972 V$ARCHIVE_GAP Synonym for V_$ARCHIVE_GAP
973 V$ARCHIVE_PROCESSES Synonym for V_$ARCHIVE_PROCESSES
974 V$AW_CALC Synonym for V_$AW_CALC
975 V$AW_OLAP Synonym for V_$AW_OLAP
976 V$AW_SESSION_INFO Synonym for V_$AW_SESSION_INFO
977 V$BACKUP Synonym for V_$BACKUP
978 V$BACKUP_ASYNC_IO Synonym for V_$BACKUP_ASYNC_IO
979 V$BACKUP_CORRUPTION Synonym for V_$BACKUP_CORRUPTION
980 V$BACKUP_DATAFILE Synonym for V_$BACKUP_DATAFILE
981 V$BACKUP_DEVICE Synonym for V_$BACKUP_DEVICE
982 V$BACKUP_PIECE Synonym for V_$BACKUP_PIECE
983 V$BACKUP_REDOLOG Synonym for V_$BACKUP_REDOLOG
984 V$BACKUP_SET Synonym for V_$BACKUP_SET
985 V$BACKUP_SPFILE Synonym for V_$BACKUP_SPFILE
986 V$BACKUP_SYNC_IO Synonym for V_$BACKUP_SYNC_IO
987 V$BGPROCESS Synonym for V_$BGPROCESS
988 V$BH Synonym for V_$BH
989 V$BSP Synonym for V_$BSP
990 V$BUFFER_POOL Synonym for V_$BUFFER_POOL
991 V$BUFFER_POOL_STATISTICS Synonym for V_$BUFFER_POOL_STATISTICS
992 V$CIRCUIT Synonym for V_$CIRCUIT
993 V$CLASS_CACHE_TRANSFER Synonym for V_$CLASS_CACHE_TRANSFER
994 V$CLASS_PING Synonym for V_$CLASS_PING
995 V$COMPATIBILITY Synonym for V_$COMPATIBILITY
996 V$COMPATSEG Synonym for V_$COMPATSEG
997 V$CONTEXT Synonym for V_$CONTEXT
998 V$CONTROLFILE Synonym for V_$CONTROLFILE
999 V$CONTROLFILE_RECORD_SECTION Synonym for V_$CONTROLFILE_RECORD_SECTION
1000 V$COPY_CORRUPTION Synonym for V_$COPY_CORRUPTION
1001 V$CR_BLOCK_SERVER Synonym for V_$CR_BLOCK_SERVER
1002 V$DATABASE Synonym for V_$DATABASE
1003 V$DATABASE_BLOCK_CORRUPTION Synonym for V_$DATABASE_BLOCK_CORRUPTION
1004 V$DATABASE_INCARNATION Synonym for V_$DATABASE_INCARNATION
1005 V$DATAFILE Synonym for V_$DATAFILE
1006 V$DATAFILE_COPY Synonym for V_$DATAFILE_COPY
1007 V$DATAFILE_HEADER Synonym for V_$DATAFILE_HEADER
1008 V$DATAGUARD_STATUS Synonym for V_$DATAGUARD_STATUS
1009 V$DBFILE Synonym for V_$DBFILE
1010 V$DBLINK Synonym for V_$DBLINK
1011 V$DB_CACHE_ADVICE Synonym for V_$DB_CACHE_ADVICE
1012 V$DB_OBJECT_CACHE Synonym for V_$DB_OBJECT_CACHE
1013 V$DB_PIPES Synonym for V_$DB_PIPES
1014 V$DELETED_OBJECT Synonym for V_$DELETED_OBJECT
1015 V$DISPATCHER Synonym for V_$DISPATCHER
1016 V$DISPATCHER_RATE Synonym for V_$DISPATCHER_RATE
1017 V$DLM_ALL_LOCKS Synonym for V_$DLM_ALL_LOCKS
1018 V$DLM_CONVERT_LOCAL Synonym for V_$DLM_CONVERT_LOCAL
1019 V$DLM_CONVERT_REMOTE Synonym for V_$DLM_CONVERT_REMOTE
1020 V$DLM_LATCH Synonym for V_$DLM_LATCH
1021 V$DLM_LOCKS Synonym for V_$DLM_LOCKS
1022 V$DLM_MISC Synonym for V_$DLM_MISC
1023 V$DLM_RESS Synonym for V_$DLM_RESS
1024 V$DLM_TRAFFIC_CONTROLLER Synonym for V_$DLM_TRAFFIC_CONTROLLER
1025 V$ENABLEDPRIVS Synonym for V_$ENABLEDPRIVS
1026 V$ENQUEUE_LOCK Synonym for V_$ENQUEUE_LOCK
1027 V$ENQUEUE_STAT Synonym for V_$ENQUEUE_STAT
1028 V$EVENT_NAME Synonym for V_$EVENT_NAME
1029 V$EXECUTION Synonym for V_$EXECUTION
1030 V$FAST_START_SERVERS Synonym for V_$FAST_START_SERVERS
1031 V$FAST_START_TRANSACTIONS Synonym for V_$FAST_START_TRANSACTIONS
1032 V$FILESTAT Synonym for V_$FILESTAT
1033 V$FILESTATXS Synonym for V_$FILESTATXS
1034 V$FILE_CACHE_TRANSFER Synonym for V_$FILE_CACHE_TRANSFER
1035 V$FILE_PING Synonym for V_$FILE_PING
1036 V$FIXED_TABLE Synonym for V_$FIXED_TABLE
1037 V$FIXED_VIEW_DEFINITION Synonym for V_$FIXED_VIEW_DEFINITION
1038 V$GCSHVMASTER_INFO Synonym for V_$GCSHVMASTER_INFO
1039 V$GCSPFMASTER_INFO Synonym for V_$GCSPFMASTER_INFO
1040 V$GC_ELEMENT Synonym for V_$GC_ELEMENT
1041 V$GC_ELEMENTS_WITH_COLLISIONS Synonym for V_$GC_ELEMENTS_W_COLLISIONS
1042 V$GES_BLOCKING_ENQUEUE Synonym for V_$GES_BLOCKING_ENQUEUE
1043 V$GES_ENQUEUE Synonym for V_$GES_ENQUEUE
1044 V$GLOBALCONTEXT Synonym for V_$GLOBALCONTEXT
1045 V$GLOBAL_BLOCKED_LOCKS Synonym for V_$GLOBAL_BLOCKED_LOCKS
1046 V$GLOBAL_TRANSACTION Synonym for V_$GLOBAL_TRANSACTION
1047 V$HS_AGENT Synonym for V_$HS_AGENT
1048 V$HS_PARAMETER Synonym for V_$HS_PARAMETER
1049 V$HS_SESSION Synonym for V_$HS_SESSION
1050 V$HVMASTER_INFO Synonym for V_$HVMASTER_INFO
1051 V$INDEXED_FIXED_COLUMN Synonym for V_$INDEXED_FIXED_COLUMN
1052 V$INSTANCE Synonym for V_$INSTANCE
1053 V$INSTANCE_RECOVERY Synonym for V_$INSTANCE_RECOVERY
1054 V$LATCH Synonym for V_$LATCH
1055 V$LATCHHOLDER Synonym for V_$LATCHHOLDER
1056 V$LATCHNAME Synonym for V_$LATCHNAME
1057 V$LATCH_CHILDREN Synonym for V_$LATCH_CHILDREN
1058 V$LATCH_MISSES Synonym for V_$LATCH_MISSES
1059 V$LATCH_PARENT Synonym for V_$LATCH_PARENT
1060 V$LIBRARYCACHE Synonym for V_$LIBRARYCACHE
1061 V$LIBRARY_CACHE
仅供参考!