Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Improving performance of calculations in PL/SQL
Hi CE,
Have you run the PL/SQL profiler? against the PL/SQL to get an idea as to what it is doing? It is loaded with the script $ORACLE_HOME/rdbms/adm in/profload.sql - you run it by starting the profiler, run your PL/SQL and then stop the profiler. You can then run two reports against it with $ORACLE_HOME/rdbms/admin/profrep.sql and profsum.sql.
I would also guess the real app does much more, it has to load the data to use and unload the results to somewhere so you should also run a normal 10046 trace and analyse if the PL/SQL is really the issue or not.
hth
kind regards
Pete
-- Pete Finnigan email:pete_at_petefinnigan.com Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details.Received on Mon Jan 26 2004 - 13:07:39 CST