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

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_MB
PHYSICAL_READ_REQUESTS PHY_R_MB PHYSICAL_WRITE_REQUESTS PHY_W_MB
---------- ---------- ------------ ------------- -----------
---------------------- ---------- -----------------------
----------         1 130755.328            0    259544.156
520041.828                2801860 130598.375                  641580
129899.297 *

*Thanks*

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 25 2014 - 17:38:00 CEST

Original text of this message