How to determine auditing is required or not? And what’s the functionality?
DBA found that the below query takes longest time, How to determine whether auditing is required or not for /purchased_product and /purchased_discount objects.
How to determine which BRM opcode/ functionality causing this query?
select distinct poid_DB, poid_ID0, poid_TYPE, poid_REV, created_t, mod_t, read_access, write_access, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, au_parent_obj_DB, au_parent_obj_ID0, au_parent_obj_TYPE, au_parent_obj_REV, cycle_discount, cycle_disc_amt, cycle_end_details, cycle_end_t, cycle_fee_amt, cycle_fee_flags, cycle_start_details, cycle_start_t, deal_obj_DB, deal_obj_ID0, deal_obj_TYPE, deal_obj_REV, descr, effective_t, flags, instantiated_t, mmc_type, node_location, object_cache_type, overridden_obj_DB, overridden_obj_ID0, overridden_obj_TYPE, overridden_obj_REV, package_id, plan_obj_DB, plan_obj_ID0, plan_obj_TYPE, plan_obj_REV, product_obj_DB, product_obj_ID0, product_obj_TYPE, product_obj_REV, purchase_discount, purchase_disc_amt, purchase_end_details, purchase_end_t, purchase_fee_amt, purchase_start_details, purchase_start_t, quantity, service_obj_DB, service_obj_ID0, service_obj_TYPE, service_obj_REV, sponsor_obj_DB,service_obj_ID0, service_obj_TYPE, service_obj_REV, sponsor_obj_DB, sponsor_obj_ID0, sponsor_obj_TYPE, sponsor_obj_REV, status, status_flags, usage_discount, usage_end_details, usage_end_t, usage_start_details, usage_start_t from au_purchased_product_t where au_purchased_product_t.au_parent_obj_ID0 = :1 and au_purchased_product_t.effective_t <= :2 order by au_purchased_product_t.effective_t desc ;
How to determine which BRM opcode/ functionality causing this query?
select distinct poid_DB, poid_ID0, poid_TYPE, poid_REV, created_t, mod_t, read_access, write_access, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, au_parent_obj_DB, au_parent_obj_ID0, au_parent_obj_TYPE, au_parent_obj_REV, cycle_discount, cycle_disc_amt, cycle_end_details, cycle_end_t, cycle_fee_amt, cycle_fee_flags, cycle_start_details, cycle_start_t, deal_obj_DB, deal_obj_ID0, deal_obj_TYPE, deal_obj_REV, descr, effective_t, flags, instantiated_t, mmc_type, node_location, object_cache_type, overridden_obj_DB, overridden_obj_ID0, overridden_obj_TYPE, overridden_obj_REV, package_id, plan_obj_DB, plan_obj_ID0, plan_obj_TYPE, plan_obj_REV, product_obj_DB, product_obj_ID0, product_obj_TYPE, product_obj_REV, purchase_discount, purchase_disc_amt, purchase_end_details, purchase_end_t, purchase_fee_amt, purchase_start_details, purchase_start_t, quantity, service_obj_DB, service_obj_ID0, service_obj_TYPE, service_obj_REV, sponsor_obj_DB,service_obj_ID0, service_obj_TYPE, service_obj_REV, sponsor_obj_DB, sponsor_obj_ID0, sponsor_obj_TYPE, sponsor_obj_REV, status, status_flags, usage_discount, usage_end_details, usage_end_t, usage_start_details, usage_start_t from au_purchased_product_t where au_purchased_product_t.au_parent_obj_ID0 = :1 and au_purchased_product_t.effective_t <= :2 order by au_purchased_product_t.effective_t desc ;
0