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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).