1 PLSQL Performance Tuning Introduction to DBMS PROFILER

[@arjunchauhan888]

Thank you so much ....you saved my whole week and rewriting the whole procedure in a package. I was very disturb with nested loop and codes... I exactly did what you guided here , found perticular queries and modified accordingly to consume less time to run. Unbelievable results came . Previously it was taking 2 minutes but for same it's taking 19 seconds. You saved my hours of running long program , now it's completing in few minutes ... drastically optimized well. Thank you so much again sir.

[@SivaAcademy]

Welcome, glad that it helped 💐💐👍

[@santoshpanigrahi205]

What changes you did Arjun. Can you please elaborate . Thank y in advance

[@janardhanakasibisi378]

The reason you say this so wonderfully is that great gift that God gave you.. It is a great blessing for us to have people like you.... Thankyou so much siva brother..

[@SivaAcademy]

🙏🙏🙏🙏🙏🙏🙏 It's my pleasure bro

[@surik972]

Just one thing to say, Plsql = Siva Academy, That's it!! Hats off Siva!! Thanks for the great efforts from your end.

[@SivaAcademy]

Thank you 💐🙏

[@misbahnazneen4526]

Thank you for the thorough explanation👍. The video provided valuable insights into performance tuning and every minute was enlightening 💡👏

[@arivolielampirai2882]

you have really put lot of effort in preparation of these videos, editing, and presentation... unbelievable.. After seeing your videos I cannot watch anybody else's videos. Because your way of communication is diff level. you connect the dots, you answer the question for why, how, what..... advantages and disadvantages of using any feature!!! so that we are able to understand and get max facts in a single video quickly!!!! Great effort Siva!!! You should be in Udemy or CourseEra, etc!!!

[@SivaAcademy]

🙏🙏🙏My pleasure bro 💐💐

[@mugilans18]

Thank you very much for initiating Performance Tuning Videos. Happy to learn through your videos.

[@SivaAcademy]

@Mugilan, Thanks for your comment bro🙏

[@twinklesahoo4098]

Thank you so much for educating us with awesome explanation....looking forward to more videos on performance tuning & explain plan....Thanks in advance!

[@SivaAcademy]

Sure, please stay tuned for more videos

[@vijaydubey1734]

You are a great mentor, who always explain the things with quality content. Hats off to you Sir 👍💐🙏🙏

[@SivaAcademy]

Thank you 💐🙏🙏💐💐

[@jvaldes1988]

Fantastic explanation on this utility. Siva, you are a great teacher! Please keep up the good work.

[@SivaAcademy]

My pleasure, thank you 💐🙏

[@giridharkodakalla]

One of the best videos on performance tuning. Excellent content and perfect example

[@SivaAcademy]

My pleasure, thank you 💐

[@eastamit]

Just amazing. Will certainly help in the interviews and the day to day work as well :)

[@SivaAcademy]

My pleasure, thank you 💐

[@ravising4145]

Really shiva your teaching technique is awesome..bro be continueee really nice explanation ..I watched your all videos ..so nice

[@SivaAcademy]

@Ravi, Thanks you.... :-)

[@ganeshsatyakumarvalavala9018]

Hi siva ,i like very much this vedio for understanding the concept of tuning.thank you very much for sharing your knowledge to people.

[@SivaAcademy]

@Ganesh, Its my pleasure, Thanks a lot for your comment.

[@srikanthgandhi7289]

Great explanation Shiva . You are true legend in Teaching. Keep good work Sir

[@SivaAcademy]

Welcome bro

[@VenkyPotla369]

Hi Siva, Nice explanation. Video is every clear to understand. Regards, Venky

[@SivaAcademy]

Thank you Venky 💐

[@shahbazahmed9127]

Brief and well explained. Thank you very much for it.

[@SivaAcademy]

Thank you bro

[@vivektarab1959]

