Re: Improving performance of calculations in PL/SQL

Hi Charlie,

One thing you might want to try to get a little more detail on what the PL/SQL is actually doing is to trace the PL/SQL "machine code" with an event - ALTER SESSION SET EVENTS '10928 TRACE NAME CONTEXT LEVEL 1';

With this event set in the trace file you will see the m-code machine code instructions interpreted by the VM - this may help you further understand what is happening with your code. The trace looks similar to natively compiled PL/SQL c code BTW.

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.