Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!y43g2000cwc.googlegroups.com!not-for-mail
From: "eavanzi" <eavanzi@romi.com.br>
Newsgroups: comp.databases.oracle.server
Subject: Re: Poor Performance on Oracle9i - 9.2.0.7
Date: 5 May 2006 11:45:24 -0700
Organization: http://groups.google.com
Lines: 9
Message-ID: <1146854724.144299.236500@y43g2000cwc.googlegroups.com>
References: <1146841778.288445.187360@v46g2000cwv.googlegroups.com>
   <1146842989.550790.211580@y43g2000cwc.googlegroups.com>
   <1146847600.818914.104950@g10g2000cwb.googlegroups.com>
   <p75n52td6skc22qanp9aqt0l500mun4cf0@4ax.com>
NNTP-Posting-Host: 200.161.69.249
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1146854730 22917 127.0.0.1 (5 May 2006 18:45:30 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 5 May 2006 18:45:30 +0000 (UTC)
In-Reply-To: <p75n52td6skc22qanp9aqt0l500mun4cf0@4ax.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 IWSS1.romi.com.br:8080 (squid/2.5.STABLE3)
Complaints-To: groups-abuse@google.com
Injection-Info: y43g2000cwc.googlegroups.com; posting-host=200.161.69.249;
   posting-account=IxHPHQwAAAByPZ-oalXcqeDSCxjNtBHT
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:266973

>Setting shared_pool_size to 14G is just ridiculous.

The shared_pool_size is 1,4G not 14G
The SGA is 2,78GB
What is the best settings for db_cache_size and log_buffer ?
Why I would remove the all hidden parameters? They are unnecessary?
Please, specify me.
Thank you.