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…

The correct answer is F. 1, 2, 3, 4, 5, and 6. 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…

Oracle Database 12c Architecture

Question

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

Options

A3, 4, and 5
B1, 2, 5, and 6
C1, 2, 3, and 4
D2, 3, 5, and 6
E2, 3, 4, 5, and 6
F1, 2, 3, 4, 5, and 6

How the community answered

(39 responses)

A
3% (1)
B
8% (3)
C
13% (5)
E
5% (2)
F
72% (28)

Explanation

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 - Statistics and metrics

Topics

#dynamic performance views#V$ views#memory monitoring#system statistics

Community Discussion

No community discussion yet for this question.

Full 1Z0-497 Practice