Cleanup Is Running Long Not Getting Completed For JDR_ATTRIBUTES (Doc ID 3048459.1)

Last updated on SEPTEMBER 25, 2024

Applies to:

Symptoms

1002948879 13:59:37 00:00:00 ad.plsql.ad_zd_seed.cleanup_table          EVENT      Cleanup Seed Data Table: APPLSYS.JDR_ATTRIBUTES, run rowset filter: ZD_EDITION_NAME = 'SET1'
1002948879 13:59:37 00:00:00 ad.plsql.ad_zd_seed.run_in_parallel        STATEMENT  [JDR_ATTRIBUTES|CLEANUP_ROWSET] Create Task, SQL: delete /* +rowid(tbl) */ from "APPLSYS"."JDR_ATTRIBUTES" tbl where not
                                                                                   (ZD_EDITION_NAME = 'SET1') and (zd_edition_name not in ('SET1', 'SET2'))  and rowid between :start_id and :end_id

1002948879 13:59:37 00:00:00 ad.plsql.ad_zd_seed.run_in_parallel        STATEMENT  [JDR_ATTRIBUTES|CLEANUP_ROWSET] Drop duplicate task
1002948879 13:59:39 00:00:01 ad.plsql.ad_zd_seed.run_in_parallel        STATEMENT  [JDR_ATTRIBUTES|CLEANUP_ROWSET] Create Task (retry)
1002948879 13:59:42 00:00:02 ad.plsql.ad_zd_seed.run_in_parallel        STATEMENT  [JDR_ATTRIBUTES|CLEANUP_ROWSET] Executing Task, chunks: 36272

Changes

Cause

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