7.7.12.20 LIST METRICHISTORY

Purpose

The LIST METRICHISTORY command displays a list of individual metrics.

Syntax

LIST METRICHISTORY [ name | attribute_filters ]  [attribute_list]  
                   {over_specification] [MEMORY] [DETAIL]

Usage Notes

• You can use the DESCRIBE METRICHISTORY command to view the complete list of METRICHISTORY attributes.

• The retention period for most metric history files is specified by the metricHistoryDays cell attribute. The default retention period is 7 days. You can modify this setting with the CellCLI ALTER CELL command.

  In addition to the metrics governed by the metricHistoryDays cell attribute, a subset of key metric observations are retained for up to one year. In all cases, historical metric observations are purged automatically if the server detects a storage space shortage.

• The over_specification syntax is as follows:

  OVER number [aggregation_type [aggregation_type]...] 
  

  In the preceding syntax, number is amount of time in minutes for the aggregation, and aggregation_type can be max, min, or avg.

• A WHERE clause can include the ageInMinutes attribute to specify the list is limited to those metrics which have the specified age. For example, the following command would show the metrics created in the previous 15 minutes:

  CellCLI> LIST METRICHISTORY WHERE ageInMinutes < 15
  

Examples

Example 7-187 Listing METRICHISTORY Attributes

This example shows the LIST command with the METRICHISTORY object, and the corresponding output. To reduce the size of the output when you run the LIST METRICHISTORY command, use filters.

CellCLI> LIST METRICHISTORY WHERE name like 'CL_.*'           -
            AND collectionTime > '2009-07-01T15:28:36-07:00'

         CL_RUNQ         stbcr03_2       6.0     2009-07-01T15:28:37-07:00
         CL_CPUT         stbcr03_2       47.6 %  2009-07-01T15:29:36-07:00
         CL_FANS         stbcr03_2       1       2009-07-01T15:29:36-07:00
         CL_TEMP         stbcr03_2       0.0 C   2009-07-01T15:29:36-07:00
         CL_RUNQ         stbcr03_2       5.2     2009-07-01T15:29:37-07:00

Example 7-188 Listing METRICHISTORY Using the OVER and MEMORY Attributes

This example shows the LIST METRICHISTORY command with the OVER and MEMORY options.

CellCLI> LIST METRICHISTORY cl_cput OVER 10 MIN MAX MEMORY
        CL_CPUT         firstcell       55.0 %  2009-11-15T06:00:17-08:00      55.0 %   57.1 %
        CL_CPUT         firstcell       54.7 %  2009-11-15T06:10:17-08:00      54.7 %   56.3 %
        CL_CPUT         firstcell       54.8 %  2009-11-15T06:20:18-08:00      54.7 %   57.2 %
        CL_CPUT         firstcell       55.0 %  2009-11-15T06:30:18-08:00      54.3 %   55.9 %
        CL_CPUT         firstcell       55.0 %  2009-11-15T06:40:18-08:00      54.9 %   57.0 %
        CL_CPUT         firstcell       55.1 %  2009-11-15T06:50:18-08:00      54.8 %   56.4 %
        CL_CPUT         firstcell       58.0 %  2009-11-15T07:00:18-08:00      55.2 %   58.0 %
        CL_CPUT         firstcell       55.5 %  2009-11-15T07:10:18-08:00      55.5 %   67.5 % 

Example 7-189 Listing METRICHISTORY Attributes Using ORDER BY and LIMIT

This example shows the LIST METRICHISTORY command with the ORDER BY and LIMIT options.

CellCLI> LIST METRICHISTORY WHERE name like '.*IO_RQ.*' DETAIL ORDER BY  -
         metricValue desc, metricObjectName desc LIMIT 4

name:                   CT_FD_IO_RQ_SM
alertState:             normal
collectionTime:         2014-05-23T10:59:06-07:00
metricObjectName:       OTHER
metricType:             Cumulative
metricValue:            3,211,568 IO requests
objectType:             IORM_CATEGORY
 
name:                   CT_FD_IO_RQ_SM
alertState:             normal
collectionTime:         2014-05-23T10:58:06-07:00
metricObjectName:       OTHER
metricType:             Cumulative
metricValue:            3,211,568 IO requests
objectType:             IORM_CATEGORY
 
name:                   CT_FD_IO_RQ_SM
alertState:             normal
collectionTime:         2014-05-22T17:23:45-07:00
metricObjectName:       OTHER
metricType:             Cumulative
metricValue:            3,211,568 IO requests
objectType:             IORM_CATEGORY
 
name:                   CT_FD_IO_RQ_SM
alertState:             normal
collectionTime:         2014-05-22T17:21:41-07:00
metricObjectName:       OTHER
metricType:             Cumulative
metricValue:            3,211,568 IO requests
objectType:             IORM_CATEGORY

Example 7-190 Listing METRICHISTORY Attributes with ASM-scoped security configured

This example for Oracle Exadata System Software release 19.1.0 shows the LIST METRICHISTORY command with the DETAIL option for a system with ASM-scoped security configured.

CellCLI> LIST METRICHISTORY WHERE name like 'DB_IO_RQ_SM' DETAIL ORDER BY  -
         metricObjectName LIMIT 4

name:                   DB_IO_RQ_SM
alertState:             normal
collectionTime:         2018-08-23T07:34:12-05:00
metricObjectName:       ASM
metricType:             Cumulative
metricValue:            *.
objectType:             IORM_DATABASE
 
name:                   DB_IO_RQ_SM
alertState:             normal
collectionTime:         2018-08-23T07:33:38-05:00
metricObjectName:       ASM1.PRODDB
metricType:             Cumulative
metricValue:            *.
objectType:             IORM_DATABASE
 
name:                   DB_IO_RQ_SM
alertState:             normal
collectionTime:         2018-08-22T14:27:45-05:00
metricObjectName:       ASM1.PRODDB
metricType:             Cumulative
metricValue:            *.
objectType:             IORM_DATABASE
 
name:                   DB_IO_RQ_SM
alertState:             normal
collectionTime:         2018-08-22T14:25:06-05:00
metricObjectName:       _OTHER_DATABASE_
metricType:             Cumulative
metricValue:            *.
objectType:             IORM_DATABASE