Thanks for the question, Shubham.
Asked: September 22, 2017 - 6:55 am UTC
Last updated: September 23, 2017 - 4:16 am UTC
Version: 11.2.0.4.0
Viewed 1000+ times
You Asked
Recently , I ran into a System Global Area (SGA) related alert as below :
SGA USAGE
INST_ID TOTAL_MB USED_MB FREE_MB FREE_PCNT
1 168836.35 105033.66 43802.71 29
And these alert kept on showing frequently for past 3 hours . It seems the area utilized by some running sessions are unusually utilizing it more and in a streak for last 3 hours.
Is there any way or query so that I can see the sessions utilizing more area of SGA and hence , take care of this alert .
and Connor said...
Well...its called the S-GA for a reason. It is a *shared* area. For example, lets say session 1 parses a massive query, which burns up lots of memory. Then 10 other sessions come along and run that query. Who is responsible for that ? Session 1 ? The other sessions running it ? Because after all, if they were not running the query that memory would be free'd up.
Unless you are getting *errors* about insufficient memory available in the SGA, I would not worry about it. I *want* my SGA to be full - otherwise I'm just wasting memory.
Is this answer out of date? If it is, please let us know via a Comment