Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

■ If a datafile or a list of datafiles is not
supplied, it will display odmstats of all
the files that are being cached ODM
enabled for the specified ORACLE_SID.
■ Statistics are reset to zero when the file
is no longer opened by anyone.
■ ODM statistics are only collected for
filesystems where odm_cache_enable has
been set. If odm_cache_enable is not set
for the filesystem which contain the
datafile, information such as CACHE
STATISTICS, HIT RATIO will be set to 0.
Notes
Following is the command option to display the ODM statistics of one database
file. It is mandatory to supply either a datafile name or use the –f list_file option.
dbed_codm_adm -S ORACLE_SID -H ORACLE_HOME -o odmstats [ datafile | -f list_file ]
For example, to show odm statistics for the datafile /oradata/tb1.dbf , use
$ dbed_codm_adm -S prod -H /orahome -o odmstats /oradata/tb1.dbf
FILENAME NREADS NWRITES RBLOCKS WBLOCKS RTIME WTIME NREQUESTIO NDISKIO HIT-RATIO
----------------------------------------------------------------------------------------
/oradata/tb1.dbf 1262 10617 51040 287056 11.0 1.0 4728 5918 22.0
Displaying ODM I/O statistics
You can display the ODM I/O statistics. I/O statistics include information such as
I/O requests, amount of data processed, for each file type and I/O type combination.
To show ODM I/O statistics for the local host, use:
$ dbed_codm_adm -o iostats
For displaying ODM I/Statistics:
■ -S ORACLE_SID, -H ORACLE_HOME, datafile, -f list_file options are not
required as the I/O statistics that is shown is specific to the local node, and it
spans all filesystems.
■ The statistics shown is not aggregated statistics from all nodes if used on an
Oracle RAC cluster.
■ Use VxFS command odmadm getiostats internally and filter the data.
85Improving database performance with Veritas Cached Oracle Disk Manager
Administering Cached ODM settings with Cached ODM Manager