Application Express and E-Business Suite 11i.
I’m just starting an installation of Oracle APEX 3.1.1 into one of our development ebs instances for 2 reasons.
- To provide a small applet to a project team
- To provide the infrastructure for the dbas to write their own little applets.
I chose this method for the following reasons (unordered)
- it’s fairly cool
- we know pl/sql much better than java
- we don’t much like forms.
- you can integrate really easily.
- deployment is pretty simple.
Those of you that have installed apex frequently will know it’s a pretty quick install on decent hardware. So the following came as rather a surprise.
timing for: English Dictionary
Elapsed: 00:03:16.71
-- Updating user account expiration. -------
timing for: Upgrade
Elapsed: 00:00:00.43
...End of install if runtime install
...create null.sql
timing for: Development Installation
Elapsed: 01:03:48.57
That’s right over an hour. The reason for this is that with 3.1.1 APEX calls DBMS_STATS.GATHER_DICTIONARY_STATS(‘APEX’); this spend almost 55 minutes performing inappropriate index lookups on the data dictionary for us. This might be solvable, though to be honest it’s probably not worth it, but just a heads-up really, the APEX install may take longer than you think in a large environment and with the latest version of the software.