Runaway Sql for solap_act_cost_plan_est:Performance on DB is affected. (Doc ID 560403.1)

Last updated on JANUARY 24, 2023

Applies to:

Goal

For the last 3 days there been an sql statement (the exact same one every time) from the
xadmin_synergen that runs for hours and hours, and kills performance on the DB, it's:

SELECT solap_act_cost_plan_est.plant, solap_act_cost_plan_est.work_type,
solap_act_cost_plan_est.work_class,
solap_act_cost_plan_est.work_category,
solap_act_cost_plan_est.work_order_no,
solap_act_cost_plan_est.planner_name,
solap_act_cost_plan_est.created_year,
solap_act_cost_plan_est.created_qtr,
solap_act_cost_plan_est.created_month,
solap_act_cost_plan_est.time_basis,
solap_act_cost_plan_est.original_estimate_amount,
solap_act_cost_plan_est.revised_estimated_amount,
solap_act_cost_plan_est.actual_amount,
solap_act_cost_plan_est.actual_to_orig_est_pct,
solap_act_cost_plan_est.actual_to_revised_est_pct
FROM solap_act_cost_plan_est solap_act_cost_plan_est
WHERE ROWNUM < 20003

-------------------------------------------------

If the session is killed it pops back up - even after rebooting the server. What is it? How can it
be stopped?

Solution

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