A fairly easy script today that isn’t really hard to work out for yourself but I find it useful to have this script kicking around for when you find high resource using Oracle server process and you want to identify the offending SQL.
set pages 1000;
set lines 200;
col username for a10;
select b.status,a.inst_id,a.PID "Ora PID",a.SPID "Server PID",
b.terminal,a.terminal,b.Process "Client Process"
from gv$process a,gv$session b where a.addr=b.paddr and b.sid=&SID
See you next week!