Database Reference
In-Depth Information
-- Database Alias : XXXX
-- Oracle Server Version : 11.2.0.3.0
-- Script restore_opt_tab_stats10g.sql (Product TuTool 6.5.2 : www.tutool.de)
-- Start Time : 08.06.13 15:40:31
-- Input Parameters :
-- owner='SYS'
-- table_name='T1'
-- restore_time=''
-- restore_or_test=''
-- display_ind_stats='y'
-- force=''
HISTORY_RETENTION
STATS_HISTORY_AVAILABILITY
-------------------------------------------------------------------- -------------------------
-----------------------------------------------------------------
31 - history retention in days 08-MAY-13 08.59.45.238000
AM +02:00 - oldest timestamp where stats history is available
You can execute DBMS_STATS.ALTER_STATS_HISTORY_RETENTION (xx) to change history retention, xx
- retention in days:
0 - never save,
-1 - never purge,
1 - 365000 - valid range of days
Information about stored optimizer statistics:
TABLE_NAME PARTITION_NAME SUBPARTITION_NAME
STAT_UPDATE_TIME STATUS ANALYZETIME
------------------------------ ------------------------------ ------------------------------ -
------------------------------------- ------------- -------------------
T1
08-JUN-13 03.32.08.267000 PM +02:00 AVAILABLE 08.06.2013 15:31:47
T1
08-JUN-13 03.32.08.158000 PM +02:00 AVAILABLE 08.06.2013 15:31:57
T1
08-JUN-13 03.31.57.612000 PM +02:00 AVAILABLE 08.06.2013 15:31:47
T1
08-JUN-13 03.31.47.379000 PM +02:00 AVAILABLE 08.06.2013 15:31:06
T1
08-JUN-13 03.31.06.850000 PM +02:00 AVAILABLE
INDEX_NAME PARTITION_NAME SUBPARTITION_NAME
STAT_UPDATE_TIME STATUS ANALYZETIME
------------------------------ ------------------------------ ------------------------------ -
