Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

Database Administration (MOSC)

SGA_TARGET_ADVICE

Nov 15, 2018 12:59PM edited Nov 22, 2018 10:57AM in Database Administration (MOSC) 3 commentsAnswered ✓

not sure why

when SGA_SIzE_FACTOR is 0.25 has less DB_TIME than factor =1, and SGA_SIZE_FACTOR =0.75 has the highest DB time among (factor 0.25,0.5,0.75,1,..2)?

SGA_SIZE SGA_SIZE_FACTOR ESTD_DB_TIME ESTD_DB_TIME_FACTOR ESTD_PHYSICAL_READS ESTD_BUFFER_CACHE_SIZE ESTD_SHARED_POOL_SIZE CON_ID

292 0.25 149320 0.4024 410222185 160 832 0

584 0.5 149320 0.4024 410222185 160 832 0

876 0.75 14784145 39.8415 1932556714 80 624 0

1168 1 371074 1 410222185 160 832 0

1460 1.25 354301 0.9548 251466199 320 960 0

1752 1.5 351333 0.9468 251466199 368 1200 0

2044 1.75 349255 0.9412 251466199 368 1488 0

2336 2 348253 0.9385 251466199 464 1680 0

1

Howdy, Stranger!

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

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

Category Leaderboard

Top contributors this month