Database Memory & 4030/4031 (MOSC)

MOSC Banner

Hi , im getting ORA-04031: unable to allocate 2072 bytes of shared memory ("shared pool","unknown o

edited May 26, 2016 9:41AM in Database Memory & 4030/4031 (MOSC) 6 commentsAnswered ✓

Hellow im getting

ORA-04031: unable to allocate 2072 bytes of shared memory ("shared pool","unknown object","sga heap(1,1)","parameter table block")

OS: SunOS

Version :11.2.0.4.0

==============================================

TOP 10 MEMORY USES FOR SGA HEAP SUB POOL 1

----------------------------------------------

"free memory               "         97 MB 29%

"event statistics per sess "         19 MB  6%

"ksunfy : SSO free list    "         18 MB  5%

Memory parameters:

####################

[0004]: __shared_pool_size=1694498816

[0004]: __large_pool_size=134217728

[0004]: large_pool_size=100663296     - > 100MB

[0004]: __java_pool_size=67108864

[0004]: java_pool_size=67108864       -> 67 MB

[0004]: __streams_pool_size=0

[0004]: _shared_pool_reserved_pct=10

[0004]: __sga_target=1375731712

[0004]: memory_target=2097152000      - > 2GB

[0004]: memory_max_target=2566914048  - > 2.5GB

[0004]: __db_cache_size=536870912

[0004]: db_cache_size=536870912          - > 536 MB

[0004]: __pga_aggregate_target=721420288 - 721 MB

LIBRARY CACHE STATISTICS:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center