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

From: Robert Pegram <pegramrg_at_yahoo.com>
Date: Mon, 23 Aug 2004 08:18:33 -0700 (PDT)
Message-ID: <20040823151833.11711.qmail@web50801.mail.yahoo.com>

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_at_rrd.com 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_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
> -----------------------------------------------------------------
>

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_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:15:25 CDT