--- mike mon <[EMAIL PROTECTED]> wrote: > We have ORACLE 9ir2 on SUN Solaris. We plan to use > Java on ORACLE very soon and need you help. > > 1. how to check the database we have is "java enable"? >
connect as system/sys and SQL> desc dbms_java > 2. If database on "java enable", which files we need > run to make it "java" enable"? $OH/javavm/install/initjvm.sql (no need to do if you are able to describe as above (Check readme files in the dir/subdir under $OH/javavm) > > 3. on init.ora file their has a entry call > "java_pool_size = ????". What value should I put in > there? > Put min.50Mb. If not "alter java class <classname> resolve" will give errors and the java class(es) will show invalid. > 4. except "java_pool_size = ??", does their has other > entry we need put on "init.ora" file to support JAVA? > Keep shared_pool_size to min 50Mb. HTH GovindanK __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Govindan=20K?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).