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:49:16
-- Input Parameters :
-- owner='SYS'
-- table_name='T1'
-- restore_time='08-JUN-13 03.31.37.285000 PM +02:00'
-- restore_or_test='restore'
-- display_ind_stats='y'
-- force=''
Information from dba_tab_statistics and dba_ind_statistics:
TABLE_NAME PARTITION_NAME SUBPARTITION_NAME
LAST_ANALYZED STATTYPE_LOCKED
------------------------------ ------------------------------ ------------------------------ -
------------------ ------------------------------------------------
T1
08.06.2013 15:31:06
INDEX_NAME PARTITION_NAME SUBPARTITION_NAME
LAST_ANALYZED STATTYPE_LOCKED
------------------------------ ------------------------------ ------------------------------ -
------------------ ------------------------------------------------
I1_T1
08.06.2013 15:31:06
I2_T1
08.06.2013 15:31:06
Restored
TABLE_NAME PARTITION_NAME SUBPARTITION_NAME
LAST_ANALYZED STATTYPE_LOCKED
------------------------------ ------------------------------ ------------------------------ -
------------------ ------------------------------------------------
T1
08.06.2013 15:31:06
INDEX_NAME PARTITION_NAME SUBPARTITION_NAME
LAST_ANALYZED STATTYPE_LOCKED
------------------------------ ------------------------------ ------------------------------ -
------------------ ------------------------------------------------
I1_T1
08.06.2013 15:31:27
I2_T1
08.06.2013 15:31:06
L.: „
Zunächst sieht man in der obigen Ausgabe den alten Statistikstand, zum Schluss wird der
Statistikstand nach dem Wiederherstellen ausgegeben. Dieser Statistikstand entspricht der
gewünschten Kombination der Analysezeitpunkte.
“
