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

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

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

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.

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

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

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/

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