My Oracle Support Banner

Exadata Cell Offloading Extremely Slow If PL/SQL is Executed from DBMS_SCHEDULER Job (Doc ID 1454011.1)

Last updated on JUNE 05, 2019

Applies to:

Oracle Exadata Storage Server Software - Version 11.1.0.3.0 and later
Information in this document applies to any platform.

Symptoms

DB : 11.2.0.2 On Exadata

+ Customer is running below query

 
+ This query is executed from PL/SQL procedure. When procedure is executed
using sqlplus session it completes in seconds (60 - 70 sec) where as if this
is scheduled through DBMS_SCHEDULER, the executions takes around 20-30 min.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.