| Lock Wait problem [message #54791] |
Thu, 05 December 2002 00:28  |
kalpaj
Messages: 3
Registered: July 2002
|
Junior Member |
|
|
I am getting regular lock waiting problem in database.
when most of the user login & Concurrently do there
work that time mostly i face this problem.
if i put querie select * from v$session i get that
time in LOCKWAIT column i see the entries.
Is there is any solution is there to reduced lock waiting.
it will be greate help for me if somebody give some
suggetion
kalpaj
|
|
|
|
| Re: Lock Wait problem [message #54854 is a reply to message #54791] |
Tue, 10 December 2002 02:27  |
seng
Messages: 191
Registered: February 2002
|
Senior Member |
|
|
Just suggestion only.
1. Huge transaction especially UPDATE, the user try ro make it to few small transactions (suitable for business logic) and the transaction has to commit after complete.
2. Huge table need to index and also include F key, which is refer by other table.
3. Restructure the SQL statement, the locking might be caused by poor SQL statement. This is more in application tunning.
4. rebuild the data structure.
- rebuild index -- free out space(delete won't free out the space)
- rebuild table(especially huge table) - free out space e.g some empty table needs more time to return for SELECT statement
5. establish(standard) in coordination between all user ... try to automate ...
Hope this is helping. Thank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
