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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12878495/viewspace-591512/