Mapping Tablespaces to Disks Using dbed_analyzer

The dbed_analyzer command provides tablespace-to-physical disk mapping information for all the datafiles in a specified database. In addition, dbed_analyzer provides information about the percentage of disk space being used by a tablespace.

Because the dbed_analyzer command output can be long, it is written to a file for easier viewing. The file name is dbed_analyzer_$ORACLE_SID.log and it is located /tmp.

Prerequisites

• You must log in as the database administrator (typically, the user ID oracle).

Usage Notes

• The -o sort=tbs option provides the layout of the specified tablespaces on the physical disk as well as the percentage 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 percentage of disk space the tablespaces are using.
• The -f filename option specifies the name of a file containing a list of the tablespaces for which to obtain mapping information.
• The -t tablespace option specifies the name of a tablespace for which to obtain mapping information.
• For more information, see the dbed_analyzer(1M) online manual page.

  To obtain storage mapping information sorted by tablespace

Use the dbed_analyzer command with the -f filename and -o sort=tbs options:

Output similar to the following is displayed in the file filename:

  To obtain storage mapping information sorted by disk

Use the dbed_analyzer command with the -f filename and -o sort=disk options:

Output similar to the following is displayed in the file filename: