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

On Nov 6, 2:03 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Nov 6, 6:36 am, chris <cboi..._at_jlr.ca> wrote:
>
>
>
>
>
> > On Nov 6, 1:38 am, sybra..._at_hccnet.nl wrote:
>
> > > On Mon, 05 Nov 2007 13:40:09 -0800, chris <cboi..._at_jlr.ca> wrote:
> > > >On Nov 5, 4:37 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> > > >> On Nov 5, 3:10 pm, chris <cboi..._at_jlr.ca> 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 Received on Tue Nov 06 2007 - 13:14:14 CST