0 Replies Latest reply on Mar 15, 2019 4:06 PM by 3631781

    learning exadata

    3631781

      I have a quick question on some of the items in v$sql as they relate to the storage cells.  I have run the following query to see what is going on..

       

       

      select 
      sql_id,
      IO_CELL_OFFLOAD_ELIGIBLE_BYTES/1024/1024 eligible_GB ,
      IO_INTERCONNECT_BYTES/1024/1024  actual_GB,
      100*(IO_CELL_OFFLOAD_ELIGIBLE_BYTES-IO_INTERCONNECT_BYTES)/IO_CELL_OFFLOAD_ELIGIBLE_BYTES "IO_SAVED_%",
      IO_CELL_OFFLOAD_RETURNED_BYTES/1024/1024 returned_bytes_GB,
      sql_text
      from v$sql 
      where IO_CELL_OFFLOAD_ELIGIBLE_BYTES > 0
      and IO_INTERCONNECT_BYTES >0
      order by IO_CELL_OFFLOAD_ELIGIBLE_BYTES desc
      

       

      Now I get a result like this..

       

        

      ELIGIBLE_GBACTUAL_GBIO_SAVED_%RETURNED_BYTES_GB
      5,03419,688-29110,570
      5,03413,264-1638,649
      5,03418,594-26910,722
      2,39323490103
      2,25710,667-3735,070
      2,2552,1017792
      1,9181,50422907
      1,83601000
      1,63211,576-6095,739

       

      Now my question is why is the Actual_GB over(IO_INTERCONNECT_BYTES) three times the Eligible_GB(IO_CELL_OFFLOAD_ELIGIBLE_BYTES) thus making my IO_SAVED a negative number.

       

      and yes I am reading the documentation along with Expert Oracle Exadata book.  Thanks in advance..