Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Slow forms/reports compilation reasons?

901340Feb 10 2012 — edited Feb 10 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 9 2012
Added on Feb 10 2012
2 comments
592 views