Datapatch / datadump lock #oracle

datapatch.md

SET LONG 500000;
SET PAGES 10000;
SET LINES 180;
SELECT systimestamp,s.sql_fulltext,
 s.sql_id,
 v.machine,
 v.sid,
 v.serial#,
 v.process,
 v.program,
 v.status,
 v.type,
 v.module,
 v.username,
 v.schemaname,
 v.plsql_object_id,
 v.resource_consumer_group,
 v.event,
 v.service_name,
 v.prev_sql_id
FROM gv$sqlarea s ,
 gv$session v, dual
WHERE v.sql_id = s.sql_id(+)
AND v.sid IN
 (SELECT SID
 FROM gv$lock
 WHERE ID1 =
  (SELECT LOCKID FROM dbms_lock_allocated WHERE
NAME='ORA$KU$DATAPUMP_SW_UPDATE'
  )
 );