SQL> show parameter pga
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ pga_aggregate_target big integer 107374182 SQL> alter system set pga_aggregate_target=150m;
System altered.
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ pga_aggregate_target big integer 150M