Database Tuning (MOSC)

MOSC Banner

Oracle 10g memory allocation

edited Apr 9, 2009 6:06PM in Database Tuning (MOSC) 2 commentsAnswered
 I am running Oracle 10G. I have 4G SGA managed by automatic memory system. 3G is currently allocated to the Variable Size and 1G to database buffers. The application that uses the DB uses lots of dynamically built SQL without binding variables. I think this is fooling the "Automatic memory system". Its there a way to determine what is the best way to allocate the SGA. Or some report that will tell me if my variable size is too large. Most of it seems to be allocated to the 'shared pool sql area'.

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