The default is 20m in 8.1.5 => 8.1.7.
You can change it to 1m in 8.1.5, and '0' in 8.1.6
(which will default to 32k)
hth
connor
--- "DEMANCHE Luc (Cetelem)" <[EMAIL PROTECTED]>
wrote: > 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).
>
=====
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
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).
