Our setup used 10g Applicatin Server with forms and Reports version 10.1.2.0.2.
All this is setup on AIX 6.
We have a custom script in place which compiles all the forms, reports, menus and plls.
Execution time of this script is approx 30 mins across all instances [Prod, test1, test2 and Dev]
However recently on our dev instance the same script is taking approx 1.5 hours for execution.
Since the execution is successful, i cant find much in the logs.
Its not that only few forms or reports are taking longer for compilation, in general compilation is slow.
Free space on moutpoint is not an issue.
I cant see anything in terms of server stats that stand out.
Any help in understanding this issue would be highly apprciated.
Thanks in advance.
Below is the output for command TOPAS, thought it might be useful.
Well, you didn't mention what the db version is so I will assume it is 10.2 or newer.
First, you need to install the Application Server (Developer Suite) 10.1.2.3 patch set (Patch ID 5983622). Then you should refer to MyOracleSupport note 1099035.1 . This is a known issue.
You should also be aware that version 10.1.2 (AS/DS) is no longer entitled to Error Correction Support. If you are actually using this product for business/production applications, I encourage you to consider moving to a supported version (e.g. 11.1.1.x or 11.1.2).
Thanks for the reply Michael.
Our database version is 10.2.0.5.0
and our we are already on Application Server 10.1.2.3 [Patch ID 5983622 is applied]
I was hoping that maybe this is related to the server, because other instances [prod and tests] are on the same versions but the compilation times on those instances is normal.
Is there someway of understanding by maybe enabling some kind of traces where the delay could be taking place