Hello Team
I have a query regarding long running jobs which I usually get from our application team saying that -
" My query is running for long time...pls check it status" ....etc
Kindly let me know what I am supposed to do in such situations - steps, srcipts to be followed.
I usually run the below scripts, say them the status of it -
select INST_ID,sid,serial#,username,to_char(logon_time,'dd:mm:yyyy hh24:mi:ss'),status,event,sql_id,osuser,machine from gv$session where username='username' order by logon_time;
select p.spid from gv$session s, gv$process p where s.sid=&a and s.paddr=p.addr;
Regards