Rafiuddin - Oracle EBS Techo-Functional
HCM, Finance, SCM, BI (OBIEE & Discoverer), Workflow, D2K, OAF, ADF, XML, AME, SSHR, FSG, API, DBA
Tuesday, September 30, 2014
Kill a database session for a particular object
selectc.owner,c.object_name,c.object_type,b.sid,b.serial#,b.status,b.osuser,b.machine
fromv$locked_object a ,v$session b,dba_objects c
whereb.sid = a.session_id
anda.object_id = c.object_id;
ALTER SYSTEM KILL SESSION '
,
';
Newer Post
Older Post
Home