2021-03-28

Oracle SQL Procedure Tracing

I have a package which several procedures

create or replace PACKAGE DAT_REPORT_V2 AUTHID CURRENT_USER AS 

  /* TODO enter package declarations (types, exceptions, methods etc) here */ 
    PROCEDURE LOAD_CONFIG;
    PROCEDURE AUX_TABLES; -- Data by CA
    PROCEDURE GEN_VIEWS;
    PROCEDURE PENDING_PROFORMAS;

END DAT_REPORT_V2;

What would be the best way to find the operations that are the slowest for each procedure?

So far, I've tried this profiler option (with the Gather SQL Statistics checked), but it then asks for a path to store some file and finally fails (after the steps in which I'm asked to provide user/password and I introduce mine).

enter image description here

enter image description here

enter image description here

enter image description here



from Recent Questions - Stack Overflow https://ift.tt/3ryzRcd
https://ift.tt/3sH9p1P

No comments:

Post a Comment