SELECT statement Processing in an Oracle Database - DBArch Video 7

You will learn from this video how a SELECT statement is processed in an Oracle Database. You will learn about the a Parse, Execute and Fetch phases in a select statement.

Our Upcoming Online Course Schedule is available in the url below

[kristinaorgandzieva]

"If you can't explain it simply, you don't understand it well enough" ... You have explained simplest of all .... You understand it perfectly. The auditorium is happy to follow such great videos for Oracle.

[claudensuhfor]

This video is the most helpful and concise video on SQL execution. Thanks man

[harisaim]

nice background music but pls reduce the volume, sometimes its overlapping your voice.
Nothing we can say about your teaching skills.hats off

[stefanmoha]

Best teaching ever seen May GOD guide you to the truth about HIM. It is the best gift someone can get in his life.

[p.vijayakumar]

Best explanation I ever seen..I was searching for right guide for oracle and I found it..Thanks for your effort..We are expecting more videos.

[Dibyajyoti]

Sir,
Thank you for this nice video.Very well explained.
I have a doubt what will happen if the buffer cache is smaller than the table size. Will it get loaded in the memory?
Thanks

[raahul]

Hi Ram. How are you? Glad to see you on youtube. Had attended one of your fabulous sessions in Dubai a few years ago. Greetings!!

[priyapattanayak]

all the videos are very helpful, Thank you so much sir
if you have any Rac Dataguard ASM Videos Link please ?

[banojswain]

Excellent explanation. Thank you🙏 sir.

[himanshubhusanrath]

Really, very nice explanation... You explained such a complex stuff in a very simple manner.. Thank you Sir :)

[madhes]

Best explanation, it would be even more better if that disturbing background music wasn't included.

[pavanb]

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 .

Thanking you in advance.

[mongodb]

Everything is nice. Presentation, Technic, Explanation. May god bless you.

[ravikishor]

I have attended core dba in multiple institutes and noone is not as clear as you. Your way of explanation is so easy to understand and concepts are explained very clearly...keep up the good work

[lukembogo]

Sir!! I salute you... you know what you are teaching, congratulations

[kodandram]

unable to concentrate due to background music in the video even though you explained it nice

[sharadraj]

Kindly remove background score its a distraction

[maheshs]

Thank you for making this video sir. A few questions,
For how long will an SQL-Area for a corresponding Query be stored in the Shared Pool before it is decided to remove it?
For how long will the Data files blocks be stored in the Buffer Cache before it is erased?
How would this work for queries involving sub-select statements(ex - select * from Emp where Emp.id in (Select id from Managers...))? I'm assuming the Parse-Execute-Fetch process is done on the sub-select statement before the result is returned as a DataFile Blocks to the outer select statement. Correct me I'm wrong.

[tirupatiraoyegireddi]

Nice Sir...Thank you very much your help...

[lalithaterala]

SUBSCRIBED YOUR CHANNEL🙏 I'm pretty feeling comfortable listening to your classes. Thank you sir.