Database Tuning (MOSC)

MOSC Banner

Should I increase the share pool size?

edited Jan 26, 2012 5:25PM in Database Tuning (MOSC) 15 comments
I ran the AWR reports in one of the database and returned library cache hit ratio as 88%. I immediately thought of increase the shared_pool size. My AWR snapshot interval is 1 hour. But for this one hour only 0.46 min is db time and the rest of the time is idle time. Is this report representative? Should I increase the shared_pool size anyway? If the database is mostly idle, the library cache yields 88%. If the database gets busy, will the library cache hit ratio get even lower percentage? Any advice? This is a 10.2.0.4 version on linux server. Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center