What do you infer from the output produced by the following query at three different times?

View the Exhibit to examine the output produced by the following query at three different times since the database 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_components
WHERE current_size!=0;
What do you infer from this?
Exhibit:

View the Exhibit to examine the output produced by the following query at three different times since the database 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_components
WHERE 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 query operations have been performed.

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

greenty99

greenty99

How can I tell the MEMORY_TARGET value is set to a nonzero value from the exhibit above?
Is it about Automatic Memory Management?
Thanks in advance.

Reply

Lucia

Lucia

Pretty part of content. I simply stumbled upon your
web site and in accession capital to say that I get in fact loved account your weblog posts.
Anyway I will be subscribing to your augment or even I
success you get admission to persistently rapidly.

barcelona trøje

Reply