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>Figure 6-25 shows a single sample query providing the parameter details. In this single sample, three processes were waiting for file number 4 and block number 54. Another sample will normally show multiple processes waiting for a different buffer. Once you have a few samples, move on to step 2.
p><p>Figure 6-25. This sample v$session_wait-based OSM script swswp.sql displays the session numbers along with their wait event parameters for a given wait event. In this situation, we are looking for buffer busy waits parameter values and parameter value patterns.
p><p>Every Oracle block buffer is part of an Oracle segment. Every Oracle segment is a segment type, such as a data segment, index segment, undo segment, or temporary segment. The solution set is based, in part, on the segment type. Using the buffer busy wait event's p1 (file number) and p2 (block number) gathered in step 1, the segment type can be determined from a query based on dba_extents and dba_data_files, such as the one shown in Figure 6-26.
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!
|
