I see alot of Memory Resize Operations in my Statspack report

11.2.0.2 on RHEL6

Hi,

This is a Statspack report using three snapshots (60 min in total).

I see a lot of memory resize operations, what can be done to avoid it? Is this bad for performance? :-) I checked an hour durign the afternoon, and a lot of resize then as well.

Regards

S

Top 5 Timed Events                                                    Avg %Total
~~~~~~~~~~~~~~~~~~                                                   wait   Call
Event                                            Waits    Time (s)   (ms)   Time
----------------------------------------- ------------ ----------- ------ ------
db file sequential read                      1,126,252       4,285      4   46.4
db file scattered read                         560,638       1,537      3   16.6
CPU time                                                     1,360          14.7
Backup: MML write backup piece                  57,169       1,115     20   12.1
read by other session                          161,639         356      2    3.9

Memory Resize Operations  DB/Inst: NEOPROD/NEOPROD  Snaps: 18450-18453
-> Status:  ERR:  ERRor,  COM: COMplete,  PEN: PENding