java之路
-
编辑 删除
nologging何时能减少redo
n[@more@]测试环境9i+XP,参考http://www.itpub.net/showthread.php?threadid=242761&perpage=15&pagenumber=1SQL> conn sys/oracle as sysdba;Connected.SQL> archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination D:oracleoradatafoxarclogOldest online log sequence 17Next log sequence to archive 18Current log sequence 18SQL> create or replace view redo_size as select value from v$mystat, v$statname where v$mystat.statistic# = v$statname.statistic# and v$
