VIEW: APPS.CSR_TIMERS_V

Source

View Text - Preformatted

SELECT seq, NAME, 'TIME' meaning, SUM (NVL (VALUE, 0)) VALUE FROM csr_timers_b WHERE UPPER (meaning) = 'TIME' GROUP BY seq, NAME, meaning UNION SELECT seq, NAME, 'COUNT' meaning, SUM (NVL (VALUE, 0)) VALUE FROM csr_timers_b WHERE UPPER (meaning) = 'COUNT' GROUP BY seq, NAME, meaning UNION SELECT seq, NAME, meaning, VALUE FROM csr_timers_b WHERE UPPER (meaning) = 'ID' UNION SELECT 120, ' > total Forms before and after retrieving resources', 'TIME', SUM (NVL (VALUE, 0)) FROM csr_timers_b WHERE seq BETWEEN 20 AND 999 AND seq NOT BETWEEN 50 AND 99 AND seq NOT BETWEEN 105 AND 115 UNION SELECT 130, ' > total retrieving qualified resources', 'TIME', SUM (NVL (VALUE, 0)) FROM csr_timers_b WHERE seq BETWEEN 105 AND 115 UNION SELECT 990, ' > total after pressing Search button', 'TIME', SUM (NVL (VALUE, 0)) FROM csr_timers_b WHERE seq BETWEEN 20 AND 999 AND seq NOT BETWEEN 50 AND 99 UNION SELECT 1391, ' > total request initialization', 'TIME', SUM (NVL (VALUE, 0)) FROM csr_timers_b WHERE seq in (1010,1015) UNION SELECT 1392, ' > total loading from DB Query', 'TIME', SUM (NVL (VALUE, 0)) FROM csr_timers_b WHERE seq between 1020 and 1035 or seq in (1045,1080,1390,1085) UNION SELECT 1430, ' > total calculating routes', 'TIME', SUM (NVL (VALUE, 0)) FROM csr_timers_b WHERE seq BETWEEN 1431 AND 1439 UNION SELECT 1491, ' > total calculating plan options', 'TIME', SUM (NVL (VALUE, 0)) FROM csr_timers_b WHERE seq in (1410,1450,1490,1431,1200,1390) UNION SELECT 1492, ' > number of plan options analyzed', 'COUNT', COUNT (*) FROM csr_timers_b WHERE seq = 1450 UNION SELECT 1493, ' > number of route calculations', 'COUNT', COUNT (*) FROM csr_timers_b WHERE seq = 1439 UNION SELECT 1494, ' > average tds route calculation', 'TIME', NVL ((SELECT SUM (NVL (VALUE, 0)) FROM csr_timers_b WHERE seq BETWEEN 1431 AND 1439) / (SELECT COUNT (*) FROM csr_timers_b WHERE seq = 9603), 0) FROM DUAL WHERE EXISTS (SELECT '' FROM csr_timers_b WHERE seq = 9603) UNION SELECT 9010, ' > total Scheduler initialization', 'TIME', SUM (NVL (VALUE, 0)) FROM csr_timers_b WHERE seq IN (1000,1005) UNION SELECT 9015, ' > total Unschedule operation', 'TIME', SUM (NVL (VALUE, 0)) FROM csr_timers_b WHERE seq BETWEEN 1050 AND 1075 UNION SELECT 9015, ' > total Scheduling planoption', 'TIME', SUM (NVL (VALUE, 0)) FROM csr_timers_b WHERE seq in (1410,1550,1560,1570,1580,1090) or seq BETWEEN 1431 AND 1439 UNION SELECT 9100, ' > total Scheduler Java-core (plan options)', 'TIME', SUM (NVL (VALUE, 0)) FROM csr_timers_b WHERE seq BETWEEN 1000 AND 8999 UNION SELECT 9200, ' > number of timing marks and infos in Java-core (plan options)', 'COUNT', COUNT (*) FROM csr_timers_b WHERE seq BETWEEN 1000 AND 9999 UNION SELECT 11900, ' > sending options to Forms, Communication', 'TIME', (SELECT SUM (NVL (VALUE, 0)) FROM csr_timers_b WHERE seq IN (11000, 11100)) - (SELECT SUM (NVL (VALUE, 0)) FROM csr_timers_b WHERE seq BETWEEN 1000 AND 8999) FROM DUAL UNION SELECT 99100, ' > total after sending options to Forms', 'TIME', SUM (NVL (VALUE, 0)) FROM csr_timers_b WHERE seq > 11100 UNION SELECT 99200, ' > total time spent in Forms', 'TIME', SUM (NVL (VALUE, 0)) FROM csr_timers_b WHERE (seq BETWEEN 20 AND 999 AND seq NOT BETWEEN 50 AND 99) OR seq > 11000 UNION ALL SELECT 99300, ' > grand total', 'TIME', SUM (NVL (VALUE, 0)) FROM (SELECT VALUE FROM csr_timers_b WHERE EXISTS (SELECT NULL FROM csr_timers_b WHERE seq = 1150) AND seq BETWEEN 1000 AND 8999 UNION ALL SELECT VALUE FROM csr_timers_b WHERE NOT EXISTS (SELECT NULL FROM csr_timers_b WHERE seq = 1150) AND ( (seq BETWEEN 20 AND 999 AND seq NOT BETWEEN 50 AND 99) OR seq > 10000 ) )

View Text - HTML Formatted

