Database Administration (MOSC)

MOSC Banner

Segment size is 10 timer larger than SGA size

edited Nov 13, 2022 7:13AM in Database Administration (MOSC) 5 commentsAnswered ✓

Experts,

When user wants to retrieve complete table data which is larger than allocated SGA.

Lets assume

SGA MAX size is 82 GB & Segment size is 800+ GB

Here segment size is 10 Times higher than SGA allocated SGA size , If so 

When the SELECT QUERY runs against that particular object and fetching full table data.,

Does it impact my SGA or PGA ? Do i need to adjust SGA Size or Complete 800 GB table data is handled by users session of the PGA.

Does it lead to Direct path read waits or no free buffer waits !

Regards,

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