SQL>
SQL> DECLARE
2 lv_sql_txt VARCHAR2(200);
3 BEGIN
4 EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE=TRUE';
5 lv_sql_txt := 'ALTER SESSION SET SORT_AREA_SIZE = 1000000';
6 EXECUTE IMMEDIATE lv_sql_txt;
7 END;
8 /
PL/SQL procedure successfully completed.
SQL>