Oracle Processes Read/Write from/in (Datafile/Redo Log File/Archive Log File/Control File)
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)
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.
Ahmad · November 19, 2018 at 8:44 pm
Thanks dude
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