FPSINPUT.BLD_WEBAPP_SPEED_TEST

>

> FPSINPUT.WIP_WAFER_HIST_LOOP

View FPSADMIN.BLD_WEBAPP_SPEED_TEST

This series of queries is very effective for testing the queries used by a slow web application: create table aaa_test_webapp# as select sysdate as inst, prev_exec_start, exec_time, sid, serial#, sql_fulltext, sql_text, machine, progress, target from adm_sessions where 0=1; insert into aaa_test_webapp# select sysdate as inst, prev_exec_start, exec_time, sid, serial#, sql_fulltext, sql_text, machine, progress, target from adm_sessions where username = 'FPSWEB' and status = 'ACTIVE' and upper(sql_text) like '%WF%'; select prev_exec_start, max(inst), sid, serial#, sql_fulltext, sql_text from aaa_test_webapp# group by prev_exec_start, sid, serial#, sql_fulltext, sql_text order by 1, 3; drop table aaa_test_webapp#;