Monitoring Exadata Storage Cells - Oracle Exadata Recipes: A Problem-Solution Approach - page 385

characters preceding both single quotes and open and close parentheses, as well as double quotes enclosing the
entire cellcli command:

[oracle@cm01dbm01 ~]$ dcli -g ./cell_group "cellcli -e \
> alter iormplan objective=\'auto\', \
> dbplan=\(\(name=visx,level=1,allocation=55\), \
> \(name=prod1,level=1,allocation=25\), \
> \(name=prod2,level=1,allocation=65\), \
> \(name=other,level=2,allocation=100\)\), \
> catplan=\(\(name=CAT_HIGH,level=1,allocation=70\), \
> \(name=CAT_MEDIUM,level=1,allocation=20\), \
> \(name=CAT_LOW,level=2,allocation=80\), \
> \(name=other,level=3,allocation=100\)\)"
cm01cel01: IORMPLAN successfully altered
cm01cel02: IORMPLAN successfully altered
cm01cel03: IORMPLAN successfully altered
[oracle@cm01dbm01 ~]$

How It Works
When using dcli to execute either CellCLI commands or host commands, there are two important considerations:
If the command contains any special characters or punctuation marks, the entire command

•

needs to be enclosed in double quotes.

\) .
With dcli , the following characters are considered special characters :
The dollar sign:

• To escape special characters, use the backslash character (

•

$
The single quote: ' •

• The less than sign:

<
The greater than sign: •

>
Open and close parentheses:

( and )
Failure to properly escape special characters in dcli could lead to either an error being raised or no output
being returned.

•

13-6. Reporting and Summarizing metrichistory Using R
Problem
You wish to summarize historical Exadata Storage Server metrics in order to recognize performance trends.

Solution
In this recipe, you will learn how to generate metrichistory metric values for specific Exadata metrics and
summarize the information using a simple shell script combined with an R script.
Since the scripts in this recipe include reporting statistical metric information using R and using an R script to
plot metric information, the first step you must perform is to install R on one of your Exadata Compute Nodes.