[root]# /usr/sbin/lsof /db/u31 | grep deleted
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
---------------------------------------------------------------------------
init 1 root cwd DIR 3,3 4096 2 /
init 1 root txt REG 3,3 27036 161176 /sbin/init
init 1 root mem REG 3,3 103044 160493 /lib/ld-2.3.2.so
init 1 root 10u FIFO 3,3 71954 /dev/initctl
portmap 1528 rpc 3u IPv4 1656 UDP *:sunrpc
xinetd 1649 root 0r CHR 1,3 65970 /dev/null
oracle 21059 oracle 268u REG 253,16 34358697984 389 /db/u31/_USERS26.DBF (deleted)
expdp 25806 oracle cwd DIR 253,16 0 1011841 /db/u31/BACKUP_06052014 (deleted)
(deleted)
SELECT s.inst_id,
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' and spid=25806
select *
from
v$process p
where spid=21059
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
---------------------------------------------------------------------------
init 1 root cwd DIR 3,3 4096 2 /
init 1 root txt REG 3,3 27036 161176 /sbin/init
init 1 root mem REG 3,3 103044 160493 /lib/ld-2.3.2.so
init 1 root 10u FIFO 3,3 71954 /dev/initctl
portmap 1528 rpc 3u IPv4 1656 UDP *:sunrpc
xinetd 1649 root 0r CHR 1,3 65970 /dev/null
oracle 21059 oracle 268u REG 253,16 34358697984 389 /db/u31/_USERS26.DBF (deleted)
expdp 25806 oracle cwd DIR 253,16 0 1011841 /db/u31/BACKUP_06052014 (deleted)
(deleted)
SELECT s.inst_id,
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' and spid=25806
select *
from
v$process p
where spid=21059