设为首页 加入收藏

TOP

ParallelQuery导致的ORA-04031(二)
2015-01-22 21:28:28 】 浏览:10188
Tags:ParallelQuery 导致 ORA-04031
60 "PRTI " 0 "SQLP " 53608 "SQLK " 28336 "gcs dynamic r " 2556288 "work area tab " 236640 "plwpil:wa " 0 "kebm run-once actions " 0 "grptab_kfgsg " 0 "AW SGA " 0 "dbktb: trace buffer " 53673984 "v_swperrcount " 0 "ksunfy : SSO free list " 27834240 "ksxp IPC state object " 346448 "ksdhng: cache history " 0 "DFW_CONFIG_CAPTURE " 0 "enqueue resources " 862232 "kzekm heap descriptor " 0 "kelt translation table " 0 "IPS_PACKAGE_UNPACK_HISTOR" 0 "kglsim hash table bkts " 2097152 "KSXR global channels " 0 "ges enqueues " 344980144 "trace buf hdr xtend " 2080 "KSXR receive buffers " 1061888 "kglsim Java timestamps " 131072 "VM OSD context " 0 "KCB Table Scan Buffer " 4194816 "knlp receive buffers " 0 "PLS chunk " 0 "knlu_init_btree:init " 0 "KEWS aggregation objs " 0 "DDE_USER_ACTION_DEF " 0 "keswxNotify:tabPlans " 131072 "EM_USER_ACTIVITY " 0 "KSXR large reply queue " 168296 "event-class map " 0 "KSQ event description " 0 "KSXP CONN Stats buffer " 728432 "KSXP CTX Stats buffer " 578128 "KSXP PORT Stats buffer " 142768 "kglsim alloc latches " 0 "kglsim used list arr " 0 "kglsim free obj list " 0 "KTCN global operators " 0 "KESTB existence bitvec " 131072 "KFD extent enqueue obj " 42792 "ksdhng: el wtr cache " 401280 "ksb cic process list " 0 "gcs shadows " 130592800 "value block f " 43832 "ksdhng: blkers cache " 72960 "FileOpenBlock " 255011680 "qmtb_init_xxta " 0 "sort segment handle " 54936 "latchnum to latch map " 0 "LISTEN ADDRESS ENTRY " 0 "vips_pkg_file " 0 "PX msg pool " 47109312 +++++ 当前PX msg pool已经分配了47M左右 。。。。。。 "Checkpoint queue " 116765184 "sim segment hits " 72960 "sim lru segments " 72960 "pesom.c:Global " 0 "peshm.c:Global " 0 "paralltp txn r " 22476896 "ASH buffers " 119537664 "ASM KFFD SO " 0 "statement queuing " 0 "v_actinc " 0 "message pool freequeue " 523240 "ADR_CONTROL " 0 "vshowincb " 0 "vproblem2 " 0 "PMON blockers " 0 "procs: ksunfy " 6408000 "sga listelement " 0 "primem_kfmdsg " 0 "agent name " 0 "SYSTEM PARAMETERS " 232944 "Online xxtafile Move sess" 0 "sched job queue " 0 "vproblem " 0 "object queue hash buckets" 8404992 "object queue hash table d" 229824 "obj stats allocation chun" 1290240 "qmnsf_heap " 0 "sim cache nbufs " 0 "qmu subheap " 53976 "MTTR advisory context " 0 "LGWR-network Server info " 34032 "LGWR debug module memory " 0 "logout storm management " 0 "log_simultaneous_copies " 49248 "sys event stats " 552960 "parameter handle " 4273688 "Parameter Handle " 0 "name-service recovery " 80776 "channel handle " 48360 "parameter blocks " 22016 "qmrcInitSGA:qmrcSGA " 0 "PARAMETER ENTRY " 0 "ASM map operations " 30552 "Security Class " 33280 "GCR " 0 "post/wait queues " 55872 "bloom filter " 0 "Auto tune undo info " 0 "pesldT03_Instance " 33848 "cp pool array " 0 "cp cmon array " 0 "UNDO INFO " 0 "Log Archive Config Contex" 0 "state objects " 107440104 "ArchLog Dest Array " 22784 "parallel kcbibr " 0 "archive_lag_target " 0 "poisoned memory " 32768 "name-service request " 0 "latch recovery structures" 0 "latches for protecting fs" 0 "latches for protecting ls" 0 "Label Cache Heap descrptr" 0 "cp connection " 0 "sched job slv " 0 "bt_subentry " 0 "Saved job ids " 0 "object level stat table " 0 "pso tbs: ksunfy " 780000 "dummy " 0 "qm_init_sga:qmdpsg " 0 "analytic workspace " 0 "sim trace buf " 0 "qm_init_sga:oidctx " 0 "Sort Segment " 16852160 "PRESENTATION ENTRY " 0 "cp srv array " 0 "recov_kgqbtctx " 26512 "dbkea sga " 0 "pesom.c:latch array " 0 "Banner Storage " 0 "qmps connections " 6
首页 上一页 1 2 3 4 下一页 尾页 2/4/4
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇Oracle11g字符集AL32UTF8修改为ZH.. 下一篇oraclehintinlinematerialize

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目