Long running SQL View

DROP VIEW SYS.SQL_MONITOR_TEST;

/* Formatted on 12/17/2014 10:29:37 AM (QP5 v5.267.14150.38599) */
CREATE OR REPLACE FORCE VIEW SYS.SQL_MONITOR_TEST
(
   INST_ID,
   STATUS,
   USERNAME,
   MODULE,
   ACTION,
   PROGRAM,
   PROCESS_NAME,
   SQL_TEXT,
   SQL_EXEC_START,
   ELAPSED_TIME
)
AS
   SELECT inst_id,
          status,
          username,
          module,
          action,
          program,
          process_name,
          sql_text,
          sql_exec_start,
          elapsed_time
     FROM gv$sql_monitor
    WHERE status = 'EXECUTING';



Also

check

SELECT sid, to_char(start_time,'hh24:mi:ss') stime,
message,( sofar/totalwork)* 100 percent
FROM v$session_longops
WHERE sofar/totalwork < 1