What are dynamic performance views?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What are dynamic performance views?
Rating:
Dynamic performance views are maintained by the Oracle server and accessible only to database administrators who connect to the server as SYS. These views are so called because they are continuously updated by Oracle while a database is running, and their contents are mainly related to performance. These views provide data on internal disk structures and memory structures. These views can only be queried. They can never be manually updated or altered. Dynamic performance views have the prefix V_$. Public synonyms for these views have the prefix V$. Oracle recommends querying the synonyms for these views, and not the actual views.
Rating:
Was this information helpful?
Other articles
- What is a complete recovery?
- What is the DBA_OUTSTANDING_ALERTS view?
- What is the iSQL*Plus interface?
- What is the REMAP_TABLESPACE parameter?
- Things to practice for Oracle 10g administrative test 1Z0-042.