Shulou(Shulou.com)05/31 Report--

Function.procedure function under the process analysis, I believe that many inexperienced people do not know what to do, so this paper summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

Problem: the stored procedure pro_end_to_end_edw_open under the function PKG_END_TO_END_EDW executes slowly, but the corresponding sql for this function.procedure cannot be found in the database.

Train of thought:

Function.procedure is shown in awr, but can not be found in the database. What happens is that when executing the stored procedure, it is found that the sql execution plan in the procedure has changed, resulting in a decline in efficiency. The root cause is caused by the sql in the process. The index cannot query the executing function.procedure in the database, only query the object_id of dba_objects, and match the v$session.PLSQL_ENTRY_OBJECT_ID to check the sql in it. It is basically due to the efficiency of sql execution.

While the sql in function.procedure is often reflected in the top sql part of the awr report, you need to optimize the function.procedure or directly optimize the problem sql or use profile to bind a better implementation plan.

After reading the above, have you mastered the method of process analysis under the function.procedure function? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.