Oracle Performance tuning | Introduction to SQL Performance Tuning

Oracle Performance tuning | Introduction to SQL Performance Tuning
---------------------------------------------------------------------------------------------------------------------------

This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.
---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 10 years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos

---------------------------------------------------------------------------------------------------------------------------

[rohanyadav]

Once again thank you siva Because of you I got new job in Plsql... Also they asked me related this tuning I told them about indexes, explain, & dbms profiler part of your videos & also practiced it well, i learnt this language in depth because of you.... Thankss keep it up.. 😊👍👏

[hajimohamed]

Thank You Siva bro...i keep on watching and learning from your videos, i quit my job in April in this crisis time, i saw your videos from June..thereafter daily 10 to 5 i made myself available for your video class...guess what ...your teaching landed me in new job....in this crisis time...SO MUCH THANKS TO YOU BRO...i turned on BELL ICON only for your channel in youtube...even in busy day schedule i pay attention when i get new video notifications....you are great soul...you are doing good, great job than celebrities.... YOU ARE A MASTERPIECE in this planet...keep up the GREAT WORK...because of your work videos ...i got new WIFI CONNECTION in my home...

[ruchidahiya]

Siva, Thankyou. for all the knowledge you share.. Can't be expressed in words how much valuable the learning and understanding are... Thankyou again🙏

[edisonphilip]

Great and clear explanation..We want Tkprof video and all the topics you mentioned for above 9 years performance tuning....

[udaybabu]

Please complete the series
This is more informative and knowledgeable 🤝

[ujjwalgiri]

Sir I cracked the job ..joined on 24th as an Oracle PLSQL developer ..thanks for clearing my doubts.

[theboss]

Thank you! Thank you for wonderful gift on auspicious day. 😍

[bishnumnnit]

Hey Siva, you r doing a wonderful job, I have suggested all my junior colleagues and team member to go through your channel to understand the concept of Sql and PLSQL, I think there is no other channel like urs with the latest update, you definitely deserve more subscribers, keep up the good work, waiting for PT series

[priyankasaluja]

Thank you for starting this video series, really looking forward for it.

[ranajparida]

Hello Siva,

Full hearted thanks to your approach. It's is something unique you made among all. A gain thanks. As you side in the videos that if we can add topics for you video play list of SQL tuning, i managed some topics below. Please consider those

1. Discuss row chaining and ROW migration, how does it happen? How can you reduce it? How do you correct it? How can we identify in the code?
2. If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace?
3. Diffrent types of Hints.
4. Explanation the parameters are comingunder autotrace report or tkprof.
5. Explain on cursor sharing. When and why is used.
6. What hard parsing and soft parsing and steps involved.
7. Explain cluster index and non cluster index for tuning.

[jay.shah]

You are a god gift for me Sir! I actually was going to ask you for these series!!

[SANJAYPATIL]

To prepare for interview within less time, your videos are very great.... material, thanks for sharing your knowledge.god bless you

[SriLife]

I appreciate u r hardwork Siva. Definitely we support u. Keep going 👏

[manoranjanray]

Thank you, please start video series of debugging.. With tips and tricks

[talendtraining]

Superb information regarding Performance tuning Siva Bro!!

[amitgautam]

Thank you sir!!! Have been waiting for performance tuning tutorial. Finally its

[hrishabkumarjha]

Thanks you so much for always providing such a great content.. 😊

[patinoricardo]

Hola Siva, tambien estaba esperando esta serie. muchas gracias por compartir. desde Argentina. abrazo

[bharathibalakrishnan]

Wonderful ! You make our life so easy. The way you explain things are how exactly I expect. To learn these, I would google altleat 10 different websites finally will end up with frustration. You put together the topics so nicely. Keep it up.Expecting more videos. Happy Ganesh Chaturthi!

[avinash]

Keep going brother ... Appreciate your time on all your wonderful videos