VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Appendix A, VERITAS Storage Foundation for Oracle Command Line Interface
Prerelease 8 September 2005, 8:55am Examples of Using the Command Line Interface
427
Examining Oracle automatic extension of datafiles.
Total of 0 datafiles are configured to auto extend.
Total of 9 datafiles are defined to the database.
Examining Oracle log modes.
The database is running in archivelog mode.
The database is running in automatic log archiving mode.
▼ To check the Oracle configuration environment and not update the VxDBA repository
Use the dbed_checkconfig command with the -v and -n options as follows:
$ /opt/VRTS/bin/dbed_checkconfig -S PROD -H /oracle/product/9i -v -n
where -v lists all files and -n stops the VxDBA repository from being updated.
Examining file system attributes.
All file systems are VxFS.
All file systems are VxFS Version 4 or higher layout.
All file systems have the same version layout (version 6).
Examining Quick I/O settings.
All datafiles are Quick I/O files.
Examining Cached Quick I/O settings.
No file systems have Cached Quick I/O enabled.
Examining datafiles fragmentation.
5 files are fragmented.
/prod_db/index02.dbf is fragmented.
/prod_db/rolbak1.dbf is highly fragmented.
/prod_db/system.dbf is highly fragmented.
/prod_db/data01.dbf is highly fragmented.
/prod_db/data02.dbf is highly fragmented.
Examining File System tunable settings.
Parameters for all VxFS file systems used by PROD.
Filesystem i/o parameters for /prod_db
read_pref_io = 65536