一次数据库的简单性能优化:增加INDEX表空间,增大在线归档日志组文件,增大在物理内存允许范围内sag_target,增大log_buffer====================================......
shared pool type object de 214516
where to latch num map 7068
work area tab 276576
writes stopped lock conte 16
writes stopped lock state 20
x$ksmfs table 12
x$rule_set 16804
xdbconf 4
xscalc 3528
xslongops 4040
xsoqmehift 4168
POOL NAME BYTES
------------ -------------------------- ----------
shared pool xsoqojhift 3272
xsoqophift 4168
xsoqsehift 2376
xssinfo 5532
************ ----------
sum 249604556
buffer_cache 784334848
fixed_sga 1223488
log_buffer 7163904
************ ----------
POOL NAME BYTES
------------ -------------------------- ----------
sum 792722240
9/9 首页 上一页 7 8 9 |
