Re: Oracle 8 Tuning

From: Rainer Herbst <rherbst__at__rz.uni-potsdam.de>
Date: Mon, 11 Aug 2003 09:06:57 +0200
Message-ID: <bh7fac$a3b$1@zeppelin.rz.uni-potsdam.de>

Mike schrieb:
> Hi All,
>
> I have around 25 databases on my HP Unix Box.These databases are
> running on Oracle 8.0.5.I need to start looking at the performance
> aspects of these databases.Can someone please tell me what areas do I
> concentrate on?
>
> TIA
>
> Mike

Sounds interesting - 25 databases, each serverd by one Oracle instance? So you have 25 instances with 25 SGA? How much memory do you have, and how much is consumed by the SGAs?

First guess - move them to one instance with a lot of RAM for the SGA. Second guess - look on the load on the hard disks. Are they all busy or are some very busy and some not?

Last, but not least, use some of the performance tools, e.g. utlbstat/utlestat, which should be even in 8.0.5.

Regards!
Rainer Received on Mon Aug 11 2003 - 02:06:57 CDT