My Oracle Support Banner

Oracle Scheduler Locking Tasks Causing Performance Issues (Doc ID 2328223.1)

Last updated on FEBRUARY 25, 2019

Applies to:

Oracle Scheduler - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Scheduler locking Tasks for more time, which is causing Performance issues.

Since upgrading to 12.1.3 the optimizer run cycles have more than doubled, and more importantly, it is locking records that it should not.
This locking issue was fixed in 12.1.2, but this fix does not seem to have been included in 12.1.3.

This is happening frequently since upgrade, locking Mobile updates for as long as 10 minutes in some cases.

SQL in v$session:

BEGIN csr_scheduler_pvt.get_qualified_resources
 (p_api_version => 1.0,
  p_init_msg_list => fnd_api.g_true,
  x_return_status => :1,
  x_msg_count => :2,
  x_msg_data => :3,
  p_task_id_tbl => :4,
  p_start_date_tbl => :5,
  p_end_date_tbl => :6,
  x_task_resources_tbl => :7); END;

Changes

 

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.