Here are the differences between data dictionary views and V$ views, in Oracle.
DBA_ / USER_ / ALL_ views are built on the data dictionary - they're not available if the database is not mounted and opened.
V$ views tend to run against the instance, and therefore may be available if the database is not mounted, or is not mounted and opened, depending on the nature of the view.
Using your example:
V$TABLESPACE is a view on X$KCCTS, which is an internal memory structure.
DBA_TABLESPACES is a view on the data dictionary table SYS.TS$
DBA_ / USER_ / ALL_ views are built on the data dictionary - they're not available if the database is not mounted and opened.
- dba_views user_views all_views are obtained from Data Dictionary tables
V$ views tend to run against the instance, and therefore may be available if the database is not mounted, or is not mounted and opened, depending on the nature of the view.
- v$ views are got from control file
Using your example:
V$TABLESPACE is a view on X$KCCTS, which is an internal memory structure.
DBA_TABLESPACES is a view on the data dictionary table SYS.TS$
0 comments:
Post a Comment