SELECT time/60 AS h, time,TOTAL_TIME, STATE,info,id,t.* FROM SYS.GV$OB_PROCESSLIST t WHERE state !='SLEEP';
.
SELECT * FROM table(DBMS_XPLAN.DISPLAY_ACTIVE_SESSION_PLAN(3221734965,'ALL'));
ALTER SESSION SET ob_query_timeout=6000000000000;
set global ob_query_timeout=6000000000000;
alter session set nls_date_language='AMERICAN';
alter session set nls_timestamp_format = 'YYYY-MM-DD HH24:MI:SS.FF';
alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS';