(no subject)

I'm running statspack on the development database, and came across a couple of weird numbers. Why is db_used_extents Pct Miss 100%? And why is dc_synonyms 34.4?

I have a lot of locally managed tablespaces, and don't use synonyms for barely anything. Could that be why? Is this even something I should be worried about?

Thanks for any insight -- I'm still pretty confused about this type of information.

Regards,

Diana

->"Pct Misses" should be very low (< 2% in most cases)
->"Cache Usage" is the number of cache entries being used
->"Pct SGA" is the ratio of usage to allocated size for that cache

                                 Get Pct Scan Pct Mod
Final Pct
Cache Requests Miss Requests Miss Req Usage SGA

---------------------- ----------- ------ -------- ----- -------- ------
----
dc_files                     1,865    5.4        0             10    100
96
dc_free_extents              3,944    1.5       49   0.0       68     87
74
dc_histogram_defs           87,372    0.2      215   0.0      630  5,403
90
dc_object_ids               16,060    8.6        0              0    455
94
dc_objects                   6,311    9.5        0            934    894
96
dc_sequences                   341    2.9        0            324      8
53
dc_synonyms                     32   34.4        0              0     33
75
dc_tablespace_quotas           224    6.3        0            210     14
61
dc_tablespaces               6,339    3.2        0             20    207
95
dc_used_extents                 54  100.0        0             54     65
76
dc_user_grants                 426    4.2        0              0     26
60
dc_users                     7,645    0.2        0              0     29

Diana Duncan
Database Architect
filefrenzy Received on Wed Nov 08 2000 - 14:31:04 CST