Monday, April 19, 2010

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 ',';

Friday, April 16, 2010

LDT generation for Business EVENTS and SUBSCRIPTIONS

Download
adjava oracle.apps.fnd.wf.WFXLoad -d username password host_of_database:port:sid thin US .wfx EVENT/SUBSCRIPTIONS
Upload
adjava oracle.apps.fnd.wf.WFXLoad -u username password host_of_database:port:sid thin US .wfx EVENT/SUBSCRIPTIONS