Need to know if we could pin redo logs into smart flash cache.
For example to pin table..
we use Alter table dhaval storage (cell_flash_cache keep) -----
Similarly can we pin redo logs into flash cache ?
If not, what is the alternative to put redo logs into flash cache ?
We need to read online redo log files,we use Oracle Golden Gate technology for replication.
Goal is to achieve best possible "read speed" from redo log files
Again, if its not possible using flash cache, need to know alternative.
In that case, are you sure that lowering the read service time will speed up the GG processing of the logs? Just want to be sure that lowering the read service time will indeed speed up the process - no sense tuning it if that's not the bottleneck.
If it is and you think read service time is the only bottleneck at this time, then the only option I know of would be to create a diskgroup out of a portion of the flash disks. This reduces the flash cache size available to the system, so be sure that the benefit will outweigh the cost.
I don't think we have a way to pin online redo logs in flash cache currently. Others can correct me if I'm wrong.
At Oracle OpenWorld the Exadata Smart Flash Log feature was announced. The Smart Flash Log feature requires Exadata Storage 18.104.22.168.0 or later, and Databases version 22.214.171.124 Bundle Patch 11 or greater. This feature allows a modest amount of flash to be used as a secondary write place. It wites redo to both flash and disk and returns the call to the db for the first one that finishes. By doing so it improves user transaction response time, and increases overall database throughput for IO intensive workloads.