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

  • From: Robert Pegram <pegramrg@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 23 Aug 2004 08:18:33 -0700 (PDT)

Traci,

We had a similar issue with AIX.  What we determined was each 9i
connection took approx 2 mb more memory from the OS than 8i.  Our
solution was to increase memory on the server.

Rob Pegram
Duke University

--- traci.l.rebman@xxxxxxx wrote:

> 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 //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> 



                
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail 
----------------------------------------------------------------
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: