Re: Multiple instances

On Thu, 14 May 1998 16:32:39 +0200, Mattias Niklasson <mn_at_mint.se> wrote:

>Hello,
>
>We are running nine (9) instances of Oracle 7.3.2 on following mashine:
>
>SUN Ultra-2
>2x167MHz
>512Mb
>6x2Gb disk mirrored over two SCSI controllers
>
>The problem is that the mashine reports 0% idle CPU time and we get long
>responsetimes when the load goes up. There are very little disk I/O.
>
>Do you think upgrading to 2x300MHz would help? Or should we just realize
>that we can't run so many instances on the same mashine?
>
>Best Regards,
>Mattias Niklasson
>

What type of application(s) are you running? If it's primarily OLTP you may be helped by using MTS (multi-threaded server).

OTOH 9 instances on such a machine is probably overloading it. If % idle is 0, you need more/faster processors.

When response time gets long, try running sar -w or vmstat and look for paging and swappping. Paging and swapping indicates a need for more memory, or to decrease the size of your SGAs.

--
Chuck Hamilton
chuckh_at_dvol.com

If at first you don't succeed, sky diving isn't for you.