0:09 - How to Start with PLSQL Tuning 1:08 - How and where to start with Performance Tuning an Inbuilt function name DBMS_Profiler 1:42 - PLSQL Performance tuning start 2:46 - We can use Provided tools DBMS_Profiler 4:02 - How to use DBMS_Profiler - 4 STEPS are there 4:54 - First you can execute profiler execution on the set of PLSQL code 6:14 - First let's start with Environment setup 6:44 - The Second thing is that you need to create the Profiler Table in the Schema where you are going to run the Execution 8:00 - For an Schema or for a Database 8:12 - Once the Profiler Execution is done the next step is Profiler Execution 9:48 - Now Practical of Environment Setup and Profiler Execution 11:40 - Start Profiler ke baad 13:07 - Now we have done our Environment setup 14:10 - Unit Id ko Join kr ke

[@ganeshthanthoni3310]

Such a awesome explanation about dbms_profiler i am really impressed your class sir keep post like this its really good things to know....

[@SivaAcademy]

Thank you Ganesh, sure please stay tuned

[@navdeepbhatia5030]

Thanks Siva fr sharing the knowledge , I have one doubt is there a way I can profile the procedure being executed from different session or a procedure which is part of some application from my session which is all together different

[@SivaAcademy]

I dont think so, however, i will check and post if its possible

[@sujaa1000]

Superbly explained and well understood, thank you very much Siva, really appreciate your hard work and your good nature of sharing so much technical knowledge. Regards, Sujaa

[@SivaAcademy]

Welcome....:-) Thanks a lot all your comments. Please share it with someone who are in need.

[@bharathkumar1831]

Thanks Siva Sir. All the videos you posting are very informative and really helpful. You are doing an Awesome Job. :)

[@SivaAcademy]

@Bharath, Thanks 🙏 for your comment bro

[@nageshkumarmk5487]

Thank you very much sir and could you please share which dml queries take more time in terms of data, like merge or update for huge table

[@SivaAcademy]

sure, please stay tuned

[@bhismkumar1482]

Thanks for the video, I used this for performance improvement.

[@sangamithiranmass3544]

excellent...I think you are the best one explaining complex topics in oracle....keep going Siva....sorry Sir😊

[@SivaAcademy]

My pleasure, thank you 😊🙏👍💐

[@lokeshagrawal6548]

Very useful and Nicely explained. Helped me a lot. Thanks a lot!!!

[@SivaAcademy]

Glad it helped!

[@RamGuptaoracle]

Very well explained. Thank You. Siva Keep uploading more performance Tuning videos in this playlist.

[@SivaAcademy]

Sure, please stay tuned

[@vivektarab1959]

0:10 - How to Start with PLSQL Tuning 1:42 - PLSQL Performance tuning start 2:46 - We can use Provided tools DBMS_Profiler 4:02 - How to use DBMS_Profiler 6:14 - First let's start with Environment setup 8:12 - Once the Profiler Execution is done the next step is Profiler Execution 10:30 - Procedre ke andar Procedure 15:35 - Profiler data 18:01 - In fact the last three

[@lunasworld1110]

Hi Siva, I liked your videos . And they helped me to learn a lot in Oracle. thanks.

[@SivaAcademy]

My pleasure 🙏 thank you

[@prajaktadeshmukh8272]

What is the actual query change you did to improve performance ?

[@junkingjunking8477]

Very well articulated and explained. Thank you, sir.

[@SivaAcademy]

Welcome 🙏💐

[@Riddilicious]

Hello Brother, Big fan of your videos. Wanted learn more on performance tuning. Could you please also do a video on awr and addm reports and how to analyse it and tune our sqls

[@denniszhang2083]

Thank you so much, Siva. You opened a door for me!

[@SivaAcademy]

My pleasure 💐

[@sivak7020]

Thank you so much brother for uploading performance tuning

[@SivaAcademy]

🙏🙏🙏🙏🙏🙏 :-) Always Welcome bro :-)

[@munikumarpoosala1264]

