| |
 |
|
Oracle Tips by Burleson Consulting
|
Upgrading an Entire Server
On mission-critical databases where speed is a primary concern,
adding additional processors may not be the best solution. Oracle
tuning professionals will sometimes recommend upgrading to a faster
server architecture. For example, many of the new 64-bit CPU
processors will handle Oracle transactions an order of magnitude
faster than their 32-bit predecessors. For example, in the IBM AIX
environment, the IBM SP2 processors run on 32 bits. IBM's next
generation of processors utilize a 64-bit technology, and these
systems can process information far faster than their 32-bit
ancestors. The new IBM Blackbird servers will often double the
overall processing speed of an Oracle database.
When making recommendations for upgrades of entire servers, many
Oracle tuning professionals use the analogy of the performance of a
16-bit PC compared to the performance of 32-bit PC. In general,
moving to faster CPU architecture can greatly improve the speed of
Oracle applications, and many vendors such as IBM will allow you to
actually load your production system onto one of the new processors
for speed benchmarks prior to purchasing the new servers.
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
