Streams AQ: enqueue blocked on low memory
Single instance
Standard 10.2.0.1.0
Win 2k3 32 bit.
For the past 2 hours, there are spikes of dark brown (Configuration) on the Performance screen in EM every 5 minutes. When I click on Top Activity, I can see that the session belongs to SYS and Program is ORACLE.EXE (MMON). When I click on SQL ID, Information has "The SQL statement is not available" but on the Details - Activity tab, I see "Streams AQ: enqueue blocked on low memory".
As far as I know, the db is set to auto memory management and we just set the SGA max size. And we haven't changed any parameters recently.
Is it a problem? If so, what should I check next?
Thanks.