Find us on Google+ Google+

February 27, 2009

Data Dictionary views Vs V$ views in Oracle

Here are the differences between data dictionary views and V$ views, in Oracle.


Data Dictionary views V$ views
Data will not be lost even after instance is shutdownedData will be lost if instance is shutdowned
Will be accessible only if instance is OPENED(some are) Will be accessible even if instance is in mount or nomount stage (STARTED)
Data dictionary view names are pluralV$ view names are singular