Thursday, January 18, 2018

How to check rman sessions in oracle database

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%';

No comments:

Post a Comment