DBPedias

All your database knowledge are belong to you

Oracle

Wait Events - SGA: MMAN sleep for component shrink

SGA: MMAN sleep for component shrink

MMAN to wait and post itself for satisfying an auto-tuned memory request while trying to fully free a component's quiesced granules. In Release 10.1, the name of this event was 'wait for SGA component shrink'. Wait Time:

10 msec

Parameter

Description

P1

component_id (corresponding to the memory pool)

P2

Current size in granules

P3

Target size in granules