Re: Increasing JavaPool / SGA

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
>
>
>

AFAIK the *file* is supposed to be in $ORACLE_HOME/dbs and the *link* in the $ORACLE_BASE/admin/$ORACLE_SID/pfile directory Do it the other way around and you are bound to be in trouble.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon May 13 2002 - 11:55:29 CDT