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.
-------------------------------
You may be able to specify memory allocated to ASH by setting the _ash_size (in bytes) instance parameter, but experience has shown Oracle does not always respect this setting.
By default, ASH is enabled on all Oracle Database 10g and above systems. With the instance parameter statistics_level=typical (default), ASH will be enabled. You can also directly turn ASH on or off by setting the instance parameter _ash_enable to either true or false. By default, when ASH buffers are written to the AWR tables, only one out of every ten samples is written. This is controlled by the _ash_disk_filter_ratio parameter, which has a default value of 10.
Personally, I would never change ASH parameters unless I had a very good reason for doing so. Even more risky would be to disable ASH. As Oracle turns increasingly to automated performance management, it needs the best performance data available, and it gets much of this data from ASH.
©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.
|