"cell Physical IO Interconnect Bytes" Wait Event In A Non-Exadata Server
(Doc ID 2079379.1)
Last updated on APRIL 25, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
AWR data:
Instance Activity Stats
Ordered by statistic name
Statistic Total per Second per Trans
cell physical IO interconnect bytes 798,064,968,192 8,867,820.79 116,158.51
v$sysstat will also show this statistic and other similar statistics:
SQL> select name, value from gv$sysstat where name like '%physical IO%';
NAME VALUE
---------------------------------------------------------------- ----------
cell physical IO interconnect bytes 798,064,968,192
cell physical IO bytes saved during optimized file creation 0
cell physical IO bytes saved during optimized RMAN file restore 0
cell physical IO bytes eligible for predicate offload 0
cell physical IO bytes saved by storage index 0
cell physical IO interconnect bytes returned by smart scan 0
cell simulated physical IO bytes eligible for predicate offload 0
cell simulated physical IO bytes returned by predicate offload 0
Example from AWR report:
physical read total bytes 465,890,599,424 5,176,814.56 67,810.47
physical write total bytes 332,174,368,768 3,691,006.24 48,348.04
cell physical IO interconnect bytes 798,064,968,192 8,867,820.79 116,158.51
465,890,599,424
+332,174,368,768
________________
798,064,968,192 total
Symptoms
When exadata hardware is not being used, but awr statistics or v$sysstat show exadata like statistics, it causes concern about a configuration or installation problem. Why are these statistics present?
Instance Activity Stats
Ordered by statistic name
Statistic Total per Second per Trans
cell physical IO interconnect bytes 798,064,968,192 8,867,820.79 116,158.51
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |