I am forwarding a problem description reported by Ramesh Seshadri our
DBA. He has an ORACLE 8 program terminating abnormally with the
following error reason. During execution the program exhausts its
available memory heap. Furthermore the error message displayed by the
ORACLE 8 program infers responsibility on the operating system,
Digital UNIX 4.0B, for this problem. We have contacted both Digital
and ORACLE concerning the matter. They aren't sure who's problem it
is; so while we wait for them to sort it out; we decided to give you
at majordomo a crack at it. What do you think: Is it an Oracle 8
problem, a Digital problem, or a programming problem?
Ramesh describes the problem as follows:
When we executed an oracle program, which has a long logic, after
performing the operation for about 2 hours, the program aborts saying
'Operating system process private memory has been exhausted'.
I referred to the Performance Tuning book of Digital and it appears
that the parameters Dfldsiz, Dflssiz, maxdsiz are the ones associated
with this error. I reset the parameter dflssiz from 2097152 to
4194304, maxssiz from 33554432 to 67108864 and maxdsiz from 1073741824
to 1610612736.
In spite of resetting all these parameters, there is no significant
improvement in the execution of the program and the same error
persists.
We would appreciate if you could help us in getting this problem
resolved by Digital. I am also in communication with Oracle support on
this matter. (* And I am trying - Kevin *)
Thanks.
Ramesh.
Received on Tue Jun 09 1998 - 01:26:23 NZST