One of the most common installation problems we find is what we
call "Too Much Application Server". This happens when you install
more Oracle Application Server components than you need, causing
For example: if your web site is maintained on a
server that contains the application server and the backend database but
only uses mod_plsql to connect directly to the database, you may
not need the application server at all. The Oracle database
installs a fully functional Oracle HTTP Server (OHS). If you are
resource constrained and installing the entire application server with
the backend database on one server, it is important not to install or
run components that you are not using.
In Oracle9iAS, there are three basic installations;
if you need one component, all included components have to also be
installed. One of the great improvements in Oracle Application
Server 10g is that while you still install those components, you are
given the option of not configuring or starting them. Why run
Portal, Reports and Discoverer when all you want is the Oracle Forms
Server? With OracleAS10g, they will still get installed to disk,
but the installer will not configure them to start. You can, of
course, configure them later.
When is an Infrastructure a Hindrance?
An Infrastructure is a hindrance when it is not
used. If your Java Application run in a single J2EE instance and
does not use the Oracle Internet Directory or Single Sign-on, why have
an infrastructure to support just OHS and OC4J? The Oracle
Infrastructure is a powerful management tool, that controls multiple
instances and allows clustering, in addition to OID and SSO, but it
comes at a price (no pun intended). The infrastructure is another
running instance and an additional Oracle9i database. If you are
not going to use it, don?t install it.
Don?t miss understand my message. All of the
OracleAS10g components are powerful tools, but if you don?t need them,
they are just wasting server resources.
Don?t Install Too Much Application Server!
So how do you monitor your server load? Check
out Chapter 10 of the Oracle Application Server 10g Administration
Handbook to determine if you server is overloaded.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.