There
is network and interconnect bandwidth to consider and varying complexity in use
among your users.
One of the curious aspects of performance is that ???good performance??? is defined by
its absence rather than by its presence. Youcan recognize bad performance easily,
but good performance is usually defined as simply the absence of bad performance.
Performance is simultaneously a very simple topic??”any novice user can implicitly
understand it??”and an extremely complex topic that can strain the ingenuity of the
most proficient database administrator.
Before getting into a specific discussion of Oracle performance, it makes sense to
define a basic methodology for investigating performance problems.
There are three basic steps to understanding how to address performance issues with
your Oracle database:
1. Define performance and performance problems.
2. Check the performance of the Oracle server software.
3. Check the overall performance of the server machine.
Defining Performance and Performance Problems
The first step in performance tuning is to determine if there actually is a performance
problem.
Pages:
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349