What are the differences between data dictionary views and V$ views, in Oracle database?
Here are the differences between data dictionary views and V$ (dynamic) views, in Oracle.
Here are the differences between data dictionary views and V$ (dynamic) views, in Oracle.
| Data Dictionary views | V$ views |
|---|---|
| Data will not be lost even after the instance is shutdown | Data will be lost if the instance is shutdown |
| Will be accessible only if the instance is OPENED | (some views) Will be accessible even if the instance is in mount or nomount stage (STARTED) |
| Data dictionary view names are plural | V$ view names are singular |
No comments:
Post a Comment