OERR: ORA-4031 "unable to allocate %s bytes of shared memory ("%s","%s","%s")" (文档 ID 4031.1)

APPLIES TO:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.1 [Release 9.2 to 11.2]
Information in this document applies to any platform.

PURPOSE

This article discusses the internal error "ORA-4031", what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance.

SCOPE

This note is intended for general audience as initial starting point for beginning diagnosis of ORA-4031.

DETAILS

Error: ORA 4031
Text: unable to allocate %s bytes of shared memory (%s,%s,%s)
-------------------------------------------------------------------------------
Cause: More shared memory is needed than was allocated in the shared
pool.
Action: If the shared pool is out of memory, either use the
DBMS_SHARED_POOL package to pin large packages,
reduce your use of shared memory, or increase the amount of
available shared memory by increasing the value of the
initialization parameters SHARED_POOL_RESERVED_SIZE and 
SHARED_POOL_SIZE.
If the large pool is out of memory, increase the initialization
parameter LARGE_POOL_SIZE.

Missed size request signified by %s bytes 

Arguments within parenthesis ("%s","%s","%s"):

First argument: SGA pool area such as Shared pool, Large pool, Java pool, Streams pool

Second argument: Code running at the time space request was made

Third and Fourth argument: Memory allocations being requested 

Known Bugs

You can restrict the list below to issues likely to affect one of the following versions by clicking the relevant button: 
             

