CPT 6: Oracle Database Server Architecture Overview - Oracle Database Basic Understanding

preview_player
Показать описание
Hello Friends,

Here with one more topic on.

CPT 6: Oracle Database Server Architecture Overview - Oracle Database Basic Understanding:
=============================================================================
PGA

SGA
- Shared pool
- Database buffer cache
- Redo log buffer
- Large pool
- Java pool
- Streams pool

Database Storage Architecture
- control files
- data files
- online redo log files
- parameter files
- Password file
- archived redo log files
- backup files
- alert log files
- trace files

Server Processes
- Dedicated server process
- Shared server process

Background Processes
- Database writer process (DBWn)
- Log writer process (LGWR)
- Checkpoint process (CKPT)
- System monitor process (SMON)
- Process monitor process (PMON)
- Recovered process (RECO)
- Archiver processes (ARCn)

#databse #OracleDatabaseServerArchitecture #RAC #exadata #oracle #oracledatabase #oracledba #database #databaseperformanceIssue

Please do follow me and support me on,

Skype: malluramadurg

Regards,
Mallikarjun Ramadurg
Mobile: +966 543796525
WhatsApp: +91 9880616848
Skype: malluramadurg
Рекомендации по теме
Комментарии
Автор

Nice video sir Thanks for providing this video

PraveenKumar-eshh
Автор

very useful topic Mallik . Thanks for providing this video if you profile the softcopy it would be so great

svvhpue
Автор

Hey mallik .. i had one doubt about stream pool.
How can you set the value of stream pool size default = 0 once its modified to higher number

HachtoAdventour
Автор

please enable captions, some words are different to understand

shubhamgupta
Автор

Thanks for the session, could you please share the document

gomathyelango
Автор

so good nut please try to clarify the sound (too bad quality)

hosnitakwa
Автор

You can explain details please make video

rohitjadhav
Автор

Please tell Which oracle DB version you are explaining?

bhupendrasomwanshi
Автор

which process write from Database buffer cache to Redo log buffer?

lsraov
Автор

Audio thik nhi hai bahot awaj kam hai maja nhi ayi video dekh k sorry

MrKhiladi