Dynamic Performance Views
来源:互联网 发布:python有什么用 编辑:程序博客网 时间:2024/05/22 14:19
Dynamic Performance Views
Throughout its operation, Oracle Database maintains a set of virtual tables that record current database activity. These views are called dynamic performance views because they are continuously updated while a database is open and in use. The views, also sometimes called V$ views, contain information such as the following:
System and session parameters
■Memory usage and allocation
■File states (including RMAN backup files)
■Progress of jobs and tasks
■SQL execution
■Statistics and metrics
The dynamic performance views have the following primary uses:
■Oracle Enterprise Manager uses the views to obtain information about the database (see "Oracle Enterprise Manager" on page 18-2).
■Administrators can use the views for performance monitoring and debugging.
Contents of the Dynamic Performance Views
Dynamic performance views are sometimes called fixed views because they cannot be altered or removed by a database administrator. However, database administrators can query and create views on the tables and grant access to these views to other users.
SYS owns the dynamic performance tables, whose names begin with V_$. Views are created on these tables, and then public synonyms prefixed with V$. For example, the V$DATAFILE view contains information about data files. The V$FIXED_TABLE view contains information about all of the dynamic performance tables and views.
For almost every V$ view, a corresponding GV$ view exists. In Oracle Real Application Clusters (Oracle RAC), querying a GV$ view retrieves the V$ view information from all qualified database instances (see "Database Server Grid" on page 17-13).
When you use the Database Configuration Assistant (DBCA) to create a database, Oracle automatically creates the data dictionary. Oracle Database automatically runs the catalog.sql script, which contains definitions of the views and public synonyms for the dynamic performance views. You must run catalog.sql to create these views and synonyms.
Storage of the Dynamic Performance Views
Dynamic performance views are based on virtual tables built from database memory structures. Thus, they are not conventional tables stored in the database. Read consistency is not guaranteed for the views because the data is updated dynamically.
Because the dynamic performance views are not true tables, the data is dependent on the state of the database and instance. For example, you can query V$INSTANCE and V$BGPROCESS when the database is started but not mounted. However, you cannot query V$DATAFILE until the database has been mounted.
http://trailblizer.blog.163.com/blog/static/596303642009964470391/
http://blog.chinaunix.net/uid-27570589-id-3322338.html
- Dynamic Performance Views
- Using Data Dictionary and Dynamic Performance Views
- Fundamental I 05 Using Data Dictionary and Dynamic Performance Views
- 128.Note the points about data dictionary views and dynamic performance views:
- Optimizing table views for performance
- Service Broker - Internal Dynamic Views
- Dynamic Performance Tables not accessible
- Dynamic Performance Tables not accessible
- Dynamic Performance Tables not accessible
- High-Performance Ray Tracing for Dynamic Scenes
- 解决Dynamic Performance Tables not accessible方法
- data dictionary and dynamic performance view
- Dynamic Performance Tables not accessible 问题解决
- 解决Dynamic Performance Tables not accessible方法
- Using the V$SEGMENT_STATISTICS Dynamic Performance View
- Dynamic Performance Tables not accessible,Automatic Statistics...
- Dynamic Performance Tables not accessible 问题解决
- [已解决]Dynamic Performance Tables not accessible
- Unity导出webPlayer并且部署到IIS
- HDFS ---- Services startup
- 快速了解反射(Reflection)
- 冒泡算法
- 常用的汇编指令集
- Dynamic Performance Views
- 【wikioi】1010 过河卒
- IO总结(六)
- s q l i t e 加密 - S Q L C i p h e r
- CCS中调试DM6467高清视频采集(TVP7002输入)
- 黑马程序员--java异常学习笔记
- shell 编程中的 while 语句
- CODE 86: Permutations II
- 【wikioi】1011 数的计算