Monitor Dynamic SGA components

Use this SQL script when logged in as SYSDBA to see what happens to the SGA components over time, how they grow and shrink

I found it very useful monitoring the SHARED_POOL usage over time.

SELECT COMPONENT ' - ' OPER_TYPE COMPONENT_STATUS,INITIAL_SIZE,TARGET_SIZE,FINAL_SIZE,STATUS,TO_CHAR(START_TIME, ‘dd-mon-yyyy hh24:mi’) START_TIME,END_TIMEFROM V$SGA_RESIZE_OPSORDER BY END_TIME;