Storage Indexes - Oracle Exadata Recipes: A Problem-Solution Approach - page 558

print "\t$day $tm: Region Idx => $rgnIdx\n" if $p;
}
if (/Col id/) {
print "\t\t$_" if $p;
}
}
close(F);
[root@cm01cel01 source]# ./lst19-07-storindsum.pl -o 29606 | more
Object: {29606 12 2273376219}
2012-11-29 01:17:09.324738*:: Region Idx => 208787
2012-11-29 01:17:09.324738*: Col id [1] numFilt 14 flg 2:
2012-11-29 01:17:09.324738*: Col id [3] numFilt 0 flg 2:
2012-11-29 01:17:09.324738*: Col id [4] numFilt 0 flg 2:
2012-11-29 01:17:09.324738*: Col id [5] numFilt 1 flg 2:
2012-11-29 01:17:09.324738*: Col id [6] numFilt 2 flg 2:
2012-11-29 01:17:09.324738*: Col id [7] numFilt 3 flg 2:
2012-11-29 01:17:09.324738*: Col id [8] numFilt 4 flg 2:
Object: {29606 12 2273376219}
2012-11-29 01:17:09.325352*:: Region Idx => 208790
2012-11-29 01:17:09.325352*: Col id [1] numFilt 14 flg 2:
2012-11-29 01:17:09.325352*: Col id [3] numFilt 0 flg 2:
2012-11-29 01:17:09.325352*: Col id [4] numFilt 0 flg 2:
2012-11-29 01:17:09.325352*: Col id [5] numFilt 1 flg 2:
2012-11-29 01:17:09.325352*: Col id [6] numFilt 2 flg 2:
2012-11-29 01:17:09.325352*: Col id [7] numFilt 3 flg 2:
2012-11-29 01:17:09.325352*: Col id [8] numFilt 4 flg 2:
... Output omitted for brevity
In the script output, you will find sections for each timestamp and region index accessed for the object provided.
This output will help you understand which columns are being tracked in the region index over time. For example, in
the first section of output above, region index 208787 contains values for columns 1, 3, 4, 5, 6, 7, and 8. Further down
in the script output, you will find different columns for this specific region index as Exadata dynamically adjusts which
columns to track. In the following trace file output, which was generated an hour and a half after the first values for the
region index were written to a trace file, we can see that column number 3 no longer resides in the storage index and
column number 10 has replaced it:
Object: {29606 12 2273376219}
2012-11-29 02:39:57.330536*:: Region Idx => 208787
2012-11-29 02:39:57.330536*: Col id [1] numFilt 14 flg 2:
2012-11-29 02:39:57.330536*: Col id [4] numFilt 1 flg 2:
2012-11-29 02:39:57.330536*: Col id [5] numFilt 2 flg 2:
2012-11-29 02:39:57.330536*: Col id [6] numFilt 3 flg 2:
2012-11-29 02:39:57.330536*: Col id [7] numFilt 4 flg 2:
2012-11-29 02:39:57.330536*: Col id [8] numFilt 0 flg 2:
2012-11-29 02:39:57.330536*: Col id [9] numFilt 0 flg 2:
2012-11-29 02:39:57.330536*: Col id [10] numFilt 0 flg 2: