CPT 6: Oracle Database Server Architecture Overview - Oracle Database Basic Understanding
ฝัง
- เผยแพร่เมื่อ 21 ส.ค. 2024
- 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,
LinkedIn: / mallik034
TH-cam: / mallik034
Fakebook: / mallik034
Blog: mallik034.blog...
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: +966 543796525
WhatsApp: +91 9880616848
Email: malluramadurg@gmail.com
LinkedIn: / mallik034
TH-cam: / mallik034
Fakebook: / mallik034
Blog: mallik034.blog...
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Nice video sir Thanks for providing this video
Well explained. Thank you!
Good xplanation sir ji
Nice explanation sir
very useful topic Mallik . Thanks for providing this video if you profile the softcopy it would be so great
Excellent sir 👍
Good one , very helpful. 👍
Nice explaination
Thank you.
please enable captions, some words are different to understand
so good nut please try to clarify the sound (too bad quality)
Thank for your feedback
thats right Very Low Volume
Thanks for the session, could you please share the document
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
Is it same for oracle 11g and 12c?
Its applicable for all oracle versions
You can explain details please make video
Please tell Which oracle DB version you are explaining?
Its applicable to all oracle versions
Which version is this
19c
which process write from Database buffer cache to Redo log buffer?
There is no process to write DB buffer cache to log buffer cache.
DBWR - DB writer
Writes buffers from DB buffer cache to DB files
LGWR - log writer
Write change vectors from log buffer cache to redo logs.
@@Mallik034 In a couple of days back one of the interviewer ask this question, but any crack that interview and I am follow your sessions and group these are very helpful for got job and also learn new things Thank you so much sir.
Server process will write the blocks to db buffer cache whenever any sql operation happens either select or insert or delete.
At the same time i believe server process will update the change vector in the redo buffer cache.
I ma glad that my channel and WhatsApp groups helping you.
Audio thik nhi hai bahot awaj kam hai maja nhi ayi video dekh k sorry
🤮🤮🤮🤮