Oracle Architecture in less than 10 minutes

[@bishupoonia5106]

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?

[@dorg99]

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 !

[@sarbasov]

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.

[@InvestWithRishi]

Have an interview tomorrow. Now feeling confident !!! ... thanks!!!

[@chmercuri]

Excelente video, ficou claro sobre a arquitetura do banco Oracle. --------------------- Excellent video, it was clear about the architecture of the Oracle database.

[@ThomasJeff4s0n]

Great video. Your accent is great. I used the automatic youtube captions and they worked perfectly as well. Thank you for the information.

[@ulysses_grant]

Great information, the best video I've seen in this subject. Thanks a lot!

[@bqtubes]

@mxsunayv I appreciate the free classes in this complex topic. I understand very well. Listen to the logic. It will be easy to follow.

[@Hjominbonrun]

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.

[@moskitokamikaze9766]

Now this explanation is simple awesome! Thanks for upload it to KZbin

[@robheusd]

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).

[@roughsealtd]

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.

[@robheusd]

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.

[@roughsealtd]

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.

[@shihabma]

yes

[@kkatkam]

Thanks for explaining Ora db architecture in simple

[@technologysamrat125]

Really good information about database. Can i use this video in my website.

[@roughsealtd]

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.

[@roughsealtd]

@mxsunayv This is why the same video is ALSO available in French, where my accent is flawless. I suggest you watch the French one.

[@Shadow-nz1dm]

roughsealtd your accent is perfect

[@roughsealtd]

@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.

[@baoshinchang1750]

Very clear and informative. Thank you!

[@maheshwaranparamasivan5177]

Very Crisp and to the point. Also Thanks for the captions :)

[@felipeserial]

Hello dear, I appreciate a lot this video, but it's from 2009, still update this structure nowadays? I mean, is it the same?

[@twolittlehorses4me]

Do not worry about your accent, It does not distract from presentation.

[@roughsealtd]

Subtitles are a KZbin feature. You upload either a plain text file or a text file that includes timing indications.

[@GirijeshT]

Really amzing video , very good accent , very well explained in 10 mins . Thnx a lot :)

[@roughsealtd]

So far I have been only posting on KZbin but I am right now considering a few more "work friendly" options (I guess that the question is motivated by KZbin being blocked at work?)

[@bqtubes]

Great presentation. Thank you for this free tutorial.

[@sivakumarm8033]

Great Explanation.. You nailed it.

[@wycherleywilliam4316]

很好的讲解，very nice,

[@Hjominbonrun]

Do you only post on youtube? I'm an mssql dba learning oracle and your vids seem very too the point.

[@sudheervlogs]

Very nice explanation

[@raju_adapa]

Entraaa maku idhi

[@sallampa]

there is one point that you mentioned wrongly that is tempfiles never records in controlfile

[@djnihal2]

good and decent explanation... job well done.. thank you :D

[@kmsunil87]

Good starter video..... Thanks

[@zes7215]

not understanding of this to perfox, not everyx, idt nerx

[@vemparalasuresh]

Thanks a lot, It's really good and basic information

[@jamsjams3083]

Really Nice information,, Good Architecture part..

[@supriya16891]

Awesome video!! It was immensely helpful......

[@newkool100]

good one...thanks for the share...

[@PradyumnaNadig]

Excellent, precise.

[@skhazra]

very good indeed.

[@sudhaprv]

Exactly the way I was looking for.... Thanks !!

[@roughsealtd]

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 ...

[@adityaniet]

excellent video

[@suvajitmaity]

This guy's are genious....

[@anzodefotouni5618]

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?

[@yilong1980]

謝謝你提供的影片，對我很有幫助

[@jayejayeee]

really informative and interesting

[@oracleKalari]

Excellent

[@VishalGorekamle]

Its Exellent....very Well Explained.

[@triajoern]

Great Video. Thanks for that. More please ,-)

[@andreastewart917]

Great video G

[@tonofurlong]

nice

[@iPhoneJerry]

Thank you

[@ashishcan1]

now thts wht we call a video

[@modiyam]

Nice & Excellent.... Thanks..!

[@PravinJanjal92]

Awesome

[@ShylaEkansh]

Good one ....

[@KadianAthior]

@polehunter This is a french accent :) Sorry.

[@jriosfer]

Thank you so much!

[@Sefr-gravity]

Thanks a lot its very helpful

[@tabrezpasha3748]

awesome video!!!

[@shivrajkadam3172]

interesting.....

[@achouab]

Awesome. Great... Thanks!

[@hnuniyal]

Excellant

[@abhisheksingh278]

Nice Video

[@shamuratov]

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.

[@arshadmoin]

Thanks!!!

[@krazyknowles]

reminds me of the French man from The Matrix 2

[@polehunter]

he must be from England!!

[@sudhize]

good one...Thanks a lot..:)

[@descendentofthemystc]

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.

[@MrPAKISTANI777]

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.

[@hasithaef]

Info conveyed is good.. Bt the voice is like Microsoft Sam's... . :)

[@Aequinaszinha]

@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.

[@9247288175]

not bad not good medium.well some time

[@wrsswijesena]

Excellent