Oracle

TaRTeSMon - Real-time SQL Monitoring Reports

Trivadis

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.