Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Increased Memory, CPU, and Oracle process size since upgrade to 9i (64-bit)

RE: Increased Memory, CPU, and Oracle process size since upgrade to 9i (64-bit)

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Mon, 23 Aug 2004 10:49:54 -0500
Message-ID: <FBE1FCA40ECAD41180400050DA2BC54004E93CA9@qtiexch2.qgraph.com>


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



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

To unsubscribe send email to: oracle-l-request_at_freelists.org 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

-----------------------------------------------------------------
Received on Mon Aug 23 2004 - 10:45:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US