Sunday, August 19, 2012

Oracle11g AMM Monitoring and Tuning

Monitoring AMM:

From dynamic view V$MEMORY_DYNAMIC_COMPONENTS shows the current sizes of all dynamically tuned memory components, including the total sizes of the SGA and instance PGA.
SQL> select * from v$memory_dynamic_components order by component;


Tuning AMM:

From view V$MEMORY_TARGET_ADVICE you can see tuning advice for the MEMORY_TARGET initialization parameter. If you use Enterprise Manager (or Grid Control) you can also use graphical Memory Advisor.

SQL> select * from v$memory_target_advice order by memory_size;
V$MEMORY_TARGET_ADVICE view contains following columns:
MEMORY_SIZE (alternative MEMORY_TARGET sizes), MEMORY_SIZE_FACTOR (value 1 shows current memory size), ESTD_DB_TIME (estimated DB time to complete the current workload), ESTD_DB_TIME_FACTOR (factor for estimated DB time) and VERSION.

So from this view you can check how db_time is changing if you make changes in MEMORY_TARGET-


From V$MEMORY_RESIZE_OPS view you can see circular history buffer of the last 800 SGA resize requests.

No comments:

Post a Comment