Which component would shrink to increase the size of the Large Pool?

View the Exhibit and examine the content of the V$SGA_RESIZE_OPS view.

You executed the following command to increase the size of the Large Pool:
SQL> ALTER SYSTEM SET large_pool_size=8M;
System altered.
Which component would shrink to increase the size of the Large Pool?

View the Exhibit and examine the content of the V$SGA_RESIZE_OPS view.

You executed the following command to increase the size of the Large Pool:
SQL> ALTER SYSTEM SET large_pool_size=8M;
System altered.
Which component would shrink to increase the size of the Large Pool?

A.
the Java Pool

B.
the Shared Pool

C.
KEEP Buffer Cache

D.
Default Buffer Cache

Show Hint

← Previous question

Next question →

Leave a Reply 3

Rodrigo

http://www.oracle.com/technetwork/articles/sql/week17-10gdba-083562.html

…
assume that after the initial allocation the RMAN job starts, indicating the need for a larger large pool; the large pool will expand from 4MB to 40MB to accommodate the demand. This additional 36MB will be carved out of the db buffers and the db block buffers will shrink…

have a look.

Reply

djeday84

23:28:38 (1)djeday84@orcl> @sga_stat

8 rows selected.

Elapsed: 00:00:00.03
23:28:40 (1)djeday84@orcl> alter system set large_pool_size=20m;

23:29:53 (1)djeday84@orcl> select component,oper_type,round (FINAL_SIZE/1024/1024) final_size_mb,END_TIME from v$sga_resize_ops where end_time > sysdate -10/24/60;

Reply

L. Zhu

D is right. default buffer pool is the one to shrink

Reply