Path: text.usenetserver.com!out04b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!k79g2000hse.googlegroups.com!not-for-mail From: chris Newsgroups: comp.databases.oracle.server Subject: Re: Significant virtual memory paging was detected on the host operating system Date: Tue, 06 Nov 2007 06:36:39 -0800 Organization: http://groups.google.com Lines: 60 Message-ID: <1194359799.822370.102300@k79g2000hse.googlegroups.com> References: <1194297035.016057.272980@y27g2000pre.googlegroups.com> <1194298634.665439.193840@19g2000hsx.googlegroups.com> <1194298809.971827.312410@k35g2000prh.googlegroups.com> NNTP-Posting-Host: 64.254.228.66 Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Trace: posting.google.com 1194359800 31013 127.0.0.1 (6 Nov 2007 14:36:40 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 6 Nov 2007 14:36:40 +0000 (UTC) In-Reply-To: User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: k79g2000hse.googlegroups.com; posting-host=64.254.228.66; posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0 Xref: usenetserver.com comp.databases.oracle.server:437369 X-Received-Date: Tue, 06 Nov 2007 09:36:40 EST (text.usenetserver.com) 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