Re: Why is UGA size so large?

From: <bdbafh_at_gmail.com>
Date: 24 Mar 2005 14:36:56 -0800
Message-ID: <1111703816.444453.50950@z14g2000cwz.googlegroups.com>

use pslist.exe from sysinternals.com:

C:\foodir> pslist -m oracle

to check the virtual memory (VM) attribute of the oracle.exe process. when this hits the process limit ... the fun starts to occur. Its not what you see in sqlplus as far as the memory allocations ... its the virtual memory of the oracle.exe that matters.

Believe me, we'd dealt with this one since "large" memory support was broken by Oracle in the 8.1.7.3.0 patchset and not fixed until the 9.2 release.

-bdbafh Received on Thu Mar 24 2005 - 16:36:56 CST