Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Host operating system was experiencing significant paging

martin_hFeb 1 2013 — edited Feb 7 2013

Hello,

I have a problem with many times discussing problem "Host operating system was experiencing significant paging but no particular root cause could be detected. Investigate processes that do not belong to this instance running on the host that are consuming significant amount of virtual memory. Also consider adding more physical memory to the host."

My database run on Windows Server 2008 R2 and have 12GB of physical RAM.

Oracle version is 10.2.0.4.0 and my sga and pga are:

sga_max_size 4000M
sga_target 3904M
pga 1200M

I try to find out something about this issue and read many blogs but unfortunately I didnt find anything which helped. Should this have something to do with the fact that on the server we have oracle database and terminal server with 30-40 users?

Any advice?

Thank you
Martin

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 7 2013

Added on Feb 1 2013

#general-database-discussions

15 comments

2,878 views