prewarming the flashcache
since Exadata only stores 8 storage indexes per storage region and these are likely chosen by the where clauses of the first sqls that run against a particular table, does it make sense to prewarm the cache by running a standard set of queries after any storage cell reboot ? Wouldn't this increase the predictability of Storage indexes without violating the hands off approach ? As i see it the uncertainty of whether a particular column has a storage index built on it is a problem if consistent performance is desired along with extreme performance :)