Query:
=================
select b.sid, b.serial#, a.spid, b.client_info
from
v$process a, v$session b
where
a.addr=b.paddr and client_info
like
'rman%';
select b.sid, b.serial#, a.spid, b.client_info,b.program
from
v$process a, v$session b
where
a.addr=b.paddr and b.program
like
'rman%';
=================
select b.sid, b.serial#, a.spid, b.client_info
from
v$process a, v$session b
where
a.addr=b.paddr and client_info
like
'rman%';
select b.sid, b.serial#, a.spid, b.client_info,b.program
from
v$process a, v$session b
where
a.addr=b.paddr and b.program
like
'rman%';

No comments:
Post a Comment