Use
You can use SAPDBA for Oracle to display the assignment of tablespaces to raw devices or data files.
Prerequisites
You have configured and started SAPDBA. Refer to
Getting Started with SAPDBA.Procedure
SAPDBA displays the assignment tablespace to data files or tablespace to raw devices, and the size of the files.
In this display, which depends on your operating system, SAPDBA displays an overview of all raw devices and their size. If your database uses raw devices, the link to the raw device is also displayed.
For more information, see
Raw Devices and SAPDBA.