Database Tuning (MOSC)

MOSC Banner

spfile required for ASM

edited Jul 27, 2009 10:08PM in Database Tuning (MOSC) 10 commentsAnswered
I read on this on a website last week and wanted to know if there is any truth to the statement that a spfile is the only way Oracle can dynamically make the ASM parameter changes dynamically.  If we are using pfile's still are we not receiving the benefits of ASM?

 

Do you have to use a spfile in order to fully utilize ASM?

 

    "Using Oracle's Automatic Shared Memory Tuning, you can instruct Oracle to manage a subset of the components that make up the SGA by setting the target size of the SGA through the new SGA_TARGET parameter. Oracle will pool from this value and dynamically distribute memory across selected components of the SGA. You do not need to set values for SHARED_POOL_SIZE, JAVA_POOL_SIZE, LARGE_POOL_SIZE, or DB_CACHE_SIZE as Oracle will automatically size these for you. Once you set the SGA_TARGET parameter to a desirable size for your SGA, these parameters will take on a value of zero and new parameters will be created

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