Tuning question

From: <kal121_at_my-deja.com>
Date: Mon, 25 Sep 2000 18:23:30 GMT
Message-ID: <8qo567$3ka$1@nnrp1.deja.com>

What is the correct solution to fix objects that have a high reload ratio? Should I increase the shared pool or pin the objects in memory?

Hit                  Reload
Type                     Executions           Hits   Ratio

Reloads Ratio

-------------------- -------------- -------------- ------- -------------
- ------- -
SQL AREA                    519,649        506,006   97.37
720    0.14
TABLE/PROCEDURE             132,942        125,332   94.28
921    0.69 *
BODY                         27,711         27,446   99.04
19    0.07
TRIGGER                          13              7   53.85
0    0.00
INDEX                           294             24    8.16
0    0.00
CLUSTER                       8,460          8,447   99.85
0    0.00
OBJECT                            0              0  100.00
0    0.00
PIPE                              0              0  100.00

0 0.00

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 25 2000 - 13:23:30 CDT