1 PLSQL Performance Tuning Introduction to DBMS PROFILER 

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.

In my last Interview, this q was asked...You have global database and u have data of 15 countries like Japan, India, China, UAE etc. You want filtered records as per country like chinese people should see only their data and likewise other country people. how will u manage this in efficient manner. I told that I will make 15 views and then grant permission accordingly. He was not satisfied by my answer, he told that for 15 countries, u will make different 15 views!! How can we handle this situation Siva...Please guide

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

plz make playlist about performance tuning for oracle sql ?

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

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

Is it only for oracle or applicable for postgresql?

Hi, this is really helpful. But i am getting following error while starting profiler!! what can be the reason?! Error starting at line : 1 in command - BEGIN dbms_profiler.start_profiler ('TestProfiler'); END; Error report - ORA-06528: Error executing PL/SQL profiler ORA-06512: at "SYS.DBMS_PROFILER", line 132 ORA-06512: at "SYS.DBMS_PROFILER", line 141 ORA-06512: at line 1 06528. 00000 - "Error executing PL/SQL profiler" *Cause: An error occurred in during execution of a PL/SQL profiler procedure.

@Shiva How to get in touch with you? If Any email address then please mention here. Thanks for all 🙏🏻

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 😊

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

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

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

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

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

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.

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

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

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

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

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

While Creating a procedure I am getting error create procedure proc_c is lv_avg_sal number; begin for i in 1..50 loop select avg(salary) into lvl_avg_sal from EMPLOYEE; end loop; end; / Procedure PROC_C compiled LINE/COL ERROR --------- ------------------------------------------------------------- 5/1 PL/SQL: SQL Statement ignored 6/6 PLS-00201: identifier 'LVL_AVG_SAL' must be declared 6/18 PL/SQL: ORA-00904: : invalid identifier Errors: check compiler log Can you help me with this.

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

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

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

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

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

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

Hi sir please make video for awr report and explain plan

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 😊

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

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

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

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

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

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

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

Siva debugging with many parameters ( package and procedure)?

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

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

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

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

Very informative and helpful. Please do you have a course on PLSQL, how can I communicate with you privately? your e_mail or ----

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

Great video. Thank you sir.

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

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

Hlo.. small query plz clarify anyone in one column 4 names are there like(rakesh , ajay, ganesh , praveen) i want 2nd name ajay how to do using sql query

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

Thank you so much brother for uploading performance tuning

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

How to tuning the package which has more than one procedure and function. How to identify which procedure and which query takes more time to execute? How to tuning the package instead of procedure or function?

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

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

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

Can I use dbms_profiler to get the package performance also ?

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

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

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

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🙏

please do video for ASH and AWR report

very good buddy. thank you so much

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

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?

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

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

very useful, thank you

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

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

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

Excellent video bro 👍👏

Very nice presentation..

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

Sir please tell DBMS_Profiler is Only used to check Performance of PLSQL not for SQL Query?

Thank you for this video.

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

Thank you very much

Very good presentation. Nicely arranged. Thanks.

Thank you so much sir

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

Thank you for your detailed explanation:)

Great explanation

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

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

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

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

Please tell DBMS_PROFILER will work in 11g or only in 12

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

Thanjk yu

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

Thanks a lot

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

Thank you

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

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

thanks

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

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

sir pls upload more videos on performance tuning

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