Success is The Progressive Realization Of A Worthy Ideal

Wednesday, February 27, 2013

kill oracle sessions


select count(1),user from v$session group by user;
select 'alter system kill session '||''''||sid||','||serial#||''''||'immediate;' from v$session
select * from v$locked_object; ----- get the sid
select sid,serial# from v$session where sid=134; ------get serial#
alter system kill session '134,2386';
Posted by Unknown at 10:18 PM

No comments:

Post a Comment

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

About Me

Unknown
View my complete profile

Blog Archive

  • ►  2014 (1)
    • ►  January (1)
  • ▼  2013 (62)
    • ►  October (1)
    • ►  July (1)
    • ►  April (14)
    • ►  March (33)
    • ▼  February (13)
      • SET MYSQL PASSWORD
      • kill oracle sessions
      • Increase the session in Oracle
      • AWR report
      • Restore a single table from a whole db backup mysql
      • rename database in sqlserver if database is runnin...
      • set mysql password for root user if forget
      • create data base link in oracle
      • Remote server backup of sqlserver
      • JOINS ORACLE
      • create new user in oracle with separate datafiles ...
      • Data warehouse
      • mysql clustering basics
  • ►  2012 (2)
    • ►  July (2)
  • ►  2010 (1)
    • ►  May (1)
  • ►  2009 (1)
    • ►  December (1)
  • ►  2008 (26)
    • ►  July (14)
    • ►  June (12)
Ethereal theme. Powered by Blogger.