awesome dude....Nice explanation.Thanks for your videos.Keep going.

[@SivaAcademy]

Welcome 🙏💐

[@abdulmazid7615]

Hi Siva sir, you are an amazing teacher, you have helped me a lot becoming a db developer. Sir can you please provide some videos on performance tuning of queries

[@SivaAcademy]

Its my pleasure, thank you, Best wishes 💐💐

[@fyitamil4206]

You are great sir. Thanks a lot for your help.

[@SivaAcademy]

Welcome bro

[@sandeeplakkakula6279]

Really nice explanation..you make it so easy for people to understand Can you make more in depth videos on performance tuning and show some real time scenarios please.

[@SivaAcademy]

Sure, will post videos on performance tuning, Please stay tuned

[@rajenderkasarla]

Thanks a lot Sir... for starting videos on performance tuning... hope you will upload all the videos of Complete Performance Tuning.

[@SivaAcademy]

@Rajender, since the performance tuning is wide area, i will try to post whatever i know on regular basis......please stay tuned.

[@rajenderkasarla]

Sure Sir... Thanks a lot for your Reply.

[@divyachowdhary1865]

Excellent presentation. very clearly explained.Please do post more videos

[@SivaAcademy]

🙏, sure please stay tuned for more videos

[@Ganeshay-996]

plz make playlist about performance tuning for oracle sql ?

[@lkchannel1550]

Very good presentation. Nicely arranged. Thanks.

[@SivaAcademy]

Thank you

[@aniketjagdale7765]

Hello sir I have watched all your videos and I just loved it, I had just one request if you could explain to us how you tune your real project code step by step then it would be really great and appreciated 😊

[@SivaAcademy]

Thank you bro, sure please stay tuned.

[@fanatic12345]

Siva sir, can tou let me know if the total_time in data table and total_run_time in runs table are in milliseconds?? Am in middle of resolving an issue and you are my encyclopaedia 😊

[@bakkibsp]

can you interpretation of explain plan output in oracle and how to optimize with respect to the explain plan output.

[@sadanb4876]

Great session . Thank you so much sir

[@SivaAcademy]

My pleasure, thank you

[@Pawan-cg5lg]

Hi Siva.. thanks for your informative videos.. This video is blur, not able to see it clear due to low video quality.. could u pls upload this video in higher quality

[@dasubabuch1596]

Siva, can u pls explain the DBMS stats table and schema concept

[@manoranjanray8181]

Siva debugging with many parameters ( package and procedure)?

[@mahendrasinghthakur9471]

Thank you so much for covering performance tuning topic sir!!

[@SivaAcademy]

@Mahendra, Welcome bro..🙏

[@meenakshisundaraar7267]

Excellent... Can you please provide vedio on how to debug plsql code?

[@gsraj511]

Thank you for your detailed explanation:)

[@SivaAcademy]

Welcome bro

[@nareshnagella6969]

I have question if any table has huge data and it is causing performance issue can i know how can we overcome this

[@BewithuNnk]

How to become a plsql developer. What are the basics required to learn & what skills need to improve. Please assist me

[@sachinzawar3085]

Excellent presentation sir...

[@SivaAcademy]

Welcome 💐

[@prasadth7859]

we can do this by using dictionary tables like v$sql,v$session can u explain this also?

[@MrSakssssss]

Thank you for the beautiful content.

[@SivaAcademy]

Welcome bro

[@vaibhavtripathi3007]

Very nice presentation..

[@SivaAcademy]

Thanks a lot

[@sindhupaturu2304]

Hello, so good explanation, request you to do some more videos regarding performance tuning, especially concentrating on the interview questions on it.

[@SivaAcademy]

Sure please stay tuned

[@tamahesh]

One doubt I have does the DBMS_PROFILER be started even though the PL/SQL code is running already in the background?

[@pravalsoni605]

Hi Sir, I'm getting while starting DBMS_Profiler as 0ra-00900 I have grated exec access also still no able to invoke dbms_profiler.start_profiler