NBBugFixedDescription 1775299512.1.0.2, 12.2.0.0ORA-4031 from explain of SQL with many subqueries and OR expansion 1703713012.1.0.2, 12.2.0.0Excess shared pool "PRTMV" memory use / ORA-4031 with partitioned tables 1681610311.2.0.4, 12.1.0.1.1, 12.1.0.2, 12.2.0.0XIN aborts with ORA-4031 due to memory leak in OCIXStreamInCommit 1671075311.2.0.4, 12.1.0.2, 12.2.0.0Excess shared pool memory use / ORA-4031 from DROP EDITION 1657178511.2.0.4, 12.1.0.2, 12.2.0.0High "KTC latch subh" SGA memory use due to "lobs commit callback" 1395145612.1.0.2, 12.2.0.0ASMCMD does not use bind variables in its SQL - affects shared pool 1600915811.2.0.3.BP19, 11.2.0.4, 12.1.0.1ORA-4031 / excess shared pool memory using Securefiles 1593175611.2.0.3.BP21, 11.2.0.4, 12.1.0.1ORA-4031 / Queries against SYS_FBA_TRACKEDTABLES not shared (do not use binds) 867373711.2.0.4, 12.1.0.1Diagnostic enhancement to summarize sub-pool allocations in ORA-4031 trace files 1405329811.1.0.6"kksss-heap" memory leak from PMON cleanup (ORA-4031) when audit enabled 1588100411.2.0.4, 12.1.0.1Excessive Memory usage with Extended Cursor Sharing 1429282511.2.0.3.BP10, 11.2.0.4, 12.1.0.1ORA-4031 in ASM as default memory parameters values for 11.2 ASM instances low 1402905011.2.0.2.BP18, 11.2.0.3.BP10, 11.2.0.4, 12.1.0.1MMAN failing to donate granules despite unused PGA (possible ORA-4031) 1400309011.2.0.3.8, 11.2.0.3.BP20, 11.2.0.4, 12.1.0.1ORA-4031 with high memory utilization in the 'init_heap_kfsg' subheap / "ASM map headers" under 'init_heap_kfsg' 1381473911.2.0.3.7, 11.2.0.3.BP19, 11.2.0.4, 12.1.0.1Excessive KQR X PO" allocations in a RAC environment (can cause ORA-4031) 1353697112.1.0.1ORA-4031 with large partition tables - superseded 1345657311.2.0.4, 12.1.0.1Many child cursors / ORA-4031 with large allocation in KGLH0 using extended cursor sharing 1343093811.2.0.3.4, 11.2.0.3.BP10, 11.2.0.4, 12.1.0.1ORA-4031 with high "KTC latch subh" memory usage 1325538811.2.0.4, 12.1.0.1Slow parsing of large number of subqueries eligible for coalescing. 1325024411.2.0.2.8, 11.2.0.2.BP18, 11.2.0.3.4, 11.2.0.3.BP10, 11.2.0.4, 12.1.0.1Shared pool leak of "KGLHD" memory when using multiple subpools 1307265411.2.0.3.8, 11.2.0.3.BP21, 11.2.0.4, 12.1.0.1Unnecessary ORA-4031 for "large pool","PX msg pool" from PQ slaves 1238796911.2.0.3, 12.1.0.1get_geometry() does not use bind variables internally leading to shared pool fragmentation 1178279011.2.0.3, 12.1.0.1Excess CPU & memory use / ORA-4030 / ORA-4031 parsing deeply nested queries 1165181011.2.0.2.3, 11.2.0.2.BP07, 11.2.0.3, 12.1.0.1ORA-4031 or Excess shared pool use can be seen by FileOpenBlock objects 1106319111.2.0.2.7, 11.2.0.2.BP17, 11.2.0.3.2, 11.2.0.3.BP04, 11.2.0.4, 12.1.0.1ORA-4031 with hint /*+ CURSOR_SHARING_EXACT */ - excessive "KKSSP^nn" memory 1063409611.2.0.3, 12.1.0.1excessive memory usage with grouping sets and temp table transformation 1035963111.2.0.3, 12.1.0.1High elapsed time and shared pool usage during parse with virtual columns 1032595311.2.0.3, 12.1.0.1ORA-600[733] / ORA-4031 allocating memory for hash join - superceded 1030890611.2.0.3, 12.1.0.1ORA-4031 using structured binary XMLIndex 1008933311.2.0.2.6, 11.2.0.2.BP15, 11.2.0.3, 12.1.0.1"init_heap_kfsg" memory leaks in SGA of db instance using ASM 1008227711.2.0.1.BP12, 11.2.0.2.3, 11.2.0.2.BP04, 11.2.0.3, 12.1.0.1Excessive allocation in PCUR or KGLH0 heap of "kkscsAddChildNo" (ORA-4031) 1004293711.2.0.3, 12.1.0.1High memory group in ges_cache_ress and ORA-4031 errors in RAC 957867011.2.0.1.BP11, 11.2.0.2.5, 11.2.0.2.BP09, 11.2.0.2.GIPSU05, 11.2.0.3, 12.1.0.1ORA-4031 from frequent Partition Maintenance Operation 940302611.2.0.2, 12.1.0.1Startup or PQ can report ORA-4031 errors requesting large "PX msg pool" chunks of memory 932013010.2.0.5.3, 11.2.0.2, 12.1.0.1ORA-4031 for "temporary tabl" using temporary table transformations (STAR / WITH) 901598311.2.0.1.1, 11.2.0.2, 12.1.0.1ORA-4031 for "temporary tabl" on query with star transformation 893445711.2.0.2, 12.1.0.1ORA-4031 during EXPLAIN PLAN or ORA-4030 during SELECT 883559111.2.0.2, 12.1.0.1Excess memory use parsing invalid SQL with COUNT() in subquery select list 881336611.1.0.7.3, 11.2.0.1.1, 11.2.0.1.BP04, 11.2.0.2, 12.1.0.1ORA-4031 due to over large granule size 853754411.2.0.2, 12.1.0.1Excess memory use / ORA-600 / dumps parsing SQL with many nested outer joins / ANSI joins 750945111.2.0.3.7, 11.2.0.3.BP19, 11.2.0.4, 12.1.0.1SGA memory leak possible for "KSN WaitID" memory when using shared servers 1354839011.2.1.8.8Error 4031 in kgttusec - plsql memory > 1g unreliable 902600811.2.0.1.BP02, 11.2.0.2, 12.1.0.1"GES_RESOURCES" may increase over time with high enqueue activity 905890011.2.0.1.BP10, 11.2.0.2OERI [kcbi_get_bhs_4] / "Shared IO Pool" takes too much SGA memory 859947711.1.0.7.3, 11.2.0.1Large "kcbi io desc" shared pool allocations can lead to ORA-4031 852817110.2.0.5.6, 11.1.0.7.10, 11.2.0.1High shared pool use due to frequent ADD/EXCHANGE partition operations 837188410.2.0.5, 11.2.0.1Dumps/Errors/Excessive Parse Time and Memory allocation with Star transformation 824473410.2.0.5, 11.1.0.7.8, 11.2.0.1NUMA Pool misconfigured at startup (ORA-4031) 822142511.1.0.7.2, 11.2.0.1ORA-4031 with kgs-heap overusing one subpool 746246310.2.0.5, 11.2.0.1R-tree Index based spatial query on large table fails with ORA-4031 / ORA-7445 [kghualloc] 744380811.2.0.1Excessive Shared Memory utilization during Query Parsing 734044810.2.0.4.1, 10.2.0.5, 11.1.0.7.1, 11.2.0.1Excess shared pool memory use / ORA-4031 from REGEXP_LIKE - superceded 725018211.2.0.1Excess shared pool memory for AQ ("kwqiccns: notification st" chunks) 720792110.2.0.5, 11.2.0.1State object leak / ORA-4031 from stale guess DBAs on secondary IOT index 703162210.2.0.5, 11.2.0.1Spin on kkojnp / ORA-600 [15160] with Star transformation 686808010.2.0.5, 11.1.0.7, 11.2.0.1ORA-4031 with NUMA 685806210.2.0.4.1, 10.2.0.5, 11.1.0.7.5, 11.2.0.1Shared pool memory leak when services created / deleted 680050710.2.0.4.1, 10.2.0.5, 11.1.0.7, 11.2.0.1Shared pool memory leak ("ksws service *" memory) using EXPDP often 673056710.2.0.5, 11.2.0.1ORA-4031 / OERI [17137] with NUMA optimization enabled 662401111.1.0.7, 11.2.0.1ORA-4030 / ORA-4031 on startup with > 4Gb SGA_TARGET 653086110.2.0.5, 11.2.0.1ORA-4301 when using stored Java 633455210.2.0.4, 11.1.0.7, 11.2.0.1Hang / ORA-4031 / OERI:kfrcsoDelete_3 on rollback of ASM file resize 627159010.2.0.4.2, 10.2.0.5, 11.1.0.7, 11.2.0.1SGA subheap imbalance with lots of free memory in a few subheaps 608616211.2.0.1Slow parsing / Excessive Memory Usage with Star Transformation and Query Rewrite 612641511.1.0.7OERI [kjccgmb:1] during shutdown instance 601118210.2.0.4, 11.1.0.7Parsing of large query takes long time / memory leak / ORA-4030 /4031 538698610.2.0.4, 11.1.0.7Leak / ORA-4031 leak when DROP UNUSED COLUMN issued on large partitioned table 13888380 ORA-4031 in DB instance when using ASM due to high use of "init_heap_kfsg" memory 10363436 Memory leak / ORA-4031 using TDE column encryption with PKI keys 1280869611.1.0.6Shared pool memory leak of "hng: All sessi" memory 730691510.2.0.4.4, 10.2.0.5, 11.1.0.6EXCHANGE PARTITION leaks "KGL handles" shared pool memory 604305210.2.0.4, 11.1.0.6Leak in perm allocations with "library cache" comments (ORA-4031) 600161710.2.0.4, 11.1.0.6LCK may accumulate CPU time / ORA-4031 possible 595070810.2.0.4, 11.1.0.6'gcs resources' and 'gcs shadows' are imbalanced across shared pool subpools 561804910.2.0.4, 11.1.0.6"mvobj part des" leaked memory after partition DDL (ORA-4031) 557323810.2.0.4, 11.1.0.6Shared pool memory use / ORA-4031 due to "obj stat memo" in one subpool 554851010.2.0.4, 11.1.0.6_FIX_CONTROL parameter leaks memory in the shared pool 554838910.2.0.4, 11.1.0.6Library cache allocation for 'column mapping' not using uniform sized extents 550850510.2.0.4, 11.1.0.6ORA-4031 while shared heap still has unused reserved extents 547917210.2.0.4, 11.1.0.6ORA-4031 with multiple partially-allocated permanent chunks 537797310.2.0.4, 11.1.0.6Register schema fails with ORA-4031 524026411.1.0.6ORA-4030 / ORA-4031 / Excessive Memory Usage with view merging and large IN LISTs. 499495610.2.0.3, 11.1.0.6Number of configured shared pool subpools not correct 446705810.2.0.4, 11.1.0.6IO requests can flush the pool / signal a hidden ORA-4031 error 35198079.2.0.8, 10.1.0.5, 10.2.0.2, 11.1.0.6ORA-4031 querying V$SEGSTAT 329172310.2.0.3, 11.1.0.6DBWR may crash instance if shared pool memory low 6347725 "obj stat mem" leak when global temporary tables used 41951759.2.0.7, 10.1.0.5, 10.2.0.1Create MVIEW with large WHERE clause may dump / ORA-4031 418429810.1.0.5, 10.2.0.1Subpool imbalance for "session parameters" can lead to ORA-4031 39483849.2.0.7, 10.1.0.4, 10.2.0.1ORA-4031 possible using LGWR ASYNC for archiving 351342710.1.0.3, 10.2.0.1ORA-4031 can cause many SGA heapdumps to occur causing shared pool latch contention 341939610.2.0.1Restore spfile with dummy instance from ASM fails with RMAN-20001 / ORA-4031 34052379.2.0.6, 10.1.0.3, 10.2.0.1ORA-4031 / excessing SGA consumption due to large IN LIST and NOT IN list 335649210.2.0.1DBMS_LOB.LOADFROMFILE leaks library cache locks / shared pool "perm" memory 32994079.2.0.6, 10.1.0.3, 10.2.0.1Invalidating cursors frequently can fragment the SGA and leak "kglau" memory 304672510.2.0.1ORA-4031 due to shared_pool fragmented with high ges resources & enqueues 29539319.2.0.4, 10.2.0.1ORA-4031 parsing query with numerous groupings*46581889.2.0.8Long waits for "ksu process alloc latch yield" 42319219.2.0.8, 10.1.0.2Truncate partition tables leaks SGA memory 32324019.2.0.5, 10.1.0.2ORA-4031 with Streams apply site+31507059.2.0.5, 10.1.0.2Fix to help reduce the chances of an ORA-4031 with high OPEN_CURSORS 31506809.2.0.5, 10.1.0.2Excessive shared pool permanent memory use / ORA-4031 possible with SESSION_CACHED_CURSORS 308381810.1.0.2Reloaded cursors can leak shared pool memory 30776519.2.0.5, 10.1.0.2LOB manipulation can leak "buffer" state objects causing hangs/shared pool problems 284613810.1.0.2Dump (under opiosq0) from SVRMGRL sessions when shared pool is full 28177289.2.0.4, 10.1.0.2Shared pool memory leak / ORA-4031 when collecting segment statistics 28047249.2.0.4, 10.1.0.2Out of memory in JAVA POOL shows an ORA-4031 "shared pool" message 27988519.2.0.4, 10.1.0.2ORA-4031 possible from SMON during SHUTDOWN or STARTUP 27930389.2.0.4, 10.1.0.2Session may die with ORA-4031 if shared pool exhausted when storing object level statistics 27869689.2.0.4, 10.1.0.2Shared pool memory leak / ORA-4031 on repeated invalidate/execute of cursors 26070299.2.0.3, 10.1.0.2High memory use optimizing SQL with functional indexes and many expressions 25867629.2.0.3, 10.1.0.2Direct LOB reads can result in ORA-4031 / excessive shared pool usage 25633019.2.0.5, 10.1.0.2ORA-4031 possible in RAC environment under load 25611159.2.0.5, 10.1.0.2SGA memory growth using outbound TCP/IP database links from shared servers 25231519.2.0.3, 10.1.0.2ORA-7445[updexe] with AUDIT_TRAIL=DB with stressed shared pool 25015919.2.0.3, 10.1.0.2ORA-928 / ORA-4031 on "ALTER VIEW <sys_view> COMPILE" if REMOTE objects exist with same name 24869549.2.0.3, 10.1.0.2ORA-4031 / Dump from concurrent DGURIServlet access to SQLX XMLType view 23518549.0.1.4, 9.2.0.2, 10.1.0.2Dispatchers may hang if ORA-4031 occurs 17823819.2.0.5, 10.1.0.2Excessive SGA use / ORA-4031 possible with large number of JOBS 28053359.2.0.4Excessive shared pool memory use for parse of certain statments using functional indexes 24420429.2.0.5ORA-4031 possible using STREAMS on multi-cpu machine 24725419.2.0.2PMON ORA-7445 [kghxfr] after shared server gets ORA-4031 22447899.0.1.4, 9.2.0.1ORA-4031 / excessive shared pool usage from query with full outer join / union 22446429.0.1.4, 9.2.0.1ALTER VIEW operations may encounter ORA-4031 errors 22085708.1.7.4, 9.0.1.4, 9.2.0.1ORA-4030 / ORA-4031 / spin during query optimization with STAR TRANSFORMATION and unmergable view 21852949.2.0.1Shared server may dump (koklhfr) after ORA-4031 in "LARGE POOL" 21673269.0.1.3, 9.2.0.1ORA-4031 possible during patch set upgrade scripts 21436379.0.1.3, 9.2.0.1ORA-4031 possible starting the cache advisory 21291788.1.7.4, 9.0.1.3, 9.2.0.1Using NULL or an empty string ('') in an INLIST can cause ORA-4031 / waste shared pool memory 21040718.1.7.4, 9.0.1.3, 9.2.0.1ORA-4031 / excessive "miscellaneous" shared pool use possible (many PINS) 18659178.1.7.3, 9.0.1.2, 9.2.0.1ORA-4031 / high CPU from OR expansion of negated predicates with RBO 13335268.1.7.3, 9.0.1.2, 9.2.0.1ORA-4031 / Poor performance using persistent Object data types 16429649.0.1.0ORA-4031 / sga leak from IOT as inner table in NESTED LOOP 16405838.1.7.1, 9.0.1.0ORA-4031 due to leak / cache buffer chain contention from AND-EQUAL access+13976038.1.7.2, 9.0.1.0ORA-4031 / SGA memory leak of PERMANENT memory for buffer handles 13966758.1.7.2, 9.0.1.0PLSQL may hang/spin/ORA-4031 with SQL WHERE (a,b) in ( (c1,d1),(c2,d2)... ) 13407188.1.7.2, 9.0.1.0OERI:KCBSTC_PARENT_AB possible in CKPT following an ORA-4031 error 13485018.1.6.3, 8.1.7.0MV refresh unnecessarily invalidates shared cursors 13287098.0.6.2, 8.1.6.3, 8.1.7.0OERI:15428 can be raised when ORA-4031 is hit internally 12560118.0.6.2, 8.1.6.2, 8.1.7.0MTS servers may OERI:1113 after an ORA-4031 (OERI:730 on 8i) 10926218.1.6.2, 8.1.7.0ORA-4031 when DROPPING a PARTITION 8987988.1.5.1, 8.1.6.0ORA-4031 on startup from large DB_BLOCK_BUFFERS (or GC_RELEASABLE_LOCKS) 4313037.3.3.1, 7.3.4.0Startup gives ORA-4031 with GC_DB_LOCKS=157K

