August 26, 2013

Exadata Statistics

Here is the list of Oracle Exadata Statistics.

cell physical IO interconnect bytes
cell physical IO interconnect bytes returned by smart scan
cell physical IO bytes saved during optimized file creation
cell physical IO bytes saved during optimized RMAN file restore
cell physical IO bytes eligible for predicate offload
cell physical IO bytes saved by storage index

cell smart IO session cache lookups
cell smart IO session cache hits
cell smart IO session cache soft misses
cell smart IO session cache hard misses
cell smart IO session cache hwm
cell smart IO sessions hwm
cell smart IO allocated memory bytes
cell smart IO memory bytes hwm

cell num smart IO sessions in rdbms block IO due to user
cell num smart IO sessions in rdbms block IO due to no cell mem
cell num smart IO sessions in rdbms block IO due to big payload
cell num smart IO sessions using passthru mode due to user
cell num smart IO sessions using passthru mode due to cellsrv
cell num smart IO sessions using passthru mode due to timezone
cell num smart file creation sessions using rdbms block IO mode
cell num fast response sessions
cell num fast response sessions continuing to smart scan
cell num active smart IO sessions

cell blocks processed by cache layer
cell blocks processed by txn layer
cell blocks processed by data layer
cell blocks processed by index layer
cell blocks helped by commit cache
cell blocks helped by minscn optimization

cell simulated physical IO bytes eligible for predicate offload
cell simulated physical IO bytes returned by predicate offload

cell CUs sent uncompressed
cell CUs sent compressed
cell CUs sent head piece
cell CUs processed for uncompressed
cell CUs processed for compressed

cell IO uncompressed bytes
cell scans
cell index scans
cell flash cache read hits
cell commit cache queries
cell transactions found in commit cache

Related Articles:  Exadata Waitevents  Oracle Exadata Terms   Oracle Exadata Interview Questions  IPMI tool