Craig Shallahamer's Blog
|
You were brought to this page based on an internet search
and as a free service to Oracle DBAs.
The text below is an except from the book,
Oracle Performance Firefighting, written by
Craig Shallahamer of
OraPub, Inc.
Figures and tables are not included on this page, only their reference.
To order the book in either print or PDF form, click
here.
©2009, 2010 by Craig Shallahamer. This is copyrighted material.
Please—Out of respect for those involved in the creation of the book and also for
their familes, we ask you to respect the copyright both in intent and deed. Thank you.
-------------------------------
<p>* Balance the workload. If you have control over the workload intensity, during peak cloning activity, consider reducing the workload specifically associated with buffer cloning. While not an exciting technical solution, workload balancing can have significant positive performance results.
</p><p>A number of solutions can help to eradicate CBC issues. Before you try to resolve CBC latch issues, ensure they exist. I know this sounds strange and almost condescending, but I find many DBAs ponder implementing solutions that do not fit the problem. Figure 6-14 is what you might see if serious CBC latch contention exists.
</p><p>If you're on a system earlier than Oracle Database 10g, the top wait event will be latch free, and as I detailed in Chapter 3, you will need to confirm the latching issue is the CBC latch. With Oracle Database 10g and later systems, as shown in Figure 6-14, the wait event will be latch: cache buffers chains. In most cases, the CPU subsystem will be heavily utilized and overburdened.
</p>
©2009, 2010 by Craig Shallahamer. This is copyrighted material.
Please—Out of respect for those involved in the creation of the book and also for
their familes, we ask you to respect the copyright both in intent and deed. Thank you.
|
|
Know what's important before it's too late!
OraPub's
Performance Training
is like no other...
More Class Pics...
Get student testimonials!
|
