Home > Veritas Storage Foundation™ for Oracle Manual Pages
DBDST_FSTAT (1M) |
|
Maintenance Commands |
Table of contents
dbdst_fstat - starts or stops I/O statistic collection on one or more
files in the database.
dbdst_fstat
-S
ORACLE_SID
-o start|stop <file-name>
dbdst_fstat
-S
ORACLE_SID
-o start|stop -f <spec-file>
dbdst_fstat
-S
ORACLE_SID
-o start|stop -t <tablespace-name>
dbdst_fstat
-S
ORACLE_SID
-o\fp stopall|list
Veritas Storage Foundation for Oracle.
To determine whether this product is installed on a Solaris system, enter:
pkginfo -l VRTSdbed
dbdst_fstat must be run as
Oracle DBA user.
This command is used to start or stop I/O statistic
collection on one or more files in the database. Statistics are collected
once every 30 minutes, and it only collects statistics for data files
in a database. The command also supports SMS tablespace but only collects
I/O statistic for data files with extension of *.DAT, *.INX, and *.LB.
Any of the specified data file name which are not found in the repository,
the command will returns error.
The following options are supported:
-
-S ORACLE_SID
-
Specifies the name of the Oracle database for which information will be retrieved.
-
-o start
-
Add specified file(s) into repository file statistic table, and
schedules statistic collection task to start collecting I/O statistic
on data files for every 30 minutes.
-
-o stop
-
Remove specified files(s) from repository file statistic table, TSDB_File.
If there is no more entry in the file statistic table, the command will stop
scheduling statistic collection task.
-
-o stopall
-
stop statistic collection and remove all statistic file entries from repository.
table, TSDB_File.
-
-o list
-
Display data files which has statistic collection set.
-
filename | -t tablespace-name | -f filename
-
user can specify either one file name, or use -f option to supply a file name
which contains a list of files, or use -t option to supply a tablespace name,
to start or stop statistic collection. For the specified tablespace name,
statistic will be collected for data files belong to the specified table space name.
dbdst_fstat
must be run as Oracle DBA user.
Please set LD_LIBRARY_PATH to include /opt/VRTSdbms3/lib32
-
0
-
Command executed successfully.
-
1
-
An Error Occured.
-
101
-
Licence check failed.
-
102
-
No license to execute this command.
-
103
-
Invalid Storage Class
-
104
-
The device or mount point is not owned by user
-
105
-
Could not get information from Oracle Database
-
255
-
Could not load program.
dbdst_classify(1M),
dbdst_admin(1M),
dbdst_convert(1M),
dbdst_file_move(1M),
dbdst_fstat(1M),
dbdst_makelbfs(1M),
dbdst_partition_move(1M),
dbdst_preset_policy(1M),
dbdst_report(1M),
dbdst_rmvol(1M),
dbdst_show_fs(1M),
dbdst_addvol(1M),
oracle_edition(7)
oracle_edition(7)
Veritas Storage Foundation for Oracle Administrator's Guide
Last updated: 15 Jan 2006
Copyright ©2009 Symantec Corporation
All rights reserved.