Runaway Sql for solap_act_cost_plan_est:Performance on DB is affected.

(Doc ID 560403.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version 1.8.0 and later
Information in this document applies to any platform.

Goal

For the last 3 days there been a 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms