6.3.7.5 Monitoring Smart I/O Using Exadata Metrics
Smart I/O metrics are identified in the METRICCURRENT
,
METRICDEFINITION
, and METRICHISTORY
objects as
having objectType=SMARTIO
.
For cumulative metrics, the metric value for a specific time period can
be determined by subtracting values from different collectionTime
periods.
Example 6-6 Displaying Smart I/O Metric Definitions
This example shows how to display the smart I/O metric definitions that are available in the Oracle Exadata System Software.
CellCLI> LIST METRICDEFINITION ATTRIBUTES NAME,DESCRIPTION WHERE OBJECTTYPE = SMARTIO
SIO_IO_EL_OF "Cumulative number of megabytes eligible for smart IO offload"
SIO_IO_EL_OF_SEC "Number of megabytes per second eligible for smart IO offload"
SIO_IO_OF_RE "Cumulative number of interconnect megabytes returned by smart IO"
SIO_IO_OF_RE_SEC "Number of interconnect megabytes per second returned by smart IO"
SIO_IO_PA_TH "Cumulative number of megabytes of passthru IOs by smart IO"
SIO_IO_PA_TH_SEC "Number of megabytes per second of passthru IOs by smart IO"
SIO_IO_RD_FC "Cumulative number of megabytes read from flash cache by smart IO"
SIO_IO_RD_FC_HD "Cumulative number of megabytes read from both flash cache and hard disk by smart IO"
SIO_IO_RD_FC_HD_SEC "Number of megabytes per second read from both flash cache and hard disk by smart IO"
SIO_IO_RD_FC_SEC "Number of megabytes per second read from flash cache by smart IO"
SIO_IO_RD_HD "Cumulative number of megabytes read from hard disk by smart IO"
SIO_IO_RD_HD_SEC "Number of megabytes per second read from hard disk by smart IO"
SIO_IO_RD_RQ_FC "Cumulative number of read IO requests from flash cache by smart IO"
SIO_IO_RD_RQ_FC_HD "Cumulative number of read IO requests from both flash cache and hard disk by smart IO"
SIO_IO_RD_RQ_FC_HD_SEC "Number of read IO requests per second from both flash cache and hard disk by smart IO"
SIO_IO_RD_RQ_FC_SEC "Number of read IO requests per second from flash cache by smart IO"
SIO_IO_RD_RQ_HD "Cumulative number of read IO requests from hard disk by smart IO"
SIO_IO_RD_RQ_HD_SEC "Number of read IO requests per second from hard disk by smart IO"
SIO_IO_RV_OF "Cumulative number of megabytes sent to DB node to balance CPU by smart IO"
SIO_IO_RV_OF_SEC "Number of megabytes per second sent to DB node to balance CPU by smart IO"
SIO_IO_SI_SV "Cumulative number of megabytes saved by storage index"
SIO_IO_SI_SV_SEC "Number of megabytes per second saved by storage index"
SIO_IO_WR_FC "Cumulative number of megabytes of flash cache population writes by smart IO"
SIO_IO_WR_FC_SEC "Number of megabytes per second of flash cache population writes by smart IO"
SIO_IO_WR_HD "Cumulative number of megabytes written to hard disk by smart IO"
SIO_IO_WR_HD_SEC "Number of megabytes per second written to hard disk by smart IO"
SIO_IO_WR_RQ_FC "Cumulative number of IO requests for flash cache population writes by smart IO"
SIO_IO_WR_RQ_FC_SEC "Number of IO requests per second for flash cache population writes by smart IO"
SIO_IO_WR_RQ_HD "Cumulative number of write IO requests to hard disk by smart IO"
SIO_IO_WR_RQ_HD_SEC "Number of write IO requests per second to hard disk by smart IO"
Columnar cache metrics are identified as having name like
'FC_COL.*'
Example 6-7 Displaying Columnar Cache Metric Definitions
This example shows how to display the columnar cache metric definitions that are available in the Oracle Exadata System Software.
CellCLI> LIST METRICDEFINITION ATTRIBUTES NAME,DESCRIPTION WHERE NAME LIKE 'FC_COL.*'
FC_COL_BYKEEP_USED "Number of megabytes used for keep objects in Columnar FlashCache"
FC_COL_BY_USED "Number of megabytes used in Columnar FlashCache"
FC_COL_IO_BYKEEP_R "Number of megabytes read from Columnar FlashCache for keep objects"
FC_COL_IO_BYKEEP_R_SEC "Number of megabytes read per second from Columnar FlashCache for keep objects"
FC_COL_IO_BY_R "Number of megabytes that were read from Columnar FlashCache"
FC_COL_IO_BY_R_ELIGIBLE "Number of megabytes eligible to read from Columnar FlashCache"
FC_COL_IO_BY_R_ELIGIBLE_SEC "Number of megabytes per second eligible to read from Columnar FlashCache"
FC_COL_IO_BY_R_SEC "Number of megabytes per second that were read from Columnar FlashCache"
FC_COL_IO_BY_SAVED "Number of megabytes saved by reads from Columnar FlashCache"
FC_COL_IO_BY_SAVED_SEC "Number of megabytes saved per second by reads from Columnar FlashCache"
FC_COL_IO_BY_W_POPULATE "Number of megabytes that are population writes into Columnar FlashCache due to read miss"
FC_COL_IO_BY_W_POPULATE_SEC "Number of megabytes per second that are population writes into Columnar FlashCache due to read miss"
FC_COL_IO_RQKEEP_R "Number of requests read for keep objects from Columnar FlashCache"
FC_COL_IO_RQKEEP_R_SEC "Number of requests read per second for keep objects from Columnar FlashCache"
FC_COL_IO_RQ_R "Number of requests that were read from Columnar FlashCache"
FC_COL_IO_RQ_R_ELIGIBLE "Number of reads eligible for Columnar FlashCache"
FC_COL_IO_RQ_R_ELIGIBLE_SEC "Number of reads per second eligible for Columnar FlashCache"
FC_COL_IO_RQ_R_SEC "Number of requests per second that were read from Columnar FlashCache"
FC_COL_IO_RQ_W_POPULATE "Number of requests that are population writes into Columnar FlashCache due to read miss"
FC_COL_IO_RQ_W_POPULATE_SEC "Number of requests per second that are population writes into Columnar FlashCache due to read miss"
Parent topic: Monitoring Smart I/O