• '*' indicates that an alert exists for that issue.
• '+' indicates a particularly notable issue / bug.
• 'P' indicates a port specific bug.
• "OERI:xxxx" may be used as shorthand for ORA-600 [xxxx].

REFERENCES

NOTE:431303.8 - Bug 431303 - Startup gives ORA-4031 with GC_DB_LOCKS=157K
NOTE:5573238.8 - Bug 5573238 - Shared pool memory use / ORA-4031 due to "obj stat memo" in one subpool
NOTE:7031622.8 - Bug 7031622 - Spin on kkojnp / ORA-600 [15160] with Star transformation
NOTE:7207921.8 - Bug 7207921 - State object leak / ORA-4031 from stale guess DBAs on secondary IOT index
NOTE:2804724.8 - Bug 2804724 - Out of memory in JAVA POOL shows an ORA-4031 "shared pool" message
NOTE:2805335.8 - Bug 2805335 - Excessive shared pool memory use for parse of certain statments using functional indexes
NOTE:2817728.8 - Bug 2817728 - Shared pool memory leak / ORA-4031 when collecting segment statistics
NOTE:2846138.8 - Bug 2846138 - Dump (under opiosq0) from SVRMGRL sessions when shared pool is full
NOTE:2953931.8 - Bug 2953931 - ORA-4031 parsing query with numerous groupings
NOTE:1642964.8 - Bug 1642964 - ORA-4031 / sga leak from IOT as inner table in NESTED LOOP
NOTE:5618049.8 - Bug 5618049 - "mvobj part des" leaked memory after partition DDL (ORA-4031)
NOTE:5950708.8 - Bug 5950708 - 'gcs resources' and 'gcs shadows' are imbalanced across shared pool subpools
NOTE:6001617.8 - Bug 6001617 - LCK may accumulate CPU time / ORA-4031 possible
NOTE:2129178.8 - Bug 2129178 - Using NULL or an empty string ('') in an INLIST can cause ORA-4031 / waste shared pool memory
NOTE:2143637.8 - Bug 2143637 - ORA-4031 possible starting the cache advisory
NOTE:6858062.8 - Bug 6858062 - Shared pool memory leak when services created / deleted
NOTE:10042937.8 - Bug 10042937 - High memory group in ges_cache_ress and ORA-4031 errors in RAC
NOTE:10082277.8 - Bug 10082277 - Excessive allocation in PCUR or KGLH0 heap of "kkscsAddChildNo" (ORA-4031)
NOTE:1865917.8 - Bug 1865917 - ORA-4031 / high CPU from OR expansion of negated predicates with RBO
NOTE:2104071.8 - Bug 2104071 - ORA-4031 / excessive "miscellaneous" shared pool use possible (many PINS)
NOTE:6011182.8 - Bug 6011182 - Parsing of large query takes long time / memory leak / ORA-4030 /4031
NOTE:6043052.8 - Bug 6043052 - Leak in perm allocations with "library cache" comments (ORA-4031)
NOTE:6086162.8 - Bug 6086162 - Slow parsing / Excessive Memory Usage with Star Transformation and Query Rewrite
NOTE:6126415.8 - Bug 6126415 - OERI [kjccgmb:1] during shutdown instance
NOTE:6271590.8 - Bug 6271590 - SGA subheap imbalance with lots of free memory in a few subheaps
NOTE:6334552.8 - Bug 6334552 - Hang / ORA-4031 / OERI:kfrcsoDelete_3 on rollback of ASM file resize
NOTE:6347725.8 - Bug 6347725 - "obj stat mem" leak when global temporary tables used
NOTE:10634096.8 - Bug 10634096 - excessive memory usage with grouping sets and temp table transformation

