Dynamic Performance Tables (271)

最新推荐文章于 2024-07-09 11:45:45 发布

转载最新推荐文章于 2024-07-09 11:45:45 发布 · 104 阅读

文章标签：

本文介绍了Oracle数据库中的一组特殊虚拟表——动态性能表。这些表记录了数据库的实时活动情况，虽然它们并非真正的数据库表，但对于数据库管理员来说至关重要。通过查询这些表，管理员可以获取关于数据库状态的重要信息。

Throughout its operation, Oracle maintains a set of virtual tables that record current
database activity. These tables are called dynamic performance tables.

Dynamic performance tables are not true tables, and they should not be accessed by
most users. However, database administrators can query and create views on the
tables and grant access to those views to other users. These views are sometimes called
fixed views because they cannot be altered or removed by the database administrator.

SYS owns the dynamic performance tables; their names all begin with V_$. Views are
created on these tables, and then public synonyms are created for the views. The
synonym names begin with V$. For example, the V$DATAFILE view contains
information about the database’s datafiles, and the V$FIXED_TABLE view contains
information about all of the dynamic performance tables and views in the database.

动态性能表
1. 当数据库运行时，Oracle将维护一组虚拟表用于记录数据库的当前状态 , 称为动态性能表
2. 动态性能视图并不是真正的表
3. 动态性能表由 SYS 用户所拥有；她们的名字都以 V_$开头。这些表上创建有视图，而视图上创
建有公共同义词。这些公共同义词的名字都以 V$ 开头

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-985716/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-985716/