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

Table 6-1
Cached ODM Manager command options (continued)
UseOption
Disable Cached ODM.-o off
Displays Cached ODM I/O statistics per file.-o odmstats
Displays cumulative I/O statistics for file-type and I/O-type
combinations.
-o iostats
The File I/O statistics would be sorted on specified column
index. This is an optional field. By default I/O statistics
would be sorted on number of physical reads (PHYRDS).
-c column_index
Used to change the default number of files displayed. Use
this option together with -o display to show the top
num files which are candidates for enabling Cached ODM.
-n num
list_file contains a list of the datafiles used by the
Oracle database will be processed by Cached ODM Manager
commands. If you do not provide a list, all of the datafiles
will be processed, except in the case of the -o on or -o
off option.
-f list_file
Specifies the tablespace for -o display option to display
candidate files for certain tablespace.
-t tbs
Specify one datafile to be processed.datafile
Displaying the candidate files for Cached ODM
The Cached ODM Manager enables you to use the dbed_codm_adm command to
display a list of candidate files.
dbed_codm_adm -S ORACLE_SID -H ORACLE_HOME -o display [ -c col_index ] \
[ -n num ] [ -t tablespace ]
The -o display option checks for unused system memory (free memory). If the
free memory is less than 25% of the total system memory, it will flag a warning
not to turn on cached ODM for any files since there is no performance gain with
Cached ODM when the system is low on memory.
The display shows the files read count (PHYRDS) using Oracle V$FILESTAT view.
The flag –c is used to sort the output on specified column.
Improving database performance with Veritas Cached Oracle Disk Manager
Administering Cached ODM settings with Cached ODM Manager
80