OK Reydp,

Thanks for your response.

At the time of the error we had 5 concurrent users.

SGA

Total System Global Area 1638811676 bytes
Fixed Size 75804 bytes
Variable Size 747274240 bytes
Database Buffers 891289600 bytes
Redo Buffers 172032 bytes

Cpu usage hit a max of 30% during the period in question. There was no unusual memory paging.

This incident has only happened once so there is no pattern to confirm.

Apologies if I was too brief in my original information but since the hash area size refers to PGA for a process I didn't think SGA was patricularly relevant. Also since the error refers specifically to a process memory shortage I didn't feel CPU usage at the server level was poignant either.