Re: Oracle 9i tuning the database performance

David Nguyen wrote:

> Hi all,
>
> I have 2 oracle 9i databases in the same box win2k server with 1000M
> memory with 2 seperate intances. One intance never use just for
> archive only (or back up if you will) but the intance still open and
> the other intance is the production intance.
>
> 1) If I stop the archive intance will help the production intance
> access to more memory and it run faster? In another word if the
> archive intance start but never use will it hurt the memory of another
> intance?
>
> 2) Second I run my application in the client machine with 4 pentiums
> processor and 1000 M memory. However my application is run so slow
> since it access the data from the server (The server has only
> databases) and I know I need to edit the parameters in the init.ora
> file of the server databases. Right now the init.ora is set up as
> default from enterprise edition since I installed it.
>
> Any suggest any parameters to improve the performance of the
> database is greatly appreciated.
>
> Thanks

More memory does not necessarily equate with faster. The only way to know is to either have significant DBA skills and experience or experiment. And usually experimentation trumps experience. Try it!

You should be using about 1/3 of that gig of RAM.

But I suspect that this is not really your issue. Have you looked at the low hanging fruit? Have you been keeping statistics fresh with DBMS_STATS? Have you explain planned the slow queries? Have you run DBMS_PROFILER on the application? Have you looked at waits? If not ... SGA tuning is the wrong place to start.

Daniel Morgan Received on Sat Mar 01 2003 - 01:10:08 CST