Oracle Database and Instance Components - DBArch Video 3

[@zippienyanchera843]

The best instructor I’ve ever met! He makes things easily absorbable! God bless your heart and add you more wisdom!

[@elthuadbrongak8893]

The best teacher in my entire life!! Thank YOU!!!

[@devips5102]

Ramkumar Sir, no words to express my happiness when I listened to ur calsses. Thank you somuch sir

[@chiengdorkcy4851]

Phenomenal one!. That's reason why l respected Asian people. their confidence is phenomenal

[@pb25801705]

your videos are awesome and very helpful. Cheers from USA

[@shivanidesai7672]

Amazing for the first time I understood anything. You make it really so simple and you use as much as layman terms for anyone to understand. Great work sir Thank you

[@prabhakarraju1523]

EXCELLENT EXPLANATION SIR, YOU ARE DESERVED FOR THE COMMENTS TO PUT IN

[@me2507b4u]

This is a superb video. You explained architecture in layman terms. I have seen many oracle videos and by far this one is THE BEST. Never knew Oracle architecture would seem so easy to understand. Kudos to you!! Thanks for sharing.

[@RamkumarSwaminathan]

Thanks... Enjoy learning

[@manikanta-yd7zf]

U r correct.
This video is very good

[@anushavenkatesan685]

Thank you Sir!! 🙏 A million likes for the simple and efficient explanation of Oracle architecture 🙏

[@rosaliamulokoshi402]

You really are the best of the best. hats off for you Sir.

[@williamharris1334]

Thank You Ramkumar! Just remarkable and clear!

[@kristinaorgandzieva8913]

Best lecturer and infinity knowledge. Bravissimo !!!

[@chetanyadavvds]

no words to say how good you are explaining, Just a Masterpiece for anyone. To the point and, each & every point is very clear.

[@dineshtutorialhindi]

I have been watching your videos from more than one year. Your way of delivering contents are very simple and easier to understand. I really like it. Thank you very much.

[@MyRahulji]

awesome way of teaching...thanks

[@babuch154]

One of the best explanation I ever watched...

[@debashishbarua3241]

the great teacher, my 5 years kids understand your explanation.thank you

[@JG-gf9ho]

Very logically, clearly. Great job.

[@gopalbhawal]

Sir , Loved the Classes , You are an amazing teacher.

[@pavannayak6583]

Very good video where even a fresher can understand in and out... appreciate your efforts

[@RamkumarSwaminathan]

+pavan nayak thanks... Stay subscribed and share the channel with others

[@moneytricks1612]

Why the playlist name is hcl tcs?

[@spiraldynamics6008]

Amazing channel , i suscribe from France ! thank you professor!

[@RamkumarSwaminathan]

Thank... Enjoy Learning

[@fahedashraf8125]

Best ever channel and a best ever teacher

[@RamkumarSwaminathan]

Thank... Enjoy Learning

[@MrManoranjansethy]

Awesome delivery mr kumar ...thank you very much

[@RamkumarSwaminathan]

+info s thanks .. enjoy learning....

[@gexpress5209]

sir, you just made my day. i am so happy you are my teacher.

[@same95ful]

best explanation and easy to grasp and understand !

[@sofianerabia9863]

best teacher ever ever and ever !

[@yashtiwari4348]

Thanks, the way you explain is nice.

[@RamkumarSwaminathan]

Thanks

[@namratagire9405]

Thank You for the best explanation

[@sachurv7822]

What an amazing explanation. None can deliver information as easy as this to be understandable for noob like me. Thanks alot sir.
Looking forward to learn more from you sir. Subscribed now 🙌

[@filalieya7725]

good explanation thank you

[@youtubeenjoyer194]

best explanation for me!! thank you

[@Bruh-jw2ze]

God level teaching bruh 🙏🔥

[@manzoor5554]

Excellent work ....done .......

[@ahosanhabib9399]

best teacher

[@CoolCool-jp4hv]

Beautiful

[@santoshjaiswal9717]

When we start the database..what does it mean @3:12.

[@chitrasrinivas7089]

Tanq so much for this awesome vdo

[@technodba]

Very good explanation

[@AD-pe8mo]

Awesome.....

[@rajareddy5043]

Hi sir, your explanation is good. subscribed

[@ashok3760]

I really appreciated! Thank u for your service sir

[@RamkumarSwaminathan]

+ashok [ thanks... Enjoy learning...

[@ab4everunited]

This is the best explanation I could find. Thak you. But could you please expalin what buffer cache is for, it is a bit unclear for me.

[@RamkumarSwaminathan]

Thanks... Any change in a computer has to be done in memory, for the work in a database (files) , buffer cache is the memory area where the data is brought to read or modify data

[@ab4everunited]

Thank you Sir for the quick reply.

[@ruchk3872]

very nicely explained...thank you

[@RamkumarSwaminathan]

+Ruchi Kolla thanks

[@ahashanimon8370]

Sir, This is just amazing.

[@jayakrishnachanumuru]

Thank you so much sir🙏

[@tiktik3672]

Hi Sir. How oracle store data in Buffer Cache when loading a table which is larger than SGA size (full table scan) ? Thanks

[@vbrdas]

Sir u r amazing

[@seriouslycurious]

Amazing content !

[@alj631]

very good explanation!!!!

[@RamkumarSwaminathan]

Thanks.. Enjoy learning

[@vamsikrishna-jq2ti]

Well explained . I have subscribed already and shared with my fellow DBA's too. Please make a video on AWR report .

[@RamkumarSwaminathan]

+vamsi krishna thanks

[@RamkumarSwaminathan]

+vamsi krishna I have a playlist on performance.. kindly go thru that..

[@swapnilmodhave9667]

nice video sir it very easy to understand

[@RamkumarSwaminathan]

+Swapnil Modhave thanks

[@funontherun85]

great explanation !

[@RamkumarSwaminathan]

Thanks... Enjoy learning

[@rajendra6871]

Sir one doubt, checkpoint ibfo will be written into dsatafiles and redo logs OR datafiles and controlfiles ??

[@RamkumarSwaminathan]

Checkpoint information is written to Datafiles and COntrolfile headers. THe below two links gives you more information on them from Oracle Documentation.docs.oracle.com/cd/E11882_01/server.112/e40540/process.htm#BABHFGFF
docs.oracle.com/cd/E11882_01/server.112/e40540/startup.htm#CNCPT89045

[@gtmgtm8312]

Sweat and shortly showed ropes., very Good brief for beginners.

[@RamkumarSwaminathan]

I am sorry... Didnt get that...

[@gtmgtm8312]

Ramkumar Swaminathan means that's a good starting video to understand further oracle videos.

[@RamkumarSwaminathan]

Thanks a lot... enjoy the learning... Your feedback is what encourages to create more... Please stay subscribed and you will get notified with the new videos...

[@mishrarohit723]

May I know how the modified data is moved to redo log buffer cache from db buffer cache

[@RamkumarSwaminathan]

The data is not moved... only the change log is maintained in the Log Buffer... DB Buffer Cache contains blocks.. which could have multiple rows in each block...

[@mvkishore]

Hi dba ji I have doubt here. Suppose I am updating a record so as u said db writer will write into datafile ie dirty buffer. But what is being updated to redolog. Does it have only log that certain data was changed or any data is also present there

[@RamkumarSwaminathan]

Redo has exact details of which rows were modified, old and new values for updates...

[@everydayinformation6337]

thank u so much sur for your explanation can provide us the documentation please ? 🙏

[@elmokhliss4852]

Thanks

[@bhaveshbhanushali7977]

awesome

[@mshubhangi]

Sir thanks for the video. Can we have it for 12c and 18c

[@tresorpharel4004]

Thank you for the explanation

[@RamkumarSwaminathan]

Most welcome... Enjoy learning

[@ab4everunited]

Hi Sir, do you have a website or something like that, where I could find the full Database architecture explanation in written format?

[@RamkumarSwaminathan]

Apologies, I don't have a blog.... It's only these videos through which I share my knowledge... There are more than 100 videos on my channel.... th-cam.com/users/RamkumarSwaminathan they are organised into playlists to help viewers

[@medo8832]

a million thanks

[@Creative-rv4if]

Ramkumar swaminathan sir can you please upload rac architecture please ur explanation is awesome

[@rajendrabangar4418]

Good explanation

[@RamkumarSwaminathan]

Thanks... enjoy learning

[@nabinpokhrel6129]

Thank you

[@sandy9732]

Sir,Please explain the pga

[@hbagi]

Awesome !

[@aliomoum1604wgsrr]

good .. thanks

[@RamkumarSwaminathan]

Thanks, enjoy learning

[@antoniodesousa1731]

What about the PGA????

[@RamkumarSwaminathan]

PGA will be apart from the SGA, its an additional memory created for the Processes to do process specific work... SGA is shared across all processes while PGA is specific to each process....

[@sagarjagtap940]

nice vedioes explained

[@RamkumarSwaminathan]

Enjoy learning

[@TechandArt]

Grt sir 🙏

[@tirupatiraoyegireddi2575]

Nice Sir..

[@krishprasad9153]

I still dont know what made that 7 ppl to dislike this video ? . Unfit to be a DBA !!!

[@RamkumarSwaminathan]

Enjoy learning...

[@loveall4969]

👍

[@nazirhussain7463]

Thanks a lot sir, how i can send you personal message?

[@RamkumarSwaminathan]

+Nazir Hussain send it to the email id given in the end of the videos

[@SaurabhRelia]

Respects

[@AmirHamza-oh1tp]

impressive

[@emilton0548]

Genius

[@nishakicooking1236]

How much earn from youTube sir please let we know

[@wolfdhib1]

nice

[@wolfdhib1]

will appreciate if you make a tutorial explaining in details how to analyse an AWR report 🙏

[@RamkumarSwaminathan]

Will make more videos on performance playlist

[@wolfdhib1]

yes please let us know :)

[@simpsonandrew9572]

This video is very comprehensive !

[@Bruh-jw2ze]

God level teaching bruh 🙏🔥

[@elmokhliss4852]

Thanks

[@donaldoji6399]

nice explanation

[@RamkumarSwaminathan]

Thanks... Enjoy Learning