Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

Note: If you do not want to change specific default values, you can omit those
parameters when you run the dbdst_admin command. You only need to enter the
parameters that need to be changed.
To define database parameters
◆
Use the dbdst_admin command as follows:
dbdst_admin -S ORACLE_SID -o setup-parameters ,\
[storage_class operations ]
setup-parameters
maxclass=number,minclass=number,statinterval=minutes,\
sweeptime=HH:MM,sweepinterval=days,\
purgetime=HH:MM,purgeinterval=days
storage_class operations
addclass=classname:"description",rmclass=classname \
definechunk=classname:128k | 256k | 512k | 1m
For example, to add a class called tier1 for database PROD, and to set up a purge
interval of one, meaning that the file statistics will be gathered for one day and
then summarized and purged, use the dbdst_admin command as follows:
$ /opt/VRTS/bin/dbdst_admin -S PROD -o addclass=tier1:"Fast Storage",\
purgeinterval=1
Setting up storage classes
When you define your database parameters, three pre-defined storage classes are
created. You will need to add or remove storage classes to fit your needs.
Adding storage classes
In addition to the default storage classes, you can add storage classes to better
manage your data.
Before adding a storage class, review the following information:
To add a storage class
◆
Use the dbdst_admin command as follows:
$ /opt/VRTS/bin/dbdst_admin -S $ORACLE_SID -o addclass=class:\
"description"
For example, to create a storage class named "FAST" for an EMC array, use the
dbdst_admin command as follows:
189Using Database Dynamic Storage Tiering
Configuring Database Dynamic Storage Tiering