Performance Monitoring in tempo reale

 select s.inst_id,

      s.sid,

      s.serial#,

      s.sql_id,

      s.USERNAME,

      substr(sqls.sql_text,0,50) as sql_text,

      s.service_name,

      s.status,

      s.seconds_in_wait,

      s.WAIT_TIME,

      s.last_call_et,

      s.machine,

      s.program,

      s.event,

      s.blocking_session,

      s.final_blocking_session,

      s.blocking_session_status,

      s.FINAL_BLOCKING_SESSION_STATUS

    --sqls.plan_hash_value

      from gv$session s, gv$sqlarea sqls

where 1=1

and s.status='ACTIVE'

--and s.username <> 'SYS'

and s.username <> 'HR'

and username not in (select username from dba_users where ORACLE_MAINTAINED='Y')

and s.sql_id=sqls.sql_id

and S.SQL_ADDRESS = SQLS.ADDRESS 

 and S.SQL_HASH_VALUE = SQLS.HASH_VALUE 

-- and s.sid=46468

order by last_call_et desc;