|
|
| |
 |
|
Oracle Tips by Burleson |
Chapter 2 Inside the
Oracle Shared Pool
Figure 2.3 Graphs Showing Effects of Flushing
Notice the overall trend
of the performance indicator between day 1 and day 2 in the graphs.
On day 1 (the day with an initial flush, as indicated by the steep
plunge on the pool utilization graph, followed by the buildup to
maximum and the flattening of the graph), the performance indicator
shows an upward trend. The performance indicator is a measure of how
long the database takes to do a specific set of tasks (from the Q
Diagnostic tool from Savant Corporation). An increase in the
performance indicator shows a net decrease in performance. On day 2,
the overall trend is downward,
|
|
