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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
