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

EMC000184502242:32:0d:01 1 1336 8 190456 - -
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
141Using Storage Mapping
Using dbed_analyzer