What are the 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 the dynamic performance views?
Rating:
The dynamic performance views are maintained on the server, and these are only accessible to the database administrator category user known as SYS. Most names of dynamic performance views have V$ as their prefix. Depending on the features installed and configured, an Oracle 10g database can have a maximum of 350 dynamic performance views. The dynamic performance views are continuously updated when the database is open and in use.
Rating:
Was this information helpful?
Other articles
- What is a checkpoint?
- What is the Memory Advisor?
- What is a procedure?
- What is the SHUTDOWN TRANSACTIONAL statement?
- What is FAST_START_MTTR_TARGET?