museshad wrote:If you are not seeing the execution time decrease even after pinning segments in the cell flash cache and you verified that are cell flash cash IOs hits, then maybe the speed of IO isn't significant to your application performance. e.g. IO time is not a significant portion of the performance profile....
However I don't understand why this does not bring down the execution time?
Jagjeet Singh wrote:Exadata can read data from disk, flash, or both at the same time (blended read). That behavior is for smart scan reads and non-smart scan reads.
Do you mean smart scan can utilized Flash Cache as well, I had expression that smart scan will be kicked out for Direct read ( directly from datafiles ). so I thought it will be direct from Disk.