Wednesday 21 March 2007

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;

No comments: