Oracle Database Architecture Part 3 | Oracle SGA and Background Processes
#oracledatabasetutorial #oracledatabasearchitecture #oracledatabase
00:00 Introduction
00:19 Database Buffer Cache
00:46 Redo Log Buffer Cache
01:15 Java Pool
01:35 Large Pool
01:52 Streams Pool
02:00 Background Processes
02:42 SMON (SYSTEM MONITOR)
02:55 PMON (PROCESS MONITOR)
03:11 DBWRn (DATABASE WRITER)
03:28 CKPT (CHECKPOINT)
03:42 LGWR (LOG WRITER)
04:13 RECOVERER PROCESSES
04:26 ARCHIVER PROCESSES
Join Our Official Telegram Channel
👉t.me/ocptechnology
Chat with me on:
👉Join WhatsApp Group: whatsapp.com/channel/0029VaS0...
👉Join Telegram Group: t.me/+GyzG3cZgs3I4NWI1
ORACLE DATABASE ARCHITECTURE PART-1
👉 • ORACLE DATABASE ARCHIT...
ORACLE DATABASE ARCHITECTURE PART-2
👉 • Oracle Database Archit...
ORACLE DATABASE ARCHITECTURE PART-3
👉 • Oracle Database Archit...
ORACLE DATABASE ARCHITECTURE PART-4
👉 • How select statement w...
ORACLE DATABASE ARCHITECTURE PART-5
👉 • update statement proce...
MY Gadgets:
👉Mic amzn.to/3lYLBW8
👉Laptop amzn.to/3ndktCa
👉Mouse amzn.to/3jn58Ok
Chat with me on:
👉Oracle Interview application play.google.com/store/apps/de...
👉Facebook page / ocptechnology
👉Instagram / ocptechnology
👉Website ocptechnology.com/
👉Twitter / ocptechnology
Пікірлер: 15
Very useful
nice ,make similar for many more topics...
@ocptechnology
Жыл бұрын
Thank you dear, yes I'll upload soon
Nice video bro
@ocptechnology
Жыл бұрын
Thank you
Useful information
@ocptechnology
Жыл бұрын
Thank you
Nice videos. We need more!👏👏
@ocptechnology
Жыл бұрын
Thank you
Bro please upload the RAC background process
@ocptechnology
Жыл бұрын
Ok bro
Correct me if i am wrong If we issue checkpoint manually will it flushes the database buffer cache and log buffer cache
@ocptechnology
Жыл бұрын
No
@tamahesh
Жыл бұрын
@@ocptechnology when does checkpoint comes into existence?
@ocptechnology
Жыл бұрын
@@tamahesh the checkpoint is comes in picture when oracle transfer the new or updated blocks from buffer cache to datafiles.