Home » RDBMS Server » Performance Tuning » Only Select Query Running . Concurrency Problem (Solaris, Oracle 10.2.0.2)
Only Select Query Running . Concurrency Problem [message #297073] Wed, 30 January 2008 01:00 Go to next message
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?
Re: Only Select Query Running . Concurrency Problem [message #297079 is a reply to message #297073] Wed, 30 January 2008 01:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If SQL Access Advisor says it why don't you try it?

Regards
Michel
Re: Only Select Query Running . Concurrency Problem [message #297080 is a reply to message #297073] Wed, 30 January 2008 01:18 Go to previous messageGo to next message
Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh
Member
If concurrent select statements happened will there be any latch contention? How to improve the performance better?
Re: Only Select Query Running . Concurrency Problem [message #297082 is a reply to message #297080] Wed, 30 January 2008 01:21 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
If concurrent select statements happened will there be any latch contention?

Maybe

Quote:
How to improve the performance better?

How to Identify Performance Problem and Bottleneck

Regards
Michel
Previous Topic: How to determine blocksize for new data warehouse?
Next Topic: Materialized View issue
Goto Forum:
  


Current Time: Sat Dec 10 12:52:20 CST 2016

Total time taken to generate the page: 0.08704 seconds