select
c.owner,
c.object_name,
c.object_type,
b.sid,
b.serial#,
b.status,
b.osuser,
b.machine
from
v$locked_object a ,
v$session b,
dba_objects c
where
b.sid = a.session_id
and
a.object_id = c.object_id;
30 November, 2018
Finding Locks on tables
Subscribe to:
Posts (Atom)
OEM Agent Installation
./agentDeploy.sh AGENT_BASE_DIR=/u001/oracle/product/agent13c OMS_HOST=oem-dev.xxx.com EM_UPLOAD_PORT=1159 AGENT_REGISTRATION_PASSWORD=*****...
-
Error: SQL> startup; ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u01/app/orac...
-
EBS 12.2 uses WebLogic Server from Fusion Middleware 11g in place of OC4J 10g as part of the release’s internal technology stack. Your o...
-
Error: REP-0001: Unable to find the Report Builder message file. Please verify your installation. Active User and all other report r...