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: REP-0001: Unable to find the Report Builder message file. Please verify your installation. Active User and all other report r...
-
FS_CLONE issues Issue 1: There is not enough space on the volume you have specified. Oracle Universal Installer has detected th...
-
When we run the autoconfig on application nodes TNSNAME.ORA IS ALSO CREATED BUT WITH VIRTUAL IP ENTRY IN HOST FIELD IT SHOULD BE WITH SCAN...