Тёмный

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

Mallik034
Подписаться 21 тыс.
Просмотров 81 тыс.
50% 1

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
RU-vid: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: +966 543796525
WhatsApp: +91 9880616848
Email: malluramadurg@gmail.com
LinkedIn: / mallik034
RU-vid: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg

Опубликовано:

 

2 июл 2020

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 29   
@PraveenKumar-es7hh
@PraveenKumar-es7hh Год назад
Nice video sir Thanks for providing this video
@edouardmariustsafacktsague1068
@edouardmariustsafacktsague1068 6 месяцев назад
Well explained. Thank you!
@rahul4u805
@rahul4u805 2 года назад
Good one , very helpful. 👍
@vaddeashokraj
@vaddeashokraj 2 года назад
Good xplanation sir ji
@sarfaraz1683
@sarfaraz1683 9 месяцев назад
Excellent sir 👍
@user-sv3vh9pu7e
@user-sv3vh9pu7e 4 месяца назад
very useful topic Mallik . Thanks for providing this video if you profile the softcopy it would be so great
@pavankumarmallela4855
@pavankumarmallela4855 6 месяцев назад
Nice explanation sir
@HachtoAdventour
@HachtoAdventour 5 месяцев назад
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
@gomathyelango5574
@gomathyelango5574 9 месяцев назад
Thanks for the session, could you please share the document
@shubhamgupta997
@shubhamgupta997 2 года назад
please enable captions, some words are different to understand
@hosnitakwa8457
@hosnitakwa8457 2 года назад
so good nut please try to clarify the sound (too bad quality)
@Mallik034
@Mallik034 2 года назад
Thank for your feedback
@azharkazi2480
@azharkazi2480 Год назад
thats right Very Low Volume
@rohitjadhav1821
@rohitjadhav1821 2 года назад
You can explain details please make video
@BHARARHROYAL
@BHARARHROYAL 4 года назад
Nice explaination
@Mallik034
@Mallik034 4 года назад
Thank you.
@bhupendrasomwanshi2996
@bhupendrasomwanshi2996 2 года назад
Is it same for oracle 11g and 12c?
@Mallik034
@Mallik034 2 года назад
Its applicable for all oracle versions
@bhupendrasomwanshi2996
@bhupendrasomwanshi2996 2 года назад
Please tell Which oracle DB version you are explaining?
@Mallik034
@Mallik034 2 года назад
Its applicable to all oracle versions
@somuumadevi3005
@somuumadevi3005 10 месяцев назад
Which version is this
@Mallik034
@Mallik034 10 месяцев назад
19c
@lsraov6311
@lsraov6311 3 года назад
which process write from Database buffer cache to Redo log buffer?
@Mallik034
@Mallik034 3 года назад
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.
@lsraov6311
@lsraov6311 3 года назад
@@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.
@Mallik034
@Mallik034 3 года назад
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.
@Mallik034
@Mallik034 3 года назад
I ma glad that my channel and WhatsApp groups helping you.
@MrKhiladi2100
@MrKhiladi2100 2 года назад
Audio thik nhi hai bahot awaj kam hai maja nhi ayi video dekh k sorry
@kkjack123
@kkjack123 9 месяцев назад
🤮🤮🤮🤮
Далее
Oracle database architecture explanation in details
16:11
Smart Sigma Kid #funny #sigma #comedy
00:26
Просмотров 12 млн
Stay on your way 🛤️✨
00:34
Просмотров 5 млн
Oracle Database Architecture - Part1
1:00:12
Просмотров 73 тыс.
Smart Sigma Kid #funny #sigma #comedy
00:26
Просмотров 12 млн