my sessions are frequently locked [message #49742] |
Thu, 07 February 2002 04:38 |
cramer
Messages: 3 Registered: February 2002
|
Junior Member |
|
|
My sessions are frequently locked. I kill the sessions in progress, but after the few minutes,le problem returns. What 's the cause of these locks? How can i sovle this problem for ever?
|
|
|
Re: my sessions are frequently locked [message #49748 is a reply to message #49742] |
Thu, 07 February 2002 11:07 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
There could be many reasons.
1.) you are in a multi session environemt, and other sessions are locking rows by not committing after update/delete.
2.) records are locked by select... for update;
3.) Your foreign key constraints aren't indexed, so when a parent row gets updated/deleted, the whole child table gets locked.
4.) logic problems - deadlocks.
5.) if it's not to do with "locks" on the server, then maybe something on your client setup. Do other users have the same problem when connecting to your accounts and doing the same things??
See what's being locked my joining these tables:
dba_objects, v$locked_object, v$lock, v$session
|
|
|