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

PL/SQL Procedure Running Slow in EBS

Avatar photoCustomer February 9, 2020 at 7:27 pm

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?

Viewing 4 reply threads
  • Author
    Replies
    • Support February 9, 2020 at 10:56 pm  

      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 February 10, 2020 at 6:56 am  

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

    • Support February 11, 2020 at 1:34 am  

      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 February 12, 2020 at 1:40 am  

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

    • Support February 13, 2020 at 2:06 am  

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

  • Author
    Replies
Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123797

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 19915

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14664

How to check if a patch is applied in Oracle EBS 12.2 14431

Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3 14117

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11997

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9936

Migration to Java Web Start in Oracle EBS 12.2 instance 9935

Securing sensitive data with Oracle VPD 7850

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6485

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2025
2024
2023
2022
2021
2020
2019
2018