Dictionary Views vs Dynamic Performance Views:
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 singular
(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 generally
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.
Monday, March 17, 2008
Data dictionary view VS Dynamic view
Posted by Bis at 11:56 AM
Labels: Fundamentals
Subscribe to:
Post Comments (Atom)
5 comments:
Thanx Deepthi .. nice info.
Thats a very good info Deepthi, thanks.
Deepti you have to learn more things regarding data dictionary views and dynamic performance views, before posting. OK..
u dont know anything diptimayee .. better learn n then post. ok
Hello Deeptimayee
Nice info.. thanks a lot for your posts.
Please send me ur gmail ID ..may be u can help me in trouble...
Anyways will wait for ur reply.
reply me vswajit@gmail.com
Post a Comment