pddbst VV-RR ***** Analysis Item Data ***** yyyy/mm/dd hh:mm:ss
No : 1
Date : 2005/05/25
Method : Reclaim
Type : T
Name : "k1234567"."table01" ("RDUSER01")
StateDate : 2005/05/19 00:10:32
------------------------------------------------------------------------------------
Information Value Method Date
---------------------------------------- ----------- -------------------- ----------
Empty Page Ratio 40 ( 50) * Reclaim pages 2005/05/25
Unused Page Ratio (30) 20 ( 30)
Used Segment for Cluster 40 ( 50)
Unused Page Differ From PCTFREE (10,10) 50 ( 75)
====================================================================================
No : 2
Date : 2005/05/31
Method :
Type : R
Name : "RDUSER01"
StateDate : 2005/05/19 00:10:32
------------------------------------------------------------------------------------
Information Value Method Date
---------------------------------------- ----------- -------------------- ----------
Used Segment Ratio (0,10) 40 ( 80) 2005/05/31
====================================================================================
No : 3
Date : 2005/06/01
Method : Reorganize
Type : T*
Name : "k1234567"."table10" ("RDUSER01")
StateDate : 2005/05/19 00:10:32
------------------------------------------------------------------------------------
Information Value Method Date
---------------------------------------- ----------- -------------------- ----------
Empty Page Ratio 25 ( 50) Reclaim pages 2005/08/10
Unused Page Ratio (30) 25 ( 30) * Reorganize 2005/06/01
Used Segment for Cluster 40 ( 50)
Unused Page Differ From PCTFREE (10,10) 60 ( 75)
====================================================================================
No : 4
Date : 2005/06/03
Method : Expand
Type : R
Name : "rd0002"
StateDate : 2005/05/19 00:10:32
------------------------------------------------------------------------------------
Information Value Method Date
---------------------------------------- ----------- -------------------- ----------
Used Segment Ratio (0,10) 78 ( 95) Expand 2005/06/03
====================================================================================
No : 5
Date : 2005/06/04
Method : Reclaim
Type : I
Name : "k1234567"."index07" ("rd0002")
StateDate : 2005/05/19 00:10:32
------------------------------------------------------------------------------------
Information Value Method Date
---------------------------------------- ----------- -------------------- ----------
Empty Page Ratio 38 ( 50) Reclaim 2005/06/04
Unused Page Ratio (30) 20 ( 30)
Unused Page Differ From PCTFREE (10,10) 70 ( 75)
Delete RowID Ratio 23 ( 30) ReclaimPx 2005/06/07
====================================================================================
No : 6
Date : 2005/06/04
Method : Reorganize
Type : L
Name : "k77a777"."table707" ("lobrdarea701")
StateDate : 2005/05/19 00:10:32
------------------------------------------------------------------------------------
Information Value Method Date
---------------------------------------- ----------- -------------------- ----------
Used Segment for LOB Columns (0,10) 70 ( 80) * Reorganize 2005/06/04
====================================================================================
No : 7
Date : 2005/06/06
Method : Expand
Type : R
Name : "RDUSER12"
StateDate : 2005/05/19 00:10:32
------------------------------------------------------------------------------------
Information Value Method Date
---------------------------------------- ----------- -------------------- ----------
Used Segment Ratio (0,10) 70 ( 80) * Expand 2005/07/01
==================================================================================== : |