停止oracle所有进程,在Oracle中,如何彻底停止expdp进程?

SET LINE 9999

COL OWNER_NAME FOR A10

COL JOB_NAME FOR A25

COL OPERATION FOR A10

COL JOB_MODE FOR A10

COL STATE FOR A15

COL OSUSER FOR A10

COL "DEGREE|ATTACHED|DATAPUMP" FOR A25

COL SESSION_INFO FOR A20

SELECT DS.INST_ID,

DJ.OWNER_NAME,

DJ.JOB_NAME,

TRIM(DJ.OPERATION) OPERATION,

TRIM(DJ.JOB_MODE) JOB_MODE,

DJ.STATE,

DJ.DEGREE || ',' || DJ.ATTACHED_SESSIONS || ',' ||DJ.DATAPUMP_SESSIONS "DEGREE|ATTACHED|DATAPUMP",

DS.SESSION_TYPE,

S.OSUSER ,

(SELECT S.SID || ',' || S.SERIAL# || ',' || P.SPID

FROM GV$PROCESS P

WHERE S.PADDR = P.ADDR

AND S.INST_ID = P.INST_ID) SESSION_INFO

FROM DBA_DATAPUMP_JOBS DJ --GV$DATAPUMP_JOB

FULL OUTER JOIN DBA_DATAPUMP_SESSIONS DS --GV$DATAPUMP_SESSION

ON (DJ.JOB_NAME = DS.JOB_NAME AND DJ.OWNER_NAME = DS.OWNER_NAME)

LEFT OUTER JOIN GV$SESSION S

ON (S.SADDR = DS.SADDR AND DS.INST_ID = S.INST_ID)

ORDER BY DJ.OWNER_NAME, DJ.JOB_NAME;

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值