Database Tuning (MOSC)

MOSC Banner

Shared Pool on statspack report not what is set in shared_pool_size

Oracle Database 19C (19.13) on Linux

I'm trying to understand what I should be tuning to affect my shared pool size.

Here are some of the parameters that are currently set:

memory_max_target		0
memory_target 			0

lock_sga			FALSE
pre_page_sga			TRUE
sga_max_size			34359738368	(32G)
sga_min_size			0
sga_target			30064771072	(28G)
unified_audit_sga_queue_size 	1048576 

shared_pool_size		4294967296	(4G)
shared_pool_reserved_size	429496728

When I run my statspack report I see:

...
Cache Sizes      Begin    End
~~~~~~~~~~~    ---------- ----------
  Buffer Cache:   6,080M       Std Block Size:     8K
   Shared Pool:  16,256M         Log Buffer:   4,096K	
...

I have a few questions:

  • How is the actual shared pool size of 16G getting calculated?

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