Tag Archives: LONG RUNNING

Long Running queries


select EVENT,P1,P2,P3,WAIT_TIME,SECONDS_IN_WAIT,STATE from v$session_wait; select rows_processed,sql_text from v$sql where hash_value = ‘849381714’; select rows_processed,sql_text,users_executing from v$sql where hash_value = ‘7973525’; select sid,serial#,target,time_remaining,elapsed_seconds,sql_hash_value from v$session_longops where time_remaining >0 and opname not like ‘RMAN%’; select sid,serial#,sql_hash_value,osuser,machine,program,process,status,to_char(LOGON_TIME,’dd/mm/yyyy hh:mi:ss’) from v$session; select sid,serial#,sql_hash_value,username,schemaname,osuser,program,process,status from v$session where sql_hash_value=824725190; Find I/O Consumption: ===================== select sid, username, round(100 * total_user_io/total_io,2) tot_io_pct from […]

https://kalyandba.wordpress.com/2015/09/04/long-running-queries/