skip to main | skip to sidebar

ORACLE APPS

ORACLE APPS TECHNICAL CONCEPTS

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

Posted by Rajesh Chigullapalli at 4:48 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2019 (1)
    • ►  September (1)
  • ►  2017 (3)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2016 (5)
    • ►  May (3)
    • ►  March (2)
  • ►  2014 (12)
    • ►  December (1)
    • ►  November (1)
    • ►  July (1)
    • ►  June (1)
    • ►  May (1)
    • ►  April (4)
    • ►  February (1)
    • ►  January (2)
  • ►  2013 (20)
    • ►  December (3)
    • ►  November (1)
    • ►  September (3)
    • ►  August (2)
    • ►  July (8)
    • ►  June (1)
    • ►  March (2)
  • ►  2012 (36)
    • ►  November (2)
    • ►  October (9)
    • ►  September (2)
    • ►  August (2)
    • ►  July (4)
    • ►  June (6)
    • ►  May (6)
    • ►  April (4)
    • ►  March (1)
  • ►  2011 (3)
    • ►  February (3)
  • ▼  2010 (14)
    • ►  September (1)
    • ►  July (2)
    • ►  June (1)
    • ►  May (6)
    • ▼  April (3)
      • Kill a database session for a particular object
      • LDT generation for Business EVENTS and SUBSCRIPTIONS
      • Calling a webservice from forms
    • ►  March (1)
  • ►  2009 (2)
    • ►  May (1)
    • ►  April (1)
  • ►  2008 (4)
    • ►  May (2)
    • ►  April (2)

About Me

Rajesh Chigullapalli
View my complete profile