Oracle DatabaseのSGA内の各コンポーネントに割り当てられているサイズを確認するための動的パフォーマンスビューを紹介します。
V$SGA
V$SGA はSGA内の各コンポーネントのサマリサイズを表示します。
SQL> select * from v$sga;
NAME VALUE CON_ID
-------------------- ---------- ----------
Fixed Size 9139032 0
Variable Size 511705088 0
Database Buffers 201326592 0
Redo Buffers 3440640 0
V$SGAINFO
V$SGAINFO は各コンポーネントのサイズや、SGAの空きサイズを表示します。
SQL> select * from v$sgainfo;
NAME BYTES RES CON_ID
-------------------------------- ---------- --- ----------
Fixed SGA Size 9139032 No 0
Redo Buffers 3440640 No 0
Buffer Cache Size 201326592 Yes 0
In-Memory Area Size 0 No 0
Shared Pool Size 209715200 Yes 0
Large Pool Size 4194304 Yes 0
Java Pool Size 4194304 Yes 0
Streams Pool Size 0 Yes 0
Shared IO Pool Size 16777216 Yes 0
Data Transfer Cache Size 0 Yes 0
Granule Size 4194304 No 0
Maximum SGA Size 725611352 No 0
Startup overhead in Shared Pool 171436720 No 0
Free SGA Memory Available 293601280 0
V$SGASTAT
V$SGASTAT はSGA内の各コンポーネントをさらに詳細に表示してくれます。
SQL> select * from v$sgastat;
POOL NAME BYTES CON_ID
-------------- -------------------------- ---------- ----------
fixed_sga 9139032 0
buffer_cache 184549376 0
log_buffer 3440640 0
shared_io_pool 16777216 0
shared pool free memory 4607008 0
shared pool ksbxic target obj 2608 1
shared pool object temp hash buckets 262144 1
shared pool archive_lag_target 9632 1
shared pool ktgCircBuf:MinActScn Trc 40032 1
shared pool KTMPJ Priv latches 1760 1
shared pool KGLH0 5402232 1
shared pool object temp hash table la 188416 1
shared pool PDBHP 806840 2
shared pool ASM kfk state object 3760 1
shared pool ksfdsscloneinfo allocatio 3200 1
shared pool KCBFLC SGA 24 1
shared pool MGA service 101224 1
shared pool AQ skiplist state object 13216 1
shared pool kkcnesg info 440 1
shared pool SGA Param Source Table 680 1
shared pool SWRF Metric Instance SGA 88 1
shared pool KTTE File Cache 2184 1
shared pool stat hash values 8144 1
shared pool mga fixvar size 48 1
shared pool INCCKEY 2112 1
shared pool Memory for TopN Table Des 16 1
shared pool PDB exp set list 680 2
shared pool KGLDA 19848 2
shared pool LISTEN ADDRESS TABLE 2048 1
shared pool KTMB CR Buf latch cleanup 512 1
shared pool ksq test state obj 32 1
shared pool cross-platform compliance 2336 1
shared pool PGA total 120 1
shared pool vproblem_bucket 2112 1
shared pool ksmsq SGA 16 1
shared pool event descriptor table 107728 1
shared pool alter system errs: kspnfy 466944 1
shared pool sim kghx free lists 8 1
shared pool ASM SR state object 35224 1
shared pool SGA structure for kelr 2912 1
shared pool KTU lat struct 160 1
shared pool KTLI buck-fl ptrs 24 1
shared pool PDB rf-release limits 1336 1
shared pool KTU lat struct 160 2
shared pool zlllab Group Tree Heap De 168 1
shared pool ksp master psta 648 2
shared pool HTTP fixed headers 72 1
shared pool ksdhng: cache history 320 1
shared pool vproblem_lastinc 5184 1
shared pool log_simultaneous_copies 432 1
shared pool name-service request 2736 1
shared pool SQL Memory Manager Base W 13400 1
shared pool SGA umbrella cascade map 4480 1
shared pool kghrcx RO batches 81120 1
shared pool kghx free lists 125272 1
shared pool Undo Meta Data 408 1
shared pool recovery apply status 25320 1
shared pool KESTB existence bitvec se 2048 1
shared pool dbkgcpsga 256 1
shared pool kdfi hash bucket child la 2560 1
shared pool HM Wt Evt Stats Array 230520 1
shared pool Redo Transsport Destinati 24320 1
shared pool Exadirect acl 4016 1
shared pool KEWS External IDs 1536 1
shared pool KUPP subheap desc 232 1
shared pool SGA Deferred Parameter Ta 5864 1
shared pool message pool context area 31512 1
shared pool ksipc state object 3336728 1
shared pool INCIDENT_FILE 2112 1
shared pool ksunfy : SSO free list 3776 1
shared pool dirty object counts array 32768 1
shared pool DDE_USER_INCIDENT_TYPE 1536 1
shared pool locator state object 47856 1
shared pool Service-level trace setti 536 1
shared pool ktsimaCtx 524448 1
shared pool change tracking state cha 3888 1
shared pool ASM rollback operations 4272 1
shared pool kecuNotifier: alloc subhe 136 2
shared pool krvxlctx 256 1
shared pool kfasga 8216 1
shared pool dbgefgHtAddSK-1 482264 1
shared pool IM extent map 1049064 1
shared pool call 129896 1
shared pool ORL error information 24 1
shared pool KSWL anchor 200 1
shared pool IPS_FILE_METADATA 2112 1
shared pool KQR X PO 1107000 1
shared pool ksupd proc death 24 1
shared pool IPDDB SGA ctx 8 1
shared pool kdmadoht 16384 2
shared pool dbktb: trace buffer 1376256 1
shared pool DDE_USER_ACTION 2496 1
shared pool ksleid alloc 240 1
shared pool ktilm hash table 16384 2
shared pool KCB buffer wait statistic 232 2
shared pool KGKP randnum shadow 40000 1
shared pool krsv_notifier_cb 8440 1
shared pool qtree_kwqspqctx 48 1
shared pool qesbl old rows 1280 1
shared pool IM segment gdh_metadata 16 1
shared pool ksbxic obj 39936 1
shared pool 438.kgght 36784 1
shared pool 423.kgght 36784 1
shared pool NETWORK BUFFER 66664 1
shared pool quiesce system context 440 1
shared pool KTSJ subheap 4960 1
shared pool HM_RECOMMENDATION 4416 1
shared pool ksmpdb per-process SGA re 600 1
shared pool kwspNfy-1 96 1
shared pool dir_ext 2880 1
shared pool HM RSLN RC 3328 1
shared pool HM Hang Stats 6016 1
shared pool ksbsa pointer array 4248 1
shared pool DNFS Disp context arr 8 1
shared pool ksu:ksusg_emptysta 16400 1
shared pool top_proc_pdb 2400 1
shared pool kzsc:kzscstob 96 1
shared pool parameter string values 397744 1
shared pool SQLK 32384 1
shared pool event list array to post 72 1
shared pool ksasga.ksasgmsgqst 19200 1
shared pool local undo segment bit ve 4096 1
shared pool Label Cache Heap descrptr 160 1
shared pool KTI latches 1632 1
shared pool ksws service object 14072 1
shared pool ksunfy: in-use PSO Numa A 8 1
shared pool ksuloi: long op used list 16 1
shared pool ksgm sga instance configu 8584 1
shared pool KSIPC AM MDT 224 1
shared pool ksipc gsment table 16 1
shared pool OS proc request holder 24000 1
shared pool pid 39128 1
shared pool DNFS Disp Cle q Rec 56 1
shared pool Database type info cache 32 1
shared pool name-service entry 2736 1
shared pool resize operation history 28808 1
shared pool DBWR array of pointers to 8 1
shared pool ksfd SGA state 136 1
shared pool ksfd SGA I/O outlier 1328000 1
shared pool KSFD Kernel IO outlier co 40 1
shared pool KCN hash latches 51200 1
shared pool branch so 296 1
shared pool array for shared redo blo 72 1
shared pool event list to post commit 144 1
shared pool KTMPJ msz pools 88 1
shared pool Inmemory xmem 64KB anchor 147640 1
shared pool kglsim count of pinned he 19584 1
shared pool kglsim count of unpinned 19584 1
shared pool kqaq_req 3920 1
shared pool Read Only Database Accoun 200 1
shared pool DISPATCHER CONFIG ENTRY 80 1
shared pool KXFR Psuedo Hash Array fo 3072 1
shared pool Sql controlelement latch 128 1
shared pool replication session stats 3952 1
shared pool kpssnfy: kpsssgct 72 1
shared pool qmps connections 65280 1
shared pool xssinfo 9360 1
shared pool kfkid hrec 32 1
shared pool kelt translation table 384 1
shared pool Service-level ID trace se 4816 1
shared pool SWRF Metric DRM Table 7632 1
shared pool Active Session History - 1528 1
shared pool KEBM SGA struct for Autot 2448 1
shared pool kelr system metrics table 296 1
shared pool KPDBE SGA Migrate Vld Cal 8 1
shared pool KCB tablespace encryption 1320 1
shared pool HM_MESSAGE 3072 1
shared pool DFW_PURGE 3648 1
shared pool vips_package_size 1536 1
shared pool vips_package_main_problem 1728 1
shared pool kwqicaqe2kc1 27216 1
shared pool qmn tasks 4104 1
shared pool KEBM SGA struct (PDB) - P 8 1
shared pool PLDIA 1254104 1
shared pool finding tracking element 4160 1
shared pool kwqmnasctx: alloc kwqmnsc 48 1
shared pool kskpdbopennfy 9696 2
shared pool latch where stats 19392 2
shared pool ksfd: consumer group i/o 4256 2
shared pool KTU latches 120 2
shared pool KTU latch cleanup 400 2
shared pool TEMP UNDO STAT INFO 41472 2
shared pool KTUR HIST INFO 4840 2
shared pool SAGE commit cache Allocat 16 2
shared pool change notification regis 16416 2
shared pool change notification obj m 16416 2
shared pool KTCNQROW colnames 5504 2
shared pool KTCN: Obj Invalidation Se 33424 2
shared pool kkaenc 1408 2
shared pool kzxiIniSGA:Late binding D 448 2
shared pool ksxmsg_htab 512 2
shared pool Result Cache: Memory Mgr 208 2
shared pool kponPdbNfy: alo eshdinfo 8 2
shared pool Key Management heap 160 2
shared pool LISTEN END-POINT ENTRY 88 1
shared pool Result Cache 193752 1
shared pool KSRMF anchor 200 1
shared pool X$KSVII table 512 1
shared pool KGSKI scheduler heap 1 de 136 1
shared pool pspool_kfsg 80 1
shared pool clear orls state object 4016 1
shared pool kebm test replies 122880 1
shared pool KTMC hash latch cleanup 18432 1
shared pool Pre-Warm Initialized Seti 144 1
shared pool ksdhng: blkrs cache 7904 1
shared pool cgidrec_kfnvsg 32 1
shared pool gwm_sga_notifier 1112 1
shared pool os statistics 16728 1
shared pool pmon slaves array 1200 1
shared pool IM extent map mem 32 1
shared pool kghpinfo freelist 48 1
shared pool ktcncchildlatch 7424 1
shared pool kspvpftbl 21656 1
shared pool obj stats hash table 960 1
shared pool kcrfa structures 15808 1
shared pool kgnfs gid list 104 1
shared pool ksipc gsm xrccm 256 1
shared pool populate state object 2584 1
shared pool kdlwss 41192 1
shared pool KTMCsrchlatclnup 512 1
shared pool KYWM RPLY CROSS INSTANCE 212992 1
shared pool SGA Non-Inheritable PDB P 200 1
shared pool SWRF Alerted Metric Metad 4160 1
shared pool ksm asr bitv 524288 1
shared pool HM Lcl Sess Info 83416 1
shared pool ksfd I/O slave ctx 256 1
shared pool ksolt LWT ksmd handles 8 1
shared pool KFM state obj 3504 1
shared pool kcfis state object 3248 1
shared pool ksfs per pdb mnt structs 28200 1
shared pool ksir PrivOp State Object 2736 1
shared pool KSIR SGA 184 1
shared pool KSGL Latch Groups 192 1
shared pool LGWR PIC 224 1
shared pool KTSL reco struct 12288 1
shared pool kebm action descriptors 480 1
shared pool sys event stats for Other 61440 1
shared pool flashback_marker_cache_si 9200 1
shared pool sot->data_kdliso 280 1
shared pool global container timeout 2048 1
shared pool Sort Segment file descrip 4128 1
shared pool PDB inst stats array 208 1
shared pool channel context areas 66432 1
shared pool parameter text value 11896 1
shared pool KGX 178296 1
shared pool ksfv instance descriptors 7936 1
shared pool vincident_file 2496 1
shared pool pending bcast scn array 72 1
shared pool kgnfs htab array 4840 1
shared pool ksfv subheap descriptor 184 1
shared pool SHRINK STAT 3088 1
shared pool ltxid: ltxid context 67984 1
shared pool vproblem 5952 1
shared pool Inmemory 1MB anchor 147640 1
shared pool kglsim size of pinned mem 38896 1
shared pool KTMC latch cleanup 192 1
shared pool KSIPC ASPC Instance Addre 131072 1
shared pool enqueue state object 2240 1
shared pool TXN TABLE SEGMENTED ARRAY 251920 1
shared pool latch descriptor dynamic 23856 1
shared pool PX scan rate stats 1080 1
shared pool file # to first dba, exte 2416 1
shared pool ksunfy_meta 1 12589184 1
shared pool kgnfs stats array 38440 1
shared pool AQ Message cache driver s 42720 1
shared pool PDB_PROBLEM 2304 1
shared pool ams_xaction 1344 1
shared pool kfmsg 28696 1
shared pool kglPdbDebugType 1272 1
shared pool qmpspdbonfy:0 65280 2
shared pool kwsbgini-fmPool_kwsbgsgn 2352 1
shared pool per-PDB PGA Stats 1848 1
shared pool nonlogged block cache wri 2480 1
shared pool LRMPD SGA Table 606256 1
shared pool PLS cca hp desc 352 1
shared pool PDB stats array 16400 2
shared pool ksb ci process list (each 1368 1
shared pool kecuNotifier: alloc subhe 136 1
shared pool enqueue resources 392232 1
shared pool ksdhng: els blkrs cache 679680 1
shared pool kwsoptSGAINfy:optlist 2752 1
shared pool modification hash table c 688128 1
shared pool highest_untunable 256 1
shared pool krbfusg 48 1
shared pool KTMPJHT latch cleanup 24 1
shared pool ktimextht latches 163840 1
shared pool ufgtab_kfmdsg 244176 1
shared pool relmd_ext 2688 1
shared pool KFK idtab_kfksga 101288 1
shared pool parameter blocks 43296 1
shared pool poisoned memory 32768 1
shared pool ts encryption key afn rev 3208 1
shared pool ksbxic chname 24 1
shared pool segmented arrays 19168 1
shared pool kss global so cache 552 1
shared pool logwriteds 284328 1
shared pool KSK VT POOL 816280 1
shared pool ktsj_init_sga task stat 168 1
shared pool KSKQ SGA:kskqlmspld 66728 1
shared pool KPDB latch structure 160 1
shared pool qmkmProtocol:qmdpsg 1600 1
shared pool SQL Workarea Histogram 1056 1
shared pool Backup Appliance state ch 3760 1
shared pool kscdnfyinitflags 8 1
shared pool process allocation slots 8000 1
shared pool Real-Time ADDM control st 840 1
shared pool INC_METER_CONFIG 2688 1
shared pool process count for each CI 1224 1
shared pool ksfs cdb mnt structs 16 1
shared pool kghrcx batch 1388568 1
shared pool KTMPJ InMemEsz pools 88 1
shared pool SYSTEM PARAMETERS 1007848 1
shared pool joxs struct 600 1
shared pool dgtab_kfmdsg 244176 1
shared pool sga node map 16 1
shared pool KTCN global operators 64 2
shared pool txncallback 85712 1
shared pool kodosgi kodos 32 1
shared pool handoff 2632 1
shared pool sched job queue 3760 1
shared pool imc-txn-wrk 50160 1
shared pool X$KSFQP ANCHOR 80 1
shared pool SGA cascade list 4504 1
shared pool KSK PDB SGA kskpdbmetric 320 1
shared pool KCN SCN/Time map 12288 1
shared pool I/O stat latches 4960 1
shared pool RTA boundary array 105600 1
shared pool DTP proc structure bitmap 1040 1
shared pool KSM SGA Slave ctx 40 1
shared pool KSK OSS PLAN 200 1
shared pool KTU PDB dynamic SGA local 40 2
shared pool system default language h 568 1
shared pool session idle latches 160 1
shared pool KTA latches 2024 1
shared pool spfile cleanup structure 16760 1
shared pool kscdnfyglobalflags 8 1
shared pool post stats 2368 1
shared pool ksuloi: garbage collectio 8 1
shared pool KGNFS PLDLIST head 16 1
shared pool KSIPCASPC SGA 2672 1
shared pool ksws service events 84480 1
shared pool dskm rac entity id 96 1
shared pool DNFS Disp Iss q Rec 40 1
shared pool DNFS Disp Com q Rec 48 1
shared pool db_block_hash_latches 204800 1
shared pool sim lru segments 1440 1
shared pool kcrfw_slave_queue_init: t 168 1
shared pool ksfd: components i/o stat 80640 1
shared pool ksfd: file i/o stats poin 3536 1
shared pool kcnibr.c@2885 136 1
shared pool Block List 388872 1
shared pool arrays for shared redo bl 24 1
shared pool KTRSGA 8 1
shared pool Global dictionary read-wr 163840 1
shared pool kglsim used list arr 2720 1
shared pool kglsim hash table 8208 1
shared pool kzxssuf heap 160 1
shared pool Key Management heap 160 1
shared pool 333.kgght 36784 1
shared pool PX subheap desc 256 1
shared pool PQ/BizCard 1536 1
shared pool Sql control element free 256 1
shared pool statement queuing 3504 1
shared pool X$KSVIS table 128 1
shared pool kkzias 144 1
shared pool trace_knlasg 504 1
shared pool kwsbgcdsjini-kwsbgjta 320 1
shared pool kwsbtmCrtLatStatNode:allo 40 1
shared pool heap_kfsg 208 1
shared pool KFG SO child 11024 1
shared pool KFK SGA 4448 1
shared pool kfmdsg 992 1
shared pool KEW PDB SGA Structure 72 1
shared pool KEWR PDB SGA - UMF MDB En 2288 1
shared pool SWRF Metric Eidbuf 225256 1
shared pool kebm slave descriptors 39424 1
shared pool KEBM Autotask state objec 20336 1
shared pool kerpiAllocSgaSubHeap:desc 136 1
shared pool jsksncb:62 1040 1
shared pool sched job slv 30112 1
shared pool SGA structure for ADR lay 16 1
shared pool dbkea msgs 1200 1
shared pool gwm_sgctx 1000 1
shared pool parameter table block 2121864 1
shared pool KSK Redo session info 3400 1
shared pool kgsk subheap descriptor 136 1
shared pool KGKP sga 48 1
shared pool ksevn window 400 1
shared pool OFS latch heap ds 136 1
shared pool ktcnqrow columns 9024 1
shared pool HM_FDG_SET 1920 1
shared pool DDE_USER_ACTION_PARAMETER 4608 1
shared pool IPS_PACKAGE_FILE 1920 1
shared pool KESTB existence bitvec 262144 1
shared pool kwqmncal: allocate buffer 4112 1
shared pool kwsbgcsoa 56 1
shared pool kwsbsmStSlv: sptr for loc 80 1
shared pool dbkgcParsePatchInfo_12:1 2736 1
shared pool MinActScn Array 320 2
shared pool ktgCircBuf:MinActScn Trc 40032 2
shared pool KTCN: Hash Table Segmente 9072 2
shared pool kodosgi kopfdo 416 2
shared pool rules engine context 200 2
shared pool SWRF Metric CHBs 219704 2
shared pool dso->mds_kdlidso 1920 1
shared pool kcbi io desc 14248 1
shared pool db_block_hash_buckets 2101248 1
shared pool kzsrs filename 536 1
shared pool HM VFY TRCFIL 520 1
shared pool parameter value memory 4360 1
shared pool KTC txn rsrc cnt 88 1
shared pool kstm drifts table 1048 1
shared pool pdb latch bitmap 128 1
shared pool L2 file global fob 80 1
shared pool 19002.kgght 36784 1
shared pool KEWS PDB System Stat valu 192 1
shared pool network connections 98360 1
shared pool branch 168952 1
shared pool gc ping pin array 8192 1
shared pool primem_kfmdsg 8200 1
shared pool KCB cacherm 106576 1
shared pool alls-ktimcem 1048824 2
shared pool UNDO INFO HASH 16608 1
shared pool object level stat table 1440 1
shared pool ksm pdb struc 3400 2
shared pool kdfi dsga 72 1
shared pool KTMA Space latch cleanup 1176 1
shared pool name-service recovery 4016 1
shared pool slave class sga anchor 360 1
shared pool kramh message flag 16 1
shared pool kghrcx RO freelist header 48 1
shared pool vips_package_history 3072 1
shared pool PDB rf-release hints 1208 1
shared pool reserved entries for all 11968 1
shared pool KKJ SHRD WRQS 240 1
shared pool kelr other metrics table 56 1
shared pool KTMPJ esz pools 88 1
shared pool memory pool stats 5440 1
shared pool temp lob duration state o 3632 1
shared pool ADR_INVALIDATION 1536 1
shared pool vadr_control 4032 1
shared pool global container timeout 2048 2
shared pool pending ckpt array for ti 16160 1
shared pool kghx free lists 12312 2
shared pool IUT Hash Table Base 512 1
shared pool PDB inst stats array 208 2
shared pool IMC extent map 50088 1
shared pool KSRMFV2 State Object 18480 1
shared pool file # translation table 40064 1
shared pool vips_pkg_file 3456 1
shared pool KSRPC I/O Stat array ptr 24 1
shared pool UNDO INFO 16 1
shared pool krssrtt 3968 1
shared pool dbkea msg body 51200 1
shared pool UNDO INFO 16 2
shared pool DNFS Disp context 64 1
shared pool Auto BMR for File Header 56 1
shared pool PG latch table 640 1
shared pool instance cnxn information 22656 1
shared pool htab_keiutsg 512 2
shared pool qksceAllocateSga:ce 1128 1
shared pool enqueue 1173432 1
shared pool SCHEDULING POLICY TABLE 64 1
shared pool KCB Table Scan Bitmap 248 1
shared pool vinc_meter_info 3840 1
shared pool ktilm hash latches 16320 1
shared pool dbkplssga 1400 1
shared pool Sql control element child 2560 1
shared pool qksbgCreateSystemEnv: qks 232 1
shared pool krbabrAncp 96 1
shared pool kdnnfy : array of kdnss 3776 1
shared pool KGLHD 67352 2
shared pool channel handle 140272 1
shared pool KKJ WRK LAT 480 1
shared pool INC_METER_INFO 3072 1
shared pool message pool freequeue 3051744 1
shared pool KTCNC inv ht 128 1
shared pool SpaceReuse Stats 526640 1
shared pool kcrlflcr: FLC logmnr sess 56 1
shared pool kfklsodtab 339824 1
shared pool LGWR-network Server info 33040 1
shared pool per-PDB PGA totals 1336 1
shared pool KSN WaitID 2080 1
shared pool Temporary RTA boundary ar 104 1
shared pool prmtzdini tz region 801416 1
shared pool kqf runtime defined table 23768 1
shared pool kponfy 1272 1
shared pool resumable 2992 1
shared pool kwsoptSGAINfy:inactive 376 1
shared pool listener addresses 16 1
shared pool 6161.kgght 167160 1
shared pool State object pools 6720 1
shared pool kcbl seq io throughput 12000 1
shared pool 6160.kgght 167160 1
shared pool krvxmctx 40 1
shared pool kebm action context 72 1
shared pool vproblem_int 5376 1
shared pool KGLSG 5260816 1
shared pool DBWR event stats array 232 1
shared pool 432.kgght 36784 1
shared pool sim_knlasg 1280 1
shared pool ksupd List head 24 1
shared pool L2 enabled array 16 1
shared pool Kernel Component SGA I/O 186000 1
shared pool SGA Parameters Families 21656 1
shared pool ksupd List head 24 2
shared pool vem_user_actlog1 1536 1
shared pool kglsim sga 576 1
shared pool Log Archive Config Contex 4488 1
shared pool VIEW 2304 1
shared pool HM PC Rank 256 1
shared pool KTMC latches 1760 1
shared pool plis struct 176 1
shared pool KTI freelists 88 1
shared pool kfklsod list 21440 1
shared pool HM SGA init var 24 1
shared pool kga sga 16 1
shared pool DTP proc structure alloc 39200 1
shared pool kjxgrgctx SGA 344 1
shared pool XCT SGA 8 1
shared pool INSTANCE INFO 56 1
shared pool ktimextht recovery area 65536 1
shared pool KGNFS PLDLIST array 8 1
shared pool KGI Session State 2008 1
shared pool kcbbl2df L2 disabling fla 8 1
shared pool dev2node map 4096 1
shared pool knstoggall_knstsga 160 1
shared pool KTU latches 120 1
shared pool ksmscrsas:2 48 1
shared pool ksunfy: pdb counts segmen 2104 1
shared pool ksuloi: long op free list 16 1
shared pool KSI resource miss count 3000 1
shared pool ksim client list 192 1
shared pool done Q child latches 224 1
shared pool ksvr msg cache 2480 1
shared pool KSIPC ASPC State Object 28888 1
shared pool ksdhng: blkers cache 15472 1
shared pool Processor group descripto 432 1
shared pool RVWR post requested array 8 1
shared pool dbwr suspend/resume ptr a 16 1
shared pool dbwriter coalesce bitmap 88 1
shared pool parallel kcbibr dbwr bitv 16 1
shared pool dbwr actual working sets 24 1
shared pool Prefetch client count per 40 1
shared pool KRSF SGA 40 1
shared pool SRL error information 24 1
shared pool ksfdodm SGA state 128 1
shared pool ksfd: block i/o stats poi 3200 1
shared pool KCN hash buckets 16384 1
shared pool temporary table lock 2632 1
shared pool SAGE commit cache node Al 2048 1
shared pool PARALLEL T RECO LATCH 3200 1
shared pool KTPR HIST TB 2808 1
shared pool redo allocation latch(es) 8320 1
shared pool change tracking DBA latch 160 1
shared pool LGWR per strand PIC array 4992 1
shared pool KTMB latches 1760 1
shared pool KTMA space latches 3360 1
shared pool KTFBN SGA 45104 1
shared pool IM segment hash table mem 24 1
shared pool ksmtimcronsg 83968 1
shared pool kdlxdup derztc 960 1
shared pool kdmfssgaheap 136 1
shared pool kdmfsdwlheap 136 1
shared pool kglsim latch area 2720 1
shared pool kglsim object batch 622104 1
shared pool kglPdbDebugStat 8 1
shared pool kzekm per-PDB TDE_CONFIGU 1208 1
shared pool Global Context Heap descr 400 1
shared pool Result Cache: State Objs 2760 1
shared pool knlsg 240 1
shared pool knlu_init_btree:init 96 1
shared pool kodosgi kopfdo 416 1
shared pool SGA structure for KWQDL h 376 1
shared pool kwslbSGAData 1872 1
shared pool procs_kfgbsg 5720 1
shared pool ASM connection state 73984 1
shared pool kffgsg 40 1
shared pool SGA structure for AWR (KE 264 1
shared pool SWRF Metric CHBs 828600 1
shared pool kebm slave reply 5168 1
shared pool KEBM autotask descriptors 88 1
shared pool KEWS statistic name 2936 1
shared pool jsksncb:57 320 1
shared pool plwppwp:PLW_STR_NEW_VAL_V 32 1
shared pool dbgefgHtInit-2 80 1
shared pool KPDB Hash Table Latches 24 1
shared pool KPDBE Children List 88 1
shared pool KPDBFL SGA 664 1
shared pool parameter handle 541744 1
shared pool pool srv list 320 1
shared pool ksfslath 4336 1
shared pool IPS_FILE_COPY_LOG 2304 1
shared pool alert_ext 10560 1
shared pool DFW_PURGE_ITEM 2880 1
shared pool v_ipsprbcnt 1536 1
shared pool vproblem1 5568 1
shared pool v_inc_meter_info_problem 1728 1
shared pool vproblem_bucket_count 2304 1
shared pool vpdb_problem 3648 1
shared pool LGWR PIC request array 2816 1
shared pool KSK scheduler 173072 1
shared pool kzsc:kzscstob_co 8192 1
shared pool AWR Flushing Error Contro 80 1
shared pool PRTMV 25064 1
shared pool KEBM SGA struct (PDB) - P 8 2
shared pool kdmgdfreeHTqueue 4120 2
shared pool dbkgcPopulatePatchInfo:1 248 1
shared pool kghpinfo min lru 96 2
shared pool pdb event stats segment s 24 2
shared pool system default language h 568 2
shared pool ktcncchildlatch 7424 2
shared pool kghifx descriptors 224 2
shared pool KTCN global clauses ht 128 2
shared pool SWRF Metric Eidbuf 73616 2
shared pool SWRF Metric WCTimebuf 1096 2
shared pool SWRF Metric RRM Table 1072 2
shared pool kkj jobq slave descriptor 1280 1
shared pool kfgbsg 48 1
shared pool vshowincb_i 1920 1
shared pool ksmd unit test 1 2736 1
shared pool buffer_pool_desc_array 4480 1
shared pool EM_TARGET_INFO 2688 1
shared pool IPS_CONFIGURATION 2880 1
shared pool krvxfda-dka 1088 1
shared pool buffer handle 1440000 1
shared pool PDB wait limits 1336 1
shared pool per_pg_set_descriptor_arr 20088 1
shared pool KKKI consumer 4928 1
shared pool KSRMA Object Descriptors 28080 1
shared pool KTCN global operands ht 128 2
shared pool kwscSGAInitNfy: flst_kwsm 2640 1
shared pool KQF optimizer stats table 2680 1
shared pool namrec_kfdsg 32 1
shared pool IMCDT Mgmt 4016 1
shared pool Securefile fast space usa 1176 2
shared pool ktimextht ht 16384 1
shared pool dbktb: sga ctx 40 1
shared pool Reset Parameter Handle 232 1
shared pool undo temp 112744 1
shared pool KSIPC ASPC InstMap 32768 1
shared pool AWR View Info (KEW layer) 160 1
shared pool generic process shared st 1008 1
shared pool KGNFS DMLIST head 16 1
shared pool event classes 2672 1
shared pool IM MRGLB 8 1
shared pool KSFD Cache Hints for IO R 88 1
shared pool KCB Table Scan 40 1
shared pool media recovery state obje 11472 1
shared pool skgxp ANT slave netstat m 8368 1
shared pool PX msg pool struct 56 1
shared pool pdb event stats 15360 1
shared pool sys event stats 1228800 1
shared pool ksp master psta 129888 1
shared pool pdb event stats 15360 2
shared pool kfiac_sg 2432 1
shared pool KMMSGPDBSA 2360 1
shared pool kjci CIC table 14336 1
shared pool KSI Indexes 288 1
shared pool PDB_SPACE_MGMT 2880 1
shared pool row cache child latch 9760 1
shared pool ksfs SGA state 21088 1
shared pool pso tbs: ksunfy 156000 1
shared pool pdb latch table 7952 1
shared pool IM affinity hash table 16384 1
shared pool PGA totals ptrs 8 1
shared pool ksdhng: cbufs 64 1
shared pool ptr to sessions under idl 8 1
shared pool KSRMA Free Rlogs 1048576 1
shared pool quiescing session 4016 1
shared pool dbktb: trace pool 45600 1
shared pool IPS_PACKAGE 4032 1
shared pool Entity type array 56 1
shared pool temporary tabl 8728 1
shared pool KYWM CROSS INSTANCE 384 1
shared pool kspd run-time context 8320 1
shared pool diagv_incident 7104 1
shared pool PDB stats array 16400 1
shared pool KTLI Log Hash Table 72 1
shared pool sctx 51648 1
shared pool Big SQL Shared Memory SO 3064 1
shared pool KSZ sga subheap descripto 136 1
shared pool kgnfs authp 16464 1
shared pool lock state hash table 647680 1
shared pool EM_DIAG_JOB 2880 1
shared pool system node table 16 1
shared pool KSIPC anchor 20640 1
shared pool recov_kgqbtctx 7320 1
shared pool koh dur heap 424 1
shared pool kcrfw_slave_phase_initall 96 1
shared pool sim trace buf 5144 1
shared pool kzsc sga heap 160 1
shared pool v_actinc 1728 1
shared pool KGLSGSTA 10296 1
shared pool KQR X PO 136176 2
shared pool kjxgrrr SGA 56 1
shared pool 1105.kgght 36784 1
shared pool kfvacfssga 8 1
shared pool ktilm hash table 16384 1
shared pool KSI ENQUEUES 72416 1
shared pool Inmemory xmem 1MB anchor 147640 1
shared pool 441.kgght 36784 1
shared pool 444.kgght 36784 1
shared pool kokcd 104 1
shared pool INC_METER_SUMMARY 3264 1
shared pool kxfpdp pointers 262136 1
shared pool kpummst global in the SGA 5808 1
shared pool 1:kngisga 32152 1
shared pool KTU avail cache 4032 1
shared pool max allowable # log files 506400 1
shared pool kdCStat hash table 16384 1
shared pool trace buffer header array 208 1
shared pool starting comp sizes snaps 192 1
shared pool SQLP 78296 1
shared pool sess Q child latches 224 1
shared pool KSK MEMINFO 787008 1
shared pool KLCS 271568 1
shared pool KSRMA anchor 339720 1
shared pool PICKLEERR 2496 1
shared pool Result Cache: Cache Mgr 832 2
shared pool Prefetch history buffer 12744 1
shared pool osp allocation 93168 1
shared pool ksacm service obj array 792 1
shared pool KSZ SGA 88 1
shared pool vips_file_metadata 2112 1
shared pool Wait event pointers 312 1
shared pool cp srv array 2736 1
shared pool event-class map 7704 1
shared pool KSK plan change state seg 23352 1
shared pool kcrfwy: shutdowns 8 1
shared pool KTC latches 1760 1
shared pool PDB nwatch 1208 1
shared pool client/application info l 160 1
shared pool ksbxic sga 56 1
shared pool enqueue_hash_chain_latche 160 1
shared pool enque hash chain latch re 88 1
shared pool kscdnfyinitnext 632 1
shared pool ksgl handle 34008 1
shared pool dia* process descriptor 16 1
shared pool kjxgrvr SGA 40 1
shared pool object queue hash table d 912 1
shared pool object queue header hash 6912 1
shared pool sim segment hits 1440 1
shared pool dbwr working sets kcbdbws 16 1
shared pool Redo Transport krsstcb Ar 64 1
shared pool kcrfw_slave_group_initall 312 1
shared pool UNDO STAT INFO 59904 1
shared pool KTUR HIST INFO 4840 1
shared pool MinActScn Array 320 1
shared pool KTLI Parent DESC LC 80 1
shared pool IM CAGLB 264 1
shared pool KTMPJ latch cleanup 384 1
shared pool Inmemory extension anchor 1048608 1
shared pool kdlxdup swapp 24 1
shared pool kdfi cmap elem child latc 10240 1
shared pool Role(rg) graph heap 160 1
shared pool Role(rs) graph heap 160 1
shared pool 435.kgght 36784 1
shared pool kzaac_vsga 8 1
shared pool cp pool array 2984 1
shared pool PX QC deq stats 1368 1
shared pool kokcss 40 1
shared pool kpondsg emon info 512 1
shared pool SGA structure for KPON ks 440 1
shared pool kwqmncini-stat 176 1
shared pool kfdsga 288 1
shared pool ASM map operations 3760 1
shared pool ssetrec_kfdsvsg 32 1
shared pool Client ID trace setting h 536 1
shared pool Array of TopN Table delta 16 1
shared pool SWRF Metric WCTimebuf 2504 1
shared pool KEWS sysstat values 360 1
shared pool diag fixed SGA 152 1
shared pool dbkea msgq 32 1
shared pool dbke_incid_cache_init 24000 1
shared pool ksu:ksunf_freelist 8064 1
shared pool DDE_USER_ACTION_DEF 2880 1
shared pool DFW_CONFIG_CAPTURE 1728 1
shared pool vips_package_file 2880 1
shared pool vproblem2 5760 1
shared pool vproblem_bucket1 2112 1
shared pool v_actprob 1536 1
shared pool vips_pkg_incident_candida 7104 1
shared pool kzsc sga heap 5688 1
shared pool kwssnmapAlloc 7072 1
shared pool qesmmaInitialize: pa_qesm 11088 1
shared pool kwssnmapAlloc 7072 2
shared pool AQ Slave list 8640 1
shared pool affs-ktimcem 16384 2
shared pool kkcnRstatIni 3248 2
shared pool zafwctx 40608 2
shared pool KEW PDB SGA Structure 72 2
shared pool KEWR PDB SGA - UMF MDB En 2288 2
shared pool SWRF Metric DRM Table 1504 2
shared pool KEWS PDB SGA 8 2
shared pool Role(ud) graph heap 160 2
shared pool Role(rs) graph heap 160 2
shared pool dso->iods_kdlidso 1280 1
shared pool dlo fib struct 12832 1
shared pool IM PJGLB 168 1
shared pool State object subpools 30560 1
shared pool IPS_PACKAGE_UNPACK_HISTOR 2304 1
shared pool LGWR post requested array 8 1
shared pool KTU latch cleanup 400 1
shared pool kghpinfo freelist 48 2
shared pool rules engine aggregate st 1480 1
shared pool Securefile fast space usa 1176 1
shared pool ASM KFFD SO 2992 1
shared pool jsksncb: 12 16 1
shared pool ksb cic process list 2440 1
shared pool KGNFS DMLIST array 8 1
shared pool KKSSP 2541144 1
shared pool bloom filter 3248 1
shared pool resize request state obje 339200 1
shared pool x$ksmfs table 160 1
shared pool grplut_kfgsg 4096 1
shared pool srsrec_kfnvsg 32 1
shared pool PRE_11g UNDOSEG DROP BITV 520 1
shared pool RMAN wallet access state 2992 1
shared pool HM user parameter memory 48 1
shared pool krsoproc 1280 1
shared pool log file size history arr 168 1
shared pool kwsbjcAllocMem: allocate 24168 1
shared pool KTSL lat struct 20480 1
shared pool AQ: Non Durable Sub state 22656 1
shared pool KGLNA 36192 1
shared pool KTSJ state object 65600 1
shared pool kglsim latches 136 1
shared pool temporary foreign ref 2920 1
shared pool kfnvsga 408 1
shared pool vips_package_main_int 1536 1
shared pool Dep type array 56 1
shared pool DISPATCHERS INFO 2632 1
shared pool KSKQ SGA 332144 1
shared pool BRANCH TABLE SEGMENTED AR 226192 1
shared pool ksdhng: cbuf 32768 1
shared pool KSVR SGA 8624 1
shared pool gc granule chunks 2400 1
shared pool incr ckpt write count arr 168 1
shared pool kskpdbstats 261632 2
shared pool keswxNotify:tabRwsStatGro 1496 1
shared pool ktud-usd hash table 264 1
shared pool DFW_CONFIG_ITEM 2112 1
shared pool SGA for UMF (KEUM) 8 1
shared pool msg Q child latches 224 1
shared pool KSK PDB SGA 9696 1
shared pool KTM PDB SGA 56 1
shared pool process group array 90640 1
shared pool parallel_max_servers 3840 1
shared pool plwspv:PLW_STR_NEW_VAL 16 1
shared pool sga latch where stats 77888 1
shared pool plwppwp:garbage handle 32 1
shared pool v_swperrcount 1536 1
shared pool Managed Standby Process A 57344 1
shared pool obj stats allocation chun 5160960 1
shared pool kspload:comment 64 1
shared pool rules engine context 200 1
shared pool Alert log 520 1
shared pool list 5120 1
shared pool grptab_kfgsg 2504 1
shared pool KTMSJ free lists ptrs 2048 1
shared pool IPS_PACKAGE_HISTORY 2880 1
shared pool pso child tracebuf ptrs 2400 1
shared pool kcrfwy: slaves 8 1
shared pool OFS req heap ds 136 1
shared pool param hash values 21648 1
shared pool alls-ktsimcsgtinfo 221432 2
shared pool RTA read control file ind 4224 1
shared pool ksu:stats_freelist_array 192 1
shared pool ksmscrsas:1 8 1
shared pool write state object 1446672 1
shared pool VIRTUAL CIRCUITS 3089632 1
shared pool kralastcomp 176 1
shared pool klcslo 561600 1
shared pool KTSL subheap 2103008 1
shared pool 330.kgght 4768 2
shared pool HM SGA context 78816 1
shared pool ksuplsb: plsql call stack 2048 1
shared pool PDB SGA versioning 1336 1
shared pool KTU avail cache 4032 2
shared pool PLS chunk 352 1
shared pool kdCStat hash table 16384 2
shared pool KTCN global operators 64 1
shared pool v_ipsprbcnt1 1536 1
shared pool ENQUEUE FREELISTS 184 1
shared pool MTTR advisory context 1648 1
shared pool ksipc netcaps 16 1
shared pool Result Cache: Cache Mgr 832 1
shared pool cinfo_kfnvsgasmb 4104 1
shared pool pdb_untunable_held 2400 1
shared pool ASMCMD BG process 3504 1
shared pool broker globals 248 1
shared pool KSI resource types 21632 1
shared pool connection_brokers spec 56 1
shared pool dbcomp session 2480 1
shared pool KTCNQROW colname ptrs 344 2
shared pool KSRMA Allocated Rlogs 1048576 1
shared pool kgh latchdir entries 8192 1
shared pool kghmpt jp records 32768 1
shared pool kghrcx recovery structure 544 1
shared pool ksim cached group entry l 90112 1
shared pool ksbcpuwtm_ctx_entry 17480 1
shared pool kso: sched delay history 28896 1
shared pool invalid low rba queue 576 1
shared pool writes stopped lock conte 32 1
shared pool dbwr suspend/resume array 16 1
shared pool KCB Table Scan Buffer 3981120 1
shared pool sim state object 40 1
shared pool Redo Transmit Queue Descr 864 1
shared pool Nettimeout Histogram 151280 1
shared pool kcrfw_slave_barrier_inita 48 1
shared pool Online Datafile Move sess 2736 1
shared pool am statistics 7448 1
shared pool plugin datafile array 3616 1
shared pool krdm mira recovery instan 8296 1
shared pool change tracking recovery 262144 1
shared pool KTPR SUBHEAP 168 1
shared pool KTI pool states 56 1
shared pool change notification regis 16416 1
shared pool change notification obj m 16416 1
shared pool KTCN: query inv Segmented 4016 1
shared pool KTMCsrchlatches 40960 1
shared pool IM SJGLB 56 1
shared pool 6162.kgght 165400 1
shared pool IM segment base objn arra 32792 1
shared pool row cache hash 6012688 1
shared pool kglsim recovery area 1632 1
shared pool DISPATCHER CONFIG TABLE 2048 1
shared pool SCHEDULING POLICY VECTOR 104 1
shared pool cp cmon array 3848 1
shared pool KXFR Hash Array latches a 2944 1
shared pool Expression usage element 2816 1
shared pool kolbsgi: KOLB's SGA initi 8 1
shared pool emon con array 3120 1
shared pool qtree_kwqbspse 48 1
shared pool KWQDL SGA Ddtc gen cleanu 48 1
shared pool SGA structure for KWQDL s 24 1
shared pool AQ: Master/Slave state ob 55440 1
shared pool time manager context 40 1
shared pool kwspNfy-2 48 1
shared pool xscalc 4144 1
shared pool kfkhsh_kfdsg 4104 1
shared pool ASM scan context 2736 1
shared pool kffssga 8 1
shared pool SWRF Metric ksuTimebuf 2504 1
shared pool KEBM autotask control arr 291304 1
shared pool KEWS sesstat values 373824 1
shared pool kerpi:heap 4016 1
shared pool jsksncb: 7 16 1
shared pool jsksncb:59 4336 1
shared pool SGA PDB Info Array 3509824 1
shared pool KGSKI sga 24 1
shared pool HM SGA kjzs ctx 24 1
shared pool PX subheap 39296 1
shared pool vincident 7104 1
shared pool vips_file_copy_log 3648 1
shared pool Sort Segment descriptors 3944 1
shared pool Sort Segment extent descr 4160 1
shared pool KSKQ master's compat seg 13496 1
shared pool KSKQ master CG stats seg 3674680 1
shared pool ksupd SQL Context 792 1
shared pool krvxfda-dta 13400 1
shared pool PLMCD 811328 1
shared pool qesmmaInitialize: ta_qesm 264 1
shared pool ksupd SQL Context 768 2
shared pool KKTIN 4256 1
shared pool AWR Flushing Error Contro 80 2
shared pool kskcgmetric 5152 2
shared pool mixed PDB latch descripto 192 2
shared pool PDB Autotask SGA 768 2
shared pool parameter blocks 43296 2
shared pool pdb latch bitmap 128 2
shared pool SAGE commit cache node Al 2048 2
shared pool KTM PDB dynamic SGA local 56 2
shared pool INSTANCE INFO 56 2
shared pool jsksncb: 3 4000 1
shared pool kcbi io desc slot 2109760 1
shared pool kghrcx latches 2720 1
shared pool ksm_obc_path 40 1
shared pool VIEWCOL 1728 1
shared pool EM_USER_ACTIVITY 2688 1
shared pool db_files 965912 1
shared pool KCFIS SGA 8 1
shared pool LGWR debug module memory 8192 1
shared pool kghpinfo min lru 96 1
shared pool KTI-UNDO 3978000 1
shared pool vnot_exist_incident 6912 1
shared pool KTC latch cleanup 480 1
shared pool PDB limit margins 1336 1
shared pool ksv reaper 29840 1
shared pool joxs heap 5392 2
shared pool KGLH0 161920 2
shared pool ksolt pool allocation 2800 1
shared pool ksm pdb struc 3400 1
shared pool prirec_kfmdsg 32 1
shared pool messages 76800 1
shared pool kghrcx alloc latch state 24 1
shared pool Detached dump directory 520 1
shared pool kswl ctxt 23768 1
shared pool kebm slave message 11912 1
shared pool SO private sga 7432808 1
shared pool ksipc shared nothing stat 34008 1
shared pool kzekm heap descriptor 304 1
shared pool Policy Cache H 12336 1
shared pool vhm_run 4416 1
shared pool krdrsb read violation arr 560000 1
shared pool kdCStat latch table 16320 1
shared pool imc buf hdl 2031568 1
shared pool ASH buffers 2097152 1
shared pool DFW_PATCH_ITEM 1920 1
shared pool file queue buckets 65536 1
shared pool kskpdbmetric 320 2
shared pool kkae edition name cache 1408 1
shared pool ssethsh_kfdsvsg 520 1
shared pool KFG state obj 6736 1
shared pool standby event stats 1216 1
shared pool tmplim and timeout for 40 2360 1
shared pool global container context 152 1
shared pool PDB top Heap Descriptor 272 1
shared pool pdb event stats segment s 24 1
shared pool kzxinfy:Child latches 160 1
shared pool ksfs per pdb stat structs 62040 1
shared pool ksz parent 8176 1
shared pool ksws java patching contex 1192 1
shared pool AQ: Message cache state o 1600 1
shared pool KTLI Bkt latches 2424 1
shared pool property service SO 3888 1
shared pool dbgdInitEventGrp: eventGr 216 1
shared pool ksupd latch recovery 168 1
shared pool KESTB existence bitvec se 2048 2
shared pool PX QC msg stats 3128 1
shared pool private strands 6945792 1
shared pool ksm_ob_path 16 1
shared pool ksolt lwt allocation 7024 1
shared pool diag descriptor 16 1
shared pool sga latch table 7952 1
shared pool pdb event stats segment 1360800 1
shared pool KTCN: Row Change Segmente 34640 1
shared pool dispatcher rate 1312 1
shared pool pdb event stats segment 129600 2
shared pool KGFM vsga 280 1
shared pool kcbl statistics 7168 1
shared pool KYWM SGA 664 1
shared pool AWR Table Info (KEW layer 3048 1
shared pool kxfpSO q freelists 368 1
shared pool KTMB latch cleanup 192 1
shared pool KGLSGTYPSTA 11448 1
shared pool dummy 39288 1
shared pool KSK PDB IO stats ptr 32792 1
shared pool trace buf hdr xtend 416 1
shared pool hot latch diagnostics 160 1
shared pool KTMSJ latches 40960 1
shared pool KFD extent enqueue obj 73128 1
shared pool ksv error msg 55472 1
shared pool v_incfcount 1728 1
shared pool Background process state 48 1
shared pool write info array 65536 1
shared pool keomgNotify 1:descriptor 512 1
shared pool groups_kfgbsg 1818624 1
shared pool row cache mutex 9019032 1
shared pool ksv slave class 501552 1
shared pool osp pool handles 296 1
shared pool KSI resource hash masks 1536 1
shared pool trace events array 72000 1
shared pool ksmplsctx 680 1
shared pool kjci objects freelist 38512 1
shared pool ktg hash buckets 13576 2
shared pool KPDBE SGA Tag Id Mapping 2856 1
shared pool ksmtimcrwnsg 83968 1
shared pool processes 2400 1
shared pool KSK PDB SGA stats 261632 1
shared pool ksolt sga memory 360 1
shared pool shadow lost write work bl 264 1
shared pool KSK OSS PLAN ENTRIES 409904 1
shared pool HM_INFO 2112 1
shared pool KXDBIO Recovery Area 56 1
shared pool kscdnfyinithead 56 1
shared pool Client ID trace settings 4016 1
shared pool AQ coordinator job list 4144 1
shared pool latch classes 352 1
shared pool ksu:system-global statist 16400 1
shared pool call 8352 2
shared pool Security Class heap 136 1
shared pool ksupd proc death 24 2
shared pool ksfdss bitmap array 12288 1
shared pool kscx capability table 672 1
shared pool KEW Reset ID Array in Ins 4184 1
shared pool OS file lock 5072 1
shared pool KEWS statistic maps 4008 1
shared pool kghrcx RO hash chain 2064 1
shared pool HM_FINDING 6144 1
shared pool pool srv hash sbuckets 360 1
shared pool procs: ksunfy 1641600 1
shared pool Auto tune undo info 96 1
shared pool 330.kgght 4816 1
shared pool keommDbopListNotify table 1600 1
shared pool Auto tune undo info 96 2
shared pool dgmhsh_kfnvsg 264 1
shared pool ksv slave 31888 1
shared pool kkcnecqnsg info 1152 1
shared pool iosts_kfmdsg 24000 1
shared pool kglsim per-gran bkt 72000 1
shared pool KGLS 1210656 1
shared pool Prefetch history buffer a 352 1
shared pool buffers waiting for write 24 1
shared pool joxs struct 600 2
shared pool alert threshol 896 1
shared pool gc region array 32 1
shared pool KTMA jlatches 3360 1
shared pool parallel kcbibr 40 1
shared pool kdfi buf child latch 20480 1
shared pool KTU SGA 40 1
shared pool xslongops 16400 1
shared pool XCT SGA 8 2
shared pool kdlxdup swappl 1360 1
shared pool local undo segment bit ve 4096 2
shared pool current pin time statisti 65536 1
shared pool ket_nfy:iter task alloc 1464 1
shared pool Banner Storage 2048 1
shared pool column vectors in finding 4160 1
shared pool KSRPC I/O Stat array 240 1
shared pool kglsim alloc latches 136 1
shared pool SQLA 3828624 1
shared pool KTL latches 1760 1
shared pool IM segment hash table glo 221432 1
shared pool ksv work msg 8192 1
shared pool kghmpt sp records 32768 1
shared pool ksm_obh_path 40 1
shared pool State object sizes 1680 1
shared pool ksunfy: instance statisti 208 1
shared pool ksunfy : array of SSO fre 192 1
shared pool ksuloi: child latches for 160 1
shared pool reset parameter blocks 43296 1
shared pool error message file name 64 1
shared pool kscdnfyinitprev 632 1
shared pool ksws RLB SGA ctx 72 1
shared pool ksir State Object 4016 1
shared pool ksdhng: cache ctx 208 1
shared pool ksdhng: wtr cache 7904 1
shared pool ksdhng: fblkrs cache 23040 1
shared pool ksacm service root 88 1
shared pool KSGL anchor 5304 1
shared pool block_sizes_array 56 1
shared pool FileOpenConsolidatedBlock 265488 1
shared pool Transportable DB Converte 4808 1
shared pool krdm mira information arr 272 1
shared pool TEMP UNDO STAT INFO 41472 1
shared pool copy latch aux 16 1
shared pool KTF MAPPINGS 12288 1
shared pool KTCN queries hash table 128 1
shared pool KTMSJ Heaps 34816 1
shared pool IM ADG GLB 35672 1
shared pool External table user state 116136 1
shared pool latches for protecting ls 480 1
shared pool Global dictionary parent 163840 1
shared pool kglsim size of unpinned m 38896 1
shared pool kglsim free obj list 408 1
shared pool Policy Cache Heap descrpt 160 1
shared pool zasasga 16 1
shared pool kzxiIniSGA:Late binding D 448 1
shared pool cp connection 6040 1
shared pool PX server deq stats 1368 1
shared pool Monitor Modification Hash 512 1
shared pool Sql controldata element l 128 1
shared pool Temporary Tables State Ob 164720 1
shared pool per-PDB Bound Stats 1976 1
shared pool emon srv array 4400 1
shared pool KFIAC Fencing state objec 8720 1
shared pool SWRF Metric TMM Table 168 1
shared pool kea advisor definition ca 1768 1
shared pool jsksncb: 9 656 1
shared pool kqlpWrntoStr:string 104 1
shared pool KGSKI scheduler heap 2 de 136 1
shared pool KGKP randnum 40000 1
shared pool ADR_CONTROL 3264 1
shared pool DDE_USER_INCIDENT_ACTION_ 1536 1
shared pool IPS_PACKAGE_INCIDENT 2112 1
shared pool IPS_REMOTE_PACKAGE 2112 1
shared pool INC_METER_IMPT_DEF 2304 1
shared pool INC_METER_PK_IMPTS 2304 1
shared pool v_nfcinc 2112 1
shared pool vips_package_incident_det 10560 1
shared pool KTC latch subh 85944 1
shared pool modification hash table e 12480 1
shared pool Reset Parameter Handle fo 232 2
shared pool KTT File Space Usage (PDB 2184 2
shared pool kwspnfy-pdb 96 2
shared pool KSPD key heap 536 1
shared pool active checkpoint queue e 3000 1
shared pool ksusessnetstat 47616 2
shared pool IM segment gdh_metadata 16 2
shared pool Policy Cache Heap descrpt 160 2
shared pool Array of TopN Table delta 16 2
shared pool SWRF Metric ksuTimebuf 1096 2
shared pool qmkmProtocol:qmdpsg 1600 2
shared pool KKTDF 944 1
shared pool jsksncb: 6 5600 1
shared pool kkj jobq work items 4144 1
shared pool set_descriptor_array 72 1
shared pool kspvpfbv 680 1
shared pool KSFD SGA I/O b 3977184 1
shared pool kghmpt sp context 40 1
shared pool session 4821952 1
shared pool ksu:ksusg_emptyinfo 160 1
shared pool krvxfda-dka 1088 2
shared pool Allocate KPDB Hash Table 8192 1
shared pool DNFS Disp comp array coun 1200 1
shared pool KTCN global operands ht 128 1
shared pool KWQDL child latches 3648 1
shared pool block iostats dynamic seg 9744 1
shared pool memory transfer history 19208 1
shared pool enqueue_hash 46992 1
shared pool ASM generic network state 2736 1
shared pool latch where range 38944 1
shared pool KCB where statistics arra 81984 1
shared pool SHARED SERVERS INFO 2544 1
shared pool spilled over messages 400 1
shared pool kdmadohtlatc 1600 1
shared pool KTCTSNL freelists 88 1
shared pool kolfsgi: KOLF's SGA initi 8 1
shared pool dpslut_kfdsg 4096 1
shared pool UNDO INFO SEGMENTED ARRAY 111312 1
shared pool KGLDA 436592 1
shared pool KEBM MetaData of RBB in I 4328 1
shared pool jsksncb: 2 15352 1
shared pool database creation languag 1136 1
shared pool KGX rowlist 12560 1
shared pool kso req alloc heapds 280 1
shared pool Cleanup state objects 1536 1
shared pool ksbdpu structure bitmap 1040 1
shared pool sskgpwcr: Sem set array 8 1
shared pool KSFV SGA 832 1
shared pool zafwctx 40608 1
shared pool finding tracking element 4128 1
shared pool top_proc_untunable 256 1
shared pool ksuprcwt 31200 1
shared pool KTMC hash latches 40960 1
shared pool PX server msg stats 3128 1
shared pool dbwr message active flag 8 1
shared pool pmon map array 2400 1
shared pool ksb process so list 2440 1
shared pool knlpmclsini - alloc 9632 1
shared pool KTLI Parent Bkt LC 408 1
shared pool vshowcatview 1920 1
shared pool SWEEPERR 2112 1
shared pool ASM rcl group 87464 1
shared pool kghpinfo bathdr 16 1
shared pool KTCNQROW colnames 5504 1
shared pool DFW_PATCH_CAPTURE 1728 1
shared pool KGNFS scontext 525920 1
shared pool pdb latch table 7952 2
shared pool ksws service hash table 24 1
shared pool KTCN: Row Change Segmente 38384 2
shared pool KSTM SGA 24 1
shared pool Sync NoAffirm Pending I/O 16896 1
shared pool PDB wallet status 520 1
shared pool kwqmncini-tbl 5080 1
shared pool ksmpdb SGA recovery 65584 1
shared pool x$rule_set 39208 1
shared pool kdmgdFreeHTQueue 4112 1
shared pool pdb latch where stats 77888 1
shared pool sim trace buf context 200 1
shared pool kglsim free heap list 408 1
shared pool ksoltholder array 9600 1
shared pool PDB nabort 1208 1
shared pool dsktab_kfgsg 78248 1
shared pool kebm run-once actions 112 1
shared pool sga dev dict 56 1
shared pool KTMA jlatch cleanup 1512 1
shared pool name-service table 16696 1
shared pool kglsim Java timestamps 131072 1
shared pool latch descriptor state 62912 1
shared pool qmtb_init_data 1728 1
shared pool KSQ event description 34768 1
shared pool modification hash table c 163840 2
shared pool kks cached parse errors 16 1
shared pool V$DATAGUARD_STATUS array 71680 1
shared pool KSI resource reuse count 3000 1
shared pool ksb rolling migration sta 104 1
shared pool vem_user_actlog 1536 1
shared pool ksipc_hashs 196424 1
shared pool fencing reid 10768 1
shared pool kdlwl_sga_subheap 232 1
shared pool ksusessnetstat 47616 1
shared pool kxfpSO qref freelists 368 1
shared pool KSWL LSPCIDS 16 1
shared pool kzekm PDB status check in 1208 1
shared pool 615.kggec 550120 1
shared pool KGLPDBSG 144 1
shared pool SEQ S.O. 94400 1
shared pool obj hash table pointers 240 1
shared pool KSK PDB SGA kskcgmetric 5152 1
shared pool KTTE TS Info 4160 1
shared pool Core dump directory 520 1
shared pool ksolt pool ksmd handles 8 1
shared pool KTI latch structure 8160 1
shared pool KGLS 357520 2
shared pool kodosgi kodos 32 2
shared pool namhsh_kfdsg 4104 1
shared pool KSK SGA 21904 1
shared pool logout storm management 2400 1
shared pool PMON blockers 4000 1
shared pool KTMSJ latch cleanup 4112 1
shared pool fixed allocation callback 136 1
shared pool KTCNQROW colname ptrs 344 1
shared pool User dump directory 520 1
shared pool per-PDB PGA limits 1336 1
shared pool ksuprlwt 31200 1
shared pool ksbxic dtp 88 1
shared pool ksbcwt 45448 1
shared pool channel sga anchor 400 1
shared pool ksws service hash table b 2048 1
shared pool ksws listener service nam 72 1
shared pool DNFS Disp spawn ctx 24 1
shared pool ksns pdb hdl tab 131136 1
shared pool ts encryption global key 3216 1
shared pool Context of deferred reuse 2560 1
shared pool buffer handles 24024 1
shared pool object queue hash buckets 524288 1
shared pool simulator hash buckets 135168 1
shared pool dbwr outstanding ios per 80 1
shared pool ksfdgfib recovery 16 1
shared pool ksfd: consumer group i/o 4256 1
shared pool kcbl state objects 12800 1
shared pool KRBMROS ANCHOR 96 1
shared pool time-based incremental me 57616 1
shared pool kcnm.c@206 136 1
shared pool transaction 1551616 1
shared pool KTCTSNL subheaps 1496 1
shared pool SAGE commit cache Allocat 16 1
shared pool KTCN: Obj Invalidation Se 29680 1
shared pool ktfa dynamic SGA allocati 632 1
shared pool SGA structure for ktslgt 23600 1
shared pool Space Background Task Des 655360 1
shared pool Inmemory 64KB anchor 147640 1
shared pool kdmadohtlatrec 480 1
shared pool kglsim hash table bkts 4194304 1
shared pool kglsim heap 460288 1
shared pool KGLSGTYPIDX 160 1
shared pool Role(ud) graph heap 160 1
shared pool distributed_transactions- 35912 1
shared pool pesldT03_Instance 36920 1
shared pool PX list of chunk lists 1120 1
shared pool sga listelement 2048 1
shared pool Result Cache: Memory Mgr 208 1
shared pool SGA structure for KPOND k 160 1
shared pool AW SGA 40 1
shared pool kfkrec_kfdsg 32 1
shared pool kfkid hash 4104 1
shared pool kfdsvsga 16 1
shared pool SWRF Metric RBSM struct 1888 1
shared pool kebmnfy:pdb status array 17480 1
shared pool keomm:emptyMon_keommSg 16672 1
shared pool plwppwp:PLW_STR_NEW_LEN_V 16 1
shared pool KXDBIO SGA 12896 1
shared pool kgnfs chtab 46368 1
shared pool ksu:stats_freelist 1254864 1
shared pool kpoxcAppContSG 35920 1
shared pool KGSK scheduler 208912 1
shared pool OFS ctx heap ds 136 1
shared pool HM_RUN 4800 1
shared pool KQR X SO 889544 1
shared pool gwm_ons_info 112 1
shared pool qesmmaInitialize: 112 1
shared pool kpscad: kpscscon 344 1
shared pool 11G QMN so 6792 1
shared pool Reset Parameter Blocks fo 43296 2
shared pool ksupdbstaen_hdl_tab 8 2
shared pool KEWR array of TopN stats 16648 1
shared pool kghpinfo bathdr 24 2
shared pool latch descriptor state 1344 2
shared pool pdb latch where stats 77888 2
shared pool ksupdbstaen_ent_tab 8 2
shared pool database creation languag 1136 2
shared pool KTU Recovery SGA 80 2
shared pool UNDO INFO HASH 16608 2
shared pool UNDO STAT INFO 59904 2
shared pool KTCN: query inv Segmented 7760 2
shared pool qksceAllocateSga:ce 1128 2
shared pool kponPdbNfy: alo einfo 72 2
shared pool SWRF Metric TMM Table 64 2
shared pool SWRF Metric RBSM struct 1888 2
shared pool KEWS PDB System Stat valu 192 2
shared pool KCB tablespace encryption 1056 2
shared pool parameter value memory 64 2
shared pool KEUM SGA struct (PDB) - P 8 2
shared pool jsksncb: 4 4032 1
shared pool expression usage tracking 12480 1
shared pool KTG hash buckets 74784 1
shared pool policy hash table descrpt 288 1
shared pool XS state object handle 2992 1
shared pool ksfm state object 32 1
shared pool IM segment hash table 221432 1
shared pool sga latch bitmap 128 1
shared pool analytic workspace 3760 1
shared pool KSKQ SGA:pdbtgt 16400 1
shared pool java static objs 43056 1
shared pool kghrcx RO batch headers 16 1
shared pool kzscnfy: 3 1600 1
shared pool joxs heap 4152 1
shared pool kmgsb circular statistics 162560 1
shared pool SGA Obsolete Param Source 24 1
shared pool file state object 1070976 1
shared pool ofs context 1096 1
shared pool threshold alert structure 4032 1
shared pool PDBHP 760560 3
shared pool kcbi memory desc 5304 1
shared pool X$KCNT array 3776 1
shared pool kdmadohtincar 4096 1
shared pool kghrcx RO latch director 16 1
shared pool dgmrec_kfnvsg 32 1
shared pool KEWS fixed SGA 7920 1
shared pool kdmadohtincar 4120 2
shared pool reservation state object 2888 1
shared pool DML lock 705760 1
shared pool UNDO INFO SEGMENTED ARRAY 115024 2
shared pool ksdhng: el wtr cache 135936 1
shared pool IP acl table h 4016 1
shared pool array of sessions 3776 1
shared pool PLS SGA hp 51424 1
shared pool ksgl SSO 28888 1
shared pool Policy Cache H 13128 2
shared pool vtest_exists 2496 1
shared pool dbf io stats 3200 1
shared pool per-PDB PGA targets 1336 1
shared pool KSRMA State Object 2503928 1
shared pool cgidhsh_kfnvsg 136 1
shared pool kglsim alloc latch area 2720 1
shared pool global container context 152 2
shared pool KQFUTTAB COLS 1152 1
shared pool kxfpsga snapshots 16384 1
shared pool KTMA sort latches 3360 1
shared pool kwstxnInitSga: tspl_kwsmc 5520 1
shared pool AQ Propagation Scheduling 64000 1
shared pool heap_kdfisga 256 1
shared pool constraints 119760 1
shared pool ksupd latch recovery 168 2
shared pool KKTSR 952 1
shared pool hash bucket array allocat 49152 1
shared pool parameter text value 192 2
shared pool PDB start index array 1208 1
shared pool kglsim Java per-gran bkt 72000 1
shared pool Checkpoint queue 576 1
shared pool KSFQ buffer pool 4016 1
shared pool kebm slave pool descripto 168 1
shared pool dbwriter coalesce buffer 2854912 1
shared pool latch where map 19472 1
shared pool ENQUEUE STATS 40392 1
shared pool KXDBIO state obj 587688 1
shared pool VM OSD context 96 1
shared pool ksoreqholder latches 352 1
shared pool L2 file db unique name 32 1
shared pool kss unit test 2784 1
shared pool KTMPJ latches 1760 1
shared pool kohsg 16 1
shared pool sim cache sizes 720 1
shared pool kspcmhdl 11056 1
shared pool ksuloi: long op statistic 244000 1
shared pool kspcmhdl 11056 2
shared pool FileIdentificatonBlock 903064 1
shared pool ktg hash buckets 13576 1
shared pool dbgefgHtInit-1 528 1
shared pool KGLHD 1379712 1
shared pool ksb action records 6360 1
shared pool kexsvAllocFeatureUsageHea 136 1
shared pool per-PDB qesmmISg 10552 1
shared pool key vector 3760 1
shared pool CDB Service Hash Table El 4160 1
shared pool pool srv hash buckets 32 1
shared pool ksbtnfy: infrequent actio 2128 1
shared pool KTMB CR Buf latches 40960 1
shared pool DNFS Disp comp array 4800 1
shared pool kghpinfo ptrs 32792 1
shared pool kfgsga 14368 1
shared pool kglPdbDebugNsp 1144 1
shared pool v_inccount 1536 1
shared pool CGS system incarn array 24864 1
shared pool ksunfy: is parent statist 24600 1
shared pool kdmadoht 16384 1
shared pool ksfv subheap 16496 1
shared pool kfnvsgasmbs 2304 1
shared pool ket (AutoTask) SGA 6144 1
shared pool KCB buffer wait statistic 5032 1
shared pool KQF runtime defined table 10080 1
shared pool LISTENER_NETWORKS PARAMET 64 1
shared pool post/wait queues 64128 1
shared pool 429.kgght 36784 1
shared pool 426.kgght 36784 1
shared pool KTU Recovery SGA 80 1
shared pool PROBLEM 3648 1
shared pool tablespace encryption key 200 1
shared pool sht bkt arr allo 11264 1
shared pool ksfdsspdbnfy1 128 2
shared pool vshowincb 1920 1
shared pool kswl sctxt 21208 1
shared pool file queue pointers 128 1
shared pool log_ext 8064 1
shared pool KCB incremental ckpt entr 1496 1
shared pool Array of cached attr 400 1
shared pool KEWS aggregation objs 3848 1
shared pool kghifx descriptors 224 1
shared pool Closed Thread SCN Bitvec 33792 1
shared pool kks sga 16 1
shared pool ksns_obj 467480 1
shared pool kcrlflcr: FLC root 1832 1
shared pool SWRF Metric Global SGA 10880 1
shared pool kjcipctx SO freelist 117600 1
shared pool KKJ SGA 2168 1
shared pool ksfcd SGA state 16416 1
shared pool JSX SGA 18456 1
shared pool sort segment handle 10328 1
shared pool sga blobs 32768 1
shared pool writes stopped lock state 24 1
shared pool procs:bitvec 40 1
shared pool IMEXT hash table 24 1
shared pool INCIDENT 6528 1
shared pool KEWS PDB SGA 8 1
shared pool kghmpt jp context 40 1
shared pool latch where stats 318080 1
shared pool ksunfy: nodes of hierarch 760 1
shared pool ksunfy: Reserved PSO Numa 8 1
shared pool ksim cached group entry s 2048 1
shared pool kgnfs ctab array 2440 1
shared pool KSK PDB IO stat per pdb 352 1
shared pool mga fixvar info 192 1
shared pool DNFS Disp cleanup ctx 24 1
shared pool signature element table 2640 1
shared pool L2 file map array 134160 1
shared pool sim cache nbufs 720 1
shared pool sim segment num bufs 720 1
shared pool simulator latch/bucket st 118784 1
shared pool dbwriter coalesce struct 48 1
shared pool kcrfw_slave_queue_init: s 8 1
shared pool ksfd shared pool recovery 24 1
shared pool file iostats dynamic seg 25232 1
shared pool block media rcv state obj 2736 1
shared pool log_checkpoint_timeout 12360 1
shared pool object lock state object 4016 1
shared pool kcnm.c@195 136 1
shared pool kcnm.c@203 24912 1
shared pool KTC variable sga 24 1
shared pool bcast ack latency base ar 72 1
shared pool KTCN global clauses ht 128 1
shared pool KTCN: Hash Table Segmente 5328 1
shared pool txn jrnl 255728 1
shared pool ktsj_init_sga proc desc 16400 1
shared pool allocate segment hash tab 204848 1
shared pool latches for protecting fs 960 1
shared pool latches for protecting ws 960 1
shared pool kdmfsdwrheap 136 1
shared pool row cache 25864 1
shared pool row cache mutex versions 3006344 1
shared pool kglsim timestamps 131072 1
shared pool KGLSGNSPIDX 144 1
shared pool kglPdbDebug 72 1
shared pool KKDLP SGA Property Tables 360 1
shared pool kzekm rsafipspath 4104 1
shared pool PARAMETER TABLE 2048 1
shared pool PARAMETER ENTRY 88 1
shared pool LISTEN ADDRESS ENTRY 296 1
shared pool Result Cache: Bloom Fltr 2048 1
shared pool X$KSVIT table 512 1
shared pool knstsg 56 1
shared pool session migration enqueue 2160 1
shared pool qtree_kwqbsgn 48 1
shared pool KWQDL SGA Dtc gen cleanup 48 1
shared pool kwsoptSGAINfy:uncached 376 1
shared pool SGA structure for KPON kp 1528 1
shared pool kwsbgini-actvmPooltab_kws 2640 1
shared pool kwsbgini: vmPool_kwsbgsgn 4088 1
shared pool kwspNfy-3 80 1
shared pool namhsh_kfgsg 296 1
shared pool srshsh_kfnvsg 264 1
shared pool kfiosg 24 1
shared pool AWR Data Source Info (KEW 8 1
shared pool SWRF Metric RRM Table 5664 1
shared pool KEWS statistic metadata 24864 1
shared pool dbkea sga 24 1
shared pool KPDBE SGA Validation Call 64 1
shared pool KGSK sga 104624 1
shared pool kso req alloc 4016 1
shared pool pmon sga 784 1
shared pool KSXP test table columns d 2880 1
shared pool IPS_PROGRESS_LOG 2880 1
shared pool ADR_CONTROL_AUX 1920 1
shared pool object queue header free 133056 1
shared pool monitoring column usage e 24864 1
shared pool KSKQ master's svcracbitma 1052856 1
shared pool work area table entry 265856 1
shared pool qesmmaInitialize: ia_qesm 264 1
shared pool qesmmaInitialize: oa_qesm 112 1
shared pool KESTB existence bitvec 262144 2
shared pool kwrsnfy: kwrsoe 2024 1
shared pool Saved job ids 64000 1
shared pool mixed PDB latch 480 2
shared pool ksuseplsrctx memory 72 1
shared pool KSK PDB IO stat per pdb 352 2
shared pool KTCN queries hash table 128 2
shared pool KTCNC inv ht 128 2
shared pool ktfa dynamic SGA allocati 632 2
shared pool zasasga 16 2
shared pool SWRF Metric Global SGA 10880 2
shared pool 615.kggec 4800 2
shared pool kzxssuf heap 160 2
shared pool Role(rg) graph heap 160 2
shared pool KKKI consumer 4072 2
shared pool kwqicaqe2kc1 27216 2
shared pool LISTEN END-POINT TABLE 2048 1
shared pool sot 240 1
shared pool KTTE File Info 4144 1
large pool free memory 3702784 0
large pool PX msg pool 491520 1
java pool free memory 4194304 0
