• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 575
  • Last Modified:

virtual memory paging is 100% full, what should be done?

virtual memory paging is 100% full, what should be done?
0
lium1
Asked:
lium1
  • 3
  • 2
3 Solutions
 
lium1Author Commented:
virtual memory paging is 100% full, what should be done?
0
 
lium1Author Commented:
Database is running very slow because of virtual memory paging 100% full?
0
 
slightwv (䄆 Netminder) Commented:
Pretty much two options:

Increase memory in the server.
and/or
Reduce existing memory usage.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Devinder Singh VirdiLead Oracle DBA TeamCommented:
How much is your actual RAM and how much is swap memory?
As suggested by slightwv, you can think to reduce SGA size as of now.
0
 
lium1Author Commented:
How do I find out the swap memory? Any suggesting t how much should SGA size to reduce?
0
 
slightwv (䄆 Netminder) Commented:
>>How do I find out the swap memory?

What OS?  I would ask your system administrator.

>>Any suggesting t how much should SGA size to reduce?

We cannot answer that.  There is no standard setting.  All databases vary.  We don't know your system, how it is used, etc...

This is a DBA tuning task.  Ask your DBA for advice.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now