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;
Subscribe to:
Post Comments (Atom)
Finding OPP Manager log for a concurrent request
=> Use below query to find the OPP manager log for a concurrent request. SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.lo...
-
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...
-
There’s lots of posts out there telling you how to determine your EBS patch levels, code levels, etc. But whenever I google them, I can’t...
-
The Automatic Workload Repository (AWR) automatically persists the cumulative and delta values for most of the statistics at all levels ex...
No comments:
Post a Comment