[@dkoothan360]

Thanks sir, really very nice explanation. Thanks a lot..

[@SivaAcademy]

@koothan, thanks for your comments bro

[@rekhapraveenkumar2519]

Great explanation

[@SivaAcademy]

Thank you

[@Reddy2344]

Can we execute select query instead of procedure once we start the profiler

[@sivaramakrishnamannem-b3b]

Hi sir, I have new requirement. In PL/SQL procedure creating time when exception error is raised that time, error message is sent via mail to us.

[@rajasekarp7873]

Excellent video bro 👍👏

[@SivaAcademy]

Thank you

[@sameerahmad7592]

Hello Sir, your video was really very helpful, I got to learnt lot of thing about Performance Tuning from it. Can you plz make me understand about the total-time calculated, how you calculated it. Since it only is main thing. Please..... Warm Regards Sameer Ahmad

[@TejaDuggirala]

Great video. Thank you sir.

[@SivaAcademy]

Welcome bro

[@deepakmishra7259]

Great videos man.Keep up the good work.

[@SivaAcademy]

Welcome

[@SureshPrajapati-ip2hx]

I become your fan as you explaining the oracle concept. Can I get a chance to learn oracle performance tuning in some more detail from you. Pls revert🙏

[@SivaAcademy]

Its my pleasure, please stay tuned, i will post videos on performance tuning also

[@ranganayakic1324]

Thank you sir, for the informative video. Request you for an explanation on the Explain Plan.

[@SivaAcademy]

@Ranganayaki, Thanks for your comment 🙏...Sure, will be posting all the performance related topics in the SQL/PLSQL performance video series, will cover explain plan as part of that....please stay tuned.

[@Ganeshay-996]

What a explained excellent sir.. Is it your online classes there total starting to end I mean plsql tutorial to real time project till...

[@SivaAcademy]

Welcome 🙏💐🙂

[@hakhandare]

Thanks for sharing valuable knowledge

[@SivaAcademy]

It's my pleasure,Thank you so much :-)

[@krishnareddy2885]

Dear sir, Please suggest any other usefull Technology for PLSQL developers....

[@SivaAcademy]

@Krishna, You can start learning, ETL, Data Mining, Reporting, Data Analysis, Visualization...etc ( based on your interest), all these are related to Data and Database technologies, so you can able to easily pickup....

[@krishnareddy2885]

@@SivaAcademy Thank You very much for your Suggestion sir...

[@Unel1993]

Hi sit , do you have videos for Explain plan in part of performance tuning ?

[@SivaAcademy]

Not yet, please stay tuned

[@rahulbadhe5930]

thank you so much, sir,,, finally got it performance tuning video,,

[@SivaAcademy]

@Rahul, 🙏 welcome bro

[@abhisheknittala7181]

very useful , thanks siva!

[@SivaAcademy]

You are welcome 😊

[@sudhansupanda4891]

Hi Siva it very nice. Kindly come up with a small code and show us how you tune it with example.

[@SivaAcademy]

Sure, I was not able to cover in single video, will try to cover in some other video

[@pankajkharade6936]

Really Helpful 👍👍👍👍

[@SivaAcademy]

Welcome 💐

[@Reddy2344]

Hi sir, could you please reply if we can execute select query instead of procedure once we start the profiler

[@SivaAcademy]

Yes, you can, but if you already know the query that takes time, then there is no need to execute using profiler. you can start tuning your query

[@sireeshasistla1296]

inorder to run this profiles commands, i need to connect to the Pluggable database as user sys, but my default connection is set to container database. when i say sqlplus / as sysdba or sqlplus / as sysdba@orclpdb, both commands are connecting to my container database but not to my PDB. this is a problem as i am not able to grant any privilages from user sys to my user scott, any help on this will be appreciated..thank you

[@nitinsoni9307]

very good buddy. thank you so much

[@SivaAcademy]

Thank you bro

