Re: SQR and Oracle

Dave:

We have been running SQR against 7.0.16 for over a year w/ no apparent problem. Your error suggests to me that you are running out of PGA. Increasing your db buffers resulted in an increased SGA, which means that less memory is available for PGA (how much less depends on the size of your db block as well as how many blocks you have cached).

Please give more info on your config:
Application environment (C/S, host, etc) Running MTS? (This affects where your data area is allocated) OS (VMS handles PGA alloc MUCH differently than unix) Hardware, including physical memory

jpivovar_at_sprocket.lcp.com

On Tue, 9 Jan 1996, Tribble Dave wrote:

> Is there any known incompatibilities between SQR and Oracle 7.0.16? We are
> running PeopleSoft reports via SQR and have running into some quirky errors
> with SQR based reports the latest:
> ORA-4030 out of process memory
> When running a particular report.
> The only thing I can see different from before is that we just increased our
> db_block_buffers from 20K to 24K
> Any ideas????
> Thanks!
>
> dlt3716_at_kcpl.com
>
Received on Tue Jan 09 1996 - 11:26:21 CST