DISABLE_PARALLEL - Perceptive Content Database IN_DB_UTIL Package for Oracle Server - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Perceptive Content Database IN_DB_UTIL Package for Oracle Server

Platform
Perceptive Content
Product
Perceptive Content Database IN_DB_UTIL Package for Oracle Server
Release
Foundation 24.1
License

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;