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.
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
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.
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 🙌
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...
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
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...
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
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
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.... ruclips.net/user/RamkumarSwaminathan they are organised into playlists to help viewers
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....
The best instructor I’ve ever met! He makes things easily absorbable! God bless your heart and add you more wisdom!
The best teacher in my entire life!! Thank YOU!!!
Ramkumar Sir, no words to express my happiness when I listened to ur calsses. Thank you somuch sir
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.
Thanks... Enjoy learning
U r correct.
This video is very good
Phenomenal one!. That's reason why l respected Asian people. their confidence is phenomenal
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
your videos are awesome and very helpful. Cheers from USA
Thank you Sir!! 🙏 A million likes for the simple and efficient explanation of Oracle architecture 🙏
EXCELLENT EXPLANATION SIR, YOU ARE DESERVED FOR THE COMMENTS TO PUT IN
Thank You Ramkumar! Just remarkable and clear!
Best lecturer and infinity knowledge. Bravissimo !!!
You really are the best of the best. hats off for you Sir.
awesome way of teaching...thanks
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.
the great teacher, my 5 years kids understand your explanation.thank you
Very logically, clearly. Great job.
One of the best explanation I ever watched...
Best ever channel and a best ever teacher
Thank... Enjoy Learning
Sir , Loved the Classes , You are an amazing teacher.
no words to say how good you are explaining, Just a Masterpiece for anyone. To the point and, each & every point is very clear.
Very good video where even a fresher can understand in and out... appreciate your efforts
+pavan nayak thanks... Stay subscribed and share the channel with others
Amazing channel , i suscribe from France ! thank you professor!
Thank... Enjoy Learning
best teacher ever ever and ever !
Awesome delivery mr kumar ...thank you very much
+info s thanks .. enjoy learning....
good explanation thank you
Thank You for the best explanation
Thanks, the way you explain is nice.
Thanks
sir, you just made my day. i am so happy you are my teacher.
best explanation for me!! thank you
Why the playlist name is hcl tcs?
Beautiful
best teacher
Tanq so much for this awesome vdo
Awesome.....
best explanation and easy to grasp and understand !
God level teaching bruh 🙏🔥
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 🙌
Very good explanation
Excellent work ....done .......
very nicely explained...thank you
+Ruchi Kolla thanks
I really appreciated! Thank u for your service sir
+ashok [ thanks... Enjoy learning...
Sir u r amazing
very good explanation!!!!
Thanks.. Enjoy learning
nice video sir it very easy to understand
+Swapnil Modhave thanks
Sweat and shortly showed ropes., very Good brief for beginners.
I am sorry... Didnt get that...
Ramkumar Swaminathan means that's a good starting video to understand further oracle videos.
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...
Hi sir, your explanation is good. subscribed
Thank you so much sir🙏
Sir, This is just amazing.
Thanks
great explanation !
Thanks... Enjoy learning
awesome
Amazing content !
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.
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
Thank you Sir for the quick reply.
Well explained . I have subscribed already and shared with my fellow DBA's too. Please make a video on AWR report .
+vamsi krishna thanks
+vamsi krishna I have a playlist on performance.. kindly go thru that..
Thank you for the explanation
Most welcome... Enjoy learning
Good explanation
Thanks... enjoy learning
a million thanks
Hi Sir. How oracle store data in Buffer Cache when loading a table which is larger than SGA size (full table scan) ? Thanks
Thank you
thank u so much sur for your explanation can provide us the documentation please ? 🙏
nice vedioes explained
Enjoy learning
May I know how the modified data is moved to redo log buffer cache from db buffer cache
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...
When we start the database..what does it mean @3:12.
Awesome !
👍
good .. thanks
Thanks, enjoy learning
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
Redo has exact details of which rows were modified, old and new values for updates...
Sir one doubt, checkpoint ibfo will be written into dsatafiles and redo logs OR datafiles and controlfiles ??
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
Ramkumar swaminathan sir can you please upload rac architecture please ur explanation is awesome
Sir thanks for the video. Can we have it for 12c and 18c
Grt sir 🙏
I still dont know what made that 7 ppl to dislike this video ? . Unfit to be a DBA !!!
Enjoy learning...
Nice Sir..
Hi Sir, do you have a website or something like that, where I could find the full Database architecture explanation in written format?
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.... ruclips.net/user/RamkumarSwaminathan they are organised into playlists to help viewers
impressive
Sir,Please explain the pga
Respects
Genius
nice
will appreciate if you make a tutorial explaining in details how to analyse an AWR report 🙏
Will make more videos on performance playlist
yes please let us know :)
What about the PGA????
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....
Thanks a lot sir, how i can send you personal message?
+Nazir Hussain send it to the email id given in the end of the videos
How much earn from youTube sir please let we know
This video is very comprehensive !
God level teaching bruh 🙏🔥
Thanks
nice explanation
Thanks... Enjoy Learning