Path: news.f.de.plusline.net!news-fra1.dfn.de!news-stu1.dfn.de!news.germany.com!postnews.google.com!i38g2000prf.googlegroups.com!not-for-mail From: jerry Newsgroups: comp.databases.oracle.server Subject: Re: Buffer cache spillover Date: Tue, 05 Jun 2007 23:24:01 -0700 Organization: http://groups.google.com Lines: 18 Message-ID: <1181111041.143078.146870@i38g2000prf.googlegroups.com> References: <1181110278.796792.41980@d30g2000prg.googlegroups.com> NNTP-Posting-Host: 12.174.80.159 Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Trace: posting.google.com 1181111041 18356 127.0.0.1 (6 Jun 2007 06:24:01 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 6 Jun 2007 06:24:01 +0000 (UTC) In-Reply-To: <1181110278.796792.41980@d30g2000prg.googlegroups.com> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: i38g2000prf.googlegroups.com; posting-host=12.174.80.159; posting-account=jZmiSQ0AAAAp4pv4O-VCg13gnXTlKaRY Xref: news.f.de.plusline.net comp.databases.oracle.server:198999 On Jun 5, 11:11 pm, jerry wrote: > We encounter the following when restarting a database Is anyone > familiar with this warning and could explain it more fully. The > database eventually completes the startup process and opens. > > Tue Apr 3 17:44:39 2007$ > Buffer cache spillover: only 32768 of 117227 buffers available$ > Tue Apr 3 17:44:39 2007$ > Tue Apr 3 17:45:35 2007$ > Buffer cache spillover: only 32768 of 84459 buffers available$ > Tue Apr 3 17:46:44 2007$ > Buffer cache spillover: only 32768 of 51691 buffers available$ > Tue Apr 3 17:48:25 2007$ I forgot to mention it is Oracle 9.2.0.6 on Linux ******* 2.4.21-47.0.1.ELhugemem #1 SMP Fri Oct 13 17:48:02 EDT 2006 i686 i686 i386 GNU/Linux