Archive for February, 2008

POW: OPTIMIZER_MODE

February 15, 2008  |  dba  |  1 Comment

Here one more Parameter of the Week  session (POW) :) Optimization is a task that can be set on a database-wide level in the Oracle database configuration parameter OPTIMIZER_MODE. By default its value is ALL_ROWS. Before 10g (9i at least), CHOOSE would allow you to use cost based optimization if you gather...

Read More

APEX charts with HTTPS connections

February 11, 2008  |  apex, dba  |  1 Comment

At Neoface we secure our apps by using Apache as a reverse proxy server. Today I've configured Apache to handle APEX calls with secured https connections. The problem that we figured out after doing it was that the flash charts from APEX 3.1 did not work. After some RTFM we discovered ...

Read More