Donald K. Burleson
RAM and the Oracle Server
The purpose of server optimization for the Oracle database is to manage the
RAM and CPU resources of the machine and ensure that expensive RAM is not
under-utilized. The techniques used to optimize Oracle database performance
on large UNIX platforms are similar to those used for a MS-Windows system.
Most Oracle consultants see shops waste millions of dollars worth of RAM. The
RAM is under-allocated because the DBA is unaware of how to accurately
analyze the RAM demands of the database. RAM is very expensive on larger
servers and depreciates regardless of use.
The knowledgeable DBA will know how to accurately predict the maximum RAM
demands for the database and will allocate RAM fully, holding in reserve only
enough to accommodate user connection spikes. Let’s review disk swapping and
see how this is accomplished.
text is an excerpt from "Creating
a Self Tuning Oracle Database", by Rampant TechPress. It is only
$9.95 and all scripts in this tips can be immediately downloaded.
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA