OracleApps02

Shivaji Rajaram Umale
Mob No. +91-7875947412

How to UnLock Table Query

( select a.sid,c.* from v$session a,v$lock b ,all_objects c where a.sid=b.sid and b.id1=object_id and object_name like 'XX%' );

 SID:-333
Serial#:- 222


ALTER SYSTEM KILL SESSION '333,222' ;
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Search This Blog

Blogs List

  • ▼  2024 (1)
    • ▼  April (1)
      • PL/SQL Script to Reset User Password from Backend
  • ►  2023 (14)
    • ►  October (3)
    • ►  July (2)
    • ►  May (2)
    • ►  April (2)
    • ►  March (5)
  • ►  2022 (2)
    • ►  November (1)
    • ►  January (1)
  • ►  2021 (1)
    • ►  February (1)
  • ►  2020 (3)
    • ►  September (1)
    • ►  May (1)
    • ►  February (1)
  • ►  2019 (6)
    • ►  November (3)
    • ►  September (2)
    • ►  February (1)
  • ►  2018 (40)
    • ►  December (3)
    • ►  September (7)
    • ►  August (5)
    • ►  July (25)
  • ►  2016 (3)
    • ►  February (3)

About Me

My photo
Shivaji Umale
Pune, Maharashtra, India
View my complete profile

Report Abuse

Thanks to visit.. Picture Window theme. Powered by Blogger.