Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!sn-ams-06!sn-xt-ams-03!sn-ams!sn-feed-ams-01!sn-ams!sn-feed-ams-03!sn-post-ams-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: Poor Performance on Oracle9i - 9.2.0.7 Date: Fri, 05 May 2006 20:13:04 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: sybrandb@hccnet.verwijderdit.nl References: <1146841778.288445.187360@v46g2000cwv.googlegroups.com> <1146842989.550790.211580@y43g2000cwc.googlegroups.com> <1146847600.818914.104950@g10g2000cwb.googlegroups.com> X-Newsreader: Forte Agent 3.3/32.846 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 17 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:266972 On 5 May 2006 09:46:40 -0700, "eavanzi" wrote: >What do you think? I would second bdbafh's remarks. The settings of init.ora show your organization doesn't have a clue about Oracle. Setting db_cache_size to 1G *causes* the cache buffer chain problem Setting shared_pool_size to 14G is just ridiculous. Set log_buffer to 10M is just ridiculous. I would also remove *all* hidden parameters. You have not been tuning so far, you have been following the 'hit and run' approach. -- Sybrand Bakker, Senior Oracle DBA