Hi,
I would like to know the Result Cache Efficiency in SQL Performance.
SGA - 1.6TB
ASMM configured
DBSIZE - 24TB
Sql Query uses bind variables and Avg ET in Secs - 70ms
Paritioned Table (Driving) - 16 P and locally partitioned indexes both size (1.4TB and 600GB) respectively.
If we use the result cache, will it boost the performance?
Regards,
Abhinav