TaRTeSMon - Real-time SQL Monitoring Reports |
Real-time SQL Monitoring Reports | Used Filter | Database Name |
---|---|---|
Generated by TaRTeSMon on 17.03.20 17 11:30:34 | sql_exec_start > sysdate -1 an d username != 'SYS' | PHYS |
REPORT_ID | CON_ID | INST_ID | STATUS | USERNAME | MODULE | ACTION | SERVICE_NAME | PROGRAM | SID | SESSION_SERIAL# | ELAPSED_TIME | SQL_TEXT | SQL_ID | SQL_EXEC_START | SQL_EXEC_ID | SQL_PLAN_HASH_VALUE | FIRST_REFRESH_TIME | LAST_REFRESH_TIME | REFRESH_COUNT | STILL_IN_MEMORY |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
51130 | 0 | 1 | DONE (ALL ROWS) | SCOTT | SQL*Plus | SYS$USERS | sqlplus@blue.trivadistraining.com (TNS V1-V3) | 38 | 26587 | 3328499 | SELECT count(*), sum(quantity*unit_price), o.category FROM orders o, order_items i WHERE o.order_id = i.order_id GROUP BY o.category ORDER BY o.category | 4uratu64md452 | 17.03.2017 10:43:16 | 16777216 | 565715841 | 17.03.2017 10:43:20 | 17.03.2017 10:43:20 | 6 | Y | |
51131 | 0 | 1 | DONE | SCOTT | SQL*Plus | SYS$USERS | sqlplus@blue.trivadistraining.com (TNS V1-V3) | 38 | 52606 | 10207565 | insert into order_items select * from order_items | 9rmpn2ckg346a | 17.03.2017 10:44:21 | 16777216 | 456270211 | 17.03.2017 10:44:25 | 17.03.2017 10:44:31 | 6 | Y | |
51132 | 0 | 1 | DONE (ALL ROWS) | SCOTT | SQL*Plus | SYS$USERS | sqlplus@blue.trivadistraining.com (TNS V1-V3) | 38 | 3452 | 3648840 | SELECT count(*), sum(quantity*unit_price), o.category FROM orders o, order_items i WHERE o.order_id = i.order_id GROUP BY o.category ORDER BY o.category | 4uratu64md452 | 17.03.2017 10:44:31 | 16777217 | 565715841 | 17.03.2017 10:44:35 | 17.03.2017 10:44:35 | 6 | Y | |
51133 | 0 | 1 | DONE | SCOTT | SQL*Plus | SYS$USERS | sqlplus@blue.trivadistraining.com (TNS V1-V3) | 38 | 3452 | 18168423 | insert into order_items select * from order_items | 9rmpn2ckg346a | 17.03.2017 10:45:14 | 16777217 | 456270211 | 17.03.2017 10:45:18 | 17.03.2017 10:45:32 | 10 | Y | |
51134 | 0 | 1 | DONE (ALL ROWS) | SCOTT | SQL*Plus | SYS$USERS | sqlplus@blue.trivadistraining.com (TNS V1-V3) | 38 | 2639 | 6719494 | SELECT count(*), sum(quantity*unit_price), o.category FROM orders o, order_items i WHERE o.order_id = i.order_id GROUP BY o.category ORDER BY o.category | 4uratu64md452 | 17.03.2017 10:45:33 | 16777218 | 565715841 | 17.03.2017 10:45:37 | 17.03.2017 10:45:40 | 7 | Y | |
51135 | 0 | 1 | DONE (ALL ROWS) | SCOTT | SQL*Plus | SYS$USERS | sqlplus@blue.trivadistraining.com (TNS V1-V3) | 38 | 33342 | 295569 | SELECT count(*), sum(quantity*unit_price), o.category FROM orders o, order_items i WHERE o.order_id = i.order_id AND o.category >= :c GROUP BY o.category ORDER BY o.category | 888hup6g940d7 | 17.03.2017 11:05:03 | 16777216 | 3760717951 | 17.03.2017 11:05:04 | 17.03.2017 11:05:26 | 18 | Y |
6 rows selected.