select
ur undo_retention,
dbs db_block_size,
((ur * (ups * dbs)) + (dbs * 24)) / 1024 / 1024 as "M_bytes"
from (select value as ur
from v$parameter
where name = 'undo_retention'),
(select (undoblks / ((end_time - begin_time) * 86400)) ups
from v$undostat where undoblks in (select max(undoblks) from v$undostat ) ),
(select value as dbs
from v$parameter
where name = 'db_block_size')
我用以上语句查出数据库峰值时的UNDO表空间的建议值为:1,851.15M,可实际上UNDO表空间为:15,342.000M。
可是UNDO还是维持在95%左右,。
请问:
1、UNDO表空间过大会导致什么样的后果?
2、像目前的情况,需要减少UNDO表空间,还是要增加UNDO 表空间?
ur undo_retention,
dbs db_block_size,
((ur * (ups * dbs)) + (dbs * 24)) / 1024 / 1024 as "M_bytes"
from (select value as ur
from v$parameter
where name = 'undo_retention'),
(select (undoblks / ((end_time - begin_time) * 86400)) ups
from v$undostat where undoblks in (select max(undoblks) from v$undostat ) ),
(select value as dbs
from v$parameter
where name = 'db_block_size')
我用以上语句查出数据库峰值时的UNDO表空间的建议值为:1,851.15M,可实际上UNDO表空间为:15,342.000M。
可是UNDO还是维持在95%左右,。
请问:
1、UNDO表空间过大会导致什么样的后果?
2、像目前的情况,需要减少UNDO表空间,还是要增加UNDO 表空间?
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/751371/viewspace-563134/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/751371/viewspace-563134/