Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.9K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 398 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
frmcmp_batch slow

i have forms server in linux 8 forms version : 12.2.1.4.0
the compilation of one form can took 10s (little form no many triggers), this very slow to achieve my devops scripts
Best Answer
-
As I mentioned, 5-10 seconds for a nearly 500k module is reasonable. That said, why does it matter how long it takes?
If you want better performance, increase the memory and CPU on the machine doing the generating and move the DB onto the machine with the middle tier. However, in the end I do not expect that you will see performance much better than what you described.
Michael Ferrante
Senior Principal Product Manager
Oracle
Twitter: @OracleFormsPM
Answers
-
The amount of time can always vary depending on many factors. Here are just a few:
- Network connectivity between Forms/Compiler and DB
- Amount of changes in the module since the last time it was compiled
- The size of the module
- Whether or not you are using the compile_all=yes option or not
- The performance of the machine where the compiler/generator is running
- The performance of the machine where the DB is running
- And so on...
As a general statement, I would say that you haven't provided enough information to suggest there is an issue.
Michael Ferrante
Senior Principal Product Manager
Oracle
Twitter: @OracleFormsPM
-
the form size is 400k
the dev server is decent to run forms server without time consumption
compile_all is used
the compilation log:
compilation /data/tomcat/tmp/ipkvvvdcutehzau/suppression_dossier_a_tort.fmb reussit
Compilation de la fonction ETAT_PAIE en cours...
Aucune erreur de compilation
Compilation de la procédure VERIF_DDE en cours...
Aucune erreur de compilation
Compilation de la procédure DATE_RETOUR en cours...
Aucune erreur de compilation
Compilation de la procédure TESTRECAP_BORD en cours...
Aucune erreur de compilation
Compilation de la procédure CHARGE en cours...
Aucune erreur de compilation
Compilation de la procédure TESTSUPP_ASSIMILE en cours...
Aucune erreur de compilation
Compilation de la procédure ECHEANCIER en cours...
Aucune erreur de compilation
Compilation de la fonction F_STOPPABLE en cours...
Aucune erreur de compilation
Compilation de la procédure LAST_PAIEMENT en cours...
Aucune erreur de compilation
Compilation de la fonction GET_DATE_RETOUR en cours...
Aucune erreur de compilation
Compilation de la procédure RETOUR_VIREMENT en cours...
Aucune erreur de compilation
Compilation de la procédure DATE_RETOUR_MANDAT en cours...
Aucune erreur de compilation
Compilation de la procédure SUPP_VALIDE en cours...
Aucune erreur de compilation
Compilation de la procédure SUP_VALIDE_NON_MANDATE en cours...
Aucune erreur de compilation
Compilation de la procédure SPAIMENT en cours...
Aucune erreur de compilation
Compilation du déclencheur WHEN-NEW-FORM-INSTANCE dans l'application Forms...
Aucune erreur de compilation
Compilation en cours du déclencheur WHEN-BUTTON-PRESSED sur l'élément EXIT du bloc de données LIENS_UTILES...
Aucune erreur de compilation
Compilation en cours du déclencheur WHEN-BUTTON-PRESSED sur l'élément ENREGISTRER du bloc de données LIENS_UTILES...
Aucune erreur de compilation
Compilation en cours du déclencheur WHEN-BUTTON-PRESSED sur l'élément UNDO du bloc de données LIENS_UTILES...
Aucune erreur de compilation
Compilation en cours du déclencheur KEY-NEXT-ITEM sur l'élément DOS_NUM_BR du bloc de données DOSSIER...
Aucune erreur de compilation
Compilation en cours du déclencheur KEY-NEXT-ITEM sur l'élément DOS_NUM du bloc de données DOSSIER...
Aucune erreur de compilation
Compilation en cours du déclencheur KEY-NEXT-ITEM sur l'élément DOS_NUM_AN du bloc de données DOSSIER...
Aucune erreur de compilation
Compilation en cours du déclencheur WHEN-BUTTON-PRESSED sur l'élément HISTORIQUE du bloc de données DOSSIER...
Aucune erreur de compilation
Fichier d'application Forms /data/tomcat/tmp/ipkvvvdcutehzau/suppression_dossier_a_tort.fmx créé
sam. avril 23 15:37:18 CET 2022
upload0s
compilation10s
-
Generating a 400k module in 5-10 seconds while using the compile_all=yes option is certainly reasonable. If you perform the compile_all plsql while in the Builder and Save the changes, when you go to generate on the command line, you can leave out the compile_all=yes and the time should be significantly improved.
Michael Ferrante
Senior Principal Product Manager
Oracle
Twitter: @OracleFormsPM
-
i remove the compile_all, same time of compilation, i change to compile_all=special same behavior, is there an option to do incremental compilation like in forms builder. the case i develop in windows and compilation done in linux server.
-
As I mentioned, 5-10 seconds for a nearly 500k module is reasonable. That said, why does it matter how long it takes?
If you want better performance, increase the memory and CPU on the machine doing the generating and move the DB onto the machine with the middle tier. However, in the end I do not expect that you will see performance much better than what you described.
Michael Ferrante
Senior Principal Product Manager
Oracle
Twitter: @OracleFormsPM