Re: Why is UGA size so large?

The few sessions mentioned do not seem to consume unreasonable amount of memory. How many sessions do you have running concurrently ?

On Win32, the 3 Gb limit applies to the total amount of memory used by Oracle, namely PGA+SGA. Your SGA could be oversized as well.

Please provide us SGA+PGA-relevant initialization parameters. Also, when ORA-04030 starts to appear, provide the following info :

select sum(pga_used_mem),sum(pga_alloc_mem),sum(pga_max_mem) from v$process.

• Kenneth Koenraadt