Shulou(Shulou.com)06/01 Report--

Before execution, you need to run $ORACLE_HOME/rdbms/admin/proftab.sql to create some key tables. BEGINDBMS _ PROFILER.START_PROFILER ('MY_APPLICATION' | | TO_CHAR (SYSDATE,'YYYYMMDD HH24:MI:SS'));-- executor MY_APPLICATION_CODE;DBMS_PROFILER.END_PROFILER;END SELECT to_char (p1.totalkeeper timeframe 1000000 camera 99999999') | |'-'| | to_char (p1.total_occur) AS time_count, SUBSTR (p2.unitaryownerpr) | |'. | | DECODE (p2.unitarynameName)) 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.