Home > Veritas Storage Foundation™ for Oracle Manual Pages
DBDST_FSTAT (1) |
|
User 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 an \1 system, enter:
lslpp -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.
This command is supported in a RAC environment. This command can be run on any
node of the RAC. The stats are collected on the same node where the command is run.
dbdst_fstat
must be run as Oracle DBA user.
Please set LIBPATH 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.