Oracle Server - Standard Edition - Version: 10.2.0.3
This problem can occur on any platform.
SYMPTOMS
V$SGA_RESIZE_OPS.STATUS displays "ERROR" for the last few rows. Then, there are no more records in this view, implying that auto-tuning has ceased.
CHANGES
CAUSE
(The status of ERROR means that the sizing operation was unable to complete.)
Memory reallocation was occurring on a minute-by-minute basis. This is because the SGA was too small, and Oracle had to keep trying to make room for various pools. As a result, pool sizes were being adjusted too frequently for MMAN to keep up; it gave up and auto-tuning stopped.
SOLUTION
The solution would be to increase the SGA_TARGET (and, if necessary, SGA_MAX_SIZE).
