Here, we??™re simply laying a foundation
for understanding Oracle performance. This understanding will help you
implement the tuning procedures most suited for your own particular implementation.
Where appropriate, we??™ll provide some basic guidance on how the latest Oracle
features help you manage performance.
Certainly, Oracle provides more and better automated tuning options in the current
release than it did when we wrote earlier editions of this book. However, getting
optimal performance is about more than tuning. There is no substitute for getting
your hardware platform properly configured with appropriate CPUs, memory, and
especially storage. Good database design is also critical for achieving optimal performance,
based on how your lines of business use the system.
Performance Tuning Basics
Performance is one of the trickiest aspects in the operation of your database since so
many factors can be involved. There is the database, to be sure. But there are also
platform deployment strategies to consider. Today, the infrastructure likely resides
Performance Tuning Basics | 155
across multiple platforms, including database servers and applications servers.
Pages:
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348