NOTE:2167326.8 - Bug 2167326 - ORA-4031 possible during patch set upgrade scripts
NOTE:2185294.8 - Bug 2185294 - Shared server may dump (koklhfr) after ORA-4031 in "LARGE POOL"
NOTE:2208570.8 - Bug 2208570 - ORA-4030 / ORA-4031 / spin during query optimization with STAR TRANSFORMATION and unmergable view
NOTE:2244642.8 - Bug 2244642 - ALTER VIEW operations may encounter ORA-4031 errors
NOTE:2244789.8 - Bug 2244789 - ORA-4031 / excessive shared pool usage from query with full outer join / union
NOTE:2351854.8 - Bug 2351854 - Dispatchers may hang if ORA-4031 occurs
NOTE:2442042.8 - Bug 2442042 - ORA-4031 possible using STREAMS on multi-cpu machine
NOTE:3046725.8 - Bug 3046725 - ORA-4031 due to shared_pool fragmented with high ges resources & enqueues
NOTE:2472541.8 - Bug 2472541 - PMON ORA-7445 [kghxfr] after shared server gets ORA-4031
NOTE:2486954.8 - Bug 2486954 - ORA-4031 / Dump from concurrent DGURIServlet access to SQLX XMLType view
NOTE:2501591.8 - Bug 2501591 - ORA-928 / ORA-4031 on "ALTER VIEW COMPILE" if REMOTE objects exist with same name
NOTE:2523151.8 - Bug 2523151 - ORA-7445[updexe] with AUDIT_TRAIL=DB with stressed shared pool
NOTE:2561115.8 - Bug 2561115 - SGA memory growth using outbound TCP/IP database links from shared servers
NOTE:2563301.8 - Bug 2563301 - ORA-4031 possible in RAC environment under load
NOTE:2586762.8 - Bug 2586762 - Direct LOB reads can result in ORA-4031 / excessive shared pool usage
NOTE:3077651.8 - Bug 3077651 - LOB manipulation can leak "buffer" state objects causing hangs/shared pool problems
NOTE:3083818.8 - Bug 3083818 - Reloaded cursors can leak shared pool memory
NOTE:3150680.8 - Bug 3150680 - Excessive shared pool permanent memory use / ORA-4031 possible with SESSION_CACHED_CURSORS
NOTE:3150705.8 - Bug 3150705 - Fix to help reduce the chances of an ORA-4031 with high OPEN_CURSORS
NOTE:7509451.8 - Bug 7509451 - SGA memory leak possible for "KSN WaitID" memory when using shared servers
NOTE:8221425.8 - Bug 8221425 - ORA-4031 with kgs-heap overusing one subpool

