Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

Using dbed_analyzer
This release adds table-level mapping, with which for a given table dbed_analyzer
lists the disks on which it resides and the space it occupies on each disk. Use the
-o sort=table option to use this enhancement.
Users previously could find which tablespace resides on which disk, but with
table-level mapping a user can learn on which disk a heavily-used table resides.
This information can help database administrators and system administrators
determine the allocation of storage, to assess backup priorities for the disk, and
to identify performance bottlenecks.
Effectively performing a parallel backup requires an understanding of which
tablespaces and tables reside on which disks. If two tablespaces or two tables
reside on the same disk, for example, backing them up in parallel will not reduce
their downtime.
The dbed_analyzer command provides tablespace-to-physical and
table-to-physical disk mapping information for all the datafiles in a specified
tablespace, list of tablespaces, or an entire database. (In contrast, the
vxstorage_stats command provides this information on a per-file basis only.)
In addition, dbed_analyzer provides information about the amount of disk space
they are using.
■ You must log in as the database administrator (typically, the user
ID oracle).
Prerequisites
■ The -o sort=tbs option provides the layout of the specified
tablespaces on the physical disk as well as the amount of disk space
they are using.
■ The -o sort=disk option provides the name of the disks
containing the specified tablespaces as well as the amount of disk
space the tablespaces are using.
■ The -o sort=table option identifies the disk and the space
occupied on it by the specified table or list of tables.
■ The -f filename option specifies the name of a file containing
a list of the tables, tablespaces ro disk names for which to obtain
mapping information.
■ The -t option specifies the name of a specified tablespace (when
used with -o sort=tbs) or table (when used with -o
sort=table) for which to obtain mapping information.
■ If -f filename or -t tablespace is not specified then all the
tablespaces in the database will be analyzed.
■ For more information, see the dbed_analyzer(1M) online manual
page.
Usage notes
Using Storage Mapping
Using dbed_analyzer
140