RE: Changing Java pool size to 0

Hi Ramesh

The java_pool_size is use want you work with the JServer.  Do you have a Java stored proc, EJB or CORBA in your DB ?  If not, you don't need the java_pool_size.

You could set it to 0.  The default is 1m.

Luc

-----Message d'origine-----
De: rpapnoi_at_chemtex.co.in [mailto:rpapnoi_at_chemtex.co.in] Date: Tuesday, June 12, 2001 8:10 AM
Ŕ: Multiple recipients of list ORACLE-L
Objet: Changing Java pool size to 0

Hi List
The following is config on my init<sid>.ora on NT4 /Oracle 816, DB size 25GB.

shared_pool_size = 52428800  # INITIAL
large_pool_size = 614400
java_pool_size = 20971520

Now my Question is Can I reduce java_pool_size to 0  as I am not using any Java module. I am using BLOB in my db & also I am using DBstudio for DB operations on NT box (Unix users please excuse!!). Please suggest the effects and side effects of changing java_pool_size to 0. or suggest the figure.

TIA Ramesh Papnoi
(BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
"The obstacles you face are mental barriers which can be broken by adopting a more positive approach."

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: rpapnoi_at_chemtex.co.in


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-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).