Database Tuning (MOSC)

MOSC Banner

Is having high MEMORY_TARGET value advantage

edited Sep 1, 2011 6:45AM in Database Tuning (MOSC) 3 commentsAnswered

We are upgrading from 9i to 11g ( old box of 32 bit to new 64 bit box ) using export and import) this week end.

Current

SGA_MAX_SIZE is 11,500MB  ( 11 GB)

SHARED_POOL_SIZE is 512MB

PGA_AGGREGATE_TARGET is 600 MB

I have almost 64 GB memory on the new box. Setting high value ( say 32 GB) to the MEMORY_TARGET will be helpful in 11g? We do not have any major performance issues in 9i now. Since 11g has automatic memory management process, I would like to set the high value and assign shared_pool_size, pga_target and sga_target as 0 on the new box. How about sort_area_size?

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