VIEW: SYS.V_$DETACHED_SESSION

Source

View Text - Preformatted

select "INDX","PG_NAME","SID","SERIAL#","PID","CON_ID" from v$detached_session

View Text - HTML Formatted

SELECT "INDX"
, "PG_NAME"
, "SID"
, "SERIAL#"
, "PID"
, "CON_ID"
FROM V$DETACHED_SESSION