Re: Increasing JavaPool / SGA

I think Jeremy Russell is correct, Oracle 9i picks up the spfile if you do a default install (which I guess you have since your instance name is ORCL).

It is a little unsafe to give advice on making changes without very careful investigation, as there are a couple of quirks in spfile usage in 9.0.1, but

1. You may be able to shut the database, rename the spfile (which will be in $ORACLE_HOME/dbs and have a name including the instance name), and restart to have Oracle pick up the init.ora file.
2. You could alter system set jave_pool_size=150000000 scope=spfile and restart the system to modify the spfile value for the java pool before restarting.

DO NOT try hacking the spfile with an editor.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



Thomas Ruschival wrote in message ...


>Hi,

> Loading a large XML-document (68MB) from a CLOB column into a table with

>the package DBMS_XMLSave always ran into a Java OutOfMemory error.So I

>decided to give it a greater JavaPool.

>Original settings in the initfile where:

>java_pool_size=117440512

>large_pool_size=1048576

>shared_pool_size=117440512

>

>I changed the Values to

>java_pool_size=150000000

>large_pool_size=5000000

>shared_pool_size=150000000

>

>With "dbshut" I shut down the database and restarted it with "dbstart"

>To my surprise none of the parameters were changed.

>I am wondering where the memory parameters for Oracle 9i Linux are set.

>BTW my instance is called ORCL1, $ORACLE_HOME is /opt/oracle/product/9.0.1.

>$ORACLE_HOME/dbs/initorcl1.ora is a symbolic link to

>/opt/oracle/admin/pfile/initorcl1.ora.

>I edited opt/oracle/admin/pfile/initorcl1.ora.

>Where else are these parameters set?

>

>Thanks in advance

>Thomas

>

>

>

>