oracle 7

expdp/impdp 杀导出导入后台进程：
--查询后台进程：
SET lines 200
COL owner_name FORMAT a10;
COL job_name FORMAT a20
COL state FORMAT a11
COL operation LIKE state
COL job_mode LIKE state


-- locate Data Pump jobs:


SELECT owner_name, job_name, operation, job_mode,
state, attached_sessions
FROM dba_datapump_jobs
WHERE job_name NOT LIKE 'BIN$%'
ORDER BY 1,2;




--杀job
SET serveroutput on
SET lines 100
DECLARE
   h1 NUMBER;
BEGIN
  -- Format: DBMS_DATAPUMP.ATTACH('[job_name]','[owner_name]');
   h1 := DBMS_DATAPUMP.ATTACH('SYS_IMPORT_SCHEMA_01','SCHEMA_USER');
   DBMS_DATAPUMP.STOP_JOB (h1,1,0);
END;

/

《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《《


提取用户密码：
select 'alter user '||name||' identified by values '||''''||password||''''||';' from sys.user$ where name=

死锁：
锁死：
select sid Holder ,KGLPNUSE Sesion , KGLPNMOD Held, KGLPNREQ Req 
from x$kglpn , gv$session where KGLPNHDL in (select p1raw from gv$session_wait where wait_time=0 and event like 'library cache %') 
and KGLPNMOD <> 0 
and gv$session.saddr=x$kglpn.kglpnuse ; 


select sid,serial# from v$session where sid=1140
and inst_id=xxx
select inst_id,sid,serial#,username,program,sql_id,status from gv$session where sid=XXX;


alter system kill session 'sid,serial#';
alter system kill session 'sid,serial#,@ORACLE_SID';   ----?适用于在其他节点杀死锁，加上SID


SQL> select spid from v$process p,v$session s where s.paddr=p.addr and s.sid=1140;


SPID
------------------------------------------------------------------------
6464


 [oracle@-or ~]$ ps -ef|grep 6464
oracle    3800  2756  0 09:56 pts/0    00:00:00 grep 6464
oracle    6464     1  0 Aug30 ?        00:00:13 oraclescmdb (LOCAL=NO)
[oracle@-or ~]$ kill -9 6464