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

Running Database Dynamic Storage Tiering reports
You can create a report that lists all updated allocation policies or you can view
an audit report, which lists recent relocation changes for a specific date range
resulting from your policies.
Viewing modified allocation policies
To create a list of modified allocation policies, use the dbdst_report command
with the policy option.
To list allocation policies
◆
Use the dbdst_report command as follows:
$ /opt/VRTS/bin/dbdst_report -S $ORACLE_SID -o policy
For example, to view a list of modified allocation policies, use the dbdst_report
command as follows:
$ /opt/VRTS/bin/dbdst_report -S $ORACLE_SID -o policy
Viewing audit reports
To view an audit report, which lists recent file relocation changes within a specific
date range, use the dbdst_report command with the audit option.
To view an audit report
◆
Use the dbdst_report command as follows:
$ /opt/VRTS/bin/dbdst_report -S $ORACLE_SID -o audit \
startdate=yyyy-mm-dd,enddate=yyyy-mm-dd
For example, to view an audit report of changes from January 1, 2006 through
March 1, 2006, use the dbdst_report command as follows:
$ /opt/VRTS/bin/dbdst_report -S $ORACLE_SID -o audit \
startdate=2006-01-01,enddate=2006-03-01
Extent balancing in a database environment
To get better performance in a database environment, normally you would use a
volume striped over several disks. As the amount of data stored in the file system
increases over time, additional space in the form of new disks must be added.
197Using Database Dynamic Storage Tiering
Running Database Dynamic Storage Tiering reports