oracle awr/snapeshot report question enquery
does this statistics store in memory or in fixed table,
i mean i did this query:
SQL> select * from dba_hist_snapshot where rownum SNAP_ID DBID INSTANCE_NUMBER STARTUP_TIME BEGIN_INTERVAL_TIME END_INTERVAL_TIME FLUSH_ELAPSED SNAP_LEVEL ERROR_COUNT SNAP_FLAG
---------- ---------- --------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------------------------------------------------------------------------- ---------- ----------- ----------
2606 1482843573 1 21-12月-09 05.13.32.000 下午 29-12月-09 10.00.19.812 下午 30-12月-09 12.00.07.459 上午 +00000 00:00:00.5
FLUSH_ELAPSED what this mean, does it mean flush all statistics in memory to fixed table .
if this is true ， this statics in about this time such as 12/30 10:00 am ' statics data ,
so i just want to ask does snapshot is store only time date (such as 12/30 10:00 am ' statics data ) or store one period time date