Re: High PGA memory usage fetching into Varrays

sideyt wrote:
> 1) What are the real bytes per value (RAM) associated with each
> element of a Varray of NUMBER? (Of INTEGER, of PLS_INTEGER, of
> VARCHAR2(20) etc).We are using arrays with more than 1 million
> elements and often get PGA usage in the gigabytes.
>
> 2) What else (besides sorting) contributes to high PGA usage? We often
> do bulk collect (with row limits) of SDO_geometries and this seems to
> easily generate out of memory errors unless we use small row limits
> like 500.
>
> 3) Are there any strategies (besides
> dbms_session.free_unused_user_memory ) to free memory and keep PGA
> memory usage lower?
>
> Our environment is 64 bit Blade servers running Linux: Oracle Database
> 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
> I would prefer real answers to these questions - not avoidance answers
> like "don't use Varrays". We are performing spatial algorithms in
> core - and are using PL/SQL successfully except for this
> limitation.Thank you.

What is your SGA size? How much memory in the box? what is the EXACT error message - there are many relating to "out of memory". Sounds like you have some tuning to do and/or upgrading the hardware to be able to accommodate the workload it is being asked to do. Received on Sat Jan 12 2008 - 21:27:25 CST