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?
Exhibit:
A.
All sessions are connected to the database instance in dedicated mode, and no RMAN or
parallel query operations have been performed.
B.
The database instance is running with manual shared memory management.
C.
The database instance is running with manual PGA management.
D.
The database instance has the MEMORY_TARGET value set to a nonzero value.
One of our guests a short while ago encouraged the following website.
we came across a cool internet site that you simply could possibly love. Take a appear when you want
very handful of internet websites that come about to be in depth below, from our point of view are undoubtedly effectively worth checking out
always a big fan of linking to bloggers that I enjoy but do not get a great deal of link love from
although web-sites we backlink to beneath are considerably not related to ours, we really feel they’re in fact worth a go by way of, so have a look