Databases Reference
In-Depth Information
Smart Flash Logging in Exadata X3 configurations can play an even greater and more beneficial role as the X3
storage cells have significantly more PCI flash. This decreases the probability of witnessing
FL_ACTUAL_OUTLIERS
metrics of significance.
13-4. Configuring Thresholds for Cell Metrics
Problem
You wish to create custom thresholds for specific Exadata metrics in order to generate alerts tailored to meet your
business requirements.
Solution
In this recipe, you will learn how to create a custom metric threshold to trigger alerts based on a desired condition.
This recipe will walk you through the steps to create a single threshold on a specific alert and show you how to create
the threshold, validate the threshold configuration using the
list threshold
CellCLI command, and confirm that the
threshold is working as planned.
1.
First, determine which metric you wish to customize the metric threshold for. In the
following example, we will use the
DB_IO_UTIL_LG
metric, which captures the I/O
utilization for a specific database on your Exadata Database Machine.
2.
Next, validate whether custom thresholds are configured by using the
list threshold
CellCLI command. You will see that we currently have no thresholds created:
CellCLI> list threshold
CellCLI>
3.
Use the
list metriccurrent
CellCLI command to determine the
metricObjectName
to
create the threshold for. Since the
DB_IO_UTIL_LG
metric is scoped to an Oracle database
name, you will see one or more database names in the
metricObjectName
attribute:
CellCLI> list metriccurrent DB_IO_UTIL_LG attributes name,metricObjectName
DB_IO_UTIL_LG DWPRD
DB_IO_UTIL_LG EDW
DB_IO_UTIL_LG VISX
DB_IO_UTIL_LG VISY
DB_IO_UTIL_LG _OTHER_DATABASE_
CellCLI>
4.
Above, we see four distinct named databases. Once you have decided which
metricObjectName
to create your threshold for, issue the following command to create
your threshold:
CellCLI> create threshold DB_IO_UTIL_LG.EDW -
> warning=50,critical=70,comparison='>',occurrences=2,observation=5
Threshold DB_IO_UTIL_LG.EDW successfully created
CellCLI>
Search WWH ::
Custom Search