Veritas InfoScale™ 8.0.2 Storage and Availability Management for Oracle Databases - AIX, Linux, Solaris

Generating historical activity reports on individual datafiles by using Cached ODM Advisor in SFHA environment

When considering datafiles as candidates for enabling Cached ODM, it is useful to be able to get more detailed reports for individual datafiles. You can generate such a report by specifying a datafile with the -o display option of the dbed_codm_adm command.

You can use the date and time range options (-d and -m) and the snapshot range option (-u) of the dbed_codm_adm command to control the activity considered for these reports. In addition, when generating report on an individual datafile, you can generate a comparative report by using multiple snapshot id ranges. You can provide the -u starting_snapshot_id-ending_snapshot_id option a second time with a different range of snapshot ids and then generate a report comparing the read performance on the datafile during the two intervals. You can use this report to compare the read performance before and after enabling Cached ODM.

The following is an example of generating a report comparing the read performance on a datafile before and after enabling Cached ODM on that datafile.

$ dbed_codm_adm -S sfaedb -H $ORACLE_HOME -o display \
 -u 58-69 -u 70-80 /data/sfaedb/data02.dbf 
Filename: /data/sfaedb/data02.dbf
Current ODM caching status: ON
Currently blacklisted: no

from AWR snapshot id 58 to 69
Snapshot  Interval End Time     Physical    Physical   Read Time
Id                              Reads       Blocks     (s)
                                            Read
58        2011/07/11 01:30:22   33026       33026      1188.13
59        2011/07/11 02:30:35   39158       39158      1358.33
60        2011/07/11 03:30:43   49186       49186      1694.08
61        2011/07/11 04:30:53   46941       46941      1652.38
62        2011/07/11 05:30:00   44090       44090      1519.78
63        2011/07/11 06:30:09   43095       43095      1511.17
64        2011/07/11 07:30:19   41272       41272      1430.41
65        2011/07/11 08:30:26   39869       39869      1379.52
66        2011/07/11 09:30:33   38540       38540      1362.99
67        2011/07/11 10:30:45   37157       37157      1309.31
68        2011/07/11 11:30:01   36034       36034      1250.8
69        2011/07/11 12:30:10   46344       46344      934.87
Average per-block read time: 33.538 ms

from AWR snapshot id 70 to 80
Snapshot  Interval End Time     Physical    Physical   Read Time
Id                              Reads       Blocks     (s)
                                            Read
70        2011/07/11 13:30:16   48041       48041      951.42
71        2011/07/11 14:30:24   46978       46978      809.31
72        2011/07/11 15:30:36   47077       47077      127.41
73        2011/07/11 16:30:47   44140       44140      370.01
74        2011/07/11 17:30:56   41467       41467      993.7
75        2011/07/11 18:30:10   39998       39998      867.62
76        2011/07/11 19:30:18   40812       40812      517.06
77        2011/07/11 20:30:29   38918       38918      706.19
78        2011/07/11 21:30:38   37572       37572      856.43
79        2011/07/11 22:30:53   37694       61675      594.25
80        2011/07/11 23:30:04   38048       38048      151.29
Average per-block read time: 14.327 ms