orcun_turkec
asked on
How can I reduce Redo Latch Contention Ratio in Oracle 11G ?
Hi experts,
I' m using Oracle 11G on . I need to reduce Redo Latch Contention Ratio .
Which parameters are used to reduce this ratio ? And what must me the exact commands,
like alter system set ... ?
I' m using Oracle 11G on . I need to reduce Redo Latch Contention Ratio .
Which parameters are used to reduce this ratio ? And what must me the exact commands,
like alter system set ... ?
Please find the below URL and check " Identifying & Reducing Redo Allocation Latch Contention" :
http://www.toadworld.com/KNOWLEDGE/KnowledgeXpertforOracle/tabid/648/TopicID/RRALC2/Default.aspx
http://www.toadworld.com/KNOWLEDGE/KnowledgeXpertforOracle/tabid/648/TopicID/RRALC2/Default.aspx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much ...
Maybe it's just that you're firing a batch with a commit inside a fast loop, or have everything else tuned so well that short OLTP transactions are only so fast because of commit serialization (in that case, whatever you are seeing is actually GOOD).
In any case, please share the evidence: What's your scenario (CPU, RAM, OLTP/OLAP, problem history)? How did you get the metrics and when did it change?