Automatic Memory

V$MEMORY_DYNAMIC_COMPONENTS displays information about the dynamic SGA components. This view summarizes information based on all completed SGA resize operations since instance startup. All sizes are expressed in bytes.

select substr(COMPONENT, 0, 10) COMPONENT, CURRENT_SIZE, USER_SPECIFIED_SIZE  from v$memory_dynamic_components where CURRENT_SIZE!=0;

V$MEMORY_RESIZE_OPS displays information about the last 800 completed memory resize operations (both automatic and manual). This does not include in-progress operations. All sizes are expressed in bytes.

select substr(COMPONENT, 0, 10), FINAL_SIZE, OPER_TYPE, OPER_MODE, status from v$memory_resize_ops order by START_TIME;

You can set alter system set "_memory_management_tracing"=31 event to trace memory management. The MMON process trace file will update statistics related to the different pools every 5 mins.

To be continued..