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
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
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.)
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.)
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
'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.
What else is running on that server?
check Task Manager for anything else using a lot of RAM.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have attached virtual memory settings & task manager screen shot. Is that because of virtual memory settings?
ss.jpg
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.
It is likely something using all the physical memory or it might be a false-positive.
In task manager, show us the performance tab.
ASKER
ASKER
Also attached init.ora parameters screen shot from AWR Report.
init.jpg
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.
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.
ASKER
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
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 ?
Again. Doesn't help.
Why are you posting everything expect what I asked for in http:#a39423229 ?
ASKER
Its in the ID: 39423256 which i already posted just below your post.
http:#a39423256
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.
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.
ASKER
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**
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok thanks..how we can find the issue?
I dint set a limit to use the RAM.
Please advice.
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.
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.
ASKER
I've requested that this question be deleted for the following reason:
no solutions
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.
It is not the Oracle database.