Which four memory structures would be automatically tuned?

You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? (Choose four)

You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? (Choose four)

A.
log buffer

B.
Java pool

C.
Large pool

D.
Fixed SGA

E.
Shared pool

F.
Streams pool

G.
Keep buffer cache

H.
Database buffer cache



Leave a Reply 1

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


dask99

dask99

In Oracle 10g R2 the Streams pool now is Automatically Managed; and the answer “F” could be valid for Oracle 10G R2.

From Oracle documentation.

Oracle® Database Concepts
10g Release 2 (10.2)
Part Number B14220-02

8 Memory Architecture

Automatically Managed SGA Components

When you set a value for SGA_TARGET, Oracle Database 10g automatically sizes the most commonly configured components, including:

The shared pool (for SQL and PL/SQL execution)
The Java pool (for Java execution state)
The large pool (for large allocations such as RMAN backup buffers)
The buffer cache
The Streams pool