| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 6 databases/one box/performance issue
> 3 GB RAM, how big to set SGA?
How about starting at ~ 2 GB for oracle server processes, and allow ~1
GB for user processes?
(I have no idea as to how much memory HP-UX uses just to breathe ...
leave it room)
How much memory does the OS use before your instances are started? (baseline)
set the oratab to not startup any instances, cycle the system and see how much memory is in use.
How much paging will you tolerate?
Do you have any users actually connecting, or any batch jobs running?
These processes will require memory (PGA/UGA)
What is the typical number of concurrent sessions? Dedicated or shared
servers?
What is the typical sort_area_size that you use? (e.g. 1 MB)
Can you obtain statistics for average values for user process memory
usage?
I've never seen an HP-UX box, but I do have a copy of Don Burleson's
Unix for Oracle DBAs pocket reference.
He suggests the utility "glance" for process memory usage (or sar).
There's a copy of SAMS unix system administration unleashed at http://ftp.cnt.ru/~ftp/EBooks/Vol_1/ch22.htm. Not that I recommend this title, it just showed up in a google search ...
hth,
Paul
Connie Milliken wrote:
>
> 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: Paul Drake INET: paled_at_home.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).Received on Sun Apr 08 2001 - 01:41:23 CDT
 |
 |