Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

fpid.sql

Download Script

break on username on sid_ser
column username for a12 heading 'User Name'
column sid_ser for a12 heading 'SID+SER'
set pages 100
set verify off
set lines 110
select b.username username, b.sid||','||b.serial# sid_ser
from v$session b
where process = '&foreground_PID'
/