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

Data Dictionary Views :

1. Data will not be lost even after the instance is shutdown .
2. Views are accessible only if the instance is OPENED .
3. Data dictionary view names are plural .

V$ Views :

1. Data will be lost if the instance is shutdown .
2. Few views are accessible even if instance is in mount or no-mount stage .
3. v$ View names are singular.

Recent Posts

Start typing and press Enter to search