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
Forums
- How one can find out expensive SQL statements, db memory issues for MSSQL from within SAP?
- ORA error invalid sql statement
- How to find Top Sql through Queries
- Oracle SQL Questions for Oracle Certified Professional Exams IZ007
- Oracle SQL: WARNING: Inbound Connection Timed Out (ORA-3136)
- How to take Snapshot of the Particular Time Period Say One Week or One Month?
- CJS-00084 SQL Statement or Script failed. Error Message: Executable E:oracleora92/bin/sqlplus.exe returns 3.
- Finding Current Running Query Execution plan with out Generating execution plan
- How to Execute the dbms_out.put_line Statement?
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.