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.

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

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.

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

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

very useful, thank you

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

plz make playlist about performance tuning for oracle sql ?

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

Thanjk yu

Great session . Thank you so much sir

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

Hi Siva,

Nice explanation. Video is every clear to understand.

Regards,
Venky

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

please do video for ASH and AWR report

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.

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

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

very good buddy. thank you so much

Thank you very much

Great explanation

Excellent video bro 👍👏

Thank you for the beautiful content.

Great video. Thank you sir.

Thanks a lot

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

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

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

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

Very nice presentation..

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

Thank you for your detailed explanation:)

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

Thank you so much sir

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.

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

thanks

Is it only for oracle or applicable for postgresql?

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

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

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

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

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

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

Really Helpful 👍👍👍👍

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

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

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

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