Virtual memory paging

in Oracle Database; Dear all, I got a performance alert as " significant virtual memory paging was detected on host " is this ...
+ Post Reply + Post New Topic
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 12
  1. #1
    noufal_y is offline Forum Advisor
    Points: 1,070, Level: 17
    Join Date
    21 Jul 2009
    Posts
    38
    Points
    1,070

    Virtual memory paging

    Dear all,

    I got a performance alert as " significant virtual memory paging was detected on host "
    is this a big issue? how can i resolve this?
    Please give me advices.

    Thanks & regards,


  2. #2
    zargon's Avatar
    zargon is offline Forum Guru
    Points: 24,550, Level: 95
    Join Date
    22 Oct 2008
    Location
    Aurora, CO
    Posts
    1,894
    Points
    24,550

    Re: Virtual memory paging

    Quote Originally Posted by noufal_y View Post
    Dear all,

    I got a performance alert as " significant virtual memory paging was detected on host "
    is this a big issue? how can i resolve this?
    Please give me advices.

    Thanks & regards,
    It's very likely your SGA is very large and it may exceed the limits of the installed RAM (you can't have all of it allocated to your shared_pool because the O/S needs some memory to function and you do need memory for connected sessions). Resize your shared pool to a smaller value and see if that corrects the problem.

  3. #3
    noufal_y is offline Forum Advisor
    Points: 1,070, Level: 17
    Join Date
    21 Jul 2009
    Posts
    38
    Points
    1,070

    Unhappy Re: Virtual memory paging

    Dear Zargon,

    I checked the memory,
    Total SGA is 1200MB ,Maximum SGA 1200MB
    Shared pool 128,Buffer cache 1024, Lpool 16,jpool 16 and other 16

    System Pro(virtual memory)

    initial 2048, maximum 6141

    So can you tell me where i have to reset
    Thanks verymuch for the support.

    Regards

  4. #4
    zargon's Avatar
    zargon is offline Forum Guru
    Points: 24,550, Level: 95
    Join Date
    22 Oct 2008
    Location
    Aurora, CO
    Posts
    1,894
    Points
    24,550

    Re: Virtual memory paging

    Quote Originally Posted by noufal_y View Post
    Dear Zargon,

    I checked the memory,
    Total SGA is 1200MB ,Maximum SGA 1200MB
    Shared pool 128,Buffer cache 1024, Lpool 16,jpool 16 and other 16

    System Pro(virtual memory)

    initial 2048, maximum 6141

    So can you tell me where i have to reset
    Thanks verymuch for the support.

    Regards
    Virtual memory is swap, it's not the installed RAM. How much RAM is installed?

  5. #5
    noufal_y is offline Forum Advisor
    Points: 1,070, Level: 17
    Join Date
    21 Jul 2009
    Posts
    38
    Points
    1,070

    Unhappy Re: Virtual memory paging

    Hi ,

    Its 4GB.
    I need to clear this alert.
    Please advice.

    Regards,

  6. #6
    zargon's Avatar
    zargon is offline Forum Guru
    Points: 24,550, Level: 95
    Join Date
    22 Oct 2008
    Location
    Aurora, CO
    Posts
    1,894
    Points
    24,550

    Re: Virtual memory paging

    Quote Originally Posted by noufal_y View Post
    Hi ,

    Its 4GB.
    I need to clear this alert.
    Please advice.

    Regards,
    WHERE did you see this alert?? OEM/Grid Control? Was it in reference to a database instance or the operating system? You need to provide more inforomation on where this alert was reported and in what context.

  7. #7
    noufal_y is offline Forum Advisor
    Points: 1,070, Level: 17
    Join Date
    21 Jul 2009
    Posts
    38
    Points
    1,070

    Re: Virtual memory paging

    Its in OEM.
    I beleive this in OS config.
    The exact alert is
    " Significant virtual memory paging was detected on the host "
    It listed in ADDM findings also.

  8. #8
    zargon's Avatar
    zargon is offline Forum Guru
    Points: 24,550, Level: 95
    Join Date
    22 Oct 2008
    Location
    Aurora, CO
    Posts
    1,894
    Points
    24,550

    Re: Virtual memory paging

    Quote Originally Posted by noufal_y View Post
    Its in OEM.
    I beleive this in OS config.
    The exact alert is
    " Significant virtual memory paging was detected on the host "
    It listed in ADDM findings also.
    You then need to work with the System Administrator to discover what is causing all of this paging/swap activity. It may be Oracle, it may be some other process. Simply because OEM reports this is not an indication that Oracle is at fault.

  9. #9
    halim is offline Junior Member
    Points: 110, Level: 2
    Join Date
    22 Apr 2009
    Location
    dhaka
    Posts
    6
    Points
    110

    Re: Virtual memory paging

    Someone Says:

    "Who lives with GUI, He died with GUI"


    Regards
    Halim

  10. #10
    zargon's Avatar
    zargon is offline Forum Guru
    Points: 24,550, Level: 95
    Join Date
    22 Oct 2008
    Location
    Aurora, CO
    Posts
    1,894
    Points
    24,550

    Re: Virtual memory paging

    Quote Originally Posted by halim View Post
    Someone Says:

    "Who lives with GUI, He died with GUI"


    Regards
    Halim
    Which means what, exactly? Who is this 'someone'? Of what relevance is your 'contribution' to the thread? What value does it provide?

Page 1 of 2 1 2 LastLast
Other Solutions
  1. ORA-01034 ORA-27101 ORACLE not available shared memory realm does not exist
    By StryderKC in forum Server Administration and Options
    Replies: 7
    Last Post: 06-07-2010, 04:34 AM
  2. Memory leak in Oracle 10g 10.0.2.3
    By fisher in forum Oracle Database
    Replies: 1
    Last Post: 03-16-2010, 01:13 AM
  3. Memory leak in 10.2.0.3 OCI client on solaris
    By vips4life in forum Oracle Database
    Replies: 4
    Last Post: 06-22-2009, 06:59 AM