VERITAS Storage Foundation 4.1 Oracle Administrator's Guide
Chapter 6, Using Storage Mapping
Prerelease 8 September 2005, 8:55am Oracle File Mapping (ORAMAP)
151
5 fv.file_name, lpad(' ', 4 * (level - 1)) || \
el.elem_name elem_name, el.elem_size, el.elem_type, \
el.elem_descr
6 from
7 v$map_subelement sb, v$map_element el, fv,
8 (select unique elem_idx from v$map_file_io_stack io, fv
9 where io.file_map_idx = fv.file_map_idx) fs
10 where el.elem_idx = sb.child_idx
11 and fs.elem_idx = el.elem_idx
12 start with sb.parent_idx in
13 (select distinct elem_idx
14 from v$map_file_extent fe, fv
15 where fv.file_map_idx = fe.file_map_idx)
16 connect by prior sb.child_idx = sb.parent_idx;
Using Oracle Enterprise Manager
Oracle Enterprise Manager is a web-based GUI for managing Oracle databases. You can use this
GUI to perform a variety of administrative tasks such as creating tablespaces, tables, and indexes;
managing user security; and backing up and recovering your database. You can also use Oracle
Enterprise Manager to view performance and status information about your database instance.
From Oracle Enterprise Manager, you can view storage mapping information and a graphical
display of the storage layout. Storage mapping information cannot be viewed with the Oracle 10g
version of the Oracle Enterprise Manager client. However, the Oracle9i version of Oracle
Enterprise Manager can be used with Oracle 10g to view storage mapping information.
For more information about Oracle Enterprise Manager, refer to your Oracle documentation.
▼ To view storage information
1. To view storage information, start Oracle Enterprise Manager and select a database from the
left navigational pane (the object tree) of the Oracle Enterprise Manager Console.
2. Expand the Databases icon and select the desired database.
The Database Connect Information window appears.
3. Enter a user name and password to log in to the database and click OK.
4. In the object tree, expand the Storage icon.
5. Under the Storage icon, expand the Datafiles icon.
6. Select the datafile for which you want to view storage layout information.