Unix Shadow Processes take more memory with 9.2
- From: Robert Pegram <pegramrg@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 26 Mar 2004 12:47:28 -0800 (PST)
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@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:
- » Unix Shadow Processes take more memory with 9.2
