Unix Shadow Processes take more memory with 9.2

From: Robert Pegram <pegramrg_at_yahoo.com>
Date: Fri, 26 Mar 2004 12:47:28 -0800 (PST)
Message-ID: <20040326204728.12715.qmail@web14424.mail.yahoo.com>

Server: AIX 5.1
Database: 9.2.0.4

We are noticing each connection to the database takes approximately 5 MB of OS memory. Our 8.1.7.4 databases take 3 MB of OS memory. Has anyone else noticed something similar? Did we miss something in the documentation.

I found note 259983.1. Applied the workaround, and this brought the usage down to about 4MB per connection.

workarea_size_policy = auto
pga_aggregate_target = 292552704

We are calculating the shadow process size per note 123754.1 as follows:

ps v <PID> (RSS - TRS) * 1024

Thanks,
Rob Pegram

---

Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html

---

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 Fri Mar 26 2004 - 14:44:18 CST