NOTE:6868080.8 - Bug 6868080 - ORA-4031 with NUMA
NOTE:11782790.8 - Bug 11782790 - Excess CPU & memory use / ORA-4030 / ORA-4031 parsing deeply nested queries
NOTE:12387969.8 - Bug 12387969 - get_geometry() does not use bind variables internally leading to shared pool fragmentation
NOTE:8599477.8 - Bug 8599477 - Large "kcbi io desc" shared pool allocations can lead to ORA-4031
NOTE:8813366.8 - Bug 8813366 - ORA-4031 due to over large granule size
NOTE:8835591.8 - Bug 8835591 - Excess memory use parsing invalid SQL with COUNT() in subquery select list
NOTE:9026008.8 - Bug 9026008 - "GES_RESOURCES" may increase over time with high enqueue activity
NOTE:7250182.8 - Bug 7250182 - Excess shared pool memory for AQ ("kwqiccns: notification st" chunks)
NOTE:9058900.8 - Bug 9058900 - OERI [kcbi_get_bhs_4] / "Shared IO Pool" takes too much SGA memory
NOTE:9320130.8 - Bug 9320130 - ORA-4031 for "temporary tabl" using temporary table transformations (STAR / WITH)
NOTE:9403026.8 - Bug 9403026 - Startup or PQ can report ORA-4031 errors requesting large "PX msg pool" chunks of memory
NOTE:10325953.8 - Bug 10325953 - ORA-600[733] / ORA-4031 allocating memory for hash join - superceded
NOTE:10359631.8 - Bug 10359631 - High elapsed time and shared pool usage during parse with virtual columns
NOTE:10363436.8 - Bug 10363436 - Memory leak / ORA-4031 using TDE column encryption with PKI keys
NOTE:7443808.8 - Bug 7443808 - Excessive Shared Memory utilization during Query Parsing
NOTE:7462463.8 - Bug 7462463 - R-tree Index based spatial query on large table fails with ORA-4031 / ORA-7445 [kghualloc]
NOTE:8934457.8 - Bug 8934457 - ORA-4031 during EXPLAIN PLAN or ORA-4030 during SELECT
NOTE:1348501.8 - Bug 1348501 - MV refresh unnecessarily invalidates shared cursors
NOTE:13548390.8 - Bug 13548390 - Error 4031 in kgttusec - plsql memory > 1g unreliable
NOTE:1782381.8 - Bug 1782381 - Excessive SGA use / ORA-4031 possible with large number of JOBS
NOTE:3948384.8 - Bug 3948384 - ORA-4031 possible using LGWR ASYNC for archiving
NOTE:9578670.8 - Bug 9578670 - ORA-4031 from frequent Partition Maintenance Operation
NOTE:1396675.8 - Bug 1396675 - PLSQL may hang/spin/ORA-4031 with SQL WHERE (a,b) in ( (c1,d1),(c2,d2)... )
NOTE:1397603.8 - Bug 1397603 - ORA-4031 / SGA memory leak of PERMANENT memory for buffer handles
NOTE:146599.1 - Diagnosing and Resolving Error ORA-04031 on the Shared Pool or Other Memory Pools [Video]
NOTE:1640583.8 - Bug 1640583 - ORA-4031 due to leak / cache buffer chain contention from AND-EQUAL access
NOTE:3232401.8 - Bug 3232401 - ORA-4031 with Streams apply site
NOTE:3291723.8 - Bug 3291723 - DBWR may crash instance if shared pool memory low
NOTE:3299407.8 - Bug 3299407 - Invalidating cursors frequently can fragment the SGA and leak "kglau" memory
NOTE:3513427.8 - Bug 3513427 - ORA-4031 can cause many SGA heapdumps to occur causing shared pool latch contention
NOTE:3405237.8 - Bug 3405237 - ORA-4031 / excessing SGA consumption due to large IN LIST and NOT IN list
NOTE:3419396.8 - Bug 3419396 - Restore spfile with dummy instance from ASM fails with RMAN-20001 / ORA-4031
NOTE:3519807.8 - Bug 3519807 - ORA-4031 querying V$SEGSTAT
NOTE:13430938.8 - Bug 13430938 - ORA-4031 with high "KTC latch subh" memory usage
NOTE:11063191.8 - Bug 11063191 - ORA-4031 with hint /*+ CURSOR_SHARING_EXACT */ - excessive "KKSSP^nn" memory
NOTE:7306915.8 - Bug 7306915 - EXCHANGE PARTITION leaks "KGL handles" shared pool memory
NOTE:11651810.8 - Bug 11651810 - ORA-4031 or Excess shared pool use can be seen by FileOpenBlock objects
NOTE:1333526.8 - Bug 1333526 - ORA-4031 / Poor performance using persistent Object data types
NOTE:7340448.8 - Bug 7340448 - Excess shared pool memory use / ORA-4031 from REGEXP_LIKE - superceded
NOTE:898798.8 - Bug 898798 - ORA-4031 on startup from large DB_BLOCK_BUFFERS (or GC_RELEASABLE_LOCKS)
NOTE:1092621.8 - Bug 1092621 - ORA-4031 when DROPPING a PARTITION
NOTE:2786968.8 - Bug 2786968 - Shared pool memory leak / ORA-4031 on repeated invalidate/execute of cursors
NOTE:2793038.8 - Bug 2793038 - Session may die with ORA-4031 if shared pool exhausted when storing object level statistics
NOTE:2798851.8 - Bug 2798851 - ORA-4031 possible from SMON during SHUTDOWN or STARTUP
NOTE:2607029.8 - Bug 2607029 - High memory use optimizing SQL with functional indexes and many expressions
NOTE:1256011.8 - Bug 1256011 - MTS servers may OERI:1113 after an ORA-4031 (OERI:730 on 8i)
NOTE:13250244.8 - Bug 13250244 - Shared pool leak of "KGLHD" memory when using multiple subpools
NOTE:10089333.8 - Bug 10089333 - "init_heap_kfsg" memory leaks in SGA of db instance using ASM
NOTE:10308906.8 - Bug 10308906 - ORA-4031 using structured binary XMLIndex
NOTE:13255388.8 - Bug 13255388 - Slow parsing of large number of subqueries eligible for coalescing.
NOTE:1328709.8 - Bug 1328709 - OERI:15428 can be raised when ORA-4031 is hit internally
NOTE:8244734.8 - Bug 8244734 - NUMA Pool misconfigured at startup (ORA-4031)
NOTE:8371884.8 - Bug 8371884 - Dumps/Errors/Excessive Parse Time and Memory allocation with Star transformation
NOTE:8528171.8 - Bug 8528171 - High shared pool use due to frequent ADD/EXCHANGE partition operations
NOTE:8537544.8 - Bug 8537544 - Excess memory use / ORA-600 / dumps parsing SQL with many nested outer joins / ANSI joins
NOTE:9015983.8 - Bug 9015983 - ORA-4031 for "temporary tabl" on query with star transformation

