ORA-04033: Insufficient memory to grow pool

 I am trying to expand by shared_pool size and I get the below error.

ERROR:-

SQL> alter system set streams_pool_size =300M scope=both;

alter system set streams_pool_size =300M scope=both

ERROR at line 1:

ORA-02097: parameter cannot be modified because specified value is invalid

ORA-04033: Insufficient memory to grow pool

Verify:-

 you do not have enough RAM allocated to the SGA to allow you to create a 300M shared pool. 

[root@ora ~]# free -g

              total        used        free      shared  buff/cache   available

Mem:             14           9           1           0           3           2

Swap:            15           2          13

[root@ora ~]#

SQL> show parameter sga_max_size;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

sga_max_size                         big integer 1G

SQL>

Solution :-

Specify a smaller value to grow the pool.

SQL> alter system set streams_pool_size =200M scope=both;

System altered.

SQL> show parameter streams_pool_size;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

streams_pool_size                    big integer 200M

SQL>