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'
)
);
Last active
September 7, 2023 12:37
-
-
Save Tracnac/95ce6505cfb97d86926f75b311d3bd71 to your computer and use it in GitHub Desktop.
Datapatch / datadump lock #oracle
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment