VIEW: SYS.PS1$

Source

View Text - Preformatted

select  ps."LOCAL_TRAN_ID",ps."SESSION_ID",ps."BRANCH_ID",ps."INTERFACE",ps."TYPE#",ps."PARENT_DBID",ps."PARENT_DB",ps."DB_USERID", u.name db_user
from    sys.pending_sessions$ ps, sys.user$ u
where   ps.db_userid = u.user#

View Text - HTML Formatted

SELECT PS."LOCAL_TRAN_ID"
, PS."SESSION_ID"
, PS."BRANCH_ID"
, PS."INTERFACE"
, PS."TYPE#"
, PS."PARENT_DBID"
, PS."PARENT_DB"
, PS."DB_USERID"
, U.NAME DB_USER FROM SYS.PENDING_SESSIONS$ PS
, SYS.USER$ U WHERE PS.DB_USERID = U.USER#