Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

changing shared_pool_size on Oracle 8i database

BaffyAug 26 2009 — edited Aug 26 2009

This is for the 'veterans' in our midst:

I've got a legacy system running Oracle database version 8.1.7.0 (8i).

I tried increasing the shared_pool_size by changing it in the init.ora file and restarting the database. When I do:
'show parameter shared_pool_size' after this change, the old value keeps coming up.

Is there a command similar to "SQL> STARTUP PFILE='/oradata/spfileORCL.ora' " in 8i which I can use to 'force' the database to read the init.ora file?

Many thanks for your antiucipated wuick responses.

Baffy

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 23 2009

Added on Aug 26 2009

#general-database-discussions

9 comments

789 views