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

Output is sorted from files with Cached ODM set to ON first then the files with

cached ODM set to OFF for ease in finding all the files with Cached ODM ON. If

there are thousands of files to display,

To display CODM states for files

◆

To display CODM states for files listed in /tmp/list run:

$ dbed_codm_adm -S prod -H /orahome -o filestate -f /tmp/list

Effective Cached ODM Status For Datafiles

(State value 'ERR' implies non-vxfs or non-existent file.)

FILENAME STATE

--------------------------------------------------------

/data/CODM/system01.dbf DEF

/data/CODM/undotbs01.dbf DEF

/data/CODM/sysaux01.dbf DFF

/data/CODM/users01.dbf OFF

/data/CODM/example01.dbf ON

Show Cached ODM statistics

After Cached ODM is enabled on the database files, one can show the effectiveness

of turning on cached ODM by displaying the ODM statistics – includes information

such as number of read operations, write operations, number of block read, block

write, cache hit ratio, etc. User can get some hint on how effective is turning on

the Cached ODM by reviewing the hit ratio.

■ Specified files must be database datafile,

or an error is returned.

■ Specified files must be on a VXFS

filesystem, or an error is returned.

Prerequisites

Improving database performance with Veritas Cached Oracle Disk Manager

Administering Cached ODM settings with Cached ODM Manager