alter session file to set parallelism

px.sql

set define "&" concat "."
set serveroutput on verify off echo off;

column PX_DEGREE_IN noprint new_value PX_DEGREE_NUM
column PX_LOCAL_IN noprint new_value PX_LOCAL

accept PX_DEGREE  prompt 'Parallel Degree for Query, DML and DDL. Append an L to set parallel_force_local=true: '

select
        regexp_replace('&PX_DEGREE','([[:digit:]]+).*','\1') PX_DEGREE_IN,
        case when instr(upper('&PX_DEGREE'),'L') > 0  then 'TRUE' else 'FALSE' end PX_LOCAL_IN
from dual;

prompt PX_DEGREE_NUM=&PX_DEGREE_NUM
prompt PX_LOCAL=&PX_LOCAL
prompt

set echo on
set verify on
alter session force parallel query parallel &PX_DEGREE_NUM ;
alter session force parallel dml parallel &PX_DEGREE_NUM ;
alter session force parallel ddl parallel &PX_DEGREE_NUM ;
alter session set parallel_force_local=&PX_LOCAL ;