shared_pool_size and stream_pool_size

SQL> show parameter sga_max_size ;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 1G

SQL> show parameter sga_target;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_target big integer 900M

SQL> show parameter pool;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_keep string
buffer_pool_recycle string
global_context_pool_size string
java_pool_size big integer 0
large_pool_size big integer 0
olap_page_pool_size big integer 0
shared_pool_reserved_size big integer 30M
shared_pool_size big integer 600M
streams_pool_size big integer 252M


If you  want to increase streams_pool_size by this command.

alter system set STREAMS_POOL_SIZE =16M sid = 'orcl';