+ Reply to Thread
Results 1 to 9 of 9

Significant virtual memory paging was detected on the host operating system

  1. Significant virtual memory paging was detected on the host operating system

    Hi everyone,

    Id' just setup a new server for our Database, here's the Spec :

    Win Server 2003 Ent. Edition (64 bit)
    2 CPUs
    24 Gb of RAM
    Oracle 10.0.2.3 (64 bit)

    My SGA is 11040 MB and the PGA 4095 MB
    so, around 17GB for the instance, and it left 7GB of RAM for the OS
    suppose to be Ok, but i have the message : Significant virtual memory
    paging was detected on the host operating system in the EM ...

    Do i do something wrong ?

    Thanks
    Chris


  2. Re: Significant virtual memory paging was detected on the host operating system

    On Nov 5, 3:10 pm, chris wrote:
    > Hi everyone,
    >
    > Id' just setup a new server for our Database, here's the Spec :
    >
    > Win Server 2003 Ent. Edition (64 bit)
    > 2 CPUs
    > 24 Gb of RAM
    > Oracle 10.0.2.3 (64 bit)
    >
    > My SGA is 11040 MB and the PGA 4095 MB
    > so, around 17GB for the instance, and it left 7GB of RAM for the OS
    > suppose to be Ok, but i have the message : Significant virtual memory
    > paging was detected on the host operating system in the EM ...
    >
    > Do i do something wrong ?
    >
    > Thanks
    > Chris


    I have trouble understanding why you need an 11 gig SGA.


    David Fitzjarrell


  3. Re: Significant virtual memory paging was detected on the host operating system

    On Nov 5, 4:37 pm, "fitzjarr...@cox.net" wrote:
    > On Nov 5, 3:10 pm, chris wrote:
    >
    >
    >
    >
    >
    > > Hi everyone,

    >
    > > Id' just setup a new server for our Database, here's the Spec :

    >
    > > Win Server 2003 Ent. Edition (64 bit)
    > > 2 CPUs
    > > 24 Gb of RAM
    > > Oracle 10.0.2.3 (64 bit)

    >
    > > My SGA is 11040 MB and the PGA 4095 MB
    > > so, around 17GB for the instance, and it left 7GB of RAM for the OS
    > > suppose to be Ok, but i have the message : Significant virtual memory
    > > paging was detected on the host operating system in the EM ...

    >
    > > Do i do something wrong ?

    >
    > > Thanks
    > > Chris

    >
    > I have trouble understanding why you need an 11 gig SGA.
    >
    > David Fitzjarrell- Hide quoted text -
    >
    > - Show quoted text -


    I'm not an expert DBA, so i think if the memory is available, i can
    give it to the database
    is it better to reduce it ? , i'd change my server bcause the old one
    crash many time because of a lack of memory

    Thanks


  4. Re: Significant virtual memory paging was detected on the host operating system

    On Nov 5, 1:40 pm, chris wrote:
    > On Nov 5, 4:37 pm, "fitzjarr...@cox.net" wrote:
    >
    >
    >
    >
    >
    > > On Nov 5, 3:10 pm, chris wrote:

    >
    > > > Hi everyone,

    >
    > > > Id' just setup a new server for our Database, here's the Spec :

    >
    > > > Win Server 2003 Ent. Edition (64 bit)
    > > > 2 CPUs
    > > > 24 Gb of RAM
    > > > Oracle 10.0.2.3 (64 bit)

    >
    > > > My SGA is 11040 MB and the PGA 4095 MB
    > > > so, around 17GB for the instance, and it left 7GB of RAM for the OS
    > > > suppose to be Ok, but i have the message : Significant virtual memory
    > > > paging was detected on the host operating system in the EM ...

    >
    > > > Do i do something wrong ?

    >
    > > > Thanks
    > > > Chris

    >
    > > I have trouble understanding why you need an 11 gig SGA.

    >
    > > David Fitzjarrell- Hide quoted text -

    >
    > > - Show quoted text -

    >
    > I'm not an expert DBA, so i think if the memory is available, i can
    > give it to the database
    > is it better to reduce it ? , i'd change my server bcause the old one
    > crash many time because of a lack of memory
    >
    > Thanks


    Cut both the SGA and PGA in half. Then when things are running with a
    normal load, use the advisory tools to figure out what they should be.

    More is not always better. Also, sometimes the advisors keep telling
    you to increase things, look closely at how much change it predicts
    will be made, don't fall into the trap of trying to get every last
    percentage point of performance that way.

    jg
    --
    @home.com is bogus.
    http://www.signonsandiego.com/uniont...s_1b3scam.html


  5. Re: Significant virtual memory paging was detected on the host operating system

    On Nov 5, 4:10 pm, chris wrote:
    > Hi everyone,
    >
    > Id' just setup a new server for our Database, here's the Spec :
    >
    > Win Server 2003 Ent. Edition (64 bit)
    > 2 CPUs
    > 24 Gb of RAM
    > Oracle 10.0.2.3 (64 bit)
    >
    > My SGA is 11040 MB and the PGA 4095 MB
    > so, around 17GB for the instance, and it left 7GB of RAM for the OS
    > suppose to be Ok, but i have the message : Significant virtual memory
    > paging was detected on the host operating system in the EM ...
    >
    > Do i do something wrong ?
    >
    > Thanks
    > Chris


    The message may be a false alarm - even checking task manager on
    Windows 2003 may be misleading. On Windows 2003, the "PF Usage"
    statistic in task manager is not page file usage, but instead total
    virtual memory usage, which includes RAM and page file. Oracle
    Enterprise Manager, I believe, is showing the "PF Usage" statistic.
    For additional information see the discussion in this link:
    http://groups.google.com/group/comp....2c4d761cace2a6

    Joel provides a good suggestion regarding a starting point for memory
    allocation.

    Charles Hooper
    IT Manager/Oracle DBA
    K&M Machine-Fabricating, Inc.


  6. Re: Significant virtual memory paging was detected on the host operating system

    On Mon, 05 Nov 2007 13:40:09 -0800, chris wrote:

    >On Nov 5, 4:37 pm, "fitzjarr...@cox.net" wrote:
    >> On Nov 5, 3:10 pm, chris wrote:
    >>
    >>
    >>
    >>
    >>
    >> > Hi everyone,

    >>
    >> > Id' just setup a new server for our Database, here's the Spec :

    >>
    >> > Win Server 2003 Ent. Edition (64 bit)
    >> > 2 CPUs
    >> > 24 Gb of RAM
    >> > Oracle 10.0.2.3 (64 bit)

    >>
    >> > My SGA is 11040 MB and the PGA 4095 MB
    >> > so, around 17GB for the instance, and it left 7GB of RAM for the OS
    >> > suppose to be Ok, but i have the message : Significant virtual memory
    >> > paging was detected on the host operating system in the EM ...

    >>
    >> > Do i do something wrong ?

    >>
    >> > Thanks
    >> > Chris

    >>
    >> I have trouble understanding why you need an 11 gig SGA.
    >>
    >> David Fitzjarrell- Hide quoted text -
    >>
    >> - Show quoted text -

    >
    >I'm not an expert DBA, so i think if the memory is available, i can
    >give it to the database
    >is it better to reduce it ? , i'd change my server bcause the old one
    >crash many time because of a lack of memory
    >
    >Thanks


    a) The memory is not available.
    b) Your calculation is wrong, as you forget to include the memory
    client processes will be using on the database server. So : you are
    not using 17Gb, you are using more. Please consult the task manager to
    verify memory used by Oracle.exe
    c) Is there any advisor in Oracle which told you to configure such
    outrageous amounts of memoryl, or do you belong to the 'More is better
    school of tuning'
    d) Likely you have an untuned application.
    Fix it.
    Stop symptom fighting.
    Contrary to what some 'gurus' state, it won't work, ever.

    --


    Sybrand Bakker
    Senior Oracle DBA

  7. Re: Significant virtual memory paging was detected on the host operating system

    On Nov 6, 1:38 am, sybra...@hccnet.nl wrote:
    > On Mon, 05 Nov 2007 13:40:09 -0800, chris wrote:
    > >On Nov 5, 4:37 pm, "fitzjarr...@cox.net" wrote:
    > >> On Nov 5, 3:10 pm, chris wrote:

    >
    > >> > Hi everyone,

    >
    > >> > Id' just setup a new server for our Database, here's the Spec :

    >
    > >> > Win Server 2003 Ent. Edition (64 bit)
    > >> > 2 CPUs
    > >> > 24 Gb of RAM
    > >> > Oracle 10.0.2.3 (64 bit)

    >
    > >> > My SGA is 11040 MB and the PGA 4095 MB
    > >> > so, around 17GB for the instance, and it left 7GB of RAM for the OS
    > >> > suppose to be Ok, but i have the message : Significant virtual memory
    > >> > paging was detected on the host operating system in the EM ...

    >
    > >> > Do i do something wrong ?

    >
    > >> > Thanks
    > >> > Chris

    >
    > >> I have trouble understanding why you need an 11 gig SGA.

    >
    > >> David Fitzjarrell- Hide quoted text -

    >
    > >> - Show quoted text -

    >
    > >I'm not an expert DBA, so i think if the memory is available, i can
    > >give it to the database
    > >is it better to reduce it ? , i'd change my server bcause the old one
    > >crash many time because of a lack of memory

    >
    > >Thanks

    >
    > a) The memory is not available.
    > b) Your calculation is wrong, as you forget to include the memory
    > client processes will be using on the database server. So : you are
    > not using 17Gb, you are using more. Please consult the task manager to
    > verify memory used by Oracle.exe
    > c) Is there any advisor in Oracle which told you to configure such
    > outrageous amounts of memoryl, or do you belong to the 'More is better
    > school of tuning'
    > d) Likely you have an untuned application.
    > Fix it.
    > Stop symptom fighting.
    > Contrary to what some 'gurus' state, it won't work, ever.
    >
    > --
    >
    > Sybrand Bakker
    > Senior Oracle DBA- Hide quoted text -
    >
    > - Show quoted text -


    Perfect, i'll go to reduce it and run the advisor
    Thanks to all


  8. Re: Significant virtual memory paging was detected on the host operating system

    On Nov 6, 6:36 am, chris wrote:
    > On Nov 6, 1:38 am, sybra...@hccnet.nl wrote:
    >
    >
    >
    >
    >
    > > On Mon, 05 Nov 2007 13:40:09 -0800, chris wrote:
    > > >On Nov 5, 4:37 pm, "fitzjarr...@cox.net" wrote:
    > > >> On Nov 5, 3:10 pm, chris wrote:

    >
    > > >> > Hi everyone,

    >
    > > >> > Id' just setup a new server for our Database, here's the Spec :

    >
    > > >> > Win Server 2003 Ent. Edition (64 bit)
    > > >> > 2 CPUs
    > > >> > 24 Gb of RAM
    > > >> > Oracle 10.0.2.3 (64 bit)

    >
    > > >> > My SGA is 11040 MB and the PGA 4095 MB
    > > >> > so, around 17GB for the instance, and it left 7GB of RAM for the OS
    > > >> > suppose to be Ok, but i have the message : Significant virtual memory
    > > >> > paging was detected on the host operating system in the EM ...

    >
    > > >> > Do i do something wrong ?

    >
    > > >> > Thanks
    > > >> > Chris

    >
    > > >> I have trouble understanding why you need an 11 gig SGA.

    >
    > > >> David Fitzjarrell- Hide quoted text -

    >
    > > >> - Show quoted text -

    >
    > > >I'm not an expert DBA, so i think if the memory is available, i can
    > > >give it to the database
    > > >is it better to reduce it ? , i'd change my server bcause the old one
    > > >crash many time because of a lack of memory

    >
    > > >Thanks

    >
    > > a) The memory is not available.
    > > b) Your calculation is wrong, as you forget to include the memory
    > > client processes will be using on the database server. So : you are
    > > not using 17Gb, you are using more. Please consult the task manager to
    > > verify memory used by Oracle.exe
    > > c) Is there any advisor in Oracle which told you to configure such
    > > outrageous amounts of memoryl, or do you belong to the 'More is better
    > > school of tuning'
    > > d) Likely you have an untuned application.
    > > Fix it.
    > > Stop symptom fighting.
    > > Contrary to what some 'gurus' state, it won't work, ever.

    >
    > > --

    >
    > > Sybrand Bakker
    > > Senior Oracle DBA

    >
    > Perfect, i'll go to reduce it and run the advisor
    > Thanks to all


    I would add, I believe the docs and some metalink docs are wrong or
    misleading on the subject of pga memory allocation. Googling for:
    pga_aggregate_target "jonathan lewis"
    is very educational and will certainly add to your understanding of
    what you are doing.

    jg
    --
    @home.com is bogus.
    http://abqordia.blogspot.com/


  9. Re: Significant virtual memory paging was detected on the host operating system

    On Nov 6, 2:03 pm, joel garry wrote:
    > On Nov 6, 6:36 am, chris wrote:
    >
    >
    >
    >
    >
    > > On Nov 6, 1:38 am, sybra...@hccnet.nl wrote:

    >
    > > > On Mon, 05 Nov 2007 13:40:09 -0800, chris wrote:
    > > > >On Nov 5, 4:37 pm, "fitzjarr...@cox.net" wrote:
    > > > >> On Nov 5, 3:10 pm, chris wrote:

    >
    > > > >> > Hi everyone,

    >
    > > > >> > Id' just setup a new server for our Database, here's the Spec :

    >
    > > > >> > Win Server 2003 Ent. Edition (64 bit)
    > > > >> > 2 CPUs
    > > > >> > 24 Gb of RAM
    > > > >> > Oracle 10.0.2.3 (64 bit)

    >
    > > > >> > My SGA is 11040 MB and the PGA 4095 MB
    > > > >> > so, around 17GB for the instance, and it left 7GB of RAM for the OS
    > > > >> > suppose to be Ok, but i have the message : Significant virtual memory
    > > > >> > paging was detected on the host operating system in the EM ...

    >
    > > > >> > Do i do something wrong ?

    >
    > > > >> > Thanks
    > > > >> > Chris

    >
    > > > >> I have trouble understanding why you need an 11 gig SGA.

    >
    > > > >> David Fitzjarrell- Hide quoted text -

    >
    > > > >> - Show quoted text -

    >
    > > > >I'm not an expert DBA, so i think if the memory is available, i can
    > > > >give it to the database
    > > > >is it better to reduce it ? , i'd change my server bcause the old one
    > > > >crash many time because of a lack of memory

    >
    > > > >Thanks

    >
    > > > a) The memory is not available.
    > > > b) Your calculation is wrong, as you forget to include the memory
    > > > client processes will be using on the database server. So : you are
    > > > not using 17Gb, you are using more. Please consult the task manager to
    > > > verify memory used by Oracle.exe
    > > > c) Is there any advisor in Oracle which told you to configure such
    > > > outrageous amounts of memoryl, or do you belong to the 'More is better
    > > > school of tuning'
    > > > d) Likely you have an untuned application.
    > > > Fix it.
    > > > Stop symptom fighting.
    > > > Contrary to what some 'gurus' state, it won't work, ever.

    >
    > > > --

    >
    > > > Sybrand Bakker
    > > > Senior Oracle DBA

    >
    > > Perfect, i'll go to reduce it and run the advisor
    > > Thanks to all

    >
    > I would add, I believe the docs and some metalink docs are wrong or
    > misleading on the subject of pga memory allocation. Googling for:
    > pga_aggregate_target "jonathan lewis"
    > is very educational and will certainly add to your understanding of
    > what you are doing.
    >
    > jg
    > --
    > @home.com is bogus.http://abqordia.blogspot.com/- Hide quoted text -
    >
    > - Show quoted text -


    Thanks again Joel, just for today, i can see better performance
    on my database, just after reducing the size of my SGA

    Chris


+ Reply to Thread