This discussion is archived
2 Replies Latest reply: Feb 10, 2012 8:02 AM by 901340 RSS

Slow forms/reports compilation reasons?

901340 Newbie
Currently Being Moderated
Hello gurus,


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.
using
rwconverter.sh
frmcmp_batch.sh

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.

Topas Monitor for host: tstapdev EVENTS/QUEUES FILE/TTY
Fri Feb 10 10:27:44 2012 Interval: 2 Cswitch 416 Readch 88
Syscall 271 Writech 223
CPU User% Kern% Wait% Idle% Physc Entc Reads 1 Rawin 0
ALL 1.0 1.6 0.0 97.4 0.02 4.4 Writes 2 Ttyout 88
Forks 0 Igets 0
Network KBPS I-Pack O-Pack KB-In KB-Out Execs 0 Namei 1
Total 0.2 0.5 1.0 0.0 0.2 Runqueue 1.5 Dirblk 0
Waitqueue 0.0
Disk Busy% KBPS TPS KB-Read KB-Writ MEMORY
Total 0.0 0.0 0.0 0.0 0.0 PAGING Real,MB 8192
Faults 1 % Comp 48
FileSystem KBPS TPS KB-Read KB-Writ Steals 0 % Noncomp 46
Total 0.1 1.5 0.1 0.0 PgspIn 0 % Client 46
PgspOut 0
Name PID CPU% PgSp Owner PageIn 0 PAGING SPACE
topas 3407896 0.0 4.5 applmgr PageOut 0 Size,MB 2048
frmweb 16449656 0.0 26.5 applmgr Sios 0 % Used 1
sshd 15990928 0.0 3.5 applmgr % Free 99
nmon12e_ 7405804 0.0 5.8 root NFS (calls/sec)
maragent 5701854 0.0 124.5 root SerV2 0 WPAR Activ 0
discusge 6160398 0.0 14.6 root CliV2 0 WPAR Total 0
emagent 15204442 0.0 94.7 applmgr SerV3 0 Press: "h"-help
syncd 1441810 0.0 0.6 root CliV3 0 "q"-quit
  • 1. Re: Slow forms/reports compilation reasons?
    Michael Ferrante (Oracle) Guru Moderator
    Currently Being Moderated
    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).
  • 2. Re: Slow forms/reports compilation reasons?
    901340 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points