Shulou(Shulou.com)06/01 Report--

Step 1: start the transaction

Step 2: find the required data block in buffer cache, and if not, load it into buffer cache from the data file

Step 3: the transaction modifies the data block of buffer cache, which is identified as "dirty data" and written to log buffer.

Step 4: transaction commit, and the LGWR process writes the log entries of "dirty data" in log buffer to redo log file.

Step 5: when the checkpoint,CKPT process updates the information in the headers of all data files, the DBWn process is responsible for writing the dirty data in Buffer Cache to the data file.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.