I have an experience on a routine basis, mostly in the high peak time, one of the table is getting locked. But its happening very frequently now these days. Could any one help me out to find out this and solving it. any tools that you recommend to identify this.
OEM and TOAD tools, read the Oracle docs for locks and enqueues.
Originally Posted by helloravi
Reply With Quote