| 15-SEP-2007 14:16:00 | TESTDB1 |
| Library Cache Statistics | ||||||||
| Namespace | Gets | GetHits | GetHit Ratio (1) |
Pins | PinHits | PinHit Ratio |
Reloads | Invalidations |
| OBJECT | 0 | 0 | 100.00 | 0 | 0 | 100.00 | 0 | 0 |
| PIPE | 4,039 | 4,037 | 99.95 | 4,039 | 4,037 | 99.95 | 0 | 0 |
| SQL AREA | 213,552 | 209,182 | 97.95 | 719,089 | 704,302 | 97.94 | 5,754 | 3,935 |
| BODY | 909 | 883 | 97.14 | 914 | 851 | 93.11 | 12 | 0 |
| TABLE/PROCEDURE | 42,146 | 39,076 | 92.72 | 75,864 | 70,371 | 92.76 | 2,003 | 0 |
| TRIGGER | 838 | 728 | 86.87 | 865 | 637 | 73.64 | 37 | 0 |
| CLUSTER | 27 | 12 | 44.44 | 15 | 5 | 33.33 | 0 | 0 |
| INDEX | 25 | 0 | 0.00 | 26 | 1 | 3.85 | 0 | 0 |
PINS=800815 Reloads=7806 Percentage=.97 Pins(HITS)=800818 Reloads (MISSES)=7806 Hit Ratio%=99.03