Sunday, March 6, 2016

Data Dictionary views Vs V$ views in Oracle

Data Dictionary views Vs V$ views in Oracle


Data Dictionary views:


Data will not be lost even after instance is shutdowned

Will be accessible only if instance is OPENED

Data dictionary view names are plural


V$ views:


Data will be lost if instance is shutdowned

(some are) Will be accessible even if instance is in mount or nomount stage (STARTED)

V$ view names are singular



No comments:

Post a Comment