| Concurrency wait. How I can resolve. [message #295327] |
Tue, 22 January 2008 02:30  |
Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh
|
Member |
|
|
In my database concurrency wait problem is going on. I ran AWR report and got ,
Top 5 Timed Events
-----------------------
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
latch: cache buffers chains 37,078 5,894 159 37.3 Concurrency
How I can resolve the problem or what changes should I make so that concurrency problem would not occur.
[Updated on: Tue, 22 January 2008 02:30] Report message to a moderator |
|
|
|
|
|
| Re: Concurrency wait. How I can resolve. [message #295345 is a reply to message #295327] |
Tue, 22 January 2008 03:10  |
Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh
|
Member |
|
|
Thank you Michel, I read your link. I identify the hot block as well as segment and also the query for which concurrency wait problem happens. What will be my next step tuning SQL or what?
Thank you.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
