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.
-------------------------------
13 As a side note-and I have tested this-the ASH sample frequency does not affect the time model views update frequency.
14 This maximum value will certainingly change from one Oracle version to the next, so don't look at this number as a fixed maximum, but more of an indication of how much memory Oracle may want to keep specifically for ASH buffers.
15 There is a kind of double hit in this situation. Because many hardware and software licenses are based on the number of CPU cores, the more CPU consumed by performance software, the more any CPU-related license will cost. So the cost of CPU consumption is not just the simple CPU time consumption calculation, but is also related to the cost of software licenses.
©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.
|