Saturday, March 2, 2013

ORACLE - Exadata Smart Scan and Storage Index


SQL> set long 50000000
SQL> set pagesize 10000
SQL> select name, value
from v$sesstat a, v$statname b
where (a.statistic# = b.statistic#)
  and (a.sid) = userenv('sid')
  and (name in (
   'cell physical IO interconnect bytes returned by smart scan',
   'physical read IO requests',
   'physical read requests optimized',
   'cell physical IO bytes saved by storage index',
   'cell physical IO bytes eligible for predicate offload',
   'cell num smart IO sessions using passthru mode due to cellsrv',
   'cell num smart IO sessions using passthru mode due to user',
   'cell flash cache read hits',
   'db block gets',
   'db block gets from cache',
   'db block gets from cache (fastpath)',
   'db block gets direct')
)
order by name;


Reduced 'cell physical IO bytes saved by storage index' after storage cell upgrade to versions before 11.2.2.3.0 [ID 1321398.1]

No comments:

Post a Comment