Which type of information is included in dynamic performance views?
1 – System and session parameters
2 – Memory usage and allocation
3 – File states (including RMAN backup files)
4 – Progress of jobs and tasks
5 – SQL execution
6 – Statistics and metrics
A.
3, 4, and 5
B.
1, 2, 5, and 6
C.
1, 2, 3, and 4
D.
2, 3, 5, and 6
E.
2, 3, 4, 5, and 6
F.
1, 2, 3, 4, 5, and 6
Explanation:
http://docs.oracle.com/cd/E16655_01/server.121/e17633/datadict.htm#CNCPT1213
(overview of dynamic performance views)
https://docs.oracle.com/database/121/CNCPT/datadict.htm#CNCPT1220
Overview of the Dynamic Performance Views
Throughout its operation, Oracle Database maintains a set of virtual tables that record current database activity. These views are dynamic because they are continuously updated while a database is open and in use. The views, also sometimes called V$ views because their names begin with V$, contain information such as the following:
• System and session parameters
• Memory usage and allocation
• File states (including RMAN backup files)
• Progress of jobs and tasks
• SQL execution
• Statistics and metrics