APEX

I've been using 10g Database and 10g application server on separate servers for some time now.

Going the two tier (11g) route has some attractions, but what are the disadvantages?

The Oracle documentation I've seen says very little on making the decision, giving benefits as:

Ease of configuration

Included in the database

No separate server installation

- but no negatives.

Does anyone have any real live experience of comparing the two options?

I'm inclined to believe that three tier might have more tuning flexibility, better performance if each tier is on a different server. Maybe worse than two tier if on one server, assuming two tier eliminates communication overheads..

Does pl/sql gateway have the caching ability of Apache/mod pl/sql - I assume not? - that could make a big difference.


Any thoughts would be welcome...