SQL> show parameter statistics_level
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
statistics_level string TYPICAL
SQL> select snap_id from dba_hist_snapshot;
SNAP_ID
----------
5
4
SQL> select snap_id, FLUSH_ELAPSED,status,error_count,snap_flag from WRM$_SNAPSHOT order by 1;
SNAP_ID FLUSH_ELAPSED STATUS ERROR_COUNT SNAP_FLAG
---------- --------------------------------------------------------------------------- ---------- ----------- ----------
1 1 0 0
2 1 0 0
3 1 0 0
4 +00000 00:06:23.1 0 0 1
5 +00000 00:06:19.0 0 0 1
6 1 0 0
6 rows selected.
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Solaris: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
4,5 是我手工收集的,没有问题。 自动收集 status 都为1, 但找不到stauts 为1 的解释。
大家有何看法?