Hello Experts,
May I know that how can i find which statement is taking more execution time in package?
Thanks in advance.
How to find Which Statement is taking more Execution Time in Package?
Answered
Next Story
Related
- How to check if Background Jobs is taking more time
tactivated the trace through ST05 and check execution plan for the sql statements tCheck DB20 statistics of the tables tSE14, checked for any missing indexes tCheck ST03N for respective... - Tuning Expensive SQL Statements
What are typical approaches to tune expensive SQL statements?Depending on the results of the analysis of an SQL statement the following optimizations can be... 
Oracle Parallel Execution Interview Questions and Answers
Oracle Parallel Execution FAQs1. What is Oracle Parallel Execution?Parallel Execution allows Oracle to perform specific database actions in parallel.2. Which subtypes of Parallel Execution exist?The...- Oracle SQL optimization Interview Questions and Answers
Q1. What is SQL optimization?Ans: SQL optimization (or SQL statement tuning or Shared Cursor cache analysis) refers to the identification, analysis and optimization of SQL statements that are...
Get solutions from our experts!
dbms_profiler helps you to know that what line number in pl sql code is taking what time to get executed by using that we can know what statement is taking most time.