Database Memory & 4030/4031 (MOSC)

MOSC Banner

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

edited Oct 7, 2010 2:04AM in Database Memory & 4030/4031 (MOSC) 4 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