asd

Sql code posted
created at 11 Feb 10:33, updated at 14 Feb 07:37

Edit | Back 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
SET LINESIZE 100
COLUMN spid FORMAT A10
COLUMN username FORMAT A10
COLUMN program FORMAT A45

SELECT s
       s.sid,
       s.serial#,
       p.spid,
       s.username,
       s.program
FROM   gv$session s
       JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE  s.type != 'BACKGROUND';
320 Bytes in 2 ms with coderay