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,
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Click Here to Expand Forum to Full Width