| 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: Increased Memory, CPU, and Oracle process size since upgrade to 9i (64-bit)
What HPUX box do you have, with what CPUs and how many/fast? Do you use SORT_AREA_SIZE and company in your init.ora or did you convert to 9i's PGA_AGGREGATE_TARGET? Did you change the pertinent kernel settings to accommodate 64-bit Oracle (e.g. maxdsiz_64, maxssiz_64bit, although to be fair, I believe these deal mostly with the SGA)?
We had the advantage moving from a 6-way 200Mhz K570 w/4GB to a 4-way 750Mhz rp5470 w/8GB on our 32-to-64 bit move. Here's our kernel settings to accommodate about 450 user processes across 4 instances (2 64-bit 9i, 2 32-bit 8i, with about 300 processes in one of the 64-bit instances):
Kernel Parm Old Val New Val fs_async 0 *MUST BE 0 FOR ORACLE!* ksi_alloc_max 2208 32928 max_thread_proc 64 256 maxdsiz 268435456 1073741824 maxdsiz_64 1073741824 2147483648 maxssiz 8388608 134217728 maxssiz_64bit 1073741824 1073741824 (N/C) maxswapchunks 16384 16384 (N/C) maxuprc ? 3704 msgmap 42 42 (N/C) msgmni 50 4116 msgseg 2048 32767 msgtql 40 4116 ncallout 515 7235 ncsize 7876 12196 (LOW) nfile 7750 14662 (LOW) nflocks 200 4096 ninode 2756 7076 (LOW) nkthread 499 7219 nproc 276 4116 semmap 66 4098 semmni 64 4096 semmns 128 4096 semmnu 30 30???? semvmx 32767 32768 shmmax 4294967296 4294967296 (N/C) shmmni 200 512 shmseg 120 120 (N/C) vps_ceiling 16 64
Hopefully, this table will be readable once it hits the list! The "Old Val" column was the value before changes for Oracle. "N/C" next to a value is for "No Change", "LOW" means the parameter is lower than the recommended Oracle value, based on study of the parameter and HP recommendations.
Rich
Rich Jesse System/Database Administrator rich.jesse_at_quadtechworld.com QuadTech, Sussex, WI USA
-----Original Message-----
Sent: Saturday, August 21, 2004 8:25 AM
Subject: Increased Memory, CPU, and Oracle process size since upgrade to 9i (64-bit)
Hello, I have recently upgraded an 8.1.7.4 (32-bit) database to 9.2.0.5
(64-bit) on an HP/UX 11.11 server with 4GB of physical memory. Our CPU
utilization, memory usage, and oracle process sizes have increased
significantly. Ress. memory for Oracle user process sizes went from 500MB
per 116 processes to 800MB per 120 processes. CPU and memory utilization
is now maxing out at 100%. Has anyone experienced anything similar that
could shed some light on how I can reduce the amount of memory used by
Oracle user processes in 9i?
Thanks in advance!
Traci
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Mon Aug 23 2004 - 10:45:24 CDT
-----------------------------------------------------------------
 |
 |