Database Tuning (MOSC)

MOSC Banner

Shared pool low

in Database Tuning (MOSC) 9 commentsAnswered ✓

Hi team,


I have significant shared pool utilization in past few days in 12.1.0.2.0 EBS prod database.

Initially i had 2.1gb of shared_pool_size and SGA_TARGET size was 14.3GB. I have monitoring shell script which gives me current free space in shared pool.

Problem is that in last 3 days i had less then 10% free space of shared pool, so i track that growth and keep adding new size.

Currently i have these settings (SHARED POOL/SGA) after my actions:

shared_pool_reserved_size big integer 140928614 

shared_pool_size     big integer 3904M 


lock_sga           boolean   FALSE  

pre_page_sga         boolean   TRUE   

Tagged:

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