Altering the Shared Pool Size
438772Mar 22 2005 — edited Mar 22 2005I am trying to start an oracle instance and tell it to use the init.ora file. However i am receiveing an error about my pool size being too small. Please see below:
SQL> startup pfile=/home/oracle/OraHome_1/dbs/init.ora
ORA-00371: not enough shared pool memory, should be atleast 52132659 bytes
I checked init.ora and the shared_pool_size is set to 3500000. However, i tried the other settings, as it had a medium and a large option, i tried these just to see what would happen. It didn't work, and i don't think this is the problem.
I then tried this query:
SQL> SELECT shared_pool_size_for_estimate,
2 shared_pool_size_factor,
3 estd_lc_time_saved
4 FROM v$shared_pool_advice;
And it output the settings for my shared_pool_size. The setting for "level 1: 76".
Can anyone tell me if this is too low, or how to fix this problem?
Thanks,
Gary