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

After you enable Cached ODM on the first set of datafiles using the –o on option,
you can continue to call the dbed_codm_adm -o display option to display the next
set of candidate datafiles.
The following example procedures indicate the usage for this command.
To show the top 10 files without Cached ODM enabled
◆
To find the top 10 files (default is 10) with the highest Read I/O and for which
Cached ODM is not enabled, run the command:
$ dbed_codm_adm -S prod -H /orahome -o display
File I/O statistics from Oracle V$FILESTAT view sorted on PHYRDS
in descending order :
FILENAME PHYRDS PHYWRTS PHYBLKR PHYBLKWRT READTIM WRITETIM
--------------------------------------------------------------------------------------
/data/CODM/system01.dbf 5303 3410 6715 4507 1440 1
/data/CODM/sysaux01.dbf 1187 10433 3115 15160 549 21
/data/CODM/undotbs01.dbf 37 4983 37 8643 26 286
To show the top 15 files without Cached ODM enabled for tablespace tbs1
◆
To find the top 15 files for tablespace tbs1 with the highest Read I/O and for
which Cached ODM is not enabled, run the command:
$ dbed_codm_adm -S prod -H /orahome -o display -n 15 -t tbs1
Enabling and disabling Cached ODM on datafiles
Using the Cached ODM Manager to manage the Cached ODM settings of datafiles
provides a greater degree of control and ease of use than manually adding each
file to the odmadm configuration file. Cached ODM Manager makes the Cached
ODM settings persistent by making an entry for each datafile that gets configured
with the tool in the mountpoint/lost+found/odmadm configuration file, creating
it the first time if necessary.
If you are using Cached ODM Manager to manage the Cached ODM settings of
datafiles, the odmadm configuration file should not be edited manually. The
settings applied with Cached ODM Manager for a datafile take precedence over
any configuration for the same file specified in the /etc/vx/odmadm configuration
file. Both are read by theodmadm utility command during the VxFS mount process
and the /etc/vx/odmadm file is processed first, followed by the lost+found/odmadm
file on the file system on which the datafile resides.
81Improving database performance with Veritas Cached Oracle Disk Manager
Administering Cached ODM settings with Cached ODM Manager