Hello,
I'm using Oracle database 10.2.0.5.0 and Oracle Forms 6i (VERY old, I know ...).
Calling stored procedure from forms program unit:
Test 1)
PROCEDURE ... -- Oracle Forms procedure
...
pkg1.proc1 (par1, par2, par3); -- call Oracle database package procedure
...
END;
That will run about 15 MINUTES.
Test 2) identical source code, except two additional lines
PROCEDURE ... -- Oracle Forms procedure
...
sys.dbms_session.set_sql_trace (TRUE); -- NEW LINE
pkg1.proc1 (par1, par2, par3); -- call Oracle database package procedure
sys.dbms_session.set_sql_trace (FALSE); -- NEW LINE
...
END;
That will run about 5 SECONDS.
What's that??
What about this huge performance difference???? Who can explain?
As far as V$SES_OPTIMIZER_ENV told me, the session parameters do not differ.
By the way, the same source code runs, called from Oracle Forms 11g, in a few seconds. Even without SQL trace.
Thank you in advance,
Stefan