What is Result cache
parameters related to result cache
how to write your results using hint to result cache and access them.
what happens to results in result cache when the underlying tables undergo DML/DDL
what happens to result cache when shared pool is flushed
what other internal features access result cache.