RE: Increased Memory, CPU, and Oracle process size since upgrade to 9i (64-bit)
- From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 23 Aug 2004 10:49:54 -0500
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@xxxxxxxxxxxxxxxxx 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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts: