Différences

Ci-dessous, les différences entre deux révisions de la page.

--- oracle:database:rman [04/12/2024 10:03] – mdl
+++ oracle:database:rman [04/12/2024 10:10] (Version actuelle) – mdl
@@ Ligne 45: / Ligne 45: @@
  \\
+== Kill runing jobs ==
+<code PLSQL>
+### Check what Session will be killed
+select s.sid, s.serial#, s.username,
+       to_char(s.logon_time,'DD-MON HH24:MI:SS') logon_time,
+       p.pid oraclepid, p.spid "ServerPID", s.process "ClientPID",
+       s.program clientprogram, s.module, s.machine, s.osuser,
+       s.status, s.last_call_et
+from  v$session s, v$process p
+where s.paddr=p.addr
+and s.program like 'rman%'
+order by s.sid
+### Generate simple command
+select '! kill -9 '||p.spid  kill_rman_process
+from  v$session s, v$process p
+where s.paddr=p.addr
+and s.program like 'rman%'
+order by s.sid
+KILL_RMAN_PROCESS
+----------------------------------
+! kill -9 2516
+! kill -9 2517
+! kill -9 2497
+</code>
+ \\
 == Job Summary with SESSION_RECID and SESSION_STAMP==
 <code PLSQL>