Project:
| View Revisions: Issue #37322 | [ Back to Issue ] | ||
| Summary | 0037322: Remove technically useless ad_process entries | ||
| Revision | 2021-07-16 14:11 by shuehner | ||
| Steps To Reproduce | a.) select p.isactive,p.ad_process_id, p.name, p.procedurename, p.classname, p.jrname from ad_process p where not exists (select 1 from ad_model_object mo where mo.ad_process_id = p.ad_process_id) and p.procedurename is null and p.classname is null and p.jrname is null order by p.ad_process_id b.) select p.isactive,p.ad_process_id, p.name, p.procedurename, p.classname, p.jrname from ad_process p where not exists (select 1 from ad_model_object mo where mo.ad_process_id = p.ad_process_id) and not exists (select 1 from information_schema.routines r where r.routine_schema = 'public' and r.routine_name ilike p.procedurename) and p.procedurename is not null and p.procedurename <> 'DBA_Recompile' and p.classname is null and p.jrname is null; |
||
| Revision | 2017-11-18 13:25 by shuehner | ||
| Steps To Reproduce | a.) select p.isactive,p.ad_process_id, p.name, p.procedurename, p.classname, p.jrname from ad_process p where not exists (select 1 from ad_model_object mo where mo.ad_process_id = p.ad_process_id) and not exists (select 1 from information_schema.routines r where r.routine_schema = 'public' and r.routine_name ilike p.procedurename) and p.procedurename is null and p.classname is null and p.jrname is null order by p.ad_process_id b.) select p.isactive,p.ad_process_id, p.name, p.procedurename, p.classname, p.jrname from ad_process p where not exists (select 1 from ad_model_object mo where mo.ad_process_id = p.ad_process_id) and not exists (select 1 from information_schema.routines r where r.routine_schema = 'public' and r.routine_name ilike p.procedurename) and p.procedurename is not null and p.procedurename <> 'DBA_Recompile' and p.classname is null and p.jrname is null; |
||
| Revision | 2017-11-18 13:25 by shuehner | ||
| Description | The ad_process table as a few rows which are technically useless because they call into one of the 3 following classes: a.) as they do not contain either of: - matching ad_model_object row - procedurename value - javaclass value - jrname value b.) They do contain a procedurename but no pl function with that name exists Note: Manually excluded dba_recompile which is created only on oracle db c.) They do contain a javaclass but that javaclass does not exist That mean that they are technically not useful for anything and can be removed. |
||
| Revision | 2017-11-18 13:17 by shuehner | ||
| Steps To Reproduce | a.) select p.isactive,p.ad_process_id, p.name, p.procedurename, p.classname, p.jrname from ad_process p where not exists (select 1 from ad_model_object mo where mo.ad_process_id = p.ad_process_id) and not exists (select 1 from information_schema.routines r where r.routine_schema = 'public' and r.routine_name ilike p.procedurename) and p.procedurename is null and p.classname is null and p.jrname is null order by p.ad_process_id |
||
| Revision | 2017-11-18 13:17 by shuehner | ||
| Description | The ad_process table as a few rows which are technically useless because they call into one of the 3 following classes: a.) as they do not contain either of: - matching ad_model_object row - procedurename value - javaclass value - jrname value b.) They do contain a procedurename but no pl function with that name exists c.) They do contain a javaclass but that javaclass does not exist That mean that they are technically not useful for anything and can be removed. |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |