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.
PleaseOut 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.
-------------------------------
10 Software vendors who rely on good performance data hate ASH with a passion. Third-party performance vendors spend a considerable amount of time and money creating and maintaining their low-overhead data collection facility. They would welcome ASH, except Oracle forces their customers to license ASH, which also allows customer to use Oracle performance products. So now the customer must ask the question, "Why purchase both Oracle's performance products and this vendor's product?" This is a question performance product vendors want to avoid.
11 Obviously, building a tool to sample v$session can be done. But on a large Oracle system, directly sampling from v$session and then storing that information can easily take over a minute!
12 Now don't panic. Every time I have checked, my inferences and ASH data match perfectly. We just need to be a little more careful and understand what we are viewing.
©2009, 2010 by Craig Shallahamer. This is copyrighted material.
PleaseOut 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.
|