ITPub博客

首页 > Linux操作系统 > Linux操作系统 > the differents between the data view and the data performace view

the differents between the data view and the data performace view

原创 Linux操作系统 作者:BEANBLACK 时间:2009-04-23 09:35:33 0 删除 编辑

1.Dictionary Views Dynamic Performance Views
The DBA_views usually have plural names(for
example,DBA_DATA_FILES).
The names of the V$views are generally singu-
lar(for example,V$DATAFILE).
2.The DBA_views are available only when the
database is open and running.
Some V$views are available even when the
database is not fully open and running.
3.The data contained in the DBA_views is gener-
ally uppercase.
The data contained in the V$views is usually
lowercase.
4.The data contained in the DBA_views is static
and is not cleared when the database is shut
down.
The V$views contain dynamic statistical data
that is lost each time the database is shut
down.

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

上一篇: 操纵数据库数据
请登录后发表评论 登录
全部评论

注册时间:2008-06-16

  • 博文量
    67
  • 访问量
    144069