Re: Oracle on HP-UX running out of Resident Memory

In <3004f220.0108131435.55b366ad_at_posting.google.com> shibumathew_at_alliantfs.com (Shibu Mathew) writes:

>Hello
 

>I am hoping very badly that someone would be able to help me on the
>following issue. We have a process that reads a large table into
>memory(I am using index by tables to hold them) and then run each line
>item from a loop, apply business logic, store the result in index by
>tables and at the end of the program write them back into a table.
>When I run this program from unix, it sometimes fails with an ora-4030
>error(out of process memory). But sometimes it works. I have watched
>this process from glance, and I have noticed that when the
>RSS(Resident memory) reaches 1.03gb, it fails. Whenever it had worked,
>the RSS does not go beyond 1 gb. Does this have anything to do with
>how the SGA is set up or how much shared memory is allocated for the
>instance. Since I am using index by tables, does the size of the PGA
>matter. What causes the RSS to grow? I would really appreciate if
>someone can give me any help on this issue.

What version of HP-UX? 32 or 64 bit? Received on Mon Aug 13 2001 - 20:05:02 CDT