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- Hide quoted text -
>
> - Show quoted text -
Perfect, i'll go to reduce it and run the advisor
Thanks to all
Received on Tue Nov 06 2007 - 08:36:39 CST
