s85 running aix 4.3.3, oracle 9i, peoplesoft FS 8. When users are running a large SQR to collect 19000 records from a database.SQR process continues to take up more memory as it moves along, until it has taken up 1024mb of memory, at which point the sqr dies with error "not enough system memory". Up to this point the CPU utilization is about 70% idle, but free memory pages remain in the 120 range (vmstat), but there is no swapping to page file. Seems like AIX is restricting the process to take up to only 1024mb of memory; is the rss ulimit parameter, or another one, restricting the amount of memory used by this sqr process ?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
rss=max memory usage by process?
- Thread starter mpezeur
- Start date
I bet your program is bumping up against MAXDATA. Please read this and make appropriate changes....
Jim Hirschauer
Jim Hirschauer
- Status
Similar threads
