RE: 6 databases/one box/performance issue

From: Suhen Pather <Suhen.Pather_at_strandbags.com.au>
Date: Sun, 08 Apr 2001 01:53:36 -0700
Message-ID: <F001.002E4B29.20010408012041@fatcity.com>

Connie,

HPUX 11.0 is a bit memory hungry.

You would need to leave some memory for the OS before allocating to the SGAs else your system will start swapping / paging.

Before allocating memory to the SGA's leave some to the HPUX buffer, Unix OS, users logging onto the box.

Check what size the the Unix buffer is set to.

Use top and glance performance monitor to check how memory is already used (and free) even before your allocate to the SGA's.

HTH
Suhen

We have 6 databases on one HPUX box (not my idea) that has 3GB RAM. In this type of situation, can the total of the 6 databases SGAs add up to 3GB? Are there any special types of calculations that should be done in this type of situation to determine optimal performance sizing for the databases?

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Connie Milliken
INET: cemail_at_sprintmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Suhen Pather
INET: Suhen.Pather_at_strandbags.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------