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 184.108.40.206.0 and later
Information in this document applies to any platform.
DB : 220.127.116.11 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!