I want to say thank you Sir, but I don't know if I could ever thank you enough for the language you give to people including me especially. Am an Oracle student but whatever I don't understand in class your lecture quickly breaks it down for me to understand quicker than I thought. This is the best thing to give to the society and it's for free. Thank you so very much Sir, I am grateful for the language and your good heart, many God give you long life and bless you in abundance.
Thankyou so much sir I had watch few other youtuber video but didn't understood it so well... it was very easy for me to understand each and every concept. Once again wholehearted thanks... 🙂🙏
Hi Sir , Thank you for all your valuable time & energy for making the videos on the oracle Dba and sharing the knowlede. Request:Please make a video on Multitenant Architecture in 12c .
Excellent 👍 I have a query . During alter database open resetlogs, what i understood is all redo logs gets flushed & assigned with new sequence no. But in many articles, i saw redologs gets written to archived logs.. can't understand why redo has to write it to archive logs when resetting logs for incomplete recovery. please clarify
Hi Sir, GREAT EXPLANATIONS - LEARNING THE CLEAR THINGS THROUGH YOUR VIDEOS - KEEP GOING SIR. I need some clarifications, 1) You told that in the last video. when commit issued the lgwr responds and writes to redolog files. then how dbwr works?, automatically or it works for the same commit statement. 2)Keeping the database in archive log able to recover the database. In real-time, the database in which condition, archivelog or noarchivelog, if it is in noarchivelog then why they are using in noarchivelog - any reason to keep this in that state. Thankyou.
HI Mohan, Look into the playlist on Backup and recovery to know more about Archive Log and NOArchive log... If you have a need that you cannot afford to lose data... then Archivelog is your configuration...
Thanks for uploading this, I currently have a system that pulls up a menu the main menu in GUI the next time you enter that menu it is completely different an old reverted menu. Obviously the issue is the first group keeps failing and switching to second group. Thinking that may be turning inactive due to misprogramming on start as we had this happen when an archive was used to update our system and broke it.
sir, thanks for the video and the explanation is good. In the video you have mentioned for every database needs to maintain more than 2 redo log groups and for each group it should have minimum 2 redo log members for log switch purpose. my doubt is how many redo log groups and redo log members are supported by the database?
How can you say redo logs improve the performance as compared to DBWR, when it is a part of the transaction....what I meant is you cannot avoid writing to data files or avoid writing to redo files. Both activities are part of the transaction. You can say that writing redo entries to the redo files takes less time as compared to write the dirty buffers to the data files. Please clarify..
I want to say thank you Sir, but I don't know if I could ever thank you enough for the language you give to people including me especially. Am an Oracle student but whatever I don't understand in class your lecture quickly breaks it down for me to understand quicker than I thought. This is the best thing to give to the society and it's for free. Thank you so very much Sir, I am grateful for the language and your good heart, many God give you long life and bless you in abundance.
Thanks.. Enjoy Learning
So far best lecture i never saw in tech industry
Best Lectures ever on Oracle Architecture. Your videos are very helpful. Thanks for sharing for free on youtube.
you are the best Sir interms of concepts and the way you teach.
your voice is so clear sir //good understanding
Thank you sir, it helped a lot to understand. Many Thanks from Korea
big thanks here from the Philippines
They way of explanation is very good sir. Thank you for sharing in UA-cam.
Sir you have provided the satisfiable explanation.....
Thanks... Enjoy learning
excellent simple in less time we can review such important basics
Thanks. Enjoy learning
Nice
thank you sir.... you cleared a lot of my doubts in oracle!
Thankyou so much sir I had watch few other youtuber video but didn't understood it so well...
it was very easy for me to understand each and every concept.
Once again wholehearted thanks... 🙂🙏
Very nice session and informative
Hi Sir , Thank you for all your valuable time & energy for making the videos on the oracle Dba and sharing the knowlede.
Request:Please make a video on Multitenant Architecture in 12c .
Excellent 👍 I have a query . During alter database open resetlogs, what i understood is all redo logs gets flushed & assigned with new sequence no. But in many articles, i saw redologs gets written to archived logs.. can't understand why redo has to write it to archive logs when resetting logs for incomplete recovery. please clarify
How to clear the log buffer?
You are my Dronacharya
Hi Ramkumar Sir,are you still taking classes for Oracle Databse?please let me know how to contact you
I like the intro music. Thank you for the video
Excellent work ...done....
youre awesome in explanation sir
Thanks... Enjoy learning
Thank you Sir for the help. These videos are awesome and super-useful.
Hi Sir, GREAT EXPLANATIONS - LEARNING THE CLEAR THINGS THROUGH YOUR VIDEOS - KEEP GOING SIR.
I need some clarifications,
1) You told that in the last video. when commit issued the lgwr responds and writes to redolog files. then how dbwr works?, automatically or it works for the same commit statement.
2)Keeping the database in archive log able to recover the database. In real-time, the database in which condition, archivelog or noarchivelog, if it is in noarchivelog then why they are using in noarchivelog - any reason to keep this in that state.
Thankyou.
HI Mohan, Look into the playlist on Backup and recovery to know more about Archive Log and NOArchive log... If you have a need that you cannot afford to lose data... then Archivelog is your configuration...
DBWR writes at its own frequency on conditions such as free buffers in buffer cache, checkpointing etc...
Ramkumar Swaminathan thankyou for your response sir.
what is the difference between commit && alter system checkpoint && alter system switch logfile on logfiles
Thanks for a very clear explanation.
Thanks.. Enjoy learning
Such an amazing teacher. Thanks
Thanks for uploading this, I currently have a system that pulls up a menu the main menu in GUI the next time you enter that menu it is completely different an old reverted menu. Obviously the issue is the first group keeps failing and switching to second group. Thinking that may be turning inactive due to misprogramming
on start as we had this happen when an archive was used to update our system and broke it.
You are a genius sir... Great
sir, thanks for the video and the explanation is good. In the video you have mentioned for every database needs to maintain more than 2 redo log groups and for each group it should have minimum 2 redo log members for log switch purpose.
my doubt is how many redo log groups and redo log members are supported by the database?
thank you sir for tis amazing class
nice presentation. However background music could have been in lower volume.
great sir..salute to you
Thanks... Enjoy Learning
Hi Sir, Could you please give exact reason why LGWR writes before DBWR? Thank you very much in advance.
If log buffer is full to accommodate new blocks
sir, we dont need background music, its distracts focus listening u. just an advice...
Excellent sir could you please explain sir how to add More group
you use the alter database command to do the same..
Thanks for well explanation sir
Nice Sir..Thank you
great video sir
Great video! Thanks a lot!
Thanks
nice explanation sir
+Gangadhar Wanjari thanks
How can you say redo logs improve the performance as compared to DBWR, when it is a part of the transaction....what I meant is you cannot avoid writing to data files or avoid writing to redo files. Both activities are part of the transaction. You can say that writing redo entries to the redo files takes less time as compared to write the dirty buffers to the data files. Please clarify..
When a commit occurs, only lgwr wires to redo logs... Dbwr did not necessarily write... A commit is complete after the redo is written...
thanks for your explanation
Enjoy learning
Awesome please make more videos
Great.....
Sir tell your institution. I will join
Excellent
Thanks... Enjoy learning...
Thank you sir..
every helpful thanks
Thank you sir
thank you
What is up with the distracting background music in the video?
Otherwise good video.
Do not add music to these videos.
respects
Please remove the background music. I disturbs the concenration......
Sir don't think bad please remove the Bg sir
I like his explanation but the constant music is DISTRACTING