Question: What is the hidden parameter
_awr_flush_threshold_metrics used for?
I need to export only my table and
index definitions for my schema. What are the ways to export
only the metadata definitions and not export the data?
Answer: The _awr_flush_threshold_metrics
= true parameter enables/disables flushing of AWR threshold
metrics. It is normally TRUE unless someone wants to disable
the flushing of the metrics for long-term retention. Also
how to flush awr data.
A Static Baseline uses AWR data from a user-defined
period which must be at least seven days. The statistics are
calculated once, when you define the baseline, and are used
forever until you switch to a new baseline. So Static
Baselines don't make any allowance for the change in a
system's work profile over time.