+ Reply to Thread + Post New Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 12
  1. #1
    noufal_y's Avatar
    noufal_y is offline Member
    Join Date
    21 Jul 2009
    Posts
    30
    Say Thanks
    2
    Thanked 0 Times in 0 Posts
    Documents
    0
    Uploads
    0

    Default 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.    Club-Oracle Complementary E-Books and Magazines
    Get your free Complementary Copy of Oracle Magazine

    You can also browse the Free Magazines and E-Books section to see the complete list of free magazines, e-books and Whitepapers.

  3. #2
    zargon's Avatar
    zargon is offline Forum Genius
    Join Date
    22 Oct 2008
    Location
    Here, or maybe there, or ...
    Posts
    473
    Say Thanks
    0
    Thanked 38 Times in 37 Posts
    Documents
    0
    Uploads
    0

    Default 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.

  4. #3
    noufal_y's Avatar
    noufal_y is offline Member
    Join Date
    21 Jul 2009
    Posts
    30
    Say Thanks
    2
    Thanked 0 Times in 0 Posts
    Documents
    0
    Uploads
    0

    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

  5. #4
    zargon's Avatar
    zargon is offline Forum Genius
    Join Date
    22 Oct 2008
    Location
    Here, or maybe there, or ...
    Posts
    473
    Say Thanks
    0
    Thanked 38 Times in 37 Posts
    Documents
    0
    Uploads
    0

    Default 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?

  6. #5
    noufal_y's Avatar
    noufal_y is offline Member
    Join Date
    21 Jul 2009
    Posts
    30
    Say Thanks
    2
    Thanked 0 Times in 0 Posts
    Documents
    0
    Uploads
    0

    Unhappy Re: Virtual memory paging

    Hi ,

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

    Regards,

  7. #6
    zargon's Avatar
    zargon is offline Forum Genius
    Join Date
    22 Oct 2008
    Location
    Here, or maybe there, or ...
    Posts
    473
    Say Thanks
    0
    Thanked 38 Times in 37 Posts
    Documents
    0
    Uploads
    0

    Default 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.

  8. #7
    noufal_y's Avatar
    noufal_y is offline Member
    Join Date
    21 Jul 2009
    Posts
    30
    Say Thanks
    2
    Thanked 0 Times in 0 Posts
    Documents
    0
    Uploads
    0

    Default 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.

  9. #8
    zargon's Avatar
    zargon is offline Forum Genius
    Join Date
    22 Oct 2008
    Location
    Here, or maybe there, or ...
    Posts
    473
    Say Thanks
    0
    Thanked 38 Times in 37 Posts
    Documents
    0
    Uploads
    0

    Default 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.

  10. #9
    halim's Avatar
    halim is offline Junior Member
    Join Date
    22 Apr 2009
    Location
    dhaka
    Posts
    4
    Say Thanks
    1
    Thanked 0 Times in 0 Posts
    Documents
    0
    Uploads
    0

    Default Re: Virtual memory paging

    Someone Says:

    "Who lives with GUI, He died with GUI"


    Regards
    Halim

  11. #10
    zargon's Avatar
    zargon is offline Forum Genius
    Join Date
    22 Oct 2008
    Location
    Here, or maybe there, or ...
    Posts
    473
    Say Thanks
    0
    Thanked 38 Times in 37 Posts
    Documents
    0
    Uploads
    0

    Default 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?

Similar Threads

  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. Replies: 0
    Last Post: 09-17-2009, 11:50 AM
  3. ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
    By cluboracle.arun in forum Server Administration and Options
    Replies: 1
    Last Post: 07-08-2009, 06:42 PM
  4. Memory leak in 10.2.0.3 OCI client on solaris
    By vips4life in forum General
    Replies: 4
    Last Post: 06-22-2009, 06:59 AM

Tags for this Thread