Smart Flash Cache in Oracle Exadata -2

Hi,

I will explain Smart Flash cache feature of Oracle Exadata in this article.

 

Read previous article before this.

Smart Flash Cache in Oracle Exadata -1

 

 

 

Exadata supports two types of flash cache mode: Write Through and Write Back. Write Through is default mode of Exadata.

 

Write Through

  • In this mode, when the write request, CellSRV writes the data to disk and sends confirmation to the database to continue the other operations and expects to receive an appropriate call to learn whether the data will be cache or not. Therefore, when this mode is used, no advantage in writing mode is achieved, but the sequential read operation is advantageous due to cache.
  • If the data will be read for the first time when the read request, CellSRV will decide whether to cache or not by considering various factors.

 

 

 

Write Back

Exadata Storage Software 11.2.3.2.0 version in the Write back mode  with write-intensive environments is selected to be advantageous when selected.

Exadata Storage Software 11.2.3.2.0 version with write-intensive environments in the Write back mode is selected to be advantageous when selected. When this mode is activated, the following actions are taken when the write operation is performed.

 

Write back mode in the Exadata Storage Software 11.2.3.2.0 have been more advantageous in the write-intensive databases. When this mode is activated, the following actions are done when the write operation is performed.

 

  • When the write request, CellSRV uses an intelligent Cache algorithm whether cache this request or not.
  • If the answer is OK, that data cached and and a confirmation will be sent to the database.
  • Data kept in cache can only be written to disk when it is used too little or when it is old.

 

 

 

You can learn which mode is used in Storage Server with the following query.

 

Or you can learn it from detailed features of Cell as follows.

Yada Cell in detaylı özelliklerinden de aşağıdaki gibi görebilirsiniz.

 

 

The following steps can be used to activate Writeback mode in Rolling mode.

CellCLI> drop flashcache

CellCLI> list griddisk attributes name,asmmodestatus,asmdeactivationoutcome

CellCLI> alter griddisk all inactive

CellCLI> alter cell shutdown services cellsrv

CellCLI> alter cell flashCacheMode=WriteBack

CellCLI> alter cell startup services cellsrv

CellCLI> alter griddisk all active

CellCLI> create flashcache all

CellCLI> list cell detail [OR] list cell attributes flashCacheMode

 

We need to perform above steps on each Cell Server. We can also do this in non-Rolling mode. However, when done in non-rolling mode, we need to have full downtime.

 

 

Writeback mode provides serious advantage to write to Cache/memory instead of disk. This mode is very suitable in database where writing operations are more than read requests. In general Write back is suitable for OLTP database, and Write Through is perfect for OLAP environments.

 

 
 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *