In addition, the Oracle Expert rules are implemented to be conservative when making recommendations that result in resource reductions. Resource reduction rules require a minimum of 100 instance statistics samples to be collected before the rules are considered to be valid. Another advantage of performing iterative tuning with Oracle Expert over time is that as changes within the database environment, such as server upgrades or hardware changes, are made Oracle Expert will automatically identify any dependencies that occur. The Oracle Expert rule mechanism allows advanced users to have ultimate control over the analysis process. The subsequent analysis would ensure that no more than 40 percent of the total memory on the system was used for the instance.
Rules reside with the object that they affect.
All Rights Reserved.