Link to home
Start Free TrialLog in
Avatar of 12karthik
12karthik

asked on

Oracle 11g Significant virtual memory paging

We have Oracle11 g in windows 2003 R2, RAM is 12gb
In enterprise manager its showing 'Significant virtual memory paging was detected on the host operating system.'
Database is in non-archive mode.
I have set the OS Virtual memory to 4092-8184 in C & E drives (only C & E drive in server)
How to resolve this issue
Avatar of Mark Geerlings
Mark Geerlings
Flag of United States of America image

This is 32-bit Windows, correct?  Or is this actually 64-bit Windows?  If this is 64-bit Windows, do you have 32-bit or 64-bit Oracle?  What values do you have in your init*.ora (or spfile) for: sga_max_size and/or sga_target?  If this is a 32-bit system, do you have it adjusted to allow your buffer_cache value to be larger than 2Gb?  Does this server also need memory for any other programs or processes besides Oracle or is it dedicated to just running one Oracle database? How long have you had this system running?  Did it used to run without causing virtual memory problems?
Is this still a problem for you?  You haven't been back to give us any more information to work with.  What does the Windows Performance Monitor show you regarding memory and swap file usage?  What does this SQL command show you:
show SGA

To run that command, you will have to open a command window on the server, then start SQL*Plus.  Here is the output from that command on one of our Linux servers that runs Oracle11:

Total System Global Area 4175568896 bytes
Fixed Size                  2234960 bytes
Variable Size             956302768 bytes
Database Buffers         3204448256 bytes
Redo Buffers               12582912 bytes

(I supported Oracle on Windows for many years, but we don't have that combination now.)
Avatar of 12karthik
12karthik

ASKER

This is windows 2003 64 bit and Oracle (11g Release 2 (11.2) for Microsoft Windows x64 (64-Bit)

'Show SGA' result is:
Total System Global Area 7482626048 bytes
Fixed Size                  2190296 bytes
Variable Size            5989467176 bytes
Database Buffers         1476395008 bytes
Redo Buffers               14573568 bytes

Attached screen shot
EM.jpg
The server has 12 Gig.  The SGA is showing about 7 Gig max.

What else is running on that server?

check Task Manager for anything else using a lot of RAM.
SOLUTION
Avatar of Mark Geerlings
Mark Geerlings
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I have attached virtual memory settings & task manager screen shot. Is that because of virtual memory settings?
ss.jpg
It is not the settings.  That just says how much virtual memory you have available.  It has nothing to do with how much of it is actually being used.

It is likely something using all the physical memory or it might be a false-positive.

In task manager, show us the performance tab.
Thanks for the info.
Attached performance tab
perform.jpg
Also attached init.ora parameters screen shot from AWR Report.
init.jpg
You will need to check your Task Manager screen multiple times per day (or night) to see if there are other programs that use large amounts of RAM at other times.  Do you have some kind of backup software running on this server?  Is this server also a Domain Admin server or a file and print server?  Or, does this server *only* run this one Oracle database?
>>Also attached init.ora parameters screen shot from AWR Report.

Doesn't help.

Again, this doesn't appear to be related to the database per say.  Something is using RAM outside the database instance itself.

We need to see OS memory usage.
This server only runs oracle database. Attached screen shot of applications installed and services.
Also in that FRhome1 is stopped and its not enabled, only working is Oralce-OraDB11g_home.
scr.jpg
>>Attached screen shot of applications installed and services.

Again.  Doesn't help.

Why are you posting everything expect what I asked for in http:#a39423229 ?
Its in the ID: 39423256 which i already posted just below your post.
http:#a39423256
AH, I completely missed that.  Sorry.

From that, you should not be paging anything.

The next time you get the alert, check to see how much RAM is being used.  If it is close to the 12Gig the server has, then go to processes, sort by memory used and see what else is using a lot.
Thanks for the support giving.
Everytime its showing Oracle only using more memory and also it not crossing 6gb i think.

**Personal contact information removed by Netminder 18 Sept 2013**
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ok thanks..how we can find the issue?
I dint set a limit to use the RAM.
Please advice.
>>ok thanks..how we can find the issue?

When you see the paging issue, look to see what is using the systems RAM.  I would go into task manager and look at processes.  Then sort by memory.

You really can't diagnose what used memory in the past unless you have something that captures system resource usage on an on-going basis.  I don't know what that might be.
I've requested that this question be deleted for the following reason:

no solutions
I have to object to your reason for closing this.  The solution is to look outside Oracle for what is using the memory when you are receiving those alerts.

It is not the Oracle database.