SQL PROD|SYS> select value from v$parameter where name = 'sort_area_size';

VALUE
----------
512000

1 row selected.

SQL PROD|SYS> alter session set sort_area_size = 33554432;

Session altered.

SQL PROD|SYS> select value from v$parameter where name = 'sort_area_size';

VALUE
----------
33554432

1 row selected.

SQL PROD|SYS>