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!

How can increase shared_pool_size when using ASMM

511057Dec 5 2007 — edited Dec 5 2007

I have a 10g R2 on AIX 5.3 with 4G (3800 M actual). I follow one note from Metalink to check the Library Cache Hit Ratio by this query

SELECT SUM(PINS) "EXECUTIONS",  SUM(RELOADS) "CACHE MISSES WHILE EXECUTING" 
FROM V$LIBRARYCACHE;

and the ratio during the busy hours is around 1.36%. According to the doc, I need to increase the shared_pool_size. How can I achieve that if the system is using the ASMM and my sga_max_size is 1408 and without stop/restart the system? does that mean I need to increase the sga max so ASMM can allocate more to shared_pool? that will cause more in OS swapping ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 2 2008

Added on Dec 5 2007

#general-database-discussions

2 comments

3,629 views