Scheduled jobs utilizing OS credentials (external job) have a long (eg, 25 seconds) delay before executing job action sqltrace wait 'JS external job'
(Doc ID 1599343.1)
Last updated on AUGUST 23, 2021
Applies to:Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Red Hat Enterprise Linux Advanced Server x86-64 (AMD Opteron Architecture)
Scheduled jobs which use credential (OS userid / password) have a long (eg, 25 seconds or below 26 secs of time) delay before job_action is executed.
DBMS_SCHEDULER external job which used to take 1 or 2 seconds now takes 26 or 27 seconds, dbms_scheduler external job latency or slow
10046 trace sqltrace shows wait "JS external job"
WAIT #139934520056016: nam='JS external job' ela= 26186759 p1=0 p2=0 p3=0 obj#=-1 tim=107054354036
XCTEND rlbk=0, rd_only=1, tim=107054354395
Recently Linux upgraded to 6.x
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document