Performance Issue On AU_PURCHASED_PRODUCT_CYCLE_F_T Post Upgrade To PS6 (Doc ID 2964609.1)

Last updated on AUGUST 16, 2023

Applies to:

Goal

Scenario:

• Customer has upgraded from Patch Set 3 (PS3) to PS6.
• There was change in the table au_purchased_product_cycle_f_t structure.
• New column last_notification_t has been added.
• Customer is seeing performance issue on this table.
• Below is the sql query:
  select rec_id, charged_from_t, charged_to_t, count, cycle_fee_end_t, cycle_fee_start_t, last_notification_offset, last_notification_t, unit
  from au_purchased_product_cycle_f_t where obj_id0 = :1

Question:

Site database administrator (DBA) has reviewed and suggested to create indexes on au_purchased_product_cycle_f_t(obj_id0). Can customer go ahead with this?

Solution

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