Oracle Performance Firefighting
by Craig Shallahamer

Get the book here



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.

-------------------------------

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