Database Administration (MOSC)

MOSC Banner

shared pool component "Remote agent" consumes 2+GB in v$sgastat

edited Sep 30, 2010 9:28AM in Database Administration (MOSC) 6 commentsAnswered
I've a 11.1.0.7 database on Solaris SPARC (64-bit) with NUMA that does not use ASMM, both SGA_target and Memory_target is set to 0, only pga_aggregate_target is set to 16GB.

shared_pool_size is set to 1.6G, however when querying v$sgastat it shows that almost 4GB is allocated for shared pool:

SQL> show parameter pool; 

NAME                                 TYPE                             VALUE 
------------------------------------ -------------------------------- ------------------------------ 
java_pool_size                       big integer                      256M 
large_pool_size                      big integer                      0 
olap_page_pool_size                  big integer                      0 
shared_pool_reserved_size            big integer                      140M 
shared_pool_size                     big integer                      1600M 
streams_pool_size                    big integer                      0 

SQL> select pool, sum(bytes) 

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