I'm trying to improve the performance of the invoice report, and came across a few things i'd like clarification on, if anyone has some experience of this..
1... an AWR report from the database shows that it is executing statements TWICE.....can anyone confirm this and/or explain why this might be
2. there are several long SQL statements which are used to INSERT into CMN_RPT_TEMP.... can anybody explain what each one is doing and if there is a way to speed up the INSERT.
The SQL itself in one example takes about 3s when I run it locally, but when I add the INSERT to the front of it it takes 144s.... quite a bit slower.
I think thats about it really. I just want to understand how it works (how it's supposed to work) and what I can to improve, as its taking upwards of 10 minutes to run some of our invoices
Thanks in advance,