Re: Help Interpreting Windows Trace

  • From: kathy duret <katpopins21@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 10 Mar 2010 10:48:50 -0800 (PST)

the /3G will get you to 3G
you can also reduce the amount of memory each process uses by using orastack 
Check the Virtual bytes you are using.
Some apps like Business Objects will release the connection from the client but 
the process stays running in Oracle.  
Some developer/dba tools when they crash leave session in Oracle 
What for old inactive and active connections
Check out MOS note 427993.1 for more details on all of the above.

--- On Wed, 3/10/10, Blessing Kamutande <kamutandeb@xxxxxxxxx> wrote:

From: Blessing Kamutande <kamutandeb@xxxxxxxxx>
Subject: Re: Help Interpreting Windows Trace
To: niall.litchfield@xxxxxxxxx
Cc: adar666@xxxxxxxxxxxx, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
Date: Wednesday, March 10, 2010, 8:02 AM

Thank you Niall,
When you say 800mb is used by user processes are you referring to Oracle 
processes or generally the whole system?
Also that 2047M is it for this one instance or all instances on the server?
For instance, say I  have two instances, do the two instances share the 2074M 
or each instance can grow it's memory usage to 2047M?
Thank you so much for the explanation.
Kind Regards

2010/3/10 Niall Litchfield <niall.litchfield@xxxxxxxxx>

It is indeed the virtual address space for user processes. (and only 1.2gb of 
it is left). You should see this change if you reduce the kernel allocation to 
1gb by use of the /3gb switch in boot.ini (or userva in the new boot 
configuration for windows7/Server2008). I'm prtetty certian that this 
information is returned by the o/s so I don't believe we can conclude that the 
instance memory allocation is 800mb, just that 800mb of user processes are 

On Wed, Mar 10, 2010 at 11:51 AM, Yechiel Adar <adar666@xxxxxxxxxxxx> wrote:

I beg to differ.

You have 2GB for oracle. The instance use about 0.8 GB now and can grow to 2 GB.
The other 2 GB (from 4GB max in 32 bit) are used for the kernel.
Adar Yechiel
Rechovot, Israel

Dion Cho wrote: 

I believe that VA stands for virtual address. 

You are on the 32bit machine where the maximum address space is 2G. Some part 
of the address is reserved for the kernel thus you have around 1.2G remained.  

Sent from my amazing iPhone. 

2010. 3. 10. 오후 7:15 Blessing Kamutande <kamutandeb@xxxxxxxxx> 작성:

Hi All,
I am runing Oracle Enterprose Edition on Windows 2003 Enterprise 
Edition 32 bit. Please help me understand the below line Correctly.
Oracle Database 10g Enterprise Edition Release - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows Server 2003 Version V5.2 Service Pack 2
CPU                 : 16 - type 586, 2 Physical Cores
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:31553M/32757M, Ph+PgF:31791M/34442M, VA:1231M/2047M
I assume Ph:31553M/32757M refers to the Physical Memory, Ph+PgF:31791M/34442M 
refers to physical + Swap space, third column is the one I'm grappling with!
VA:1231M/2047M what does it refer too? which available & total  memory? And 
what does VA stand for?
Thank you in advance for the clarification.
Kind Regards

Niall Litchfield
Oracle DBA


Other related posts: