What is Exadata Smart Flash Logging?
In an OLTP environment, it is crucial to have fast response times to redo log writes i.e. low latency. When multiplexing redo logs for high availability i.e. to protect against hardware failure, redo log writes are only acknowledged when redo is written to all redo log members i.e when the slowest disk completes the write. By this nature, whenever a disk slows down even if for a moment it can have impact on redo log performance and throughput.
Flash alone can’t resolve this issue as flash can also momentarily slow down due to issues in erase cycles or wear leveling and remember the acknowledgement is only given when the redo is written to all redo log members.
Exadata Smart Flash Logging, is the feature that writes to both hard disk and flash with the acknowledgement given as soon as either completes the write, thus improving response time and throughput. So if a write is slow to hard disk the flash will give a quicker acknowledgement but when flash is experiencing a slow down due to erase cycles or wear leveling then the hard disk will acknowledge, smoothing out response times.
The Exadata Smart Flash Cache isn’t permanent but a temporary store to provide fast response times by storing redo until it’s safely written to disk.
No changes are required to redo log configuration and is transparent to database and recovery.
How to enable Smart Flash Logging?
It’s enabled out the box or for older systems it’s enabled when applying cell patch version 126.96.36.199 and also requires Database 188.8.131.52 Bundle Patch 11 or higher.
How to disable Smart Flash Logging?
This shouldn’t be done unless instructed to do so by Oracle Support or Development.
How much flash is used by Smart Flash Logging?
By default just 512Mb is used per cell, which should be sufficient for most situations. It’s a small investment for huge performance benefit. Statistics record the number of successful write and unsuccessful writes due to the temporary space filled. In which case the size may need to be increased. Also I/O Resource Manager (IORM) can be used to disable Smart Flash Logging for none critical databases.
Do standby redo logs use Smart Flash Logging?
Yes, standby redo logs benefit from Smart Flash Logging just as redo logs as long as cell patch 184.108.40.206 or higher is applied and Database 220.127.116.11 Bundle Patch 11 or higher is applied.
How to check that Smart Flash Logging is configured?
Using CellCLI run “LIST FLASHLOG DETAIL” and if output is returned as shown below with the details, then this means that Smart Flash Logging is configured:
[root@v1ex1dbadm01 ~]# dcli -g /opt/oracle.SupportTools/onecommand/cell_group -l root cellcli -e "list flashlog detail" v1ex1celadm01: name: v1ex1celadm01_FLASHLOG v1ex1celadm01: cellDisk: FD_00_v1ex1celadm01,FD_01_v1ex1celadm01 v1ex1celadm01: creationTime: 2015-06-28T17:52:43+01:00 v1ex1celadm01: degradedCelldisks: v1ex1celadm01: effectiveSize: 512M v1ex1celadm01: efficiency: 100.0 v1ex1celadm01: id: 366421ec-bf77-499e-870f-f0cf5390343e v1ex1celadm01: size: 512M v1ex1celadm01: status: normal v1ex1celadm02: name: v1ex1celadm02_FLASHLOG v1ex1celadm02: cellDisk: FD_01_v1ex1celadm02,FD_00_v1ex1celadm02 v1ex1celadm02: creationTime: 2015-06-28T17:52:44+01:00 v1ex1celadm02: degradedCelldisks: v1ex1celadm02: effectiveSize: 512M v1ex1celadm02: efficiency: 100.0 v1ex1celadm02: id: 9f670843-c9cc-4156-a32e-8d23fa79cdb8 v1ex1celadm02: size: 512M v1ex1celadm02: status: normal v1ex1celadm03: name: v1ex1celadm03_FLASHLOG v1ex1celadm03: cellDisk: FD_01_v1ex1celadm03,FD_00_v1ex1celadm03 v1ex1celadm03: creationTime: 2015-06-28T17:52:33+01:00 v1ex1celadm03: degradedCelldisks: v1ex1celadm03: effectiveSize: 512M v1ex1celadm03: efficiency: 100.0 v1ex1celadm03: id: 749bada6-8ae2-4c51-8410-97622f9a9532 v1ex1celadm03: size: 512M v1ex1celadm03: status: normal [root@v1ex1dbadm01 ~]#
For more info:
Exadata Smart Flash Logging FAQ (Doc ID 1372894.1)
Oracle Exadata Whitepaper: Exadata Smart Flash Cache Features and the Oracle Exadata Database Machine
If you found this blog post useful, please like as well as follow me through my various Social Media avenues available on the sidebar and/or subscribe to this oracle blog via WordPress/e-mail.
Zed DBA (Zahid Anwar)