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

Where is the RSS growing? eg In the data segment?

The process memory regions report in glance will show this.

If the data segment, then as noted in another post - check ulimit. Also check maxdsiz - the system wide data segment size limit.

Regards,
Eric Stahl

shibumathew_at_alliantfs.com (Shibu Mathew) wrote:

>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.
>
>Thank You
>Shibu Mathews
Received on Tue Aug 21 2001 - 22:45:28 CDT