Re: Help Interpreting Windows Trace

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 10 Mar 2010 12:30:44 +0000
Message-ID: <7765c8971003100430x7bd031a0n2c5750d1cbe94bdb_at_mail.gmail.com>

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 running.

Niall

On Wed, Mar 10, 2010 at 11:51 AM, Yechiel Adar <adar666_at_inter.net.il> 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_at_gmail.com> 작성:
>
> Hi All,
>
> I am runing Oracle Enterprose Edition 10.2.0.4 on Windows 2003 Enterprise
> Edition 32 bit. Please help me understand the below line Correctly.
>
> Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 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
> Blessing
>
>
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 10 2010 - 06:30:44 CST