VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Using VxDBA to Perform Administrative Operations Prerelease 8 September 2005, 8:55am
342 VERITAS Storage Foundation for Oracle Administrator’s Guide
Displaying and Updating Tablespace Information
Use the Display/Update Tablespace Information menu option to display the list of tablespaces of
an Oracle instance and their associated datafiles. This menu option is also available on the
Database Administration menu.
This operation displays a screen similar to the following:
VxDBA maintains a repository that stores the pertinent information needed to display
configuration information. This repository is located at /etc/vx/vxdba/$ORACLE_SID.
When the database configuration changes, the information stored in the repository may not be
up-to-date. When VxDBA detects that the repository is no longer consistent with Oracle’s system
catalog, VxDBA asks you if you want to update its repository with the latest configuration
information.
Displaying Datafile and File System Information
Use the Display Datafile/File System Information menu option to display the list of database files
and the file systems used by the Oracle instance.
--------------------------------------------------------
VxDBA: Display/Update Tablespace Information - PROD
--------------------------------------------------------
Database Status : ONLINE
# File Systems : 1
# Tablespaces : 4
# Datafiles : 4
Tablespace Name File Name
----------------------------- ---------------------------------
SYSTEM /db01/PROD/sys1
TSTAB /db01/PROD/tstab
TSIDX /db01/PROD/tsidx
TSTMP /db01/PROD/tstmp