Memory used.

[Swathi]

Hi

 

How can we know how much RAM is being used by oracle in my server.

We have 8GB RAM on Windows 2003 Server.

 

Regards

Swathi

DISCLAIMER: This email may contain privileged information and is intended solely for the addressee, and any disclosure of this information is strictly prohibited, and may be unlawful. If you have received this mail by mistake, please inform the sender immediately and delete this mail. Any information expressed in this mail does not necessarily reflect the views of CANARA BANK. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the Bank. The recipient should check this email and any attachments for the presence of viruses. The sender declares that no liability can be cast upon the sender for any error or omissions in the contents of the message that arise, as a result of e-mail transmission and further declares that the sender cannot be made liable for any loss suffered by any person, on account of having acted upon any messages which is vitiated by error, omissions or interception.

[Anand Buldeo]

HI,

 It can be checked through Task Manager, processes. In processes calculate the total memory used by oracle.exe

 

Regards

Anand

 

--
Regards
Anand Buldeo

[swathi]

Hi

In task manager it shows around 1,921,760K for oracle.exe
ie it is using only 2GB of the RAM.
We have used 3GB switch also.
How can i make oracle use atleast 5GB of RAM in our server?

Regards
Swathi

[Anand Buldeo]

Hi,

If your OS is of 32 bit, it is the limitation of OS to use only 2.7GB of memory for oracle.exe processes after applying 3GB switch in boot.ini file. But it also have some disadvantages..check metalink for that

 

Anand

--
Regards
Anand Buldeo

[sampath]

To find the memory used by oracle

execute the following queries

SQL> select sum(pga_used_mem) from v$process;

Add the result to result of the following query

SQL> select sum(value) from v$sga;



Sampath

On Nov 24, 5:14 pm, "Anand Buldeo" <anandbul...@gmail.com> wrote:
> Hi,
> If your OS is of 32 bit, it is the limitation of OS to use only 2.7GB of
> memory for oracle.exe processes after applying 3GB switch in boot.ini file.
> But it also have some disadvantages..check metalink for that
>
> Anand
>