Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Poor Performance on Oracle9i - 9.2.0.7

Re: Poor Performance on Oracle9i - 9.2.0.7

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 05 May 2006 20:13:04 +0200
Message-ID: <p75n52td6skc22qanp9aqt0l500mun4cf0@4ax.com>


On 5 May 2006 09:46:40 -0700, "eavanzi" <eavanzi_at_romi.com.br> 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
Received on Fri May 05 2006 - 13:13:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US