IO_CELL_OFFLOAD_RETURNED_BYTES stats
From: Ls Cheng <exriscer_at_gmail.com>
Date: Fri, 25 Apr 2014 17:38:00 +0200
Message-ID: <CAJ2-Qb9T5gmfAZ0Fq0hD=kt=0ptDE3hx-f1g4axZ-NmsyjfR-Q_at_mail.gmail.com>
Hi
Date: Fri, 25 Apr 2014 17:38:00 +0200
Message-ID: <CAJ2-Qb9T5gmfAZ0Fq0hD=kt=0ptDE3hx-f1g4axZ-NmsyjfR-Q_at_mail.gmail.com>
Hi
I am check a query statistics in Exadata and I noticed that v$sql.IO_CELL_OFFLOAD_ELIGIBLE_BYTES is cero but IO_CELL_OFFLOAD_RETURNED_BYTES has a pretty high value.
How can this possible?
*selectexecutions,disk_reads*16384/(1024*1024)
PHY_MB,IO_CELL_OFFLOAD_ELIGIBLE_BYTES/1024/1024 as "OFFLOADED_MB",
IO_CELL_OFFLOAD_RETURNED_BYTES/1024/1024 as
"OFFLOAD_RT_MB",IO_INTERCONNECT_BYTES/1024/1024 as
"ICONNECT_MB",PHYSICAL_READ_REQUESTS ,PHYSICAL_READ_BYTES/1024/1024 PHY_R_MB , PHYSICAL_WRITE_REQUESTS ,PHYSICAL_WRITE_BYTES/1024/1024 PHY_W_MBfrom v$sqlwhere sql_id = '4j92kqhrpcpr6'EXECUTIONS PHY_MB OFFLOADED_MB OFFLOAD_RT_MB ICONNECT_MBPHYSICAL_READ_REQUESTS PHY_R_MB PHYSICAL_WRITE_REQUESTS PHY_W_MB
---------- ---------- ------------ ------------- ----------- ---------------------- ---------- ----------------------- ---------- 1 130755.328 0 259544.156 520041.828 2801860 130598.375 641580129899.297 *
*Thanks*
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 25 2014 - 17:38:00 CEST