Metadata indicates data about the database. As a DBA we need frequently access the metadata in oracle database. There are two types of metadata views.
1)Data dictionary views.
2)Dynamic performance views.
Comparison between these Two:
A)Data dictionary views have names that begin with DBA_,ALL_, and USER_.Dynamic performance views have names that begin with V$.
B)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.
C)The data contained in the DBA_ views is generally uppercase.The data contained in the V$ views is usually lowercase.
D)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.
No comments:
Post a Comment