The DISABLE_PARALLEL stored procedure is used to disable forced parallelism for DDL and DML and QUERY for the current session by executing the following alter session commands. This is equivalent to running SET_PARALLEL(1).
ALTER SESSION DISABLE PARALLEL DDL; ALTER SESSION DISABLE PARALLEL DML; ALTER SESSION DISABLE PARALLEL QUERY;
Exceptions
- NO_ALTER_PARALLEL – Exception for ORA 12841 error.
- OTHERS
Example
EXEC IN_DB_UTIL.DISABLE_PARALLEL;