Re: Increasing JavaPool / SGA

Thomas, 9i uses either a pfile or an spfile (new) - AFA*I*K, the spfile takes precedence over the pfile. Depending on your startup command in 'dbstart', it may be using the spfile version of your parameters.

If you can't find more stuff in the manuals, post again and I'll dig my reference material out again.

HTH On Mon, 13 May 2002 15:16:39 +0200, "Thomas Ruschival" <t.ruschival_at_vivid-md.de> wrote:

>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
>
>
>
>
Received on Tue May 14 2002 - 06:41:46 CDT