Real world problems

Check items running in the Database

WITH vs AS ( SELECT LOGON_TIME, ROWNUM rnum, inst_id, sid, serial#, status,SADDR, username, last_call_et, command, machine, osuser, module, action, resource_consumer_group, client_info, client_identifier, type, terminal, sql_id, sql_child_number FROM gv$session ) SELECT LOGON_TIME, vs.inst_id, vs.sid, serial# serial, vs.sql_id, vs.username “Username”, CASE WHEN vs.status = ‘ACTIVE’ THEN last_call_et ELSE NULL END “Sec in Wait”, ( SELECT x.command_name FROM …