Code Listing 1: V$SESSION and V$SQL query finds lock

SID   SQL_TEXT
---   ---------------------------------------------------------------------
270   update accounts set balance = balance - 750 where account_no = 333
254   update accounts set balance = balance - 1000 where account_no = 333
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy