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 ...        ?    



orcun_turkecAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AkenathonCommented:
You don't have commands to control ratios, you need to dig deep into the causes for your contention and do something about it. Start by determining whether you actually have a problem... are your users complaining? Is your server hogged? What are all the symptoms and what do they tell you?

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?
0
pinkurayCommented:
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
0
schwertnerCommented:
Redo Log contention can be reduced in following ways:

1. Enlarge Redo Cache size (it is in the SGA, i.e. in the RAM)
2. Add additional Online Redo Log groups to the server  (on Hard Disks)
    For instance from 3 to 8
3. Enlarge the size of the members of the Online Redo Log groups
    For instance from 512 MB to 1024 MB or even more

Observe the interval between the log switches in the alert<SID>.ora file.
If log switces happen too often estimate again the above components.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
orcun_turkecAuthor Commented:
Thank you very much ...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.