Re: Database management strategy

From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Tue, 7 Feb 2012 06:29:56 -0800 (PST)
Message-ID: <18181822.2401.1328624996974.JavaMail.geo-discussion-forums_at_yqbr20>

Technically Real Application Cluster (RAC) instances are one Oracle database being accessed by multiple Oracle instances running on different physical servers so the answer to you one question is yes.

When the Oracle database is slowly consuming the available server resources you options would be to add cpu or upgrade cpu (same number, but newer faster cpu's), adding more memory, upgrading the IO cards, adding disks to the disk array, and/or upgrading or replacing the disk array depending on exactly what resources you are consuming.

Migration to RAC and tuning to ensure Oracle is efficiently using the resources it is consuming would also be options.

HTH -- Mark D Powell -- Received on Tue Feb 07 2012 - 08:29:56 CST