1。我的系统中dc_sequences pct miss非常高,都达到70%了,调整了几个插入频繁的表的sequence cache还是不建好转,系统中总共有4000多个sequences,我怎么知道是哪几个sequence 需要调整cache值呢?
2。还有dc_tablespace_quotas这个pct miss是怎么引起的,可以怎么优化呢?
^LDictionary Cache Stats for DB: ESALInstance: rac3Snaps: 2102 -2103
->"Pct Misses"should be very low ("Cache Usage" is the number of cache entries being used
->"Pct SGA" is the ratio of usage to allocated size for that cache
GetPctScan PctModFinal
Cache
Requests MissReqsMiss ReqsUsage
------------------------- ------------ ------ ------- ----- -------- ----------
dc_histogram_data
4,6140.1 0
01,800
dc_histogram_data_values 4840.0 0
0376
dc_histogram_defs
6,9050.8 0
09,015
dc_object_ids
15,0350.1 0
06,172
dc_objects
128,8530.0 0
02,290
dc_profiles
254,6580.0 0
0
2
dc_rollback_segments
51,8530.0 0
0958
dc_segments
6,4200.8 0
06,592
dc_sequences
891 68.9 0
891 79
dc_table_scns
1432.8 0
2
3
dc_tablespace_quotas
1100.0 0
1
1
dc_tablespaces
15,4460.0 0
0 10
dc_user_grants
1,527,9230.0 0
0 13
dc_usernames
255,0280.0 0
0
5
dc_users
1,927,5720.0 0
0 16
-------------------------------------------------------------
|