Shulou(Shulou.com)06/01 Report--

SQL > show parameter undo

NAME TYPE VALUE

-

Undo_management string AUTO

Undo_retention integer 900

Undo_tablespace string UNDOTBS1

SQL > alter system set undo_retention=1800 scope=both

SQL > show parameter undo

NAME TYPE VALUE

-

Undo_management string AUTO

Undo_retention integer 1800

Undo_tablespace string UNDOTBS1

SQL > select sum (d.bytes) "undo" from v$datafile d, v$tablespace t, dba_tablespaces s where s.contents = 'UNDO' and s.status =' ONLINE' and t.name = s.tablespace_name and d.ts# = t.ts#

Undo

-

31457280

SQL > select max (undoblks/ ((end_time-begin_time) * 3600mm 24)) "UNDO_BLOCK_PER_SEC" from v$undostat

UNDO_BLOCK_PER_SEC

-

2.90217391

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.