| Only Select Query Running . Concurrency Problem [message #297073] |
Wed, 30 January 2008 01:00  |
Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh
|
Member |
|
|
In my database there is running more than 500 same select statements within half an hour. There is concurrency problems and latch contention occurs. Now if I run only select statements(same select statement-concurrent) will there be any concurrency wait and latch contention? How can I perform to improve my database so that query can perform faster.
From SQL Access Advisor recommendation if I create index can they can be beneficial so that concurrency problem and latch wait problem be solved?
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
