Important! For Oracle databases, do not collect statistics on the temporary tables such as TMP_Wgn3RLS.
The temporary database tables are dynamic tables, with rows continually being added or removed. Any statistics gathered on these tables are never accurate. For example, if you collect statistics for a temporary table while it is empty, the query optimizer will fail to identify the most efficient query mechanism. This can seriously undermine performance and event searches filtered by management group may be significantly slower.
Instead of collecting statistics on temporary database tables, set the following Oracle initialization parameter to 4. This ensures that statistics are collected immediately before a query runs, allowing searches to be optimized correctly.
optimizer_dynamic_sampling
Note: Wgn_stats deletes statistics from all temporary tables.
|
Copyright © 2014 CA.
All rights reserved.
|
|