Large process sizes
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