SELECT SEQ
, NAME
, 'TIME' MEANING
, SUM (NVL (VALUE
, 0)) VALUE
FROM CSR_TIMERS_B
WHERE UPPER (MEANING) = 'TIME' GROUP BY SEQ
, NAME
, MEANING UNION SELECT SEQ
, NAME
, 'COUNT' MEANING
, SUM (NVL (VALUE
, 0)) VALUE
FROM CSR_TIMERS_B
WHERE UPPER (MEANING) = 'COUNT' GROUP BY SEQ
, NAME
, MEANING UNION SELECT SEQ
, NAME
, MEANING
, VALUE
FROM CSR_TIMERS_B
WHERE UPPER (MEANING) = 'ID' UNION SELECT 120
, ' > TOTAL FORMS BEFORE
AND AFTER RETRIEVING RESOURCES'
, 'TIME'
, SUM (NVL (VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 20
AND 999
AND SEQ NOT BETWEEN 50
AND 99
AND SEQ NOT BETWEEN 105
AND 115 UNION SELECT 130
, ' > TOTAL RETRIEVING QUALIFIED RESOURCES'
, 'TIME'
, SUM (NVL (VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 105
AND 115 UNION SELECT 990
, ' > TOTAL AFTER PRESSING SEARCH BUTTON'
, 'TIME'
, SUM (NVL (VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 20
AND 999
AND SEQ NOT BETWEEN 50
AND 99 UNION SELECT 1391
, ' > TOTAL REQUEST INITIALIZATION'
, 'TIME'
, SUM (NVL (VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ IN (1010
, 1015) UNION SELECT 1392
, ' > TOTAL LOADING
FROM DB QUERY'
, 'TIME'
, SUM (NVL (VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 1020
AND 1035 OR SEQ IN (1045
, 1080
, 1390
, 1085) UNION SELECT 1430
, ' > TOTAL CALCULATING ROUTES'
, 'TIME'
, SUM (NVL (VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 1431
AND 1439 UNION SELECT 1491
, ' > TOTAL CALCULATING PLAN OPTIONS'
, 'TIME'
, SUM (NVL (VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ IN (1410
, 1450
, 1490
, 1431
, 1200
, 1390) UNION SELECT 1492
, ' > NUMBER OF PLAN OPTIONS ANALYZED'
, 'COUNT'
, COUNT (*)
FROM CSR_TIMERS_B
WHERE SEQ = 1450 UNION SELECT 1493
, ' > NUMBER OF ROUTE CALCULATIONS'
, 'COUNT'
, COUNT (*)
FROM CSR_TIMERS_B
WHERE SEQ = 1439 UNION SELECT 1494
, ' > AVERAGE TDS ROUTE CALCULATION'
, 'TIME'
, NVL ((SELECT SUM (NVL (VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 1431
AND 1439) / (SELECT COUNT (*)
FROM CSR_TIMERS_B
WHERE SEQ = 9603)
, 0)
FROM DUAL
WHERE EXISTS (SELECT ''
FROM CSR_TIMERS_B
WHERE SEQ = 9603) UNION SELECT 9010
, ' > TOTAL SCHEDULER INITIALIZATION'
, 'TIME'
, SUM (NVL (VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ IN (1000
, 1005) UNION SELECT 9015
, ' > TOTAL UNSCHEDULE OPERATION'
, 'TIME'
, SUM (NVL (VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 1050
AND 1075 UNION SELECT 9015
, ' > TOTAL SCHEDULING PLANOPTION'
, 'TIME'
, SUM (NVL (VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ IN (1410
, 1550
, 1560
, 1570
, 1580
, 1090) OR SEQ BETWEEN 1431
AND 1439 UNION SELECT 9100
, ' > TOTAL SCHEDULER JAVA-CORE (PLAN OPTIONS)'
, 'TIME'
, SUM (NVL (VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 1000
AND 8999 UNION SELECT 9200
, ' > NUMBER OF TIMING MARKS
AND INFOS IN JAVA-CORE (PLAN OPTIONS)'
, 'COUNT'
, COUNT (*)
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 1000
AND 9999 UNION SELECT 11900
, ' > SENDING OPTIONS TO FORMS
, COMMUNICATION'
, 'TIME'
, (SELECT SUM (NVL (VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ IN (11000
, 11100)) - (SELECT SUM (NVL (VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ BETWEEN 1000
AND 8999)
FROM DUAL UNION SELECT 99100
, ' > TOTAL AFTER SENDING OPTIONS TO FORMS'
, 'TIME'
, SUM (NVL (VALUE
, 0))
FROM CSR_TIMERS_B
WHERE SEQ > 11100 UNION SELECT 99200
, ' > TOTAL TIME SPENT IN FORMS'
, 'TIME'
, SUM (NVL (VALUE
, 0))
FROM CSR_TIMERS_B
WHERE (SEQ BETWEEN 20
AND 999
AND SEQ NOT BETWEEN 50
AND 99) OR SEQ > 11000 UNION ALL SELECT 99300
, ' > GRAND TOTAL'
, 'TIME'
, SUM (NVL (VALUE
, 0))
FROM (SELECT VALUE
FROM CSR_TIMERS_B
WHERE EXISTS (SELECT NULL
FROM CSR_TIMERS_B
WHERE SEQ = 1150)
AND SEQ BETWEEN 1000
AND 8999 UNION ALL SELECT VALUE
FROM CSR_TIMERS_B
WHERE NOT EXISTS (SELECT NULL
FROM CSR_TIMERS_B
WHERE SEQ = 1150)
AND ( (SEQ BETWEEN 20
AND 999
AND SEQ NOT BETWEEN 50
AND 99) OR SEQ > 10000 ) )