Skip to Main Content

Different between SGA_TARGET and TOTAL SGA

YockeeApr 11 2022 — edited Apr 11 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 11g.

Comments
Post Details
Added on Apr 11 2022
4 comments
44 views