My Oracle Support Banner

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)

Symptoms

 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"

*** 2xxx-04-01T06:16:18.657195-04:00
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

 

Changes

 Recently Linux upgraded to 6.x

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!


In this Document
Symptoms
Changes
Cause
Solution
References

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