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