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 and later
Information in this document applies to any platform.


DB : 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.


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.