| rahul |
Posted: Nov 14, 2007 01:23:47 AM |
Total Post: 16
Joined: Feb, 2007
|
Dear Friends
I have a question if any one know the possible answers please reply me soon.
Q:- I have a table which contains only 20 rows . two concurrent transaction perform dml activity (Just like one perform insert and second perform updated) and its take much more time ? whats the reason behind this.
thanks
amit k bhatnagar
|
|
|
 Manu |
| Posted: Nov 19, 2007 12:27:34 AM |  |
|
Total Post: 11
Joined: May, 2006
|
There might be a table level lock. check whether tehre is any specification for locking in the update SQLs.
|
|
|
|
|
| praveen |
| Posted: Nov 27, 2007 04:07:50 AM | |
|
Total Post: 3
Joined: Nov, 2007
|
check for locks on that table
use V$LOCKS table for reference.
|
|
|
|
|
| mohamed riaz |
| Posted: Dec 22, 2007 04:20:16 PM | |
|
Total Post: 91
Joined: Sep, 2006
|
Hi,
Can you help me for how will you tuing SQL QUERY ? This is a interview question.
Regards
Riaz
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
