Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Oracle shadow process
Hello All,
How does oracle allocate memory to oracle shadow
process (client). eg. oracleORCL
(DESCRIPTION=(LOCAL=no
)(ADDRESS=(PROTOCOL=BEQ))).
I have dedicated connections to the databases and the
processes are using 320M-340M of memory. Is there any
parameter I can change to reduce the memory allocation
to about 30M or less.
Current value for Sort area size value is 65536.
Thanks
Sonia P.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sonia pajerowski INET: spajerowski_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Wed Jan 30 2002 - 13:07:12 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).