Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Different between SGA_TARGET and TOTAL SGA

YockeeApr 12 2022

Hi,
What is the difference between SGA_TARGET (in V$PARAMETER) and Total SGA (the sum of all values in V$SGA) ?
For the SGA_TARGET, I run : SELECT name,value,display_value,isdefault,isbasic FROM V$PARAMETER WHERE name IN ('memory_target', 'sga_target', 'pga_aggregate_target'); I get around 14 GB.
image.png

For the total SGA, I run : SELECT sum(value)/1024/1024 "TOTAL SGA (MB)" FROM v$sga; I get around 26 GB. The query on SGA size (SELECT name,value/1024/1024 “SGA (MB)” “FROM v$sga;) gives out result as follows :
image.png

From https://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams193.htm#REFRN10256, it says "SGA_TARGET specifies the total size of all SGA components".
If SGA_TARGET is the total of all SGA, then why do they differ ?
Thanks for clearing up my confusion.
I am using Oracle 11.2g.
Comments
Post Details
Added on Apr 12 2022
#memory, #performance, #performance-availability, #performance-availability-discussions, #tuning
3 comments
553 views