System Global Area (SGA) - Overview
==================================================================
SQL> startup
ORACLE instance started.
Total System Global Area 1252663296 bytes (<-- total size loaded into memory)
Fixed Size 2252824 bytes (<-- release specific; varies; out of your control)
Variable Size 788533224 bytes (<-- control structures for the SGA itself)
Database Buffers 452984832 bytes (<-- 'db_block_buffers')
Redo Buffers 8892416 bytes (<-- 'log_buffers' or the default minimum for your platform)
Database mounted.
Database opened.
SQL>
Fixed SGA
======================
The fixed SGA is a component of the SGA that varies in size from platform to platform and release to release. The size of the fixed portion is constant for a release and a platform of Oracle, that is, it cannot be changed through any means such as altering the initialization parameters The fixed size component is out of your control. It varies from release to release and platform to platform. Thus It contains a collection of objects that point to other areas inside the rest of the SGA. this area as a bootstrap section of the SGA, something Oracle uses internally to find the other bits and pieces of the SGA
Redo Buffers
=============================
Redo log buffer Redo Buffers is roughly equal to the parameter log_buffer.
Database Buffers
============================
Database buffer cache It’s size is equal to db_block_size * db_block_buffers.
(Note: db_block_buffers is deprecated as of 9i, so if the init parameter db_cache_size) is set, the buffer cache’s size will be set according to this value.
Variable portion
=====================
The variable portion is called variable because its size (measured in bytes) can be changed.For consideration of the variable size, it is useful to look at v$sgastat.The variable size is most affected by java_pool_size + large_pool_size + shared_pool_size but other parameters will contribute to it (eg: every control_file will consume 256 bytes of variable size memory
compute sum of bytes on pool
break on pool skip 1
set pagesize 9999
set pause on
SQL> select pool, name, bytes from v$sgastat order by pool, name;
POOL NAME BYTES
------------ -------------------------- ----------
java pool free memory 16777216
************ ----------
sum 16777216
large pool PX msg pool 491520
free memory 33062912
************ ----------
sum 33554432
shared pool 1:kngisga 32152
ADR_CONTROL 1504
ADR_INVALIDATION 664
AQ Propagation Scheduling 16000
ASH buffers 2097152
ASM KFFD SO 2648
ASM generic network state 2584
ASM kfk state object 2776
ASM map operations 2904
ASM rollback operations 2648
ASM scan context 3544
AW SGA 40
AWR Table Info (KEW layer 1216
Active Session History - 1528
Alert log 520
ArchLog Dest Array 22784
Array of cached attr 400
Auto tune undo info 96
BRANCH TABLE SEGMENTED AR 220296
Background process state 48
Banner Storage 2048
CGS system incarn array 24864
Checkpoint queue 205312
Cleanup state objects 1760
Client ID trace setting h 536
Client ID trace settings 3928
Closed Thread SCN Bitvec 33792
Core dump directory 520
DBWR array of pointers to 8
DBWR event stats array 216
DDE_USER_ACTION 1128
DDE_USER_ACTION_DEF 1320
DDE_USER_ACTION_PARAMETER 2080
DDE_USER_INCIDENT_ACTION_ 664
DDE_USER_INCIDENT_TYPE 664
DFW_CONFIG_CAPTURE 752
DFW_CONFIG_ITEM 944
DISPATCHER CONFIG ENTRY 88
DISPATCHER CONFIG TABLE 2048
DISPATCHERS INFO 2496
DML lock 410784
Detached dump directory 520
EM_DIAG_JOB 1320
EM_TARGET_INFO 1224
EM_USER_ACTIVITY 1224
ENQUEUE STATS 23040
ENQUQUE FREELISTS 168
FAL req blks 744
FAST SPACEUSAGE 312328
File Space Usage 11344
FileIdentificatonBlock 760896
FileOpenBlock 1972416
Global Context Heap descr 400
HM_FDG_SET 848
HM_FINDING 2632
HM_INFO 944
HM_MESSAGE 1416
HM_RECOMMENDATION 2072
HM_RUN 1976
HTTP fixed headers 72
I/O stat latches 4960
INCCKEY 848
INCIDENT 3008
INCIDENT_FILE 848
INC_METER_CONFIG 1224
INC_METER_IMPT_DEF 1040
INC_METER_INFO 1320
INC_METER_PK_IMPTS 1040
INC_METER_SUMMARY 1416
IO_SHARES_KGSKCAP 8
IPS_CONFIGURATION 1320
IPS_FILE_COPY_LOG 1040
IPS_FILE_METADATA 944
IPS_PACKAGE 1880
IPS_PACKAGE_FILE 848
IPS_PACKAGE_HISTORY 1320
IPS_PACKAGE_INCIDENT 944
IPS_PACKAGE_UNPACK_HISTOR 1040
IPS_PROGRESS_LOG 1320
IPS_REMOTE_PACKAGE 944
JSX SGA 3776
KCB Table Scan 40
KCB Table Scan Bitmap 256
KCB Table Scan Buffer 4198400
KCB buffer wait statistic 3352
KCB incremental ckpt entr 720
KCB tablespace encryption 1064
KCB undo bitvec 4096
KCB where statistics arra 37440
KCFIS SGA 8
KESTB existence bitvec 262144
KESTB existence bitvec se 2048
KEWS External IDs 1536
KEWS aggregation objs 4032
KEWS fixed SGA 5704
KEWS sesstat seg tbl 8
KEWS sesstat values 160056
KEWS statistic maps 3216
KEWS statistic metadata 16864
KEWS statistic name 2288
KEWS sysstat values 256
KFD extent enqueue obj 42816
KFG SO child 8440
KFG state obj 7032
KFK SGA 4224
KFK idtab_kfksga 64832
KFM state obj 2904
KGI Session State 1080
KGKP randnum 40000
KGKP randnum shadow 40000
KGKP sga 48
KGLA 387112
KGLDA 661056
KGLH0 14281776
KGLHD 3297912
KGLNA 6032
KGLS 7288000
KGLSG 5267216
KGNFS scontext 524480
KGSK scheduler 63328
KGSK sga 8240
KGSKI schedule 41384
KGSKI scheduler heap 1 de 232
KGSKI scheduler heap 2 de 232
KGSKI sga 72
KGX 133224
KGX rowlist 6624
KKBTD 16576
KKJ SGA 720
KKJ SHRD WRQS 240
KKJ WRK LAT 480
KKKI consumer 4056
KKSSP 1159840
KKTDF 7744
KKTIN 12800
KKTSR 17704
KOKTD 289560
KQF optimizer stats table 1904
KQF runtime defined table 8928
KQFUTTAB COLS 472
KQR L PO 1350760
KQR L SO 68608
KQR M PO 1842728
KQR M SO 379904
KQR S SO 3072
KRBMROS ANCHOR 96
KRSF SGA 40
KSFD Cache Hints for IO R 72
KSFD SGA I/O b 4190328
KSFQ buffer pool 3032
KSFV SGA 832
KSI ENQUEUES 11760
KSI Indexes 288
KSI resource types 16224
KSIR SGA 144
KSK OSS PLAN 3360
KSK SGA 168016
KSK VT POOL 353600
KSKQ SGA 14200
KSKQ SGA NODEINFO 1359872
KSN WaitID 1560
KSPD key heap 4056
KSQ event description 9208
KSRPC I/O Stat array 144
KSRPC I/O Stat array ptr 16
KSTM SGA 24
KSVR SGA 2384
KSXP test table columns d 1320
KSZ sga subheap descripto 136
KTA latches 2024
KTC latch cleanup 480
KTC latch subh 54608
KTC latches 1760
KTC txn rsrc cnt 88
KTC variable sga 24
KTCN global clauses ht 128
KTCN global operands ht 128
KTCN global operators 64
KTCN queries hash table 128
KTCN: Hash Table Segmente 5240
KTCN: Obj Invalidation Se 24632
KTCN: Row Change Segmente 34552
KTCN: query inv Segmented 3928
KTCNC inv hashtable 128
KTCNQROW colname ptrs 344
KTCNQROW colnames 1296
KTCTSNL freelists 88
KTCTSNL subheaps 1496
KTF MAPPINGS 12288
KTI freelists 88
KTI latch structure 4320
KTI latches 864
KTI pool states 32
KTI-UNDO 1901880
KTPR HIST TB 2808
KTPR SUBHEAP 168
KTRSGA 8
KTSJ subheap 4056
KTSL lat struct 40960
KTSL reco struct 24576
KTU SGA 32
KTU avail cache 4032
KTU lat struct 160
KTU latch cleanup 208
KTU latches 120
KTUR HIST INFO 4840
KUPP subheap desc 232
KWQDL SGA Ddtc gen cleanu 48
KWQDL SGA Dtc gen cleanup 48
KWQDL child latches 2880
KXFR Hash Array latches a 2944
KXFR Psuedo Hash Array fo 3072
KYWM CROSS INSTANCE 384
KYWM RPLY CROSS INSTANCE 53248
KYWM SGA 296
L2 enabled array 16
L2 file global fob 72
L2 file map array 4896
LGWR debug module memory 8192
LGWR post requested array 8
LGWR-network Server info 34048
LISTEN ADDRESS ENTRY 144
LISTEN ADDRESS TABLE 2048
LRMPD SGA Table 326480
Label Cache Heap descrptr 160
Log Archive Config Contex 1096
Log Archive Trace PID Lis 40
MS alert log 72704
MTTR advisory context 1648
Managed Standby Proc Arra 34816
MinActScn Array 320
Monitor Modification Hash 512
NETWORK BUFFER 65576
Nettimeout Histogram 151280
OS file lock 8632
OS proc request holder 13816
Online Datafile Move sess 2392
PARALLEL T RECO LATCH 6400
PARAMETER ENTRY 48
PARAMETER TABLE 2048
PG latch table 640
PICKLEERR 1128
PLDIA 2536016
PLMCD 3852552
PLS SGA hp 46240
PLS cca hp desc 352
PLS chunk 352
PMON blockers 6400
PQ/BizCard 1536
PQ/ResSched 1040
PRESENTATION ENTRY 72
PRESENTATION TABLE 2048
PROBLEM 1600
PRTDS 165968
PRTMV 166232
PX QC deq stats 1696
PX QC msg stats 2904
PX list of chunk lists 1088
PX msg pool struct 56
PX server deq stats 1696
PX server msg stats 2904
PX subheap 79656
PX subheap desc 256
Parameter Handle 3128
Parameter Table 69936
Policy Cache Heap descrpt 160
Pre-Warm Initialized Seti 128
Prefetch client count per 32
Prefetch history buffer 11328
Prefetch history buffer a 320
Processor group descripto 256
RTA Boundary Info thread 71808
RTA read control file ind 4224
RULEC 20696
RVWR post requested array 8
Read Only Database Accoun 160
Rec Ping Per Thread Info 21128
Result Cache: Bloom Fltr 2048
Result Cache: Cache Mgr 208
Result Cache: Memory Mgr 200
Result Cache: State Objs 2896
Role graph heap 160
Role related heap 160
SAGE commit cache Allocat 16
SAGE commit cache node Al 2048
SCHEDULING POLICY TABLE 64
SCHEDULING POLICY VECTOR 104
SEQ S.O. 57304
SERVICE NAME ENTRY 96
SERVICE NAMES TABLE 2048
SGA - AWR Metric RBSM str 992
SGA - SWRF DrvMet Runtime 6368
SGA - SWRF Metric CHBs 1000856
SGA - SWRF Metric Eidbuf 151440
SGA - SWRF Metrics WCTime 2064
SGA - SWRF Metrics ksuTim 2064
SGA - SWRF RawMet Runtime 4656
SGA - SWRF Time Model Bas 120
SGA Obsolete Param Source 24
SGA Param Source Table 368
SGA struct - SWRF Metrics 9120
SGA structure for ADR lay 8
SGA structure for AWR (KE 256
SGA structure for KPON kp 3192
SGA structure for KPON ks 400
SGA structure for KWQDL h 280
SGA structure for KWQDL s 24
SGA structure for kelr 2368
SGA structure for ktslgt 47200
SHARED SERVERS INFO 3672
SHRINK STAT 3000
SQL Memory Manager Base W 13400
SQL Workarea Histogram 1056
SQLA 16705016
SQLK 20240
SQLP 479232
SWEEPERR 944
SWRF Alerted 4160
SYSTEM PARAMETERS 550904
Saved job ids 8000
Security Class heap 136
Service-level ID trace se 4600
Service-level trace setti 536
Sort Segment 12288
Space Background Task Des 72000
State object pools 4608
State object subpools 6528
Storage for kcrr state ob 104
TBS STAT 16000
TXN TABLE SEGMENTED ARRAY 241736
Temporary Tables State Ob 80688
Temporary storage for RTA 72
Transportable DB Converte 4720
UNDO INFO 16
UNDO INFO HASH 8672
UNDO INFO SEGMENTED ARRAY 55272
UNDO STAT INFO 59904
Undo Meta Data 216
User dump directory 520
VIEW 1040
VIEWCOL 752
VIRTUAL CIRCUITS 852472
VM OSD context 96
Wait History Array 8
Wait History Segment 256880
Wait event pointers 384
X$KSFQP ANCHOR 80
X$KSVII table 512
X$KSVIS table 128
X$KSVIT table 512
active checkp 720
alert threshol 4056
alert_ext 3480
alter system errs: kspnfy 116736
ams_xaction 568
analytic workspace 2904
archive_lag_target 9632
array 1 for shared redo b 24
array 2 for shared redo b 24
bcast ack latency base ar 72
block iostats dynamic seg 9656
block media rcv state obj 2520
block_sizes_array 48
bloom filter 2776
branch 105880
branch so 360
broker globals 232
buffer handles 528008
buffer_pool_desc_array 3456
buffers waiting for write 24
call 72896
change notification obj m 16416
change notification regis 16416
change tracking recovery 262144
change tracking state cha 2584
channel context areas 87480
channel handle 66600
channel sga anchor 384
character set memory 59608
character set object 480256
cinfo_kfnsg 4104
client/application info l 160
constraints 79768
copy latch aux 16
cp cmon array 3632
cp connection 2704
cp pool array 2608
cp srv array 3024
cross-platform compliance 2232
database NCHAR language h 568
database creation languag 568
db_block_hash_buckets 2920448
db_files 456200
dbgdInitEventGrp: eventGr 216
dbgefgHtAddSK-1 482048
dbgefgHtInit-1 528
dbgefgHtInit-2 40
dbke_incid_cache_init 12000
dbkea msg body 51200
dbkea msgq 32
dbkea msgs 1200
dbkea sga 24
dbktb: sga ctx 48
dbktb: trace buffer 2457600
dbktb: trace pool 13200
dbwr actual working sets 16
dbwr message active flag 8
dbwr outstanding ios per 72
dbwr suspend/resume array 16
dbwr suspend/resume ptr a 16
dbwr working sets kcbdbws 16
dbwriter coalesce bitmap 256
dbwriter coalesce buffer 4198400
dbwriter coalesce struct 48
dev2node map 4096
dgtab_kfmdsg 25144
dia* process descriptor 16
diag descriptor 16
diag fixed SGA 136
diagv_incident 3296
dir_ext 1320
dirty object counts array 524288
dispatcher rate 1312
dispatcher service names 16
distributed_transactions- 23048
dlo fib struct 12832
done Q child latches 224
dpslut_kfdsg 512
dskm rac entity id 96
dsktab_kfgsg 58176
dummy 39744
enqueue 694792
enqueue resources 181456
enqueue_hash 25392
enqueue_hash_chain_latche 160
error message file name 64
event classes 1584
event descriptor table 65824
event list array to post 72
event list to post commit 72
event statistics per sess 3248544
event statistics ptr arra 1976
event-class map 5472
fencing reid 17976
file # to first dba, exte 2416
file # translation table 40064
file iostats dynamic seg 22936
file state object 1507392
fixed allocation callback 312
flashback_marker_cache_si 9200
free memory 41763688
generic process shared st 464
groups_kfgbsg 90624
grplut_kfgsg 512
grptab_kfgsg 3480
hash bucket array allocat 49152
heap_kfsg 208
hot latch diagnostics 160
incr ckpt write count arr 168
instance cnxn information 11856
invalid low rba queue 512
iosts_kfmdsg 3600
java static objs 34952
joxs heap 4192
joxs struct 160
jsksncb: 2 7840
jsksncb: 3 4000
jsksncb: 4 4032
jsksncb: 6 4176
jsksncb: 7 3840
jsksncb: 9 4976
kcbbl2df L2 disabling fla 8
kcbl seq io throughput 12000
kcbl state objects 25600
kcbl statistics 6144
kccsgehtt 360
kcfis state object 2392
kcrfa structures 9184
kcrrorlerr.alo 48
kdlwl_sga_subheap 232
kdlwss 22032
kdlxdup swapp 16
kdlxdup swappl 2400
kea advisor definition ca 480
kebm run-once actions 64
kebm slave descriptors 7680
kebm slave message 304
kebm slave reply 888
kebm test replies 30720
kelr other metrics table 48
kelr system metrics table 296
kelt translation table 360
keswx:plan en 2112
keswxNotify:tabPlans 1024
ket (AutoTask) SGA 832
kewr MMON Remote Flush Re 30720
kfasga 1048
kfdsga 144
kfgbsg 40
kfgsga 104
kfiosg 16
kfkhsh_kfdsg 4104
kfkid hash 4104
kfkid hrec 24
kfklsod list 15008
kfklsodtab 333928
kfkrec_kfdsg 24
kfmdsg 216
kfmsg 3608
kfnvsga 24
kga sga 8
kghx free lists 45024
kglsim Java per-gran bkt 26400
kglsim Java timestamps 131072
kglsim alloc latch area 2720
kglsim alloc latches 136
kglsim count of pinned he 12512
kglsim count of unpinned 12512
kglsim free heap list 408
kglsim free obj list 408
kglsim hash table 8208
kglsim hash table bkts 4194304
kglsim heap 297600
kglsim latch area 2720
kglsim latches 136
kglsim object batch 328440
kglsim per-gran bkt 26400
kglsim recovery area 1632
kglsim sga 576
kglsim size of pinned mem 24752
kglsim size of unpinned m 24752
kglsim timestamps 131072
kglsim used list arr 2720
kgnfs authp 16464
kgnfs ctab array 1240
kgnfs gid list 104
kgnfs htab array 2440
kgnfs stats array 18040
kgsk subheap descriptor 136
kjxgrrr SGA 56
kjxgrvr SGA 40
kkae edition name cache 408
kkj jobq wor 4128
kkj jobq slav 1280
kks sga 56
kkzias 144
kmgsb circular statistics 162304
knlsg 144
knlu_init_btree:init 96
knstoggall_knstsga 192
knstsg 56
kodosgi kodos 32
kodosgi kopfdo 416
koh dur heap 424
kohsg 16
kokcss 24
kolbsgi: KOLB's SGA initi 8
kolfsgi: KOLF's SGA initi 8
kponfy 912
kpscad: kpscscon 456
kpssnfy: kpsssgct 72
kpummst global in the SGA 2576
kqf runtime defined table 21120
kqlpWrntoStr:string 104
kramh message flag 16
krbabrAncp 96
krbfusg 40
krdrsb read violation arr 560000
krsv_notifier_cb 33760
krvxdka 872
krvxdta 1760
krvxlctx 248
krvxmctx 40
ksacm service obj array 768
ksacm service root 88
ksb action records 4272
ksb ci process list (each 880
ksb cic process list 912
ksb process so list 912
ksb rolling migration sta 96
ksbsa pointer array 2856
ksbtnfy: infrequent actio 2856
ksbxic obj 30080
ksbxic sga 40
kscdnfyglobalflags 8
kscdnfyinitflags 8
kscdnfyinithead 16
kscdnfyinitnext 40
kscdnfyinitprev 40
ksdhng: blkers cache 7904
ksdhng: blkrs cache 3952
ksdhng: cache ctx 208
ksdhng: cache history 320
ksdhng: cbuf 32768
ksdhng: cbufs 64
ksdhng: el wtr cache 43472
ksdhng: els blkrs cache 355680
ksdhng: fblkrs cache 11856
ksdhng: wtr cache 3952
ksfd I/O slave ctx 256
ksfd SGA state 96
ksfd shared pool recovery 24
ksfd: block i/o stats poi 3200
ksfd: components i/o stat 188160
ksfd: consumer group i/o 13824
ksfd: file i/o stats poin 3480
ksfdgfib recovery 16
ksfdss bitmap array 8704
ksfdsscloneinfo allocatio 3200
ksfm state object 88
ksfv instance 9984
ksfv subheap 16536
ksfv subheap descriptor 184
ksgm sga instance configu 8584
ksim cached group entry l 5632
ksim cached group entry s 128
ksim client list 168
ksir PrivOp State Object 2392
ksir State Object 3032
ksleid alloc 176
ksmd unit test 1 5296
kso req alloc 4056
kso req alloc heapds 280
kso: sched delay history 28896
kspd run-time context 24
kspload:comment 64
kss unit test 3928
kstm drifts table 1048
ksu: ksusg_emptypxsta 5488
ksu:ksunf_fre 4032
ksu:ksusg_emptyinfo 160
ksuloi: child latches for 160
ksuloi: garbage collectio 8
ksuloi: long op free list 16
ksuloi: long op statistic 181792
ksuloi: long op used list 16
ksunfy : SSO free list 3090464
ksunfy : array of SSO fre 176
ksunfy : array of session 1976
ksunfy: Reserved PSO Numa 8
ksunfy: in-use PSO Numa A 8
ksunfy: is parent statist 8232
ksunfy: nodes of hierarch 480
ksunfy: system-global sta 5488
ksv reaper 15096
ksv slave 15768
ksv slave class 197712
ksvr msg cache 2392
ksws service events 52608
ksws service object 3168
ksz parent 9656
ktcnc child latches 5888
ktcnqrow columns 4328
ktfa dynamic SGA allocati 632
ktg hash buckets 13576
ktgCircBuf:MinActScn Trc 40032
ktlbk state objects 292680
ktsj_init_sga proc desc 176
ktsj_init_sga task stat 24
ktud-usd hash table 264
kwqicaqe2kc1 11616
kwqmncal: allocate buffer 7968
kwqmncini-slv 18400
kwqmncini-stat 120
kwqmncini-tbl 4136
kwrsnfy: kwrs 1624
kxfpSO q freelists 368
kxfpSO qref freelists 368
kxfpdp pointers 28800
kxfpsga snapshots 4096
kzekm heap descriptor 304
kzsrs filename 536
kzxslnfy: 0 304
latch classes 352
latch hash-value table 2328
latch nowait fails or sle 181600
latch recovery alignment 80
latch recovery structures 3344
latch wait-event table 2328
latches for protecting fs 960
latches for protecting ls 480
latches for protecting ws 960
latchnum to latch map 4656
list 4096
listener addresses 8
locator state object 40680
lock state hash table 647680
log file size history arr 168
log_checkpoint_timeout 12360
log_simultaneous_copies 432
logout storm management 1200
max allowable # log files 506400
media recovery state obje 10480
memory transfer history 19208
message pool context area 22960
message pool freequeue 1353408
messages 36000
modification 145440
monitoring co 12480
msg Q child latches 224
multiblock re 16416
name-service entry 3544
name-service recovery 3032
name-service request 2392
name-service table 16144
namhsh_kfdsg 4104
namhsh_kfgsg 288
namrec_kfdsg 24
network connections 66640
obj hash table pointers 176
obj stats allocation chun 2703360
obj stats hash table 704
object level stat table 1056
object queue 87360
object queue hash buckets 147456
object queue hash table d 4032
os statistics 16472
osp allocation 24176
osp pool handles 8
parallel kcbibr 32
parallel kcbibr dbwr bitv 8
parallel_max_servers 5760
param hash values 11656
parameter blocks 23312
parameter handle 84456
parameter string values 209216
parameter table block 629424
parameter text value 8136
parameter value memory 824
pending bcast scn array 72
per_pg_set_descriptor_arr 14336
peshm.c: Global_Sub_Heap 232
peshm.c:Global 4056
peshm.c:latch 160
pesldT03_Instance 36920
pesom.c: Global_Sub_Heap 232
pesom.c: Pesom_Global_Hea 232
pesom.c:Global 37336
pesom.c:Object 4056
pesom.c:latch array 320
pesom.c:subheap ds array 184
plis struct 136
plugin datafile array 3616
plwppwp:PLW_STR_NEW_LEN_V 16
plwppwp:PLW_STR_NEW_VAL_V 32
plwppwp:garbage handle 32
plwspv:PLW_STR_NEW_VAL 16
poisoned memory 32768
policy hash table descrpt 280
post stats 1560
post/wait queues 38016
primem_kfmdsg 1032
prirec_kfmdsg 24
private strands 3677184
prmtzdini tz region 801416
process count for each CI 456
process group array 69904
processes 1200
procs: ksunfy 642000
procs_kfgbsg 4048
property service SO 4312
pso child tracebuf ptrs 1200
pso tbs: ksunfy 78000
pspool_kfsg 80
ptr to sessions under idl 8
qesbl old rows 1120
qesmmaInitialize: 112
qesmmaInitialize: ia_qesm 264
qesmmaInitialize: oa_qesm 112
qesmmaInitialize: pa_qesm 11088
qesmmaInitialize: ta_qesm 264
qksbgsg 152
qm_init_sga:qmdpsg 1064
qmn tasks 4160
qmps connections 65280
qmtb_init_data 1728
qtree_kwqbsgn 48
qtree_kwqbspse 48
qtree_kwqspqctx 48
quiesce system context 440
quiescing session 3928
recov_kgqbtctx 7320
redo allocation latch(es) 4480
relmd_ext 1224
replication session stats 1976
reservation state object 3056
reserved entries for all 5760
resize operation history 28808
resize request state obje 491200
resumable 3672
row cache 8641136
row cache child latch 8320
rules engine aggregate st 1416
rules engine context 200
sched job queue 5752
sched job slv 14008
segmented arrays 16968
service names array 16
sess Q child latches 224
session idle latches 160
set_descriptor_array 64
sga blobs 32768
sga dev dict 56
sga listelement 2048
sga node map 16
sht bkt arr allo 11264
sim cache nbufs 640
sim cache sizes 640
sim kghx free lists 8
sim lru segments 1280
sim segment hits 1280
sim segment num bufs 640
sim state object 96
sim trace buf 5144
sim trace buf context 200
sim_knlasg 1280
simulator hash buckets 131328
simulator latch/bucket st 7424
skgxp ANT slave netstat m 4184
slave class sga anchor 360
sort segment handle 2640
spfile cleanup structure 16760
sskgpwcr: Sem set array 8
standby event stats 1216
starting comp sizes snaps 144
stat hash values 2720
state objects 10520
statement queuing 2904
sys event stats 656160
sys event stats for Other 43744
system default language h 568
tablespace encryption key 192
tablespace encryption mas 16
temp lob duration state o 3928
temporary foreign ref 3800
temporary table lock 2840
threshold ale 4032
time manager context 40
trace buf hdr xtend 208
trace buffer header array 208
trace events array 72000
trace_knlasg 504
transaction 685784
ts encryption key afn rev 3208
txncallback 74536
ufgtab_kfmdsg 25144
v_actinc 752
v_actprob 664
v_inc_meter_info_problem 664
v_inccount 664
v_incfcount 664
v_ipsprbcnt 664
v_ipsprbcnt1 664
v_nfcinc 848
v_swperrcount 664
vem_user_actlog 664
vem_user_actlog1 664
vhm_run 2072
vinc_meter_info 1696
vincident 3296
vincident_file 1040
vips_file_copy_log 1696
vips_file_metadata 944
vips_package_file 1320
vips_package_history 1416
vips_package_incident_det 4992
vips_package_main_int 664
vips_package_main_problem 752
vips_package_size 664
vips_pkg_file 1600
vips_pkg_incident_candida 3296
vnot_exist_incident 3200
vproblem 2728
vproblem1 2544
vproblem2 2632
vproblem_bucket 848
vproblem_bucket1 848
vproblem_bucket_count 944
vproblem_int 2448
vproblem_lastinc 2352
vshowcatview 848
vshowincb 752
vshowincb_i 752
vtest_exists 1040
where to latch num map 11352
work area tab 220864
write info array 65536
write state object 2704176
writes stopped lock conte 32
writes stopped lock state 24
x$ksmfs table 32
x$rule_set 17608
xscalc 4056
xslongops 14776
xssinfo 6008
zafwctx 40608
zasasga 8
************ ----------
sum 184549376
buffer_cache 503316480
fixed_sga 2252824
log_buffer 8892416
************ ----------
sum 514461720
903 rows selected.
https://www.toadworld.com/platforms/oracle/w/wiki/611.system-global-area-sga-overview
==================================================================
SQL> startup
ORACLE instance started.
Total System Global Area 1252663296 bytes (<-- total size loaded into memory)
Fixed Size 2252824 bytes (<-- release specific; varies; out of your control)
Variable Size 788533224 bytes (<-- control structures for the SGA itself)
Database Buffers 452984832 bytes (<-- 'db_block_buffers')
Redo Buffers 8892416 bytes (<-- 'log_buffers' or the default minimum for your platform)
Database mounted.
Database opened.
SQL>
Fixed SGA
======================
The fixed SGA is a component of the SGA that varies in size from platform to platform and release to release. The size of the fixed portion is constant for a release and a platform of Oracle, that is, it cannot be changed through any means such as altering the initialization parameters The fixed size component is out of your control. It varies from release to release and platform to platform. Thus It contains a collection of objects that point to other areas inside the rest of the SGA. this area as a bootstrap section of the SGA, something Oracle uses internally to find the other bits and pieces of the SGA
Redo Buffers
=============================
Redo log buffer Redo Buffers is roughly equal to the parameter log_buffer.
Database Buffers
============================
Database buffer cache It’s size is equal to db_block_size * db_block_buffers.
(Note: db_block_buffers is deprecated as of 9i, so if the init parameter db_cache_size) is set, the buffer cache’s size will be set according to this value.
Variable portion
=====================
The variable portion is called variable because its size (measured in bytes) can be changed.For consideration of the variable size, it is useful to look at v$sgastat.The variable size is most affected by java_pool_size + large_pool_size + shared_pool_size but other parameters will contribute to it (eg: every control_file will consume 256 bytes of variable size memory
compute sum of bytes on pool
break on pool skip 1
set pagesize 9999
set pause on
SQL> select pool, name, bytes from v$sgastat order by pool, name;
POOL NAME BYTES
------------ -------------------------- ----------
java pool free memory 16777216
************ ----------
sum 16777216
large pool PX msg pool 491520
free memory 33062912
************ ----------
sum 33554432
shared pool 1:kngisga 32152
ADR_CONTROL 1504
ADR_INVALIDATION 664
AQ Propagation Scheduling 16000
ASH buffers 2097152
ASM KFFD SO 2648
ASM generic network state 2584
ASM kfk state object 2776
ASM map operations 2904
ASM rollback operations 2648
ASM scan context 3544
AW SGA 40
AWR Table Info (KEW layer 1216
Active Session History - 1528
Alert log 520
ArchLog Dest Array 22784
Array of cached attr 400
Auto tune undo info 96
BRANCH TABLE SEGMENTED AR 220296
Background process state 48
Banner Storage 2048
CGS system incarn array 24864
Checkpoint queue 205312
Cleanup state objects 1760
Client ID trace setting h 536
Client ID trace settings 3928
Closed Thread SCN Bitvec 33792
Core dump directory 520
DBWR array of pointers to 8
DBWR event stats array 216
DDE_USER_ACTION 1128
DDE_USER_ACTION_DEF 1320
DDE_USER_ACTION_PARAMETER 2080
DDE_USER_INCIDENT_ACTION_ 664
DDE_USER_INCIDENT_TYPE 664
DFW_CONFIG_CAPTURE 752
DFW_CONFIG_ITEM 944
DISPATCHER CONFIG ENTRY 88
DISPATCHER CONFIG TABLE 2048
DISPATCHERS INFO 2496
DML lock 410784
Detached dump directory 520
EM_DIAG_JOB 1320
EM_TARGET_INFO 1224
EM_USER_ACTIVITY 1224
ENQUEUE STATS 23040
ENQUQUE FREELISTS 168
FAL req blks 744
FAST SPACEUSAGE 312328
File Space Usage 11344
FileIdentificatonBlock 760896
FileOpenBlock 1972416
Global Context Heap descr 400
HM_FDG_SET 848
HM_FINDING 2632
HM_INFO 944
HM_MESSAGE 1416
HM_RECOMMENDATION 2072
HM_RUN 1976
HTTP fixed headers 72
I/O stat latches 4960
INCCKEY 848
INCIDENT 3008
INCIDENT_FILE 848
INC_METER_CONFIG 1224
INC_METER_IMPT_DEF 1040
INC_METER_INFO 1320
INC_METER_PK_IMPTS 1040
INC_METER_SUMMARY 1416
IO_SHARES_KGSKCAP 8
IPS_CONFIGURATION 1320
IPS_FILE_COPY_LOG 1040
IPS_FILE_METADATA 944
IPS_PACKAGE 1880
IPS_PACKAGE_FILE 848
IPS_PACKAGE_HISTORY 1320
IPS_PACKAGE_INCIDENT 944
IPS_PACKAGE_UNPACK_HISTOR 1040
IPS_PROGRESS_LOG 1320
IPS_REMOTE_PACKAGE 944
JSX SGA 3776
KCB Table Scan 40
KCB Table Scan Bitmap 256
KCB Table Scan Buffer 4198400
KCB buffer wait statistic 3352
KCB incremental ckpt entr 720
KCB tablespace encryption 1064
KCB undo bitvec 4096
KCB where statistics arra 37440
KCFIS SGA 8
KESTB existence bitvec 262144
KESTB existence bitvec se 2048
KEWS External IDs 1536
KEWS aggregation objs 4032
KEWS fixed SGA 5704
KEWS sesstat seg tbl 8
KEWS sesstat values 160056
KEWS statistic maps 3216
KEWS statistic metadata 16864
KEWS statistic name 2288
KEWS sysstat values 256
KFD extent enqueue obj 42816
KFG SO child 8440
KFG state obj 7032
KFK SGA 4224
KFK idtab_kfksga 64832
KFM state obj 2904
KGI Session State 1080
KGKP randnum 40000
KGKP randnum shadow 40000
KGKP sga 48
KGLA 387112
KGLDA 661056
KGLH0 14281776
KGLHD 3297912
KGLNA 6032
KGLS 7288000
KGLSG 5267216
KGNFS scontext 524480
KGSK scheduler 63328
KGSK sga 8240
KGSKI schedule 41384
KGSKI scheduler heap 1 de 232
KGSKI scheduler heap 2 de 232
KGSKI sga 72
KGX 133224
KGX rowlist 6624
KKBTD 16576
KKJ SGA 720
KKJ SHRD WRQS 240
KKJ WRK LAT 480
KKKI consumer 4056
KKSSP 1159840
KKTDF 7744
KKTIN 12800
KKTSR 17704
KOKTD 289560
KQF optimizer stats table 1904
KQF runtime defined table 8928
KQFUTTAB COLS 472
KQR L PO 1350760
KQR L SO 68608
KQR M PO 1842728
KQR M SO 379904
KQR S SO 3072
KRBMROS ANCHOR 96
KRSF SGA 40
KSFD Cache Hints for IO R 72
KSFD SGA I/O b 4190328
KSFQ buffer pool 3032
KSFV SGA 832
KSI ENQUEUES 11760
KSI Indexes 288
KSI resource types 16224
KSIR SGA 144
KSK OSS PLAN 3360
KSK SGA 168016
KSK VT POOL 353600
KSKQ SGA 14200
KSKQ SGA NODEINFO 1359872
KSN WaitID 1560
KSPD key heap 4056
KSQ event description 9208
KSRPC I/O Stat array 144
KSRPC I/O Stat array ptr 16
KSTM SGA 24
KSVR SGA 2384
KSXP test table columns d 1320
KSZ sga subheap descripto 136
KTA latches 2024
KTC latch cleanup 480
KTC latch subh 54608
KTC latches 1760
KTC txn rsrc cnt 88
KTC variable sga 24
KTCN global clauses ht 128
KTCN global operands ht 128
KTCN global operators 64
KTCN queries hash table 128
KTCN: Hash Table Segmente 5240
KTCN: Obj Invalidation Se 24632
KTCN: Row Change Segmente 34552
KTCN: query inv Segmented 3928
KTCNC inv hashtable 128
KTCNQROW colname ptrs 344
KTCNQROW colnames 1296
KTCTSNL freelists 88
KTCTSNL subheaps 1496
KTF MAPPINGS 12288
KTI freelists 88
KTI latch structure 4320
KTI latches 864
KTI pool states 32
KTI-UNDO 1901880
KTPR HIST TB 2808
KTPR SUBHEAP 168
KTRSGA 8
KTSJ subheap 4056
KTSL lat struct 40960
KTSL reco struct 24576
KTU SGA 32
KTU avail cache 4032
KTU lat struct 160
KTU latch cleanup 208
KTU latches 120
KTUR HIST INFO 4840
KUPP subheap desc 232
KWQDL SGA Ddtc gen cleanu 48
KWQDL SGA Dtc gen cleanup 48
KWQDL child latches 2880
KXFR Hash Array latches a 2944
KXFR Psuedo Hash Array fo 3072
KYWM CROSS INSTANCE 384
KYWM RPLY CROSS INSTANCE 53248
KYWM SGA 296
L2 enabled array 16
L2 file global fob 72
L2 file map array 4896
LGWR debug module memory 8192
LGWR post requested array 8
LGWR-network Server info 34048
LISTEN ADDRESS ENTRY 144
LISTEN ADDRESS TABLE 2048
LRMPD SGA Table 326480
Label Cache Heap descrptr 160
Log Archive Config Contex 1096
Log Archive Trace PID Lis 40
MS alert log 72704
MTTR advisory context 1648
Managed Standby Proc Arra 34816
MinActScn Array 320
Monitor Modification Hash 512
NETWORK BUFFER 65576
Nettimeout Histogram 151280
OS file lock 8632
OS proc request holder 13816
Online Datafile Move sess 2392
PARALLEL T RECO LATCH 6400
PARAMETER ENTRY 48
PARAMETER TABLE 2048
PG latch table 640
PICKLEERR 1128
PLDIA 2536016
PLMCD 3852552
PLS SGA hp 46240
PLS cca hp desc 352
PLS chunk 352
PMON blockers 6400
PQ/BizCard 1536
PQ/ResSched 1040
PRESENTATION ENTRY 72
PRESENTATION TABLE 2048
PROBLEM 1600
PRTDS 165968
PRTMV 166232
PX QC deq stats 1696
PX QC msg stats 2904
PX list of chunk lists 1088
PX msg pool struct 56
PX server deq stats 1696
PX server msg stats 2904
PX subheap 79656
PX subheap desc 256
Parameter Handle 3128
Parameter Table 69936
Policy Cache Heap descrpt 160
Pre-Warm Initialized Seti 128
Prefetch client count per 32
Prefetch history buffer 11328
Prefetch history buffer a 320
Processor group descripto 256
RTA Boundary Info thread 71808
RTA read control file ind 4224
RULEC 20696
RVWR post requested array 8
Read Only Database Accoun 160
Rec Ping Per Thread Info 21128
Result Cache: Bloom Fltr 2048
Result Cache: Cache Mgr 208
Result Cache: Memory Mgr 200
Result Cache: State Objs 2896
Role graph heap 160
Role related heap 160
SAGE commit cache Allocat 16
SAGE commit cache node Al 2048
SCHEDULING POLICY TABLE 64
SCHEDULING POLICY VECTOR 104
SEQ S.O. 57304
SERVICE NAME ENTRY 96
SERVICE NAMES TABLE 2048
SGA - AWR Metric RBSM str 992
SGA - SWRF DrvMet Runtime 6368
SGA - SWRF Metric CHBs 1000856
SGA - SWRF Metric Eidbuf 151440
SGA - SWRF Metrics WCTime 2064
SGA - SWRF Metrics ksuTim 2064
SGA - SWRF RawMet Runtime 4656
SGA - SWRF Time Model Bas 120
SGA Obsolete Param Source 24
SGA Param Source Table 368
SGA struct - SWRF Metrics 9120
SGA structure for ADR lay 8
SGA structure for AWR (KE 256
SGA structure for KPON kp 3192
SGA structure for KPON ks 400
SGA structure for KWQDL h 280
SGA structure for KWQDL s 24
SGA structure for kelr 2368
SGA structure for ktslgt 47200
SHARED SERVERS INFO 3672
SHRINK STAT 3000
SQL Memory Manager Base W 13400
SQL Workarea Histogram 1056
SQLA 16705016
SQLK 20240
SQLP 479232
SWEEPERR 944
SWRF Alerted 4160
SYSTEM PARAMETERS 550904
Saved job ids 8000
Security Class heap 136
Service-level ID trace se 4600
Service-level trace setti 536
Sort Segment 12288
Space Background Task Des 72000
State object pools 4608
State object subpools 6528
Storage for kcrr state ob 104
TBS STAT 16000
TXN TABLE SEGMENTED ARRAY 241736
Temporary Tables State Ob 80688
Temporary storage for RTA 72
Transportable DB Converte 4720
UNDO INFO 16
UNDO INFO HASH 8672
UNDO INFO SEGMENTED ARRAY 55272
UNDO STAT INFO 59904
Undo Meta Data 216
User dump directory 520
VIEW 1040
VIEWCOL 752
VIRTUAL CIRCUITS 852472
VM OSD context 96
Wait History Array 8
Wait History Segment 256880
Wait event pointers 384
X$KSFQP ANCHOR 80
X$KSVII table 512
X$KSVIS table 128
X$KSVIT table 512
active checkp 720
alert threshol 4056
alert_ext 3480
alter system errs: kspnfy 116736
ams_xaction 568
analytic workspace 2904
archive_lag_target 9632
array 1 for shared redo b 24
array 2 for shared redo b 24
bcast ack latency base ar 72
block iostats dynamic seg 9656
block media rcv state obj 2520
block_sizes_array 48
bloom filter 2776
branch 105880
branch so 360
broker globals 232
buffer handles 528008
buffer_pool_desc_array 3456
buffers waiting for write 24
call 72896
change notification obj m 16416
change notification regis 16416
change tracking recovery 262144
change tracking state cha 2584
channel context areas 87480
channel handle 66600
channel sga anchor 384
character set memory 59608
character set object 480256
cinfo_kfnsg 4104
client/application info l 160
constraints 79768
copy latch aux 16
cp cmon array 3632
cp connection 2704
cp pool array 2608
cp srv array 3024
cross-platform compliance 2232
database NCHAR language h 568
database creation languag 568
db_block_hash_buckets 2920448
db_files 456200
dbgdInitEventGrp: eventGr 216
dbgefgHtAddSK-1 482048
dbgefgHtInit-1 528
dbgefgHtInit-2 40
dbke_incid_cache_init 12000
dbkea msg body 51200
dbkea msgq 32
dbkea msgs 1200
dbkea sga 24
dbktb: sga ctx 48
dbktb: trace buffer 2457600
dbktb: trace pool 13200
dbwr actual working sets 16
dbwr message active flag 8
dbwr outstanding ios per 72
dbwr suspend/resume array 16
dbwr suspend/resume ptr a 16
dbwr working sets kcbdbws 16
dbwriter coalesce bitmap 256
dbwriter coalesce buffer 4198400
dbwriter coalesce struct 48
dev2node map 4096
dgtab_kfmdsg 25144
dia* process descriptor 16
diag descriptor 16
diag fixed SGA 136
diagv_incident 3296
dir_ext 1320
dirty object counts array 524288
dispatcher rate 1312
dispatcher service names 16
distributed_transactions- 23048
dlo fib struct 12832
done Q child latches 224
dpslut_kfdsg 512
dskm rac entity id 96
dsktab_kfgsg 58176
dummy 39744
enqueue 694792
enqueue resources 181456
enqueue_hash 25392
enqueue_hash_chain_latche 160
error message file name 64
event classes 1584
event descriptor table 65824
event list array to post 72
event list to post commit 72
event statistics per sess 3248544
event statistics ptr arra 1976
event-class map 5472
fencing reid 17976
file # to first dba, exte 2416
file # translation table 40064
file iostats dynamic seg 22936
file state object 1507392
fixed allocation callback 312
flashback_marker_cache_si 9200
free memory 41763688
generic process shared st 464
groups_kfgbsg 90624
grplut_kfgsg 512
grptab_kfgsg 3480
hash bucket array allocat 49152
heap_kfsg 208
hot latch diagnostics 160
incr ckpt write count arr 168
instance cnxn information 11856
invalid low rba queue 512
iosts_kfmdsg 3600
java static objs 34952
joxs heap 4192
joxs struct 160
jsksncb: 2 7840
jsksncb: 3 4000
jsksncb: 4 4032
jsksncb: 6 4176
jsksncb: 7 3840
jsksncb: 9 4976
kcbbl2df L2 disabling fla 8
kcbl seq io throughput 12000
kcbl state objects 25600
kcbl statistics 6144
kccsgehtt 360
kcfis state object 2392
kcrfa structures 9184
kcrrorlerr.alo 48
kdlwl_sga_subheap 232
kdlwss 22032
kdlxdup swapp 16
kdlxdup swappl 2400
kea advisor definition ca 480
kebm run-once actions 64
kebm slave descriptors 7680
kebm slave message 304
kebm slave reply 888
kebm test replies 30720
kelr other metrics table 48
kelr system metrics table 296
kelt translation table 360
keswx:plan en 2112
keswxNotify:tabPlans 1024
ket (AutoTask) SGA 832
kewr MMON Remote Flush Re 30720
kfasga 1048
kfdsga 144
kfgbsg 40
kfgsga 104
kfiosg 16
kfkhsh_kfdsg 4104
kfkid hash 4104
kfkid hrec 24
kfklsod list 15008
kfklsodtab 333928
kfkrec_kfdsg 24
kfmdsg 216
kfmsg 3608
kfnvsga 24
kga sga 8
kghx free lists 45024
kglsim Java per-gran bkt 26400
kglsim Java timestamps 131072
kglsim alloc latch area 2720
kglsim alloc latches 136
kglsim count of pinned he 12512
kglsim count of unpinned 12512
kglsim free heap list 408
kglsim free obj list 408
kglsim hash table 8208
kglsim hash table bkts 4194304
kglsim heap 297600
kglsim latch area 2720
kglsim latches 136
kglsim object batch 328440
kglsim per-gran bkt 26400
kglsim recovery area 1632
kglsim sga 576
kglsim size of pinned mem 24752
kglsim size of unpinned m 24752
kglsim timestamps 131072
kglsim used list arr 2720
kgnfs authp 16464
kgnfs ctab array 1240
kgnfs gid list 104
kgnfs htab array 2440
kgnfs stats array 18040
kgsk subheap descriptor 136
kjxgrrr SGA 56
kjxgrvr SGA 40
kkae edition name cache 408
kkj jobq wor 4128
kkj jobq slav 1280
kks sga 56
kkzias 144
kmgsb circular statistics 162304
knlsg 144
knlu_init_btree:init 96
knstoggall_knstsga 192
knstsg 56
kodosgi kodos 32
kodosgi kopfdo 416
koh dur heap 424
kohsg 16
kokcss 24
kolbsgi: KOLB's SGA initi 8
kolfsgi: KOLF's SGA initi 8
kponfy 912
kpscad: kpscscon 456
kpssnfy: kpsssgct 72
kpummst global in the SGA 2576
kqf runtime defined table 21120
kqlpWrntoStr:string 104
kramh message flag 16
krbabrAncp 96
krbfusg 40
krdrsb read violation arr 560000
krsv_notifier_cb 33760
krvxdka 872
krvxdta 1760
krvxlctx 248
krvxmctx 40
ksacm service obj array 768
ksacm service root 88
ksb action records 4272
ksb ci process list (each 880
ksb cic process list 912
ksb process so list 912
ksb rolling migration sta 96
ksbsa pointer array 2856
ksbtnfy: infrequent actio 2856
ksbxic obj 30080
ksbxic sga 40
kscdnfyglobalflags 8
kscdnfyinitflags 8
kscdnfyinithead 16
kscdnfyinitnext 40
kscdnfyinitprev 40
ksdhng: blkers cache 7904
ksdhng: blkrs cache 3952
ksdhng: cache ctx 208
ksdhng: cache history 320
ksdhng: cbuf 32768
ksdhng: cbufs 64
ksdhng: el wtr cache 43472
ksdhng: els blkrs cache 355680
ksdhng: fblkrs cache 11856
ksdhng: wtr cache 3952
ksfd I/O slave ctx 256
ksfd SGA state 96
ksfd shared pool recovery 24
ksfd: block i/o stats poi 3200
ksfd: components i/o stat 188160
ksfd: consumer group i/o 13824
ksfd: file i/o stats poin 3480
ksfdgfib recovery 16
ksfdss bitmap array 8704
ksfdsscloneinfo allocatio 3200
ksfm state object 88
ksfv instance 9984
ksfv subheap 16536
ksfv subheap descriptor 184
ksgm sga instance configu 8584
ksim cached group entry l 5632
ksim cached group entry s 128
ksim client list 168
ksir PrivOp State Object 2392
ksir State Object 3032
ksleid alloc 176
ksmd unit test 1 5296
kso req alloc 4056
kso req alloc heapds 280
kso: sched delay history 28896
kspd run-time context 24
kspload:comment 64
kss unit test 3928
kstm drifts table 1048
ksu: ksusg_emptypxsta 5488
ksu:ksunf_fre 4032
ksu:ksusg_emptyinfo 160
ksuloi: child latches for 160
ksuloi: garbage collectio 8
ksuloi: long op free list 16
ksuloi: long op statistic 181792
ksuloi: long op used list 16
ksunfy : SSO free list 3090464
ksunfy : array of SSO fre 176
ksunfy : array of session 1976
ksunfy: Reserved PSO Numa 8
ksunfy: in-use PSO Numa A 8
ksunfy: is parent statist 8232
ksunfy: nodes of hierarch 480
ksunfy: system-global sta 5488
ksv reaper 15096
ksv slave 15768
ksv slave class 197712
ksvr msg cache 2392
ksws service events 52608
ksws service object 3168
ksz parent 9656
ktcnc child latches 5888
ktcnqrow columns 4328
ktfa dynamic SGA allocati 632
ktg hash buckets 13576
ktgCircBuf:MinActScn Trc 40032
ktlbk state objects 292680
ktsj_init_sga proc desc 176
ktsj_init_sga task stat 24
ktud-usd hash table 264
kwqicaqe2kc1 11616
kwqmncal: allocate buffer 7968
kwqmncini-slv 18400
kwqmncini-stat 120
kwqmncini-tbl 4136
kwrsnfy: kwrs 1624
kxfpSO q freelists 368
kxfpSO qref freelists 368
kxfpdp pointers 28800
kxfpsga snapshots 4096
kzekm heap descriptor 304
kzsrs filename 536
kzxslnfy: 0 304
latch classes 352
latch hash-value table 2328
latch nowait fails or sle 181600
latch recovery alignment 80
latch recovery structures 3344
latch wait-event table 2328
latches for protecting fs 960
latches for protecting ls 480
latches for protecting ws 960
latchnum to latch map 4656
list 4096
listener addresses 8
locator state object 40680
lock state hash table 647680
log file size history arr 168
log_checkpoint_timeout 12360
log_simultaneous_copies 432
logout storm management 1200
max allowable # log files 506400
media recovery state obje 10480
memory transfer history 19208
message pool context area 22960
message pool freequeue 1353408
messages 36000
modification 145440
monitoring co 12480
msg Q child latches 224
multiblock re 16416
name-service entry 3544
name-service recovery 3032
name-service request 2392
name-service table 16144
namhsh_kfdsg 4104
namhsh_kfgsg 288
namrec_kfdsg 24
network connections 66640
obj hash table pointers 176
obj stats allocation chun 2703360
obj stats hash table 704
object level stat table 1056
object queue 87360
object queue hash buckets 147456
object queue hash table d 4032
os statistics 16472
osp allocation 24176
osp pool handles 8
parallel kcbibr 32
parallel kcbibr dbwr bitv 8
parallel_max_servers 5760
param hash values 11656
parameter blocks 23312
parameter handle 84456
parameter string values 209216
parameter table block 629424
parameter text value 8136
parameter value memory 824
pending bcast scn array 72
per_pg_set_descriptor_arr 14336
peshm.c: Global_Sub_Heap 232
peshm.c:Global 4056
peshm.c:latch 160
pesldT03_Instance 36920
pesom.c: Global_Sub_Heap 232
pesom.c: Pesom_Global_Hea 232
pesom.c:Global 37336
pesom.c:Object 4056
pesom.c:latch array 320
pesom.c:subheap ds array 184
plis struct 136
plugin datafile array 3616
plwppwp:PLW_STR_NEW_LEN_V 16
plwppwp:PLW_STR_NEW_VAL_V 32
plwppwp:garbage handle 32
plwspv:PLW_STR_NEW_VAL 16
poisoned memory 32768
policy hash table descrpt 280
post stats 1560
post/wait queues 38016
primem_kfmdsg 1032
prirec_kfmdsg 24
private strands 3677184
prmtzdini tz region 801416
process count for each CI 456
process group array 69904
processes 1200
procs: ksunfy 642000
procs_kfgbsg 4048
property service SO 4312
pso child tracebuf ptrs 1200
pso tbs: ksunfy 78000
pspool_kfsg 80
ptr to sessions under idl 8
qesbl old rows 1120
qesmmaInitialize: 112
qesmmaInitialize: ia_qesm 264
qesmmaInitialize: oa_qesm 112
qesmmaInitialize: pa_qesm 11088
qesmmaInitialize: ta_qesm 264
qksbgsg 152
qm_init_sga:qmdpsg 1064
qmn tasks 4160
qmps connections 65280
qmtb_init_data 1728
qtree_kwqbsgn 48
qtree_kwqbspse 48
qtree_kwqspqctx 48
quiesce system context 440
quiescing session 3928
recov_kgqbtctx 7320
redo allocation latch(es) 4480
relmd_ext 1224
replication session stats 1976
reservation state object 3056
reserved entries for all 5760
resize operation history 28808
resize request state obje 491200
resumable 3672
row cache 8641136
row cache child latch 8320
rules engine aggregate st 1416
rules engine context 200
sched job queue 5752
sched job slv 14008
segmented arrays 16968
service names array 16
sess Q child latches 224
session idle latches 160
set_descriptor_array 64
sga blobs 32768
sga dev dict 56
sga listelement 2048
sga node map 16
sht bkt arr allo 11264
sim cache nbufs 640
sim cache sizes 640
sim kghx free lists 8
sim lru segments 1280
sim segment hits 1280
sim segment num bufs 640
sim state object 96
sim trace buf 5144
sim trace buf context 200
sim_knlasg 1280
simulator hash buckets 131328
simulator latch/bucket st 7424
skgxp ANT slave netstat m 4184
slave class sga anchor 360
sort segment handle 2640
spfile cleanup structure 16760
sskgpwcr: Sem set array 8
standby event stats 1216
starting comp sizes snaps 144
stat hash values 2720
state objects 10520
statement queuing 2904
sys event stats 656160
sys event stats for Other 43744
system default language h 568
tablespace encryption key 192
tablespace encryption mas 16
temp lob duration state o 3928
temporary foreign ref 3800
temporary table lock 2840
threshold ale 4032
time manager context 40
trace buf hdr xtend 208
trace buffer header array 208
trace events array 72000
trace_knlasg 504
transaction 685784
ts encryption key afn rev 3208
txncallback 74536
ufgtab_kfmdsg 25144
v_actinc 752
v_actprob 664
v_inc_meter_info_problem 664
v_inccount 664
v_incfcount 664
v_ipsprbcnt 664
v_ipsprbcnt1 664
v_nfcinc 848
v_swperrcount 664
vem_user_actlog 664
vem_user_actlog1 664
vhm_run 2072
vinc_meter_info 1696
vincident 3296
vincident_file 1040
vips_file_copy_log 1696
vips_file_metadata 944
vips_package_file 1320
vips_package_history 1416
vips_package_incident_det 4992
vips_package_main_int 664
vips_package_main_problem 752
vips_package_size 664
vips_pkg_file 1600
vips_pkg_incident_candida 3296
vnot_exist_incident 3200
vproblem 2728
vproblem1 2544
vproblem2 2632
vproblem_bucket 848
vproblem_bucket1 848
vproblem_bucket_count 944
vproblem_int 2448
vproblem_lastinc 2352
vshowcatview 848
vshowincb 752
vshowincb_i 752
vtest_exists 1040
where to latch num map 11352
work area tab 220864
write info array 65536
write state object 2704176
writes stopped lock conte 32
writes stopped lock state 24
x$ksmfs table 32
x$rule_set 17608
xscalc 4056
xslongops 14776
xssinfo 6008
zafwctx 40608
zasasga 8
************ ----------
sum 184549376
buffer_cache 503316480
fixed_sga 2252824
log_buffer 8892416
************ ----------
sum 514461720
903 rows selected.
https://www.toadworld.com/platforms/oracle/w/wiki/611.system-global-area-sga-overview
online donation india
ReplyDeletePlan india is a child rights organisation providing children, especially girls, with access to education, healthcare, protection and livelihood opportunities. • Plan India is a child rights organization providing children, especially girls, with access to education, healthcare, protection and livelihood opportunities