Oracle Profiling Tools Dbms_profiler Parsing code

Tag:pac    Analysis    art   file   home    sysdate   tar   str   rdbms   

You need to run $oracle_home/rdbms/admin/proftab.sql  to create some key tables before executing. Begindbms_profiler. Start_profiler (' My_application ' | | To_char (sysdate, ' yyyymmdd hh24:mi:ss '));--execution procedure My_application_code;dbms_profiler. End_profiler; END; Select to_char (p1.total_time/10000000, ' 99999999 ')        | | ' -'        | | To_char (p1.total_occur)  as time_count,         substr   (p2.unit_owner,1,20)          | | '. '          | | DECODE (P2.unit_name, ', ' <anonymous> ', SUBSTR (p2.unit_name,1,20))           as unit,         to_char (p1.line#) | |   '-' | | p3.text text  from plsql_profiler_data p1       , Plsql_profiler_units p2       ,all_source p3       , (Select sum (total_time)  AS  grand_total from plsql_profiler_units)  p4 where p2.unit_owner not in (' SYS ', ' SYSTEM ')    and p1. runid=3   and  (P1. total_time >=p4.grand_total/100)    and p1. Runid=p2. Runid   and p2. Unit_number=p1. Unit_number   and p3. Type= ' Package body '    and p3. Owner=p2. unit_owner   and p3.line=p1.line#   and p3.name=p2.unit_name    ORDER BY p1.total_time DESC;

Oracle Profiling Tools Dbms_profiler Parsing code