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

■ The Cached ODM Manager will execute the odmadm setcachefile abc=on
command and also add or update the entry into the configuration file.
If you want to disable caching for abc:
■ The Cached ODM Manager will only execute the command odmadm
setcachefile abc=off and also update the entry in the configuration file.
■ Cached ODM Manager will not disable filesystem odm_cache_enable flag, since
there may be other files that is still cached ODM enabled. The SFDB tools do
not provide the command to disable filesystem odm_cache_enable flag. If the
filesystem odm_cache_enableflag is disabled by other means, the per file
caching will still be there just that caching will not be in effect.
Display the Cached ODM states of the database files
Following is the command option to display all the database files and their states.
The datafile | -f list_file parameter is optional. If no datafile or -f list_file
parameter is supplied, all the files in the database will be displayed.
ddbed_codm_adm -S ORACLE_SID -H ORACLE_HOME -o filestate \
[ datafile | -f list_file ]
Cached ODM is configured at two levels:
■ File System level
For the file system level, there are two states: ON or OFF.
■ File level
For the file level, there are three states: ON, OFF or DEF (default).
Table 6-2 illustrates how to determine the most effective Cached ODM setting.
Table 6-2
File Level
OFFONDEFFile system level
OFFONDEFON
OFFOFFOFFOFF
The dbed_codm_adm command displays the effective state for the Cached ODM
configuration. In the case of non-existent or non-File System files, a special state
called error state (ERR) is displayed.
83Improving database performance with Veritas Cached Oracle Disk Manager
Administering Cached ODM settings with Cached ODM Manager