Veritas Storage Foundation for Oracle 5.0 Administrator's Guide, HP-UX 11i v3, Second Edition, December 2008

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:
$ /opt/VRTS/bin/dbdst_admin -S $ORACLE_SID -o list,maxclass=number,\
minclass=number,sweepinterval=interval,sweeptime=hh:mm,\
statinterval=interval,purgeinterval=interval,purgetime=hh:mm,\
addclass=class:"description",rmclass=class
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:
$ /opt/VRTS/bin/dbdst_admin -S $ORACLE_SID -o addclass=FAST:\
"fast EMC array"
189Using Database Dynamic Storage Tiering
Configuring Database Dynamic Storage Tiering