Oracle Processes Read/Write from/in (Datafile/Redo Log File/Archive Log File/Control File)

Published by Ahmad on

Oracle Processes Read/Write from/in (Datafile/Redo Log File/Archive Log File/Control File)

In Oracle Database 5  Background Processes will Read/Write from 

Datafile

Redo Log File

Archive Log File

Control File

 & these 5 Background Processes are-:

CKPT

DBWN

LGWR

ARCn

SERVER PROCESS


1-CKPT -:  Read/Write from/in Data File Headers.

           Read/Write from/in Control File.

2-DBWn -:  Write in Data File Only.

3-Lgwr -:  Write in Redo Log File.
  
           Read/Write from/in Control File.

4-ARCn -:  Read from Redo Log File.

           Write in Archive Log File.

           Read/Write from/in Control File.

5-Server Process -: Read/Write from/in Data file.

                    Read from Redo Log File.

                    Write in Archive Log File.

                    Read/Write from/in Control File.

Check regularly my post and give feedback & comments.

Thanks

Ahmad

(Oracle Consultant)

(OCE in 11gR2 RAC)

(OCP in 11gR2/10gR2/9iR2)

 

 

 

Categories: Database

16 Comments

Rashmeet Kaur · November 13, 2018 at 1:45 pm

Thanks for sharing such an useful information. keep writing your blogs Sir.

Justin · November 13, 2018 at 5:38 pm

Hello sir all the information provided are really informative and useful

Nassyam Basha · November 13, 2018 at 6:14 pm

Excellent Info.

Somesh · November 13, 2018 at 8:59 pm

Good post. Simple and easy to understand.

Gopi · November 13, 2018 at 9:55 pm

Awesome.. Thanks for sharing!!

Abdulmatheen · November 14, 2018 at 1:40 am

Very useful info,in tabular form classic,thanks for sharing.

Mohammmed Anzar Khan · November 14, 2018 at 9:44 am

Indeed Sir… Very important and conceptual information which includes internal flow of databases.

Mohammmed Anzar Khan · November 14, 2018 at 9:46 am

Indeed Sir… Very important and conceptual information which includes internal flow of database as well.

Mujeeb · November 14, 2018 at 9:50 am

Well Explained & good information.

prasannakumar · November 14, 2018 at 6:40 pm

Thanks for sharing…great job

Sunil · November 14, 2018 at 7:12 pm

Very Crucial basic information, gr8 Explanation.

    JAFFER · November 14, 2018 at 9:37 pm

    Indepth details explaining simply. Thanks for such great news sharing us.

JAFFER · November 14, 2018 at 9:33 pm

Indepth details explaining simply. Thanks for such great news sharing us.

manish Yadav · November 15, 2018 at 6:15 am

Great information. Thanks

Mukesh · November 15, 2018 at 3:27 pm

Very useful info

Leave a Reply

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