How can check RMAN channel


SQL> col client_info format a30
SQL> col sid format 999
SQL> col spid format 9999

SQL> select s.sid,p.spid,s.client_info
  from v$process p, v$session s
  where p.addr = s.paddr
  and client_info like '%rman%';

SID SPID CLIENT_INFO
---- ------------------------ ------------------------------
 95 32571584 rman channel=ORA_DISK_1
 112 24444988 rman channel=ORA_DISK_2
 86 26083462 rman channel=ORA_DISK_3
 94 22479094 rman channel=ORA_DISK_4
 77 26870012 rman channel=ORA_DISK_5
 117 19464446 rman channel=ORA_DISK_6
 109 17956954 rman channel=ORA_DISK_7
 107 17498366 rman channel=ORA_DISK_8
 125 16384000 rman channel=ORA_DISK_9
 119 15925382 rman channel=ORA_DISK_10
 131 15663136 rman channel=ORA_DISK_11

SID SPID CLIENT_INFO
---- ------------------------ ------------------------------
 97 15007980 rman channel=ORA_DISK_12
 93 12845218 rman channel=ORA_DISK_13
 81 12452038 rman channel=ORA_DISK_14
 99 10944602 rman channel=ORA_DISK_15
 101 10813450 rman channel=ORA_DISK_16
 91 10551416 rman channel=ORA_DISK_17
 89 6422592 rman channel=ORA_DISK_18
 100 25297046 rman channel=ORA_DISK_19
 121 41615584 rman channel=ORA_DISK_20

20 rows selected.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: