The `dbms_parallel` package provides introspection of the parallel PSQL constructs of [[Parallel Statement (pSqlParallelStatement)|Parallel Statement]]: the `parallel ... branch ... end parallel` compound statement and the parallel for-loops. Available from release 27.0. ## `effective_degree`: The degree actually granted. Return the effective degree granted to the nearest enclosing parallel construct: the minimum of the construct's own degree, the `invantive-sql-psql-max-parallel` setting and twice the number of logical processors, clamped to 1 while a session transaction is open. Outside a parallel construct the function returns 1. The outcome is assigned to a variable of the block before it is used in a statement. ## `saved_exceptions`: The failures of the last 'save exceptions' construct. Enumerate the individual failures behind the most recently raised `parallel_error` collecting exception on the execution context, as a table function used in a select through table(...). Each row holds the columns INSTANCE, MESSAGE_CODE, MESSAGE and OCCURRED_UTC, naming the failed branch by its label or the failed iteration by its loop-variable values. The function is valid inside the exception handler which caught `parallel_error`; elsewhere it raises `itgenpsp017`.