Oracle Performance tuning | Oracle hard parse vs soft parse

[@sansurvase2]

I have to say this, your explanation and "graphical representation" in videos much much better than big institutes and organizations. You are amazing!

[@SivaAcademy]

Thank you bro

[@MrSarath06]

Wow..You are the REAL " TEACHER "🔥 I learned a lot..really a lots. THANK YOU.

[@SivaAcademy]

Welcome bro

[@venkkatmerla4389]

Hi Siva, Thank you for your vedios lot of doubts are cleared by your vedios and your graphical view of explanation is outstanding

[@SivaAcademy]

Welcome bro

[@garry9330810749]

You are absolutely spot on to cover the basics which are usually let go otherwise. I have come to brush up my sql knowledge and now i know what i did not know earlier. Thank you for the work you are doing.

[@SivaAcademy]

Thank you bro

[@SuNiLKuMaR-iq9pz]

Wow....Excellent. Mind-Blowing explanation (clyster clear). Eagerly waiting for "Bind Variable" / "Adaptive cursor sharing" explanations... Thank you Very Much.

[@SivaAcademy]

Welcome bro, please stay tuned

[@KarthikAB-vh4jn]

Hi Siva, Your session contains lots of information which boost our DBA skills. Thank you very much for your video. Please keep posting such videos which helps lots of Junior DBA's to boosts the technical skills. If we get such videos on AWR report analysis it will be great.

[@praveenreddy4507]

I am following all your videos without missing even single video. Really you are explaining very good, please share multiple videos especially on performance tuning ,hints and how to analyse the explain plan etc.

[@SivaAcademy]

Thank you Praveen, please stay tuned for more video's

[@m.s.k5300]

I would have to crack the last clint round.If i saw this video before..anyway now i got confident to answer all questions by watching of your videos siva thanks a lot.. my self also Shiva..

[@SivaAcademy]

My pleasure bro

[@lakshmiganesh7786]

The best explanation i ever seen sir it it is possible upload more and more videos we are waiting to see

[@SivaAcademy]

Thank you, please stay tuned for more video's

[@juno7893]

Another great video 👏🏻👏🏻👏🏻

[@SivaAcademy]

Thank you

[@ssr6616]

Awesome video sir. Great efforts.

[@SivaAcademy]

Thank you

[@parijujare2241]

Hi siva sir. I am following all your videos. Its really very nice and easy to understand. please share remaining videos of this series. Thanks a lot..

[@shaikzakir5699]

Thanks for uploading amazing information. Please continue this series. Awr reoprts and query tuning vedios

[@SivaAcademy]

Welcome, please stay tuned, will cover in upcoming videos in this series

[@snehalr4312]

Its really helpful for us if you continue this series because after one certain level they are looking for optimisation its humble request to can please some more videos...that help uss....

[@shanmugapriyanb6967]

Thank you for making this kind of videos

[@SivaAcademy]

Welcome 🙏💐

[@aazhiazhagu]

As usual, this video is very useful. 👍

[@SivaAcademy]

Thank you bro

[@srikanthreddy2080]

Thank you so much brother,very nice explanation

[@SivaAcademy]

Thank you bro

[@vivekanand470]

Excellent explanation👍

[@SivaAcademy]

Thank you bro

[@Sonukumar-ce9es]

Hi Sir very good content, eagerly waiting for the next videos related to sql performance tuning.

[@SivaAcademy]

Thank you, please stay tuned

[@kunuturuaravindareddy5580]

As usual super

[@SivaAcademy]

Thanks a lot

[@nilanchalkar]

Thank you Sir...keep it up 👍🏼

[@kumar-bi1to]

Excellent 👌

[@SivaAcademy]

Thanks a lot 😊

[@vijaydubey366]

Always awesome 🙏🙏

[@SivaAcademy]

Thank you Vijay

[@kannadasan6113]

Thanks bro very useful 🔥

[@SivaAcademy]

Welcome bro

[@vivektarab16]

02:36, 03:32,06:09,06:56,07:15

[@kumaravm1964]

Hi Siva, I am following your channel and its really useful and valuable as well in terms of conceptual as well as interview answering basis. Could you please suggest me or share any links with respect to 1) how to clear "Oracle Database SQL Certified Associate" 2) what are the concepts to be covered in order to clear the certification 3) any links for materials 4) share video name if you would have already done anything which relates to certification. The same questions i have mailed you as well. Your response is much Appreciated. Thank you. Stay Safe.

[@aniketjagdale7765]

Sir please make more videos in this series covering other topics related to performance tuning

[@debiprasad1390]

Thanks for all the tutorials, could you share a video explaining AWR and ASH report in depth.

[@SivaAcademy]

Yes bro, will add to upcoming list

[@ranajparida5412]

Nice explanation

[@SivaAcademy]

Thanks

[@MayurAshtikar05]

Hii shiva..can u continue/complete this tuning series as u discuss in introduction video that u r going to cover these topic..its very usefull..thnks in advance.

[@manikandanpanneer1650]

Yes, today I received

[@sagarjadhav299]

Hii shiva.Sir .Can you continue/complete this tuning series as you discuss in introduction video that you are going to cover these topic..iIs very Usefull. Please complete the series.

[@MukeshYadav-sf8cn]

Excellent series. Can you upload next videos on this performance series. It will be great help as your videos are very informative and helpful.

[@SivaAcademy]

Thank you, Will upload soon, please stay tuned

[@srikanthbanakar8811]

Sir please continue the this series videos we are waiting for this

[@SivaAcademy]

Sure bro, will be restarting soon, please stay tuned bro

[@srikanthbanakar8811]

@@SivaAcademy I want to understand how to find the long running queries,tools, which how to tune those... Which you are told us to explain us in the introduction video ..

[@SivaAcademy]

All the details you can find using v$ view's, I will cover in upcoming videos

[@mohannagr2824]

Sir please continue with performance tuning series so we can learn

[@SivaAcademy]

sure bro, please stay tuned

[@HandloomChoice]

Very nicce videos

[@SivaAcademy]

Thank you bro

[@sandhyaranimuppalla1042]

When we will get next video? Any traing providing?

[@shanmugaraj09]

when will be the next video in this series ?

[@ganeshvelaga5607]

Nice explanation. Here you need to execute same query from different user or after changing any value in v$parameter . And I request you to make an video for ACS and the columns is_bind_sensitive, is_bind_aware columns in V$sql.

[@SivaAcademy]

Sure, will get it added in up videos

[@amolshinde4711]

Wow very nice but I have one question like how many day's the relevant information will available in shared pool

[@SivaAcademy]

As the new queries get loaded, the older unused info will get removed, hence Oracle may hard parse again later point if the same query is executed

[@aniketjagdale7765]

Hello sir please make more videos on this topic in this video series

[@SivaAcademy]

Sure, please stay tuned

[@maboodahmad7289]

Sir please make more videos on this series.

[@SivaAcademy]

Sure bro, please stay tuned

[@mahnars88]

Please explain in detail about SQL Tuning with explain plan & Hints 🙏

[@SivaAcademy]

Sure bro

[@jayashreejayashankar2143]

worth watching

[@SivaAcademy]

my pleasure

[@amarnathdoddi7921]

Shiva sir what happened to this performance tuning videos we are willing from long days bro.why your are ignoring this video's

[@hometv7587]

Kindly make a video on oracle architecture .

[@SivaAcademy]

very soon bro, please stay tuned

[@neerajshukla6907]

Hi Siva, If possible could you create some videos on Partitioning concept

[@SivaAcademy]

Sure Neeraj, please stay tuned

[@ranvijaymehta]

Thanks sir

[@SivaAcademy]

Welcome bro

[@mrthrinadhrao]

Can you explain( explain plan)

[@jsanjayb]

Nice

[@SivaAcademy]

Thanks

[@KrishnaChaitanyaKornana-ef1oc]

Please do the next videos in this section.

[@SivaAcademy]

Please stay tuned, will post soon

[@vivektarab16]

00:23 00:47

[@BabitaSingh-rn4ol]

Please make more videos

[@SivaAcademy]

Sure, please stay tuned

[@vivektarab16]

00:59, 02:05

[@vivekpampattiwar5193]

Hello sir, Can u pls make the video on partition, types of partition in detail,local index,global index,global partition index,local partition index! Pls If u do so it will help most of the people. 🙏

[@SivaAcademy]

Definitely Vivek, please stay tuned

[@mahendrasinghthakur9471]

Very well explained👍🏻

[@SivaAcademy]

Thank you bro