Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!z34g2000cwc.googlegroups.com!not-for-mail From: "sybrandb@yahoo.com" Newsgroups: comp.databases.oracle.server Subject: Re: Oracle benchmark Date: 3 Mar 2006 01:59:42 -0800 Organization: http://groups.google.com Lines: 14 Message-ID: <1141379982.512484.262190@z34g2000cwc.googlegroups.com> References: <44080a87$0$29112$5fc30a8@news.tiscali.it> NNTP-Posting-Host: 192.33.239.29 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1141379988 3440 127.0.0.1 (3 Mar 2006 09:59:48 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 3 Mar 2006 09:59:48 +0000 (UTC) In-Reply-To: <44080a87$0$29112$5fc30a8@news.tiscali.it> User-Agent: G2/0.2 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),gzip(gfe),gzip(gfe) X-HTTP-Via: 1.1 PXYBEBR003 Complaints-To: groups-abuse@google.com Injection-Info: z34g2000cwc.googlegroups.com; posting-host=192.33.239.29; posting-account=3-ZCkwwAAAAif1uTJMVWCyzt_MY2v5ol Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:262674 The best hint I can give you is to read the Oracle Concepts manual, and the Performance Tuning manual. You are wasting your time, as you don't seem to understand anything about how the buffer cache mechanism works. You are up to an exercise in futility, because Oracle never has the complete database in SGA. Even if it would have been possible, the figures you call 'benchmarks' would be completely irrelevant once the database starts growing. You don't plan to increase the SGA once the database grows, do you? If you do, I would either replace Oracle or find another job. -- Sybrand Bakker Senior Oracle DBA