I just realized that there is a transcript of the video, so i don't have to turn on the speakers very loud to understand what's being said ! very useful ! Thanks !
Greate tutorial! Thanks. I do not find the accent so bad as some say. I understood every single word and hence it is even better and more understandable than native english speak.
I was hoping you have blogs as well, since your explanations of core concepts are easy to understand and concise while other video's and blogs are not user friendly. I actually want to create a blog of how to do a small piece of work in mssql, and then how to do the exact same thing in oracle on the same page, for myself as a learning tool and reference guide.
Excelente video, ficou claro sobre a arquitetura do banco Oracle. --------------------- Excellent video, it was clear about the architecture of the Oracle database.
TechnologySamrat Yes, embedded the video is allowed. As long as you don't edit it and don't try to pretend that you are the author, you can use it wherever you want.
If two queries are functionally the same (returning same resultset) but not litterally the same, they get parsed as different queries? (for example: differences in whitespace between tokens, and differences in case of keywords in queries, or alternate syntax forms which are functionally the same).
I'm not too sure about spaces, case is indifferent, but different aliases and even comments change the "signature" of a query. And of course you have multiple ways of returning the same result with different queries; joins can be written in different ways, and can be replaced by subqueries. Only the text counts for signatures, it's not thought for interactive queries but for prepared queries in programs that are executed repeatedly.
So, oracle would not create an abstract syntax tree in the soft parse phase? If the query has a bind variable, the signature does not depend on the value of the bindvar? The excution plan might differ for different values of a bindvar due to statistics.
Exactly, the signature only depends on text. Concerning bind variables, you have put the finger of one of the major performance stability issues. Oracle tries to anticipate problems when statistics hint at a distribution of values that may be hazardous, and may put queries under watch, checking actual against expected performance, but it only notices it after one query has gone wrong. Dynamic sampling may help.
So far I have been only posting on RUclips but I am right now considering a few more "work friendly" options (I guess that the question is motivated by RUclips being blocked at work?)
This is exactly what I have been looking for since I struggling with oracle architecture. Thanks a bunch. Is it possible to have access to more in depth videos on oracle architecture even if ti cost some money?
I'm not too comfortable with blogs; I have either too little or too much to say. Add to this that 24-hour days are already too short for what I'm doing ...
good tutorial, but you have to do more pauses and be more expressive, not simply read from your notes, otherwise is very difficult to follow you. anyway thank you for your effort.
The video was great up until the last two minutes. It's great to explain advanced technical terms at a basic level for people to understand if the people actually understood what the guy is saying. And then let's have CAPTIONS AVAILABLE IF I FEEL LIKE IT at the top just to tease everyone. "Full transcript available for a small fee" Like sorry you're not french and I half assed my english pronunciations, if you want to understand me give me money. What a fucking joke.
@seekknowledge2010 "Crappy American" should be replaced with "crappy people" Not all Americans think this way nor dislike to do hard work. Nor do you know if he is actually an American because there are other countries that speak English, and the Americas speak Spanish and Portuguese as well as English.... Your generalization is discriminatory.
Extremely useful for beginners. Great explanation. Now I can do better on my exams today.
I just don't understand why would anyone dislike this video?
I just realized that there is a transcript of the video, so i don't have to turn on the speakers very loud to understand what's being said !
very useful !
Thanks !
Have an interview tomorrow. Now feeling confident !!! ... thanks!!!
Greate tutorial! Thanks. I do not find the accent so bad as some say. I understood every single word and hence it is even better and more understandable than native english speak.
I was hoping you have blogs as well, since your explanations of core concepts are easy to understand and concise while other video's and blogs are not user friendly.
I actually want to create a blog of how to do a small piece of work in mssql, and then how to do the exact same thing in oracle on the same page, for myself as a learning tool and reference guide.
@mxsunayv I appreciate the free classes in this complex topic. I understand very well. Listen to the logic. It will be easy to follow.
Great video. Your accent is great. I used the automatic youtube captions and they worked perfectly as well. Thank you for the information.
Excelente video, ficou claro sobre a arquitetura do banco Oracle.
---------------------
Excellent video, it was clear about the architecture of the Oracle database.
Now this explanation is simple awesome! Thanks for upload it to RUclips
Subtitles are a RUclips feature. You upload either a plain text file or a text file that includes timing indications.
Great information, the best video I've seen in this subject. Thanks a lot!
@sallampa
> strings control.dbf | grep temp
/usr/lib/oracle/xe/oradata/XE/temp.dbf
/usr/lib/oracle/xe/oradata/XE/temp.dbf
It's there.
Very Crisp and to the point. Also Thanks for the captions :)
Thanks for explaining Ora db architecture in simple
Do you only post on youtube?
I'm an mssql dba learning oracle and your vids seem very too the point.
Hello dear, I appreciate a lot this video, but it's from 2009, still update this structure nowadays? I mean, is it the same?
Really good information about database. Can i use this video in my website.
TechnologySamrat
Yes, embedded the video is allowed. As long as you don't edit it and don't try to pretend that you are the author, you can use it wherever you want.
Do not worry about your accent, It does not distract from presentation.
If two queries are functionally the same (returning same resultset) but not litterally the same, they get parsed as different queries? (for example: differences in whitespace between tokens, and differences in case of keywords in queries, or alternate syntax forms which are functionally the same).
I'm not too sure about spaces, case is indifferent, but different aliases and even comments change the "signature" of a query. And of course you have multiple ways of returning the same result with different queries; joins can be written in different ways, and can be replaced by subqueries. Only the text counts for signatures, it's not thought for interactive queries but for prepared queries in programs that are executed repeatedly.
So, oracle would not create an abstract syntax tree in the soft parse phase? If the query has a bind variable, the signature does not depend on the value of the bindvar? The excution plan might differ for different values of a bindvar due to statistics.
Exactly, the signature only depends on text. Concerning bind variables, you have put the finger of one of the major performance stability issues. Oracle tries to anticipate problems when statistics hint at a distribution of values that may be hazardous, and may put queries under watch, checking actual against expected performance, but it only notices it after one query has gone wrong. Dynamic sampling may help.
yes
Really amzing video , very good accent , very well explained in 10 mins .
Thnx a lot :)
there is one point that you mentioned wrongly that is tempfiles never records in controlfile
@mxsunayv
This is why the same video is ALSO available in French, where my accent is flawless. I suggest you watch the French one.
roughsealtd your accent is perfect
So far I have been only posting on RUclips but I am right now considering a few more "work friendly" options (I guess that the question is motivated by RUclips being blocked at work?)
Very clear and informative. Thank you!
This is exactly what I have been looking for since I struggling with oracle architecture.
Thanks a bunch.
Is it possible to have access to more in depth videos on oracle architecture even if ti cost some money?
not understanding of this to perfox, not everyx, idt nerx
Great Explanation.. You nailed it.
I'm not too comfortable with blogs; I have either too little or too much to say. Add to this that 24-hour days are already too short for what I'm doing ...
Great presentation. Thank you for this free tutorial.
Awesome video!! It was immensely helpful......
Excellent, precise.
Thanks a lot, It's really good and basic information
Good starter video..... Thanks
Really Nice information,, Good Architecture part..
很好的讲解，very nice,
Exactly the way I was looking for.... Thanks !!
good one...thanks for the share...
Very nice explanation
Entraaa maku idhi
now thts wht we call a video
good and decent explanation... job well done..
thank you :D
Its Exellent....very Well Explained.
This guy's are genious....
good tutorial, but you have to do more pauses and be more expressive, not simply read from your notes, otherwise is very difficult to follow you.
anyway thank you for your effort.
very good indeed.
Great Video. Thanks for that. More please ,-)
excellent video
謝謝你提供的影片，對我很有幫助
Great video G
Excellent
really informative and interesting
Nice & Excellent.... Thanks..!
awesome video!!!
@polehunter
This is a french accent :) Sorry.
Thanks a lot its very helpful
Thank you
Thank you so much!
Good one ....
Awesome. Great... Thanks!
Awesome
Nice Video
Thanks!!!
Excellant
nice
interesting.....
reminds me of the French man from The Matrix 2
he must be from England!!
Video and contents are awesome, but the accent is not easy to digest "VERY VARD HARD ACCENT' he would have used other auto speech type of options.
The video was great up until the last two minutes. It's great to explain advanced technical terms at a basic level for people to understand if the people actually understood what the guy is saying. And then let's have CAPTIONS AVAILABLE IF I FEEL LIKE IT at the top just to tease everyone. "Full transcript available for a small fee" Like sorry you're not french and I half assed my english pronunciations, if you want to understand me give me money. What a fucking joke.
Info conveyed is good.. Bt the voice is like Microsoft Sam's... . :)
@seekknowledge2010 "Crappy American" should be replaced with "crappy people" Not all Americans think this way nor dislike to do hard work. Nor do you know if he is actually an American because there are other countries that speak English, and the Americas speak Spanish and Portuguese as well as English.... Your generalization is discriminatory.
good one...Thanks a lot..:)
not bad not good medium.well
some time
Excellent