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

Administering Cached ODM settings with Cached ODM

Manager

The Cached ODM Manager simplifies the task of managing the cached ODM

settings for database administrators:

■ Cached ODM Manager enables you to manage and configure cached ODM on

database files without requiring root privileges.

■ The settings applied with the Cached ODM Manager are automatically

persistent and common across all the cluster nodes.

■ While the Cached ODM Manager does not provide an interface to the ODM

cachemap, it enables setting the cached ODM setting to ON/ OFF (and not to

DEF).

The Cached ODM Manager command dbed_codm_admshould be run by a DBA.

Note: If you are using Cached ODM Manager for clone databases, a clone database

will not have the cached ODM settings enabled when it is enabled for the primary

database. You must manually enable cached ODM by setting odm_cache_enable

= 1 for the clone database.

The Cached ODM Manager command dbed_codm_adm syntax is illusterated below

and its options are listed in Table 6-1.

dbed_codm_adm [ -S ORACLE_SID ] [ -H ORACLE_HOME ] -o display \

[ datafile | -f list_file ] [ -t tablespace ]

Table 6-1

Cached ODM Manager command options

UseOption

Specify the ORACLE_SID-S ORACLE_SID

Specify the ORACLE_HOME-H ORACLE_HOME

Display the top 10 files (10 is the default) sorted on a

certain column of the V$FILESTAT view of the database

(the default sort column is PHYRDS).

-o display

Show the file state whether they have cached ODM turned

on or not.

-o filestate

Enable Cached ODM.-o on

79Improving database performance with Veritas Cached Oracle Disk Manager

Administering Cached ODM settings with Cached ODM Manager