Re: Help Interpreting Windows Trace

From: De DBA <dedba_at_tpg.com.au>
Date: Fri, 12 Mar 2010 09:35:24 +1000
Message-ID: <4B997E3C.5070806_at_tpg.com.au>

You can observe this if you get ProcessExplorer, formerly from SysInternals, now available from Microsoft. (http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx). This tool does not install anything, so you can run it safely on the server.

Each oracle instance shows up as a single process image in the process table, as opposed to *NIX where each oracle background process is a separate entity. On Windows the background processes, server processes, etc. are all threads within the Oracle.exe process image.

Cheers,
Tony

On 11/03/10 7:01 PM, Yechiel Adar wrote:
> Some basic windows 32 bit info:
> Windows allocate for each program up to 4 GB memory.
> Each 4 GB address space is divided: 2 GB belong to the program and 2 GB
> to windows.
> So each of your instances has 2 GB.
> The 2 GB include the oracle instance and the buffers, and all the memory
> used by the connections.
>
> Using the /3GB switch change the division to: 1 GB to windows, 3 GB to
> the program.
>
> Adar Yechiel
> Rechovot, Israel
>
>
>
> Blessing Kamutande wrote:

>> 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
>> Blessing
>>

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

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

Received on Thu Mar 11 2010 - 17:35:24 CST