Home » RDBMS Server » Performance Tuning » Concurrency and row cache lock problem in oracle10.2 (oracle10.2 ,suse linux)
Concurrency and row cache lock problem in oracle10.2 [message #382192] Wed, 21 January 2009 05:17 Go to next message
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

[Updated on: Wed, 21 January 2009 05:26]

Report message to a moderator

Re: Concurrency and row cache lock problem in oracle10.2 [message #382217 is a reply to message #382192] Wed, 21 January 2009 06:53 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- OraFAQ Forum Guide, Performance Tuning section
- Performances Tuning sticky
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide
- Database Performance Tuning Guide.

Regards
Michel
Previous Topic: converting Normal Table to Partitioned Table
Next Topic: Io cost too high
Goto Forum:
  


Current Time: Sat Dec 10 18:50:34 CST 2016

Total time taken to generate the page: 0.06262 seconds