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
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