DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DBMS_Profiler - output formatting

  1. #1
    Join Date
    Apr 2003
    Posts
    5

    DBMS_Profiler - output formatting

    I want to format the output gathered in the tables PLSQL_PROFILER_UNITS and PLSQL_PROFILER_DATA after executing the relevant functions of DBMS_PROFILER package

    I tried using the script profsum.sql (copied profsum.sql and profrep.sql from ..\ORANT\plsql\demo) to generate the report

    But the script does not give the expected result
    It gets hanged max of the times

    I tried to comment out some queries in the script where I suspected the problem could be
    But could not get thru

    Can anybody provide me the scripts for the same purpose
    Script should display the performance informance, coverage information etc


    Thanks and Regards,
    Pooja

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width