OraFAQ Forum: Performance Tuning » Concurrency and row cache lock problem in oracle10.2

Home » RDBMS Server » Performance Tuning » Concurrency and row cache lock problem in oracle10.2 (oracle10.2 ,suse linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Concurrency and row cache lock problem in oracle10.2 [message #382192]

Wed, 21 January 2009 05:17

kordestaniamir
Messages: 1
Registered: January 2009
Location: iran

Junior Member

hi
I have concurrency problem while load on my DB increases to 30 or 40 request per second. I searched for a solution and found some answers for it like changing SGA Size and Increasing cache size of sequences related to row cache lock and I did it, but it made the situation worse and I had to revert everything.
CAN ANY BODY PROVIDE ME WITH ANY OTHER SOLUTION.
great thanks Sad