91 views

Description

The scheduled job Event Management  - Delete Work Notes is causing large table scans, which sometime run for hours.

There is a GlideRecord call from this job to sys_journal_field table. This call may cause database servers to run very high on IO WAIT due to large table scans.

 

Steps to Reproduce

  1. Use an instance with Event Management com.glideapp.itom.snac plugin active
  2. Use a large sys_journal_field table
  3. Run the job and collect the SQL from the database side. For large tables, SQL runs for minutes and sometimes hours.

Workaround

Add an index on sys_journal_field table on name, element_id fields in order to prevent a full table scan.
 

Related Problem: PRB884265

Seen In

There is no data to report.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2017-11-16 16:53:29
Published:2017-11-17