Performance problem on Digital UNIX

From: Joãp Repas Gonçalves <repas_at_pyxis.pt>
Date: Thu, 15 Feb 2001 22:57:29 -0000
Message-ID: <0bZi6.59$NuS3.131149@news.jazztel.pt>

I'm running True64 v.5 and Oracle 8.
Because we have performance problems with some select statements which need sort, we decided to set the Oracle parameter SORT_AREA_SIZE from 20MBytes to 50 MBytes.
After running the same complex SQL statement we got the following message: ORA-04030: out of process memory when trying to allocate 4128 bytes (callheap, sortarea)
ORA-07324: smpall: malloc error while allocating pga. Digital Unix Error: 12: Not enough space

Which kernel parameters should I change in order to run the query without memory problems. Received on Thu Feb 15 2001 - 16:57:29 CST