| 15-SEP-2007 14:14:29 | TESTDB1 |
| Data Dictionary Cache Statistics | |||||
| Parameter | Gets | GetMisses | % Cache Misses (1) | Count | Usage |
| dc_histogram_defs | 11,600 | 9,543 | 82.00 | 4 | 3 |
| dc_constraints | 15 | 9 | 60.00 | 6 | 5 |
| dc_used_extents | 2,945 | 1,583 | 54.00 | 33 | 20 |
| dc_truncates | 27 | 7 | 26.00 | 2 | 1 |
| dc_constraint_defs | 426 | 86 | 20.00 | 11 | 10 |
| dc_tablespace_quotas | 144 | 27 | 19.00 | 22 | 7 |
| dc_sequence_grants | 81 | 15 | 19.00 | 2 | 1 |
| dc_constraint_defs | 5,591 | 780 | 14.00 | 175 | 174 |
| dc_segments | 14,216 | 1,750 | 12.00 | 102 | 99 |
| dc_histogram_data | 4,902 | 587 | 12.00 | 2 | 0 |
| dc_indexes | 16,520 | 1,767 | 11.00 | 133 | 132 |
| dc_database_links | 51 | 5 | 10.00 | 5 | 2 |
| dc_objects | 26,901 | 2,223 | 8.00 | 407 | 403 |
| dc_object_ids | 4,666 | 366 | 8.00 | 106 | 105 |
| dc_table_grants | 6,718 | 453 | 7.00 | 133 | 132 |
| dc_sequences | 209 | 14 | 7.00 | 14 | 13 |
| dc_synonyms | 2,368 | 118 | 5.00 | 34 | 33 |
| dc_columns | 352,319 | 15,229 | 4.00 | 1,482 | 1,474 |
| dc_tables | 67,421 | 1,554 | 2.00 | 251 | 246 |
| dc_free_extents | 528,233 | 3,109 | 1.00 | 173 | 160 |
| dc_usernames | 12,251 | 29 | 0.00 | 20 | 19 |
| dc_tablespaces | 2,715 | 4 | 0.00 | 6 | 4 |
| dc_user_grants | 17,586 | 20 | 0.00 | 53 | 15 |
| dc_users | 22,440 | 25 | 0.00 | 20 | 16 |
| dc_rollback_segments | 56,563 | 8 | 0.00 | 18 | 9 |
| dc_tablespaces | 291,270 | 7 | 0.00 | 17 | 7 |