Large process sizes

From: David Walker <davidw_at_sequent.com>
Date: Fri, 27 Aug 93 22:20:25 GMT
Message-ID: <1993Aug27.222025.7010_at_sequent.com>


Help !

I help manage and tuen a number of sites. The application has a large amount of work done in Forms 3 user exits. The Oracle shadow processes appear to be exceedingly large especially in one site. (the order of magnitude is 8Mb for a standard site and 20Mb for the exceptional site. The only init.ora parameter that I know to affect this is sort_area (I'm ignoring the shared memory that maps the SGA for the moment). I've run the instance with a number of sort_area_size values and observed the following prss data (I've only shown the Virtual Memory column) ...

sort_area_size = default (I believe 64KB)



Process: oracle
text        1492
data+bss     648  to  2124
shared      5584

sort_area_size = 512KB



Process: oracle
text 1492
data+bss 4024 to 5992
shared 5584

sort_area_size = 1MB



Process: oracle
text 1492
data+bss 11116 to 16092
shared 5584

Whereas I would expect the private data to increase by the value of sort_area_size, I am seeing a much greater increase. Any thoughts ?

Thanks in advance for all your help

David

davidw_at_sequent.com Received on Sat Aug 28 1993 - 00:20:25 CEST

Original text of this message