How does ASM work?
ASM determines how to create summary folders by: analyzing your database tables using query statistics (when available) using default values known as the ASM policy (for more information, see “What is the ASM policy?”) ASM automatically creates and maintains the best set of summary folders based on the above combination. ASM converts your summary policy into a list of recommended summary folder definitions. You can either implement these recommendations without further intervention (the actual set of summary tables dynamically adjusts with system usage) or execution can be stalled until you have specifically sanctioned one or more of the recommendations. ASM requires table space to create summary folders but you can adjust how much space in the Summary Wizard (for more information, see “How to run ASM using the Summary Wizard”). Note: ASM works on the EUL as a whole, not just the currently selected business areas. This means that ASM can use folders from all business areas in the curre
