用户反馈业务跑不下去，sql一运行就是ora-04031错误，说实话，现在硬件条件都很顶，这种错误还是挺少见的，版本11.2.0.4.
1、检查报错日志
ORA-04031: 无法分配 4160 字节的共享内存 ("shared pool","unknown object","sga heap(1,0)","modification ")
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Wed Nov 06 11:27:44 2024
Errors in file /oracle/app/oracle/diag/rdbms/orcldb/orcldb2/trace/orcldb2_ora_123241.trc (incident=1313056):
ORA-04031: 无法分配 4160 字节的共享内存 ("shared pool","unknown object","sga heap(1,0)","modification ")
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Wed Nov 06 11:27:49 2024
Errors in file /oracle/app/oracle/diag/rdbms/orcldb/orcldb2/trace/orcldb2_ora_128269.trc (incident=1312991):
ORA-04031: 无法分配 4160 字节的共享内存 ("shared pool","unknown object","sga heap(1,0)","modification ")
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Wed Nov 06 11:27:54 2024
Errors in file /oracle/app/oracle/diag/rdbms/orcldb/orcldb2/trace/orcldb2_ora_126267.trc (incident=1312854):
ORA-04031: 无法分配 4160 字节的共享内存 ("shared pool","unknown object","sga heap(1,0)","modification ")
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.很奇怪的报错，提示有问题的是"sga heap(1,0)","modification "，而且用户的shared_pool设置的比较大，内存使用还有很多空间，扩展了内存和sga大小，又手动调整了shared_pool的值，重启服务器，还是一样报错。
2、查看trace
Memory Utilization of Subpool 1 (SGA HEAP)
==============================================
Allocation Name Size
___________________________ ____________
"free memory " 751763344
"miscellaneous " 3672
"vem_user_actlog1 " 0
"gcs res hash bucket " 67108864
"file state object " 1427200
"ENQUEUE STATS " 23040
"sql area " 0
"UNDO STAT INFO " 59904
"txncallback " 196992
"write state object " 2558136
"transaction " 1698288
"Wait History Array " 0
"gc partition table " 1048576
"dlo fib struct " 12832
"row cache " 1091816
"temporary tabl " 45064
"KCB tablespace encryption" 0
"invalid low rba queue " 0
"dbkea msg body " 7168
"write info array " 65536
"KSXP OSD MISC Stats buffe" 267696
"KSXR pending messages que" 861984
"KSZ sga subheap descripto" 0
"KQF runtime defined table" 0
"KWQDL SGA Ddtc gen cleanu" 0
"KTCN: Row Change Segmente" 0
"KTCN: query inv Segmented" 0
"bt_qentry " 9544
"kkslLoadParentOnLock:lite" 1000464
"kksLoadBaseParentOnLock:b" 868208
"kkslLoadBaseParentOnLock:" 0
"knlp free ipc state objec" 0
"kcbbl2df L2 disabling fla" 0
"kglsim size of unpinned m" 0
"kglsim count of pinned he" 0
"kglsim size of pinned mem" 0
"kglsim count of unpinned " 0
"ksim cached group entry l" 0
"ksb ci process list (each" 0
"ksfdsscloneinfo allocatio" 0
"ksim sga instance group e" 0
"KTCN queries hash table " 0
"kso: sched delay history " 28896
"ksir PrivOp State Object " 0
"qmn tasks " 4160
"dso->iods_kdlidso " 256
"dictionary cache " 0
"PLMCD " 673568
"PLDIA " 36600
"PRTDS " 0
"PRTMV " 16224
"dso->mds_kdlidso " 0
"execution ID memory " 0
"User dump directory " 0
"sot " 104
"ktsj_init_sga task stat " 0
"dbgefgHtAddSK-1 " 244376
"ksdhng: els blkrs cache " 938160
"ksacm service obj array " 0
"ksuxds ksuseecx memory " 0
"vshowincb_i " 0
"gcs resources " 559913952
"kdlw_atom_ins_hts:shtho " 0
"gc name table " 301989888
"gcs opaque in " 4104
"gcs pnp histo " 4160
"ges resource " 3975072
"knlp free small rcv buf " 0
"SQLA " 1386552432
"SQLP " 90976
"SQLK " 48576
"work area tab " 35496
"kglsim free heap list " 0
"plwpil:wa " 0
"vincident_file " 0
"dbktb: trace buffer " 30687232
"v_swperrcount " 0
"ksunfy : SSO free list " 8145312
"enqueue resources " 19800
"kelt translation table " 0
"kglsim hash table bkts " 598016
"kglsim Java timestamps " 131072
"ges enqueues " 16152432
"trace buf hdr xtend " 0
"KCB Table Scan Buffer " 4198400
"trace events array " 72000
"knlp receive buffers " 9520
"EM_USER_ACTIVITY " 0
"kglsim alloc latches " 0
"event-class map " 5472
"KSQ event description " 0
"KSXP CTX Stats buffer " 184040
"KSXP PORT Stats buffer " 37096
"KSXP CONN Stats buffer " 46032
"KTCN global operators " 0
"KESTB existence bitvec " 37888
"ksdhng: el wtr cache " 114664
"ksb cic process list " 0
"gcs shadows " 390028608
"ksdhng: blkers cache " 72960
"vips_pkg_file " 0
"alert threshol " 0
"qmtb_init_data " 0
"sort segment handle " 18400
"procs_kfgbsg " 0
"SERVICE NAME ENTRY " 0
"subbtree_kwqspqctx " 0
"recovery domain " 0
"SHARED SERVERS INFO " 0
"locator state object " 232240
"post agent " 0
"post stats " 0
"active checkp " 17280
"plwsppwp:wa " 0
"channel sga anchor " 0
"Checkpoint queue " 1398688
"sim lru segments " 8800
"sim segment hits " 8800
"pesom.c:Global " 4160
"pesom.c:Object " 0
"ASH buffers " 14680064
"paralltp txn r " 32952
"sot->data_kdliso " 0
"stat hash values " 0
"message pool freequeue " 267424
"procs: ksunfy " 1836120
"prirec_kfmdsg " 0
"SYSTEM PARAMETERS " 92640
"agent name " 0
"sched job queue " 5728
"object queue hash buckets" 1009664
"object queue hash table d" 27720
"obj stats allocation chun" 399360
"PG latch table " 0
"sim cache sizes " 0
"sim cache nbufs " 0
"LMS post requested array " 0
"parameter handle " 53176
"name-service recovery " 0
"SWRF Alerted " 4160
"ASM map operations " 10632
"PARAMETER ENTRY " 0
"pga detail array " 0
"param hash values " 11656
"pesldT03_Instance " 36920
"bt_subentry " 0
"Label Cache Heap descrptr" 0
"pso tbs: ksunfy " 223080
"qm_init_sga:qmdpsg " 0
"sim trace buf " 5144
"Sort Segment " 112320
"PRESENTATION ENTRY " 0
"recov_kgqbtctx " 0
"TBS STAT " 16000
"buffer handles " 1480904
"prmtzdini tz region " 801416
"DML lock " 572312
"savepoints " 0
"obj stats hash table " 0
"sim_knlasg " 0
"db_files " 238088
"base-kglhdusr " 753328
"ASM scan context " 0
"cco_subnode " 0
"cco_pubnode " 0
"cco_subname " 0
"KQR L PO " 9188672
"parameter table block " 459920
"kccsgehtt " 0
"process_memory_detail " 49152
"lm heartbeat " 0
"KGSK sga " 8240
"BRANCH TABLE SEGMENTED AR" 32904
"ksv slave " 0
"parameter value memory " 0
"k2q_lock " 736760
"ASM extent pointer array " 2997696
"krvxmctx " 0
"PX list of chunk lists " 0
"parameter text value " 0
"parallel_max_servers " 40608
"redo allocation latch(es)" 0
"kglhdusr " 1664
"modification " 1053696
"monitoring co " 37440
"rules engine aggregate st" 0
"ktcmvcb " 0
"KGLHD " 75370256
"KGLDA " 16861744
"KGLH0 " 430847632
"KGLSG " 756544
"KKSSP " 1399856
"KKBTD " 118688
"KGLNA " 1893872
"KKTSR " 4536
"KOKTD " 0
"KKTDF " 0
"KKTIN " 0
"SAGE commit cache node Al" 18432
"SGA Obsolete Param Source" 0
"SGA structure for AWR (KE" 0
"SGA - SWRF Metrics WCTime" 0
"SGA - SWRF Metrics ksuTim" 0
"ASM kfk state object " 0
"change tracking state cha" 0
"change notification regis" 4096
"Prefetch history buffer " 0
"change notification obj m" 4096
"client/application info l" 7680
"kokcd " 0
"kkzias " 0
"kdlwss " 12256
"kfasga " 0
"library cache " 0
"Storage for kcrr state ob" 0
"xssinfo " 0
"buffer_pool_desc_array " 0
"row cache child latch " 0
"osp allocation " 202456
"stfxtb statistics table " 5936
"plwda:PLW_STR_NEW_VAL_VEC" 0
"plwppwp:PLW_STR_NEW_VAL_V" 0
"plwiiw: kglpql warnings " 0
"KGLS " 6930976
"object queue " 1951040
"KGLA " 9376
"per_pg_set_descriptor_arr" 86016
"peshm.c: Global_Sub_Heap " 0
"SCHEDULING POLICY VECTOR " 0
"XCT XGA " 0
"SGA - SWRF Metric Eidbuf " 56736
"Processor group descripto" 0
"simulator hash buckets " 4801728
"resize operation history " 28808
"State object subpools " 0
"Result Cache: State Objs " 0
"character set memory " 0
"sim segment num bufs " 4400
"character set object " 0
"NETWORK BUFFER " 65576
"OS file lock " 0
"qesmmaInitialize: ta_qesm" 0
"array 2 for shared redo b" 3456
"SGA - SWRF Metric CHBs " 181408
"db_block_hash_buckets " 107085824
"IPDDB SGA ctx " 0
"temporary foreign ref " 0
"kglsim object batch " 20166216
"x$ksxpif:ent " 0
"ksuseplsrctx memory " 0
"ksws service events " 13152
"INCIDENT_FILE " 0
"INC_METER_INFO " 0
"fixed allocation callback" 0
"file # to first dba, exte" 2416
"file iostats dynamic seg " 0
"done Q child latches " 5376
"kscdnfyglobalflags " 0
"KEWS statistic maps " 0
"kxfpSO q freelists " 0
"temporary table lock " 2816
"KEWS statistic name " 0
"kebm slave message " 0
"DBWR event stats array " 0
"kxfpsga snapshots " 4096
"kcbi memory desc " 8808
"kebm slave reply " 0
"kgnfs ctab array " 24040
"event descriptor table " 65616
"kpssnfy: kpsssgct " 0
"kpscad: kpscscon " 0
"KTSL lat struct " 5760
"dbwriter coalesce buffer " 4198400
"ksmd unit test 1 " 0
"ksws RLB SGA ctx " 0
"dbwriter coalesce bitmap " 0
"krsv_notifier_cb " 25320
"KTU avail cache " 0
"kcbi io desc slot " 2924632
"ktcnqrow columns " 4328
"DISPATCHER CONFIG TABLE " 2048
"gcs resource freelist arr" 0
"gcs resource segmented ar" 0
"gcs shadows segmented arr" 0
"gc delta push object arra" 0
"KTCTSNL freelists " 0
"ges enqueue cur. usage pe" 0
"ges process descriptor ar" 0
"KTSL reco struct " 3552
"ksxp stats bkts " 4224
"KGI Session State " 40
"kodosgi kopfdo " 0
"kkslBind_value " 404984
"kdlw_write:bfs " 0
"kdlw_write:bmd " 0
"kdlx: cmapwent " 0
"DDE_USER_ACTION_PARAMETER" 0
"TXN TABLE SEGMENTED ARRAY" 28912
"vproblem_bucket_count " 0
"KFG state obj " 7008
"kzsrs filename " 0
"ksdhng: cbufs " 0
"ksfv instance " 0
"dirty object counts array" 3604480
"kwqmncini-tbl " 4136
"kwqasown: cci " 0
"kwqmn:tskdata " 0
"dbwr actual working sets " 0
"dbgdInitEventGrp: eventGr" 0
"temp lob duration state o" 3904
"Temporary Tables State Ob" 0
"ges regular msg buffers " 8345208
"kdlxdup swapp " 0
"jsksncb: 9 " 555008
"KTU lat struct " 0
"KTC latch subh " 163152
"HM_RECOMMENDATION " 2072
"kodosgi kodos " 0
"KSFD SGA I/O b " 4190328
"KSI Indexes " 0
"KSK VT POOL " 6496320
"I/O stat latches " 4960
"kwqarcb: cci " 0
"ges shared global area " 33944
"ges msg pool watchlist " 0
"kcbi io desc " 22528
"kdlx: xctx " 0
"kdlx: cmpx " 0
"kfklsodtab " 49816
"IPS_FILE_COPY_LOG " 0
"gcs commit sga state " 106504
"K2Q latches " 8480
"KTSL subheap " 84200
"knlpipcsob " 0
"ksz parent " 67288
"ksv reaper " 8416
"kglsim heap " 11844480
"event statistics per sess" 8575104
"event list to post commit" 0
==============================================
Memory Utilization of Subpool 2 (SGA HEAP)
==============================================
Allocation Name Size
___________________________ ____________
"free memory " 963336688
"miscellaneous " 440
"ges big msg buffers " 56801208
"gcs res hash bucket " 67108864
"vproblem_bucket1 " 0
"file state object " 1427200
"sql area " 0
"txncallback " 157656
"write state object " 2558112
"transaction " 2122752
"branch " 0
"vinc_meter_info " 0
"KJXM msg stat table array" 0
"gc lock contexts " 768000
"row cache " 55536
"temporary tabl " 32608
"KCB tablespace encryption" 0
"invalid low rba queue " 0
"dbkea msg body " 7168
"KXFR Psuedo Hash Array fo" 0
"branch so " 0
"KSXP OSD MISC Stats buffe" 247416
"KSXP conn table columns d" 4984
"KWQDL SGA Dtc gen cleanup" 0
"KTCN: Row Change Segmente" 34528
"ges process array " 4585528
"kksLoadBaseParentOnLock:b" 853768
"kkslLoadParentOnLock:lite" 950640
"kkslLoadBaseParentOnLock:" 0
"knlp free ipc state objec" 0
"kglsim count of unpinned " 0
"kglsim size of unpinned m" 0
"kglsim count of pinned he" 0
"kglsim size of pinned mem" 0
"kelr system metrics table" 0
"ksunfy: is parent statist" 8232
"ksunfy : array of SSO fre" 0
"ksuloi: long op statistic" 184000
"ksim cached group entry l" 5120
"ksb ci process list (each" 0
"ksfd shared pool recovery" 0
"ktfa dynamic SGA allocati" 0
"kpummst global in the SGA" 0
"ksim sga instance group e" 0
"KTCN global operands ht " 0
"DFW_CONFIG_ITEM " 0
"ksr message pool free que" 0
"threshold ale " 0
"alert_ext " 0
"vproblem_int " 0
"call " 2207704
"dso->iods_kdlidso " 0
"dictionary cache " 0
"PLMCD " 383840
"PLDIA " 0
"PRTDS " 0
"PRTMV " 22128
"dso->mds_kdlidso " 0
"execution ID memory " 0
"groups_kfgbsg " 90624
"sot " 104
"ktsj_init_sga proc desc " 0
"KSXR pending reply queue " 0
"dbgefgHtAddSK-1 " 74056
"ksdhng: els blkrs cache " 938160
"PROBLEM " 0
"hash bucket array allocat" 49152
"gcs resources " 559913952
"kdlw_atom_ins_hts:shtho " 0
"kgsk subheap descriptor " 0
"ges resource " 3305512
"knlp free small rcv buf " 0
"SQLA " 1435922560
"SQLP " 318336
"SQLK " 36432
"work area tab " 35496
"AW SGA " 0
"dbktb: trace buffer " 30687232
"ksunfy : SSO free list " 8145312
"enqueue resources " 15400
"kxfpSO qref freelists " 0
"kglsim hash table bkts " 598016
"trace buf hdr xtend " 0
"ges enqueues " 17255896
"knlu_init_btree:init " 0
"dskm rac entity id " 0
"knlp receive buffers " 0
"KSXP PORT Stats buffer " 35200
"kglsim recovery area " 0
"KSQ event description " 0
"KSXP CTX Stats buffer " 155488
"KSXP CONN Stats buffer " 46032
"ENQUQUE FREELISTS " 8064
"KESTB existence bitvec " 37888
"KFD extent enqueue obj " 0
"ksdhng: el wtr cache " 114664
"FileOpenBlock " 0
"gcs shadows " 390028608
"Core dump directory " 0
"qmtb_init_data " 0
"LISTEN ADDRESS ENTRY " 0
"sort segment handle " 25384
"SERVICE NAME ENTRY " 0
"log_checkpoint_timeout " 12360
"qtree_kwqbspse " 0
"subbtree_kwqspqctx " 0
"recovery domain " 91808
"SHARED SERVERS INFO " 0
"locator state object " 0
"post agent " 0
"memory transfer history " 19208
"QSMQUTL summar " 0
"plwshs:temphdl " 0
"segmented arrays " 4168
"Checkpoint queue " 1411520
"sim segment hits " 8800
"sim lru segments " 8800
"sim state object " 0
"peshm.c:Global " 0
"pesom.c:Global " 4160
"ASH buffers " 14680064
"sot->data_kdliso " 56
"v_actinc " 0
"message pool freequeue " 261152
"procs: ksunfy " 1831840
"SYSTEM PARAMETERS " 76144
"agent name " 0
"object queue hash buckets" 1009664
"object queue hash table d" 27720
"obj stats allocation chun" 399360
"sim cache nbufs " 0
"sim cache sizes " 0
"LGWR debug module memory " 8192
"parameter handle " 75088
"name-service recovery " 5720
"PARAMETER TABLE " 0
"pga detail array " 0
"bloom filter " 0
"PX QC msg stats " 0
"cp pool array " 0
"cp connection " 0
"poisoned memory " 32768
"name-service request " 0
"latch recovery structures" 7480
"latches for protecting fs" 0
"pso tbs: ksunfy " 223080
"Sort Segment " 112320
"PRESENTATION ENTRY " 0
"dbkea sga " 0
"recov_kgqbtctx " 0
"quiescing session " 0
"enqueue " 0
"buffer handles " 1672896
"DML lock " 643800
"sga dev dict " 0
"savepoints " 0
"obj stats hash table " 0
"media recovery state obje" 0
"OS proc request holder " 8296
"db_files " 40800
"base-kglhdusr " 739976
"ASM scan context " 0
"cco_subnode " 0
"cco_pubnode " 0
"cco_subname " 0
"KQR L PO " 20480
"parameter table block " 452472
"KSIR SGA " 0
"ASM rollback operations " 0
"KYWM SGA " 0
"process_memory_detail " 32768
"lm heartbeat " 4160
"BRANCH TABLE SEGMENTED AR" 36096
"ksv slave " 15744
"parameter value memory " 0
"RTA Boundary Info thread " 71808
"k2q_lock " 841960
"ASM extent pointer array " 2993488
"krvxlctx " 0
"multiblock re " 65664
"parameter text value " 0
"KCFIS SGA " 0
"parallel_max_servers " 36720
"reserved entries for all " 5760
"kglhdusr " 4752
"monitoring co " 20800
"ktcmvcb " 0
"KGLHD " 74373488
"KGLDA " 17106744
"KGLH0 " 435683000
"KGLSG " 754024
"KKSSP " 1665728
"KKBTD " 156904
"KGLNA " 1976736
"KKTSR " 14464
"KOKTD " 276112
"KKTDF " 0
"SAGE commit cache node Al" 18432
"SGA - SWRF Metrics WCTime" 0
"SGA - SWRF Metrics ksuTim" 0
"SGA - SWRF RawMet Runtime" 0
"kga sga " 0
"KKTIN " 2072
"ASM kfk state object " 9824
"change tracking recovery " 262144
"change notification regis" 4096
"Prefetch history buffer " 0
"change notification obj m" 4096
"Client ID trace setting h" 0
"kponfy " 0
"kokcd " 0
"knstsg " 0
"latch classes " 0
"system default language h" 0
"name-service entry " 0
"knstso " 0
"kdlwss " 17160
"kfdsga " 0
"library cache " 0
"kfgsga " 0
"KKJ SGA " 0
"spfile cleanup structure " 16760
"xssinfo " 5984
"row cache child latch " 0
"HM_RUN " 0
"osp allocation " 235984
"policy hash table descrpt" 0
"plwda:PLW_STR_NEW_LEN_VEC" 0
"plwppwp: kglpql warnings " 0
"plwppwp:PLW_STR_NEW_LEN_V" 0
"plwiiw: kglpql warnings " 0
"KGLS " 7613944
"object queue " 1847040
"KGLA " 9376
"per_pg_set_descriptor_arr" 172032
"XCT XGA " 0
"SGA structure for ktslgt " 23600
"process count for each CI" 0
"Pre-Warm Initialized Seti" 6144
"Processor group descripto" 0
"Prefetch history buffer a" 0
"rules engine context " 0
"channel context areas " 87480
"slave class sga anchor " 0
"simulator hash buckets " 4805760
"State object subpools " 4416
"Rec Ping Per Thread Info " 21128
"Result Cache: State Objs " 2872
"ASM generic network state" 2264
"AWR Table Info (KEW layer" 0
"character set memory " 0
"sim segment num bufs " 4400
"character set object " 269160
"OS file lock " 8608
"sess Q child latches " 5376
"qesmmaInitialize: oa_qesm" 0
"SGA - SWRF Metric CHBs " 62400
"db_block_hash_buckets " 105811968
"java static objs " 34952
"dbke_incid_cache_init " 240000
"temporary foreign ref " 3776
"kglsim object batch " 20316912
"kglsim per-gran bkt " 139200
"x$ksxpif:ent " 0
"ksuseplsrctx memory " 0
"ksdhng: blkrs cache " 36480
"kqlpWrntoStr:string " 0
"x$rule_set " 17608
"kqlpPlsClnup:string " 0
"fixed allocation callback" 0
"file iostats dynamic seg " 22912
"vips_package_incident_det" 2448
"KEWS statistic maps " 0
"KEWS statistic name " 0
"kebm slave message " 0
"DBWR event stats array " 0
"kcbi memory desc " 7328
"kcrfa structures " 0
"kebm slave reply " 0
"ksdhng: cache ctx " 0
"event descriptor table " 0
"kpscad: kpscscon " 0
"KTSL lat struct " 5760
"dbwriter coalesce bitmap " 0
"ksmd unit test 1 " 2624
"kscdnfyinitflags " 0
"ksws msg buffers " 2056192
"dbwriter coalesce buffer " 4198400
"krsv_notifier_cb " 8440
"kcbi io desc slot " 2929400
"KTU avail cache " 0
"ktg hash buckets " 0
"iosts_kfmdsg " 72000
"kgqbt_alloc_block " 2048
"DISPATCHER CONFIG ENTRY " 0
"gcs resource segmented ar" 0
"gc delta push statistics " 0
"generic process shared st" 0
"ges enqueue max. usage pe" 0
"ges deadlock xid freelist" 11264
"KTSL reco struct " 3456
"kspload:comment " 0
"KGI Session State " 120
"kodosgi kopfdo " 0
"KWQDL deq log " 18432
"kkslBind_value " 368936
"kdlw_write:bfs " 0
"kdlw_write:bmd " 0
"kdlx: cmapwent " 0
"kdlxdup swappl " 2400
"HM SGA kjzs ctx " 0
"DDE_USER_ACTION_PARAMETER" 0
"TXN TABLE SEGMENTED ARRAY" 36080
"KJC receiver " 0
"ksfv instance " 0
"X$SKGXPIA table " 17152
"dirty object counts array" 3604480
"ksu:ksunf_fre " 20160
"kwqmn:tskdata " 0
"ksu:stats_fre " 10880
"kwqasown: cci " 0
"dbwr outstanding ios per " 0
"dbwr actual working sets " 0
"KGSKI schedule " 0
"KGNFS scontext " 524480
"Temporary Tables State Ob" 1478376
"temp lob duration state o" 3608
"gc policy history array " 24576
"jsksncb: 9 " 0
"KTU lat struct " 0
"KTC latch subh " 199008
"KTUR HIST INFO " 4840
"gcs resource freelist " 0
"ksdhng: cbuf " 4096
"KSI Indexes " 0
"kwqarcb: cci " 0
"ges process descriptor " 21416
"KGX rowlist " 4224
"kcbi io desc " 21296
"kdlx: cmpx " 0
"kdlx: xctx " 0
"kfklsodtab " 44880
"kzxslnfy: 0 " 0
"Wait History Segment " 4742400
"knlpipcsob " 0
"KSK OSS PLAN " 3360
"gcs shadows freelist " 0
"KTSJ subheap " 4160
"KTSL subheap " 73360
"IPS_PACKAGE_FILE " 0
"IPS_PROGRESS_LOG " 0
"ksz parent " 81480
"ksbxic sga " 0
"kglsim heap " 11904000
"ksv reaper " 12624
"event statistics per sess" 8561952
"event list to post commit" 0
==============================================
Memory Utilization of Subpool 3 (SGA HEAP)
==============================================
Allocation Name Size
___________________________ ____________
"free memory " 1873404960
"miscellaneous " 376
"sga blobs " 32768
"gcs res hash bucket " 67108864
"file state object " 1427176
"dgtab_kfmdsg " 0
"sql area " 0
"txncallback " 177312
"write state object " 0
"dbkea msgs " 0
"transaction " 1698264
"branch " 1947208
"HM Wt Evt Stats Array " 164160
"KJXM msg statistics table" 0
"gc lock contexts " 0
"row cache " 1077560
"temporary tabl " 4064
"KCB where statistics arra" 9360
"KCB tablespace encryption" 0
"invalid low rba queue " 0
"dbkea msg body " 0
"resumable " 0
"dbgefgHtInit-1 " 0
"KXFR Hash Array latches a" 0
"KSXP OSD MISC Stats buffe" 214992
"KSXP ctx table columns de" 0
"KQF optimizer stats table" 0
"KTCN: Obj Invalidation Se" 0
"bt_qentry " 9544
"kksLoadBaseParentOnLock:b" 792768
"kkslLoadParentOnLock:lite" 745360
"kkslLoadBaseParentOnLock:" 0
"knlp free ipc state objec" 0
"kglsim size of unpinned m" 0
"kglsim count of unpinned " 0
"kglsim count of pinned he" 0
"kglsim size of pinned mem" 0
"kewr MMON Remote Flush Re" 30720
"ksunfy: nodes of hierarch" 0
"ksunfy : array of SSO fre" 0
"ksuloi: long op free list" 0
"ksgm sga instance configu" 8584
"ksb ci process list (each" 0
"ksfd: block i/o stats poi" 0
"vips_file_copy_log " 0
"ksr message pool free que" 0
"v_ipsprbcnt " 0
"threshold ale " 8160
"dso->iods_kdlidso " 0
"dictionary cache " 0
"vshowcatview " 0
"vtest_exists " 0
"PLMCD " 758328
"PLDIA " 20336
"PRTDS " 0
"gcs scan queue " 0
"PRTMV " 26120
"dso->mds_kdlidso " 384
"kelr other metrics table " 0
"execution ID memory " 0
"kglsim Java per-gran bkt " 139200
"sot " 0
"KSXR pending reply queue " 100312
"dbgefgHtAddSK-1 " 74064
"ksdhng: els blkrs cache " 938880
"ksfv subheap descriptor " 0
"ksuxds ksuseecx memory " 0
"DISPATCHERS INFO " 0
"gcs resources " 559923936
"kdlw_atom_ins_hts:shtho " 0
"gcs opaque in " 4104
"ges resource " 3841160
"knlp free small rcv buf " 0
"SQLA " 1025910640
"SQLP " 194168
"SQLK " 48576
"work area tab " 59160
"KJGCR global context " 0
"kebm run-once actions " 0
"dbktb: trace buffer " 30687232
"ksunfy : SSO free list " 8145312
"enqueue resources " 17600
"kglsim hash table bkts " 598016
"trace buf hdr xtend " 0
"ges enqueues " 17257528
"knlp receive buffers " 0
"KSXP PORT Stats buffer " 33000
"kglsim used list arr " 0
"KSQ event description " 0
"KSXP CTX Stats buffer " 185168
"KSXP CONN Stats buffer " 49256
"KTCNQROW colname ptrs " 0
"KESTB existence bitvec " 36864
"KFD extent enqueue obj " 42792
"ksdhng: el wtr cache " 114576
"FileOpenBlock " 37100648
"gcs shadows " 389004192
"sort segment handle " 32616
"qmtb_init_data " 0
"latchnum to latch map " 4656
"SERVICE NAME ENTRY " 0
"latch wait-event table " 0
"locator state object " 232240
"post agent " 0
"SERVICE NAMES TABLE " 0
"QSMQUTL summar " 0
"plwspv:value-1 " 0
"segmented arrays " 12768
"Checkpoint queue " 1411520
"sim lru segments " 8800
"sim segment hits " 8800
"sht bkt arr allo " 11264
"pesom.c:Global " 4160
"ASH buffers " 14680064
"sot->data_kdliso " 56
"message pool freequeue " 288064
"procs: ksunfy " 1831840
"sga listelement " 0
"SYSTEM PARAMETERS " 75864
"agent name " 0
"object queue hash buckets" 1013760
"object queue hash table d" 27216
"obj stats allocation chun" 368640
"sim cache sizes " 0
"sim cache nbufs " 0
"ams_xaction " 0
"MTTR advisory context " 0
"LGWR-network Server info " 34048
"peshm.c:latch " 0
"logout storm management " 24000
"sys event stats " 656160
"parameter handle " 56320
"name-service recovery " 5424
"pga detail array " 0
"bloom filter " 0
"Auto tune undo info " 0
"cp pool array " 0
"cp connection " 0
"ArchLog Dest Array " 22784
"state objects " 4200
"bt_subentry " 0
"latches for protecting ws" 0
"Saved job ids " 8000
"object level stat table " 0
"pso tbs: ksunfy " 223080
"Sort Segment " 108160
"PRESENTATION ENTRY " 0
"recov_kgqbtctx " 4392
"Result Cache: " 0
"qmps connections " 65280
"quiescing session " 0
"enqueue " 12584312
"buffer handles " 1481328
"property service SO " 0
"DML lock " 572312
"VIEW " 0
"ADR_INVALIDATION " 0
"savepoints " 0
"obj stats hash table " 0
"message pool context area" 22960
"media recovery state obje" 10456
"OS proc request holder " 8296
"db_files " 38328
"base-kglhdusr " 739896
"PX server msg stats " 0
"cco_pubnode " 0
"cco_subnode " 0
"cco_subname " 0
"KQR L PO " 51545152
"KQR M SO " 8677000
"parameter table block " 465480
"KQR L SO " 21349248
"KSKQ SGA " 14200
"KSVR SGA " 0
"KSXR SGA " 27856
"ASM rollback operations " 0
"process_memory_detail " 0
"BRANCH TABLE SEGMENTED AR" 26352
"parameter value memory " 0
"k2q_lock " 736760
"ASM extent pointer array " 3012928
"JSX SGA " 0
"parameter text value " 0
"parallel_max_servers " 36720
"replication session stats" 36480
"kglhdusr " 2064
"kglsgivl " 4096
"monitoring co " 16640
"ktcmvcb " 0
"krvxdka " 0
"KGLHD " 72962872
"KGLDA " 16300144
"KGLH0 " 406453144
"KGLSG " 747616
"KKSSP " 1073280
"KKBTD " 147456
"KGLNA " 3060176
"KKTSR " 56488
"KOKTD " 0
"KKTDF " 0
"SAGE commit cache node Al" 18432
"SGA structure for KPON kp" 0
"SGA structure for KWQDL s" 0
"SGA - SWRF Metrics ksuTim" 0
"SGA - SWRF RawMet Runtime" 0
"SGA - SWRF DrvMet Runtime" 0
"SQL Memory Manager Base W" 13400
"ASM kfk state object " 7368
"kks sga " 0
"skgxp ANT slave netstat m" 4184
"change notification regis" 4096
"Prefetch history buffer " 0
"kokcd " 0
"KFK SGA " 4224
"name-service entry " 0
"kdlwss " 17144
"library cache " 0
"starting comp sizes snaps" 0
"KGX " 133224
"row cache child latch " 0
"L2 enabled array " 0
"namhsh_kfdsg " 4104
"namhsh_kfgsg " 0
"Closed Thread SCN Bitvec " 33792
"Client ID trace settings " 0
"osp allocation " 223896
"stfxtb stat table array " 0
"partitioned file hash buc" 131072
"KGLS " 7883608
"object queue " 1959360
"KGLA " 59112
"per_pg_set_descriptor_arr" 86016
"XCT XGA " 0
"SGA - SWRF Metric Eidbuf " 15600
"Processor group descripto" 0
"Prefetch history buffer a" 0
"simulator hash buckets " 4801664
"State object subpools " 0
"xslongops " 0
"character set memory " 0
"sim segment num bufs " 4400
"character set object " 0
"alter system errs: kspnfy" 116736
"Active Session History - " 0
"qesmmaInitialize: " 0
"name-service " 8160
"x$ksxpif " 0
"listener addresses " 0
"db_block_hash_buckets " 107085824
"kglsim object batch " 19551840
"HM_MESSAGE " 0
"ktud-usd hash table " 0
"ksuseplsrctx memory " 0
"ksws service object " 0
"kqlpWrntoStr:string " 0
"fixed allocation callback" 0
"kqlpWrntoStr:value " 0
"ksb action records " 4272
"KEWS statistic maps " 0
"KEWS statistic name " 0
"kebm slave message " 0
"KYWM CROSS INSTANCE " 0
"DBWR event stats array " 0
"kcbi memory desc " 5104
"kebm slave reply " 0
"ksdhng: wtr cache " 36480
"ksfdgfib recovery " 0
"IPS_PACKAGE " 0
"kpscad: kpscscon " 0
"KTSL lat struct " 5920
"dbwriter coalesce buffer " 4198400
"dbwriter coalesce bitmap " 0
"ktg hash buckets " 4256
"kcbi io desc slot " 2931352
"kcbl statistics " 6144
"Global Context Heap descr" 0
"KFK idtab_kfksga " 0
"gcs shadows segmented arr" 0
"gc instance cache transfe" 262144
"KTC latch cleanup " 0
"ges deadlock xid hash tab" 17800
"ges recovery domain table" 0
"KSFQ buffer pool " 0
"KTSL reco struct " 0
"kspload:comment " 0
"ksv slave class " 351616
"kscdnfyinithead " 0
"writes stopped lock state" 0
"X$KSVII table " 0
"kqlpaac:value-1 " 0
"KGI Session State " 80
"kxfpdp pointers " 28800
"kodosgi kopfdo " 0
"X$KSXPPING table " 20480
"IPS_REMOTE_PACKAGE " 0
"KWQDL ht cco " 7216
"kkslBind_value " 303240
"kdlw_write:bmd " 0
"kdlw_write:bfs " 0
"kdlx: cmapwent " 0
"vips_package_main_int " 0
"TXN TABLE SEGMENTED ARRAY" 36080
"KFM state obj " 0
"ges reserved msg buffers " 8440008
"KJCT remote i " 0
"KJC dest ctx " 0
"INC_METER_PK_IMPTS " 0
"ksdhng: cbufs " 0
"ksfv instance " 0
"dirty object counts array" 3604480
"kwqasown: cci " 0
"kwqmn:tskdata " 0
"dbwr suspend/resume ptr a" 0
"dbwr actual working sets " 0
"database creation languag" 0
"tablespace encryption key" 0
"KGSK scheduler " 1023376
"KGSKI schedule " 0
"temp lob duration state o" 0
"joxs struct " 0
"Transportable DB Converte" 0
"KTC latch subh " 199008
"KTU lat struct " 0
"gcs resource freelist " 0
"UNDO INFO SEGMENTED ARRAY" 0
"KTA latches " 11224
"ksdhng: cbuf " 4096
"KTU latches " 7320
"kwqarcb: cci " 0
"ges process hash table " 132000
"KGX rowlist " 0
"kcbi io desc " 22000
"kdlx: xctx " 0
"kdlx: cmpx " 0
"kfklsodtab " 49816
"knlpipcsob " 0
"KSI ENQUEUES " 11760
"KTSL subheap " 73360
"v_inc_meter_info_problem " 0
"kjxgrrr SGA " 0
"ksz parent " 60552
"ksbxic obj " 0
"kglsim heap " 11630208
"kgnfs authp " 8232
"ksv reaper " 4208
"event statistics per sess" 8561952
"event list array to post " 0
"event list to post commit" 0
"KFG SO child " 0
==============================================
Memory Utilization of Subpool 4 (SGA HEAP)
==============================================
Allocation Name Size
___________________________ ____________
"free memory " 2066765392
"miscellaneous " 2768
"SWEEPERR " 0
"dsktab_kfgsg " 0
"Wait event pointers " 0
"file state object " 0
"vips_package_file " 0
"dgtab_kfmdsg " 25120
"sql area " 0
"txncallback " 157632
"write state object " 2558136
"transaction " 1910496
"KJXM msg statistics table" 6912
"KJCTS process batching st" 0
"row cache " 37824
"temporary tabl " 28728
"KCB where statistics arra" 28080
"KCB tablespace encryption" 0
"invalid low rba queue " 0
"dbkea msg body " 8192
"resumable " 0
"dbgefgHtInit-2 " 0
"EM_DIAG_JOB " 0
"KSXP OSD MISC Stats buffe" 259648
"KSXR pending consumption " 0
"KTCN: Obj Invalidation Se" 24608
"kjip2data freelist elemen" 64000
"kkslLoadParentOnLock:lite" 941984
"kksLoadBaseParentOnLock:b" 826496
"kkslLoadBaseParentOnLock:" 0
"knlp free ipc state objec" 0
"kolfsgi: KOLF's SGA initi" 0
"kglsim size of pinned mem" 0
"kglsim count of unpinned " 0
"kglsim size of unpinned m" 0
"kglsim count of pinned he" 0
"kea advisor definition ca" 0
"ksunfy : array of session" 36480
"ksuloi: long op used list" 0
"ksb ci process list (each" 0
"threshold ale " 0
"kwqmncgr: allocate buffer" 0
"v_incfcount " 0
"ksim group query request " 0
"ktgCircBuf:MinActScn Trc " 40032
"dso->iods_kdlidso " 256
"dictionary cache " 0
"call " 0
"PLMCD " 554232
"PLDIA " 0
"PRTDS " 0
"gcs scan queue " 0
"PRTMV " 32448
"dso->mds_kdlidso " 3872
"execution ID memory " 0
"v_inccount " 0
"sot " 104
"dbgefgHtAddSK-1 " 0
"ksdhng: els blkrs cache " 938160
"ksuxds ksuseecx memory " 0
"KYWM RPLY CROSS INSTANCE " 53248
"DISPATCHERS INFO " 0
"gcs resources " 560982448
"kdlw_atom_ins_hts:shtho " 0
"gcs opaque in " 4104
"ges resource " 3305512
"knlp free small rcv buf " 0
"SQLA " 1032464520
"SQLP " 115872
"SQLK " 32384
"kkae edition name cache " 0
"work area tab " 27608
"dbktb: trace buffer " 30670848
"ksunfy : SSO free list " 8145312
"enqueue resources " 24224
"processes " 24000
"kzekm heap descriptor " 0
"kglsim hash table bkts " 598016
"KSXR global channels " 0
"ges enqueues " 17257528
"qksbgsg " 0
"trace buf hdr xtend " 0
"knlu_init_btree:init " 0
"knlp receive buffers " 0
"KTUCLO RAC STATE ARRAY " 4112
"KSXP PORT Stats buffer " 30824
"KSXP CONN Stats buffer " 52456
"KSQ event description " 0
"KSXP CTX Stats buffer " 191104
"KESTB existence bitvec " 36864
"ksdhng: el wtr cache " 114664
"ksdhng: fblkrs cache " 109440
"gcs shadows " 386931312
"sort segment handle " 30552
"qmtb_init_data " 0
"LISTEN ADDRESS ENTRY " 0
"Security Class heap " 0
"standby event stats " 0
"latch hash-value table " 0
"vhm_run " 0
"subbtree_kwqspqctx " 0
"post agent " 0
"plis struct " 0
"QSMQUTL summar " 0
"segmented arrays " 4176
"Checkpoint queue " 1411520
"sim lru segments " 8800
"sim segment hits " 8800
"pesom.c:Global " 8320
"ASH buffers " 12582912
"statement queuing " 0
"sot->data_kdliso " 0
"latch recovery alignment " 0
"message pool freequeue " 123808
"vproblem1 " 0
"PMON blockers " 0
"procs: ksunfy " 1831840
"SYSTEM PARAMETERS " 76072
"agent name " 0
"Online Datafile Move sess" 0
"object queue hash buckets" 1013760
"object queue hash table d" 27720
"obj stats allocation chun" 368640
"sim cache nbufs " 0
"sim cache sizes " 0
"parameter handle " 68816
"parameter blocks " 23312
"pga detail array " 0
"PX QC deq stats " 0
"cp cmon array " 0
"state objects " 0
"name-service request " 0
"latches for protecting ls" 0
"Nettimeout Histogram " 151280
"sched job slv " 0
"obj hash table pointers " 0
"pso tbs: ksunfy " 223080
"analytic workspace " 0
"Sort Segment " 112320
"PRESENTATION TABLE " 0
"PRESENTATION ENTRY " 0
"bt_subentry_nm " 0
"buffer handles " 1481328
"property service SO " 4288
"DML lock " 643824
"broker globals " 0
"savepoints " 0
"Monitor Modification Hash" 0
"obj stats hash table " 0
"Managed Standby Proc Arra" 34816
"OS proc request holder " 9312
"db_files " 44728
"base-kglhdusr " 728296
"qtree_kwqspqctx " 0
"cco_subnode " 0
"cco_subname " 0
"cco_pubnode " 0
"KQR L PO " 86016
"parameter table block " 464264
"kglsgivl2 " 28160
"process_memory_detail " 32768
"plwspv:PLW_STR_NEW_VAL " 0
"KGKP sga " 0
"BRANCH TABLE SEGMENTED AR" 32880
"parameter value memory " 0
"RTA read control file ind" 4224
"k2q_lock " 841960
"ASM extent pointer array " 3004376
"block iostats dynamic seg" 0
"parameter text value " 0
"parallel_max_servers " 40608
"kglhdusr " 4272
"monitoring co " 54080
"ktcmvcb " 0
"krvxdta " 0
"KGLHD " 72540760
"KGLDA " 16298096
"KGLH0 " 404456144
"KGLSG " 747728
"KKSSP " 2193464
"KKBTD " 126728
"KGLNA " 1501528
"joxs heap " 0
"KOKTD " 9480
"KKTDF " 0
"SAGE commit cache node Al" 16384
"SGA struct - SWRF Metrics" 9120
"SGA - SWRF RawMet Runtime" 0
"SGA - SWRF DrvMet Runtime" 0
"SGA - SWRF Time Model Bas" 0
"partitioned file latches " 20480
"SGA - SWRF Metrics WCTime" 0
"SGA - AWR Metric RBSM str" 18240
"KKTSR " 0
"KKTIN " 0
"ASM kfk state object " 4912
"change notification regis" 4096
"Prefetch history buffer " 0
"MS alert log " 72704
"kokcd " 0
"sys event stats for Other" 43744
"parameter string values " 209216
"kdlwss " 13880
"kfiosg " 0
"library cache " 0
"L2 file map array " 4896
"row cache child latch " 0
"namhsh_kfgsg " 0
"Client ID trace settings " 0
"osp allocation " 192472
"stfxtb statistics table " 5936
"sskgpwcr: Sem set array " 0
"plwgc: plwgc_garbage_clea" 0
"KGLS " 8926216
"object queue " 1917760
"KGLA " 0
"per_pg_set_descriptor_arr" 86016
"XCT XGA " 0
"SGA structure for ktslgt " 23600
"Processor group descripto" 0
"sim trace buf context " 0
"simulator hash buckets " 4801664
"State object subpools " 4864
"reservation state object " 0
"Result Cache: Memory Mgr " 0
"xslongops " 14752
"ASM generic network state" 0
"character set memory " 0
"sim segment num bufs " 4400
"Active Session History - " 0
"SQL Workarea Histogram " 0
"MinActScn Array " 0
"qesmmaInitialize: pa_qesm" 11088
"db_block_hash_buckets " 105807872
"KSI resource types " 16224
"kglsim object batch " 19706400
"HM_FDG_SET " 0
"ktlbk state objects " 5417280
"x$ksxpif:ent " 0
"ksuseplsrctx memory " 0
"ksu:ksusg_emptyinfo " 0
"ksws service events " 26304
"fixed allocation callback" 0
"vips_pkg_incident_candida" 0
"kqlpWrntoStr:value " 0
"file iostats dynamic seg " 0
"ksfd I/O slave ctx " 0
"KEWS statistic maps " 0
"KEWS statistic name " 0
"KEWS sysstat values " 0
"kebm slave message " 0
"ket (AutoTask) SGA " 0
"kcbl state objects " 25600
"kcfis state object " 0
"DDE_USER_INCIDENT_TYPE " 0
"KTCNC inv hashtable " 0
"knstoggall_knstsga " 0可以看到，搜索modification发现还有1M多可以用，但是分配44160字节就报错，很明显是有问题的，感觉像是bug，查看mos果然有发现：
ORA-4031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","sga heap(4,0)","modification ") (Doc ID 1675470.1)
Bug 18276481 - ORA-4031: UNABLE TO ALLOCATE 4160 BYTES OF SHARED MEMORY DUE TO HIGH PERM CHUNK是个和subpool相关的bug，根据文章修改隐藏参数后解决
alter system set "_enable_shared_pool_duration"=false sid='*' scope=spfile;
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