[@AliElsayed]

very useful, thank you

[@SivaAcademy]

Thank you

[@supriyapatil1781]

Is this functionality available in 11g?? If it is there could you please tell me the path for proftab.sql file??

[@ramchinthakayala2092]

Eventually you started performance tuning ...just Awesome bro keep it up. But I have a little doubt like profiler and dbms_profiler are same?

[@SivaAcademy]

Thanks... Both are same bro, profiler is just a generic term we use, however dbms_profiler is the package to profile the code

[@bijayinisamal5666]

Thank you for this video.

[@SivaAcademy]

@Bijayini... Thanks for your comment

[@deepakmishra7259]

Hi In the case of a live environment,where many people are sharing the same user, once the profiler has been started will it not capture the data for the other operations also?

[@SivaAcademy]

No, its session specific. Only your session data will be captured.

[@Rocky-dw3zy]

Sir please make more videos on performance tuning..and tkprof,impdp,expdp,backup,recovery,import,export etc

[@SivaAcademy]

sure, will be starting SQL performance tuning series soon, please stay tuned

[@MyFraggi]

Thank u for all the wonderful knowledgeable vdos👍👍 just have a doubt...At 17.22 sec, why did u truncate plsql_profiler_data table...as next time we may need it...we should only delete the data from it...plz correct me if i m wrong

[@SivaAcademy]

Thank you for your comments, yeah its not needed to truncate....i prefer to truncate every time, because its better to query....otherwise we need to query for the specific run id. you can keep the old records as well.

[@khushik8994]

@@SivaAcademy ya..very true...but we can delete all records from the table too, so no old run id and at the same time, we can have structure of the table ready with us.

[@khushik8994]

@@SivaAcademy Sir, ur email id is [e-mail]? also, on google, I got very different website...having unknown fonts... sivaacademy.ruplayers.com. Is it your website?

[@SivaAcademy]

[e-mail], this is my mail id

[@venkateswarlupotla9619]

how to change clob data into file and attach the data to mail oracle 12c

[@balajiguduru9783]

Good job brother, thanks, really like it

[@SivaAcademy]

Welcome 🙏

[@ShivaKumar-vf6nh]

Sir, can we do this on production ? as it contains insertions, deletions etc..

[@SivaAcademy]

Generally we won't do this in production, Unless its absolutely necessary

[@pranabsahu8583]

Is it only for oracle or applicable for postgresql?

[@SivaAcademy]

This is Oracle specific package, postgres should have some similar concept

[@WorldEye88]

What is the value in the time column in the plsql_profiler_data table? is not microseconds? Thank you

[@SivaAcademy]

I guess it's microseconds only

[@dhavalpandya4162]

Sir plz make more series on performance tuning. Is it already done ?

[@SivaAcademy]

sure, please stay tuned

[@abinashdas12]

Thank you sir,pls try to complete all aspect of performance tunning

[@SivaAcademy]

@Abinash, Sure, since the performance tuning is wide area, i will try to post whatever i know on regular basis......please stay tuned.

[@ur8946]

Hi Sir , How you generate the graph ? which you presented in Last slide .

[@SivaAcademy]

@ur, that I have created from excel sheet

[@rajakumark589]

Sir thanks very match detailed sharing, Please Share the final join query

[@SivaAcademy]

@Rajakumar, its just joining the three tables mentioned in the video, once you learned the basics data getting stored in these tables, you can join based on your need. however I guess i posted all the queries in the link, let me check back once again.

[@RamGuptaoracle]

Super explanation

[@SivaAcademy]

Thank you

[@srikanth_yandapalli]

Siva, Great work..appreciated from DBMS. How we can do same with AWR, ADDM & ASH reports? thanks in advance :)

[@SivaAcademy]

sure, please stay tuned, will add soon

[@manisatyasaicherukuri9472]

Thank you sir... 🙏🙏🙏

[@SivaAcademy]

Welcome bro 🙏👍💐