View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has undergone workloads of different capacities:

SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_components WHERE current_size!=0; What do you infer from this?

Question

View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has undergone workloads of different capacities:

SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_components WHERE current_size!=0; What do you infer from this?

Accepted Answer

C. The database instance has the MEMORY_TARGET value set to a nonzero value.

Answer

A. The database instance is running with manual PGA management.

Answer

B. The database instance is running with manual shared memory management.

Answer

D. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel

View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has undergone workloads of different capacities: SQL> SELECT…

Question

Exhibit

Options

How the community answered

Community Discussion