Re: Increase JavaPool / SGA

Thanks alot!

here at work my collegue has set up our testing database using a predefined database sample provided by the DBCA it uses the SPFILE. At home I didn't use the a predefined sample, my instance can be configured altering the pfile.
You cannot alter the JAVA_POOL_SIZE on a running instance!, Well at least I cant do this. -> ORA-02095

bye thomas

"Thomas Ruschival" <t.ruschival_at_vivid-md.de> schrieb im Newsbeitrag news:20020513183535.2d05ba20.t.ruschival_at_vivid-md.de...
> Same Post as in NEWS:comp.databases.oracle.server
> it seems to fit in here better.
>
> 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 Thu May 16 2002 - 07:55:30 CDT