标题: 获取undo表空间最大大小推荐的sql [打印本页] 作者: 郑全 时间: 2014-6-1 09:57 标题: 获取undo表空间最大大小推荐的sql 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');