Oracle 19c Performance Tuning Series- Video 002 

Oracle 19c Performance Tuning Series - Collection of Videos. From Beginners to Advanced Topics
Also check my book on Oracle 19c multitenant Architecture on Amazon ( www.amazon.com... )
-- Get DB session detail based on OS process ID
set lines 300
col username format A15
col service_name format A15
col spid format A8
col machine format A25
col sql_text format A32
col state format A12
col sid format 999
SELECT p.spid, s.sid, s.username, s.service_name,
s.machine, s.status, s.sql_id,
(SELECT SUBSTR(sql_text,1,50) FROM gv$sql where sql_id = s.sql_id and rownum=1) sql_text,
s.last_call_et, s.state, s.blocking_session
FROM gv$session s, gv$process p
WHERE s.inst_id = p.inst_id
AND s.paddr = p.addr
AND p.spid = &spid;