Memory Management Tips

We discussed setting the STATISTICS_LEVEL parameter to TYPICAL or ALL to enable ASMM. For a more detailed understanding of various statistics levels, query the V$STATISTICS_LEVEL view.

You can use ALTER SESSION or ALTER SYSTEM to change the values if you decide to switch back and forth using ASMM. Use the following query to get your database session settings:

 SQL> select STATISTICS_NAME, SESSION_STATUS, ACTIVATION_LEVEL from V$STATISTICS_LEVEL; STATISTICS_NAME SESSION_ ACTIVAT ---------------------------------------- -------- ------- Buffer Cache Advice ENABLED TYPICAL MTTR Advice ENABLED TYPICAL Timed Statistics ENABLED TYPICAL Timed OS Statistics DISABLED ALL Segment Level Statistics ENABLED TYPICAL PGA Advice ENABLED ...

Get Oracle® Database 10g Insider Solutions now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.