top of page

Profile in PLSQL

  • Writer: Rumesh Aponso (RMAX)
    Rumesh Aponso (RMAX)
  • Nov 15, 2024
  • 1 min read

Updated: Nov 22, 2024

DECLARE 
   file_name_ VARCHAR2(1000); 
   result_ NUMBER; 
   trace_name_ VARCHAR2(1000) := 'my_trace'; 
   filename_ VARCHAR2(1000) := trace_name_||'.trc'; 
BEGIN 
   file_name_ := fnd_profiler_api.Start_Profiling(filename_); 
   --PUT_YOUR_CODE_HERE 
   result_ := fnd_profiler_api.Stop_Profiling(file_name_, trace_name_); 
   Dbms_Output.Put_Line(result_); 
END;

Related Posts

See All
BLOB to CLOB in PLSQL

How to get file content in a BLOB file into a CLOB in PL/SQL. The below function can be used if the BLOB file contains text format data...

 
 
 
Fnd Dynamic Tab Page in IEE Client

[FndWindowRegistration("YVVDA_COMPANY_ADDR", "YvvdaCompanyAddr", FndWindowRegistrationFlags.HomePage)] [FndDynamicTabPage("frmCompanyAddr...

 
 
 

Comentários


Copyright © 2025 RMAXOneNote

  • Online CV
  • LinkedIn
  • Youtube
  • GitHub
  • Blogger
bottom of page