Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tons of free memory, but getting ORA-4033.

Re: Tons of free memory, but getting ORA-4033.

From: <bdbafh_at_gmail.com>
Date: 14 Feb 2006 08:55:09 -0800
Message-ID: <1139936109.412806.104980@g47g2000cwa.googlegroups.com>


What is the value of the init.ora (or spfile) parameter

sga_max_size

SQL> select * from v$parameter where name='sga_max_size";

This value is static and can't be adjusted online (at least in 10g R1). The sum of the buffer cache, various pools, pga_aggregate_target (if used) all count against the process limit, which you have not yet hit. A single oracle.exe process will never hit 2 GB of virtual memory (without /3GB) as the real limit is closer to 1.7 GB.

If you do not explicitly set the value for the parameter sga_max_size, it is a computed value. You can explicitly set it higher in the parameter file, but it will count against the oracle.exe process' virtual memory allocation even if the memory is not "committed".

The utility "pslist.exe" from SysInternals is useful for tracking VM under a process.

btw - the 10.1.0.5 patchset is out for MS Win32 OSes (but no CPUJan2006 patch for it).

-bdbafh Received on Tue Feb 14 2006 - 10:55:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US