We help IT Professionals succeed at work.

How much memory is being used

joe_echavarria
on
Hi,

  I will like to know if there is a way i can use to monitor how much memory is being use by the instance ?, let say i have SGA of 8G and i want to know how much is being used by each of the SGA sections, like by the buffer cache, shared pool, etc.
  Some query will be good.

  Thanks for your help.
Comment
Watch Question

SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
If you are licensed, AWR/ADDM reports.

If not, I believe Statspack reports will help.

There are some views but I believe they are related to AWR.
SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
Should add that real-time should be able to be seen in dbConsole or Grid Control.
SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
Not sure how granular you want to get but here are some starting points.  The docs will have the descriptions:

select * from v$sga;
select * from v$sgainfo;

You can dig deeper with views like v$sgastat.
joe_echavarriaDatabase Administrator

Author

Commented:
What i need to know is how the memory allocation look for the instance, having a new size for the SGA.

What should be the query to perform ?
SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
I do not understand what "having a new size for the SGA" means.
joe_echavarriaDatabase Administrator

Author

Commented:
That i increased the size of the sga_max_size to 8 G
SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
Log in to sqplus as system and use: show parameter sga

You can also query v$parameter for 'sga_max_size' and 'sga_target' unless you are using 11g and Automatic Memory Management then the parameters are 'memory_target' and 'max_memory_target'

Explore More ContentExplore courses, solutions, and other research materials related to this topic.