Re: Increase JavaPool / SGA

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: 14 May 2002 07:26:19 -0700
Message-ID: <abr6qb0tmp@drn.newsguy.com>

In article <37fab3ab.0205140511.651c9222_at_posting.google.com>, mikerault_at_earthlink.net says...
>
>Actually you need to change it using ALTER SYSTEM SET
>JAVA_POOL_SIZE=xM SCOPE=FILE and then do the CREATE pfile FROM spfile
>command. Then restart.
>
>"Ikarus" <luciver_at_zone.at> wrote in message
>news:<mDSD8.56815$5a4.774018_at_news.chello.at>...
>> Hi!
>>
>> In 9i you 2 Parameter File. The init File and the spinit. You can change the
>> Parameter on the running
>> Instance ???

I'm not 100% sure why you recommend using the CREATE PFILE command here, unless it's to provide a backup of the SPFILE. WHen you use the STARTUP command, it's default behaviour in 9i is to use the SPFILE if it can find one. You have to override this by specifying a PFILE clause if you want to use the PFILE you created. Oh, and the command should be ALTER SYSTEM SET JAVA_POOL_SIZE=xM SCOPE=SPFILE, not SCOPE=FILE.

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Tue May 14 2002 - 09:26:19 CDT