HomeНаука и техникаRelated VideosMore From: Ramkumar Swaminathan

Oracle Database and Instance Components - DBArch Video 3

260 ratings | 23544 views
In this video you will learn about the Relationship between and Oracle Instance and an Oracle Database. You will know about the various components of an Instance ( SGA and Background Processes) and the various files of the Database and how they interact. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Html code for embedding videos on your blog
Text Comments (61)
Antonio de Sousa (7 days ago)
What about the PGA????
Ramkumar Swaminathan (5 days ago)
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....
Donald Oji (11 days ago)
nice explanation
Ramkumar Swaminathan (9 days ago)
Thanks... Enjoy Learning
The Marvel Lover (15 days ago)
Now this is what is call a explanation, I didn't even had to replay a single second clip, explained so beautifully, Mai to aapka fan hogaya :D :D , all the best.!!
Ramkumar Swaminathan (9 days ago)
Thanks... Enjoy Learning
ALJ (25 days ago)
very good explanation!!!!
Ramkumar Swaminathan (20 days ago)
Thanks.. Enjoy learning
Fahed Ashraf (2 months ago)
Best ever channel and a best ever teacher
Ramkumar Swaminathan (2 months ago)
Thank... Enjoy Learning
Spiral Dynamics (2 months ago)
Amazing channel , i suscribe from France ! thank you professor!
Ramkumar Swaminathan (2 months ago)
Thank... Enjoy Learning
Neha Koul (3 months ago)
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.
Ramkumar Swaminathan (2 months ago)
Thanks... Enjoy learning
Rajendra patel (3 months ago)
Sir one doubt, checkpoint ibfo will be written into dsatafiles and redo logs OR datafiles and controlfiles ??
Ramkumar Swaminathan (3 months ago)
Checkpoint information is written to Datafiles and COntrolfile headers. THe below two links gives you more information on them from Oracle Documentation.https://docs.oracle.com/cd/E11882_01/server.112/e40540/process.htm#BABHFGFF https://docs.oracle.com/cd/E11882_01/server.112/e40540/startup.htm#CNCPT89045
Rohit Mishra (3 months ago)
May I know how the modified data is moved to redo log buffer cache from db buffer cache
Ramkumar Swaminathan (3 months ago)
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...
Rajendra Bangar (3 months ago)
Good explanation
Ramkumar Swaminathan (3 months ago)
Thanks... enjoy learning
yash tiwari (4 months ago)
Thanks, the way you explain is nice.
Ramkumar Swaminathan (3 months ago)
Thanks
Ali Omoum (4 months ago)
good .. thanks
Ramkumar Swaminathan (4 months ago)
Thanks, enjoy learning
Akram Dhiabi (6 months ago)
nice
Akram Dhiabi (5 months ago)
yes please let us know :)
Ramkumar Swaminathan (5 months ago)
Will make more videos on performance playlist
Akram Dhiabi (6 months ago)
will appreciate if you make a tutorial explaining in details how to analyse an AWR report 🙏
red4ever (6 months ago)
Hi Sir, do you have a website or something like that, where I could find the full Database architecture explanation in written format?
Ramkumar Swaminathan (6 months ago)
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.... https://www.youtube.com/c/RamkumarSwaminathan they are organised into playlists to help viewers
red4ever (6 months ago)
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.
red4ever (6 months ago)
Thank you Sir for the quick reply.
Ramkumar Swaminathan (6 months ago)
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
funontherun85 (6 months ago)
great explanation !
Ramkumar Swaminathan (6 months ago)
Thanks... Enjoy learning
m .v kishore (7 months ago)
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
Ramkumar Swaminathan (7 months ago)
Redo has exact details of which rows were modified, old and new values for updates...
sagar jagtap (7 months ago)
nice vedioes explained
Ramkumar Swaminathan (7 months ago)
Enjoy learning
Youyou Pharel (8 months ago)
Thank you for the explanation
Ramkumar Swaminathan (8 months ago)
Most welcome... Enjoy learning
Swapnil Modhave (9 months ago)
nice video sir it very easy to understand
Ramkumar Swaminathan (9 months ago)
+Swapnil Modhave thanks
pavan nayak (10 months ago)
Very good video where even a fresher can understand in and out... appreciate your efforts
Ramkumar Swaminathan (10 months ago)
+pavan nayak thanks... Stay subscribed and share the channel with others
vamsi krishna (10 months ago)
Well explained . I have subscribed already and shared with my fellow DBA's too. Please make a video on AWR report .
Ramkumar Swaminathan (10 months ago)
+vamsi krishna I have a playlist on performance.. kindly go thru that..
Ramkumar Swaminathan (10 months ago)
+vamsi krishna thanks
info s (10 months ago)
Awesome delivery mr kumar ...thank you very much
Ramkumar Swaminathan (10 months ago)
+info s thanks .. enjoy learning....
ashok (11 months ago)
I really appreciated! Thank u for your service sir
Ramkumar Swaminathan (11 months ago)
+ashok [ thanks... Enjoy learning...
Nazir Hussain (11 months ago)
Thanks a lot sir, how i can send you personal message?
Ramkumar Swaminathan (11 months ago)
+Nazir Hussain send it to the email id given in the end of the videos
Ruchi Kolla (11 months ago)
very nicely explained...thank you
Ramkumar Swaminathan (11 months ago)
+Ruchi Kolla thanks
gtm gtm (1 year ago)
Sweat and shortly showed ropes., very Good brief for beginners.
Ramkumar Swaminathan (1 year ago)
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...
gtm gtm (1 year ago)
Ramkumar Swaminathan means that's a good starting video to understand further oracle videos.
Ramkumar Swaminathan (1 year ago)
I am sorry... Didnt get that...
Nice Sir..

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.