Master OracleApps

Pages

  • Home
  • XML Publisher
  • UTL_FILE

Thursday, April 2, 2015

KILL THE SESSIONS:


SELECT * FROM  v$access
WHERE UPPER(object) like 'TABLE_NAME'

select sid, serial#, command, taddr, 'alter system kill session '||''''||sid||', '||serial#||'''' 
from   v$session where sid in (5)

alter system kill session '5, 25869'
Posted by siva at 4:47 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

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

Blog Archive

  • ►  2018 (3)
    • ►  May (2)
    • ►  January (1)
  • ▼  2015 (12)
    • ▼  April (12)
      • AR Invoice Information: SELECT rct.trx_number,...
      • ATTACHMENTS AT FORM Level: SELECT fds.short_te...
      • DB LINK Creation  CREATE DATABASE LINK "DB_LINK...
      • UPDATE Person Details Through API: /******...
      • UPDATE Organization Details Through API: /*****...
      • UPDATE Customer Account Details Through API:  DE...
      • KILL THE SESSIONS: SELECT * FROM  v$access WHER...
      • Organization  and Classifications Through API: ...
      • TCA Queries The SQL queries involving follow...
      • FND_PROFILE AND FND_GLOBAL:  Following are ...
      • Pick Confirm using API: INV_PICK_WAVE_PICK_CONF...
      • Email Sending Program by using UTL_SMTP Mail. P...
  • ►  2013 (40)
    • ►  April (29)
    • ►  March (4)
    • ►  February (7)

About Me

siva
View my complete profile
Picture Window theme. Powered by Blogger.