Re: Increasing JavaPool / SGA

Goddamn! I'm not often "correct" - I guess I must be on a roll ;)

Now, if I only had a job to go with it and I could be very correct on a regular basis ....

On Sun, 19 May 2002 20:55:24 +0100, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>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
>
>a) 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.
>
>b) 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
>>
>>
>>
>>
>
>
Received on Tue May 21 2002 - 06:46:55 CDT