오라클 세션 조회

SELECT S.SID, S.SERIAL#, S.USERNAME , S.PROCESS,
P.SPID ,S.STATUS,
DECODE(S.COMMAND,
'0','NO',
'1','Create Tab',
'2','Insert',
'3','Select',
'6','Update',
'7','Delete',
'9','Create Idx',
'10','Drop Idx',
'15','Alter Tbl',
'24','Create Proc',
'32','Create Link',
'33','Drop Link',
'36','Create RBS',
'37','Alter RBS',
'38','Drop RBS',
'40','Alter TBS',
'41','Drop TBS',
'42','Alter Sess',
'45','Rollback',
'62','Anal Table',
'63','Anal Index',
'85','Truncate') COMMAND,
SUBSTR(S.PROGRAM, 1, 35) PRG
FROM V$SESSION S ,V$PROCESS P
WHERE P.ADDR(+) = S.PADDR
--AND S.USERNAME = 'BILL'
ORDER BY S.SID