Home › Discussions › Questions & Answers › PL/SQL Procedure Running Slow in EBS

PL/SQL Procedure Running Slow in EBS

Avatar photoCustomer Questions & Answers 5 replies

A custom PL/SQL package we use is running very slowly. We want to use `DBMS_PROFILER` to analyze which lines are consuming the most time. How can I analyze the resulting profiler data easily in Excel?

5 replies

  • Support Enginatics

    You can use the DBA DBMS Profiler Data report. This report provides an Excel version of Oracle’s `dbms_profiler` PL/SQL performance analysis.

  • Avatar photoCustomer

    I heard there are prerequisites for using `DBMS_PROFILER`. What must I ensure about the compilation mode of my PL/SQL code?

  • Support Enginatics

    To gather information using `DBMS_PROFILER`, the PL/SQL code must be compiled in INTERPRETED mode, not NATIVE mode. Before compilation, execute `alter session set plsql_code_type=interpreted;`.

  • Avatar photoCustomer

    Once I run the profiler, what commands do I use to start and stop data collection?

  • Support Enginatics

    You use `dbms_profiler.start_profiler(optional run_comment);` to start collection and `dbms_profiler.stop_profiler;` to stop it.

  • You must be logged in to reply to this post.