单选题View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities:SQL SELECT substr(component, 0, 10) COMP, current_size CS, user_spe
题目
单选题
View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities:SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0;What do you infer from this()
A
The database instance is running with manual PGA management.
B
The database instance is running with manual shared memory management.
C
The database instance has the MEMORY_TARGET value set to a nonzero value.
D
All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel queryoperations have been performed