NOTE:1340718.8 - Bug 1340718 - OERI:KCBSTC_PARENT_AB possible in CKPT following an ORA-4031 error
NOTE:4658188.8 - Bug 4658188 - Long waits for "ksu process alloc latch yield"
NOTE:4994956.8 - Bug 4994956 - Number of configured shared pool subpools not correct
NOTE:5479172.8 - Bug 5479172 - ORA-4031 with multiple partially-allocated permanent chunks
NOTE:5240264.8 - Bug 5240264 - ORA-4030 / ORA-4031 / Excessive Memory Usage with view merging and large IN LISTs.
NOTE:5508505.8 - Bug 5508505 - ORA-4031 while shared heap still has unused reserved extents
NOTE:5548389.8 - Bug 5548389 - Library cache allocation for 'column mapping' not using uniform sized extents
NOTE:5377973.8 - Bug 5377973 - Register schema fails with ORA-4031
NOTE:5548510.8 - Bug 5548510 - _FIX_CONTROL parameter leaks memory in the shared pool
NOTE:5386986.8 - Bug 5386986 - Leak / ORA-4031 leak when DROP UNUSED COLUMN issued on large partitioned table
NOTE:396940.1 - Troubleshooting and Diagnosing ORA-4031 Error [Video]
NOTE:4184298.8 - Bug 4184298 - Subpool imbalance for "session parameters" can lead to ORA-4031
NOTE:3356492.8 - Bug 3356492 - DBMS_LOB.LOADFROMFILE leaks library cache locks / shared pool "perm" memory
NOTE:4195175.8 - Bug 4195175 - Create MVIEW with large WHERE clause may dump / ORA-4031
NOTE:4231921.8 - Bug 4231921 - Truncate partition tables leaks SGA memory
NOTE:4467058.8 - Bug 4467058 - IO requests can flush the pool / signal a hidden ORA-4031 error
NOTE:6530861.8 - Bug 6530861 - ORA-4301 when using stored Java
NOTE:6624011.8 - Bug 6624011 - ORA-4030 / ORA-4031 on startup with > 4Gb SGA_TARGET
NOTE:6730567.8 - Bug 6730567 - ORA-4031 / OERI [17137] with NUMA optimization enabled
NOTE:6800507.8 - Bug 6800507 - Shared pool memory leak ("ksws service *" memory) using EXPDP often

  

相关内容

   

 

产品

   

• Oracle Database Products > Oracle Database > Oracle Database > Oracle Database - Enterprise Edition > RDBMS

 

关键字

   

BUGTAG_ADDBUGS

 

错误

   

4031 ERROR;ORA-4031;ORA-4301