Beginning
with Oracle10G, when statistics are gathered for a table, the old statistics are
retained so should there be any problem with performance of queries dependent
on those statistics, the old ones can be restored.How
long does Oracle retain the statistics for ?
The
default peri【阅读全文】
一:以归档模式运行数据库1.shutdown immediate关闭数据库[oracle@oracle-n1 ~]$ sqlplus "/as sysdba"SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 7 11:30:42 2012Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.SQL> shutdown immediate;2.启动数...【阅读全文】