See disk file disk I / O number of
V $ FILESTAT contains the following column
Help
FILE # file number in the V $ DATAFILE in Canada can be obtained after the FILE # Name
PHYRDS has completed the number of physical reads
PHYWRTS has completed the number of physical write
PHYBLKRD read the number of physical block
PHYBLKWRT write the number of physical block
The time to read READTIM
The time to write WRITETIM
Note the last two parameters contain 0 unless TIMED_STATISTICS set to TRUE
Use the following query to monitor these values
SQL> col name format a40
SQL> SELECT phyrds, phywrts, d.name
2 FROM v $ datafile d, v $ filestat f
3 WHERE d.file # = f.file # order by d.name;
PHYRDS PHYWRTS NAME
---------- ---------- ------------------------------ ----------
46317 179816 / data1/oradata/dbnms/sysaux01.dbf
147921 131974 / data1/oradata/dbnms/sysaux02.dbf
98538 85339 / data1/oradata/dbnms/system01.dbf
5979 10033 / data1/oradata/dbnms/system02.dbf
511 203266 / data1/oradata/dbnms/undotbs01.dbf
14633943 424908 / data1/oradata/dbnms/user02.dbf
2305255 2752296 / data1/oradata/dbnms/users01.dbf
179712 30608 / data2/oradata/dbnms/GOLDPEN.dbf
58854 5099 / data2/oradata/dbnms/INFOCASES.dbf
2046999 55947 / data2/oradata/dbnms/MARKET_NEW.dbf
2026600 64013 / data2/oradata/dbnms/MARKET_NEW1.dbf
PHYRDS PHYWRTS NAME
---------- ---------- ------------------------------ ----------
2319092 102828 / data2/oradata/dbnms/MARKET_NEW2.dbf
2052449 68187 / data2/oradata/dbnms/MARKET_NEW3.dbf
333 299 / data2/oradata/dbnms/ccidnet.dbf
337 299 / data2/oradata/dbnms/ccidnetindex.dbf
15 rows selected.
Related Posts of See disk file disk I / O number of
-
ORACLE table space-related operations
sqlplus / nolog connect / as sysdba startup sqlplus / nolog connect / as sysdba SHUTDOWN IMMEDIATE If you want to use windows default date format. English is not in the configuration variables in the environment: NLS_LANG american_america.us7ASCII - ...
-
Study Notes
First, restore block: One, how bad block detection? Alert.log usually through command-line prompt or from these tips you can know where the bad block file and block number. 2, all available from the implementation of block restore backup files? RMAN under
-
Oracle Database Exp / Imp tools for performance tuning
Abstract: Oracle Exp / Imp instrument is a simple, convenient and flexible backup and restore data transfer tool, it can implement the entire class library, user-level, table-class data backup and recovery. For the amount of data in class G or G with ...
-
Database tuning problem (parameter binding, Histogram Analysis)
1, histogram Analysis of depth. . 20080901 ~ 20060101 ~ 99991231 2, the binding parameters The use of different parameters of the different analysis. . . The use of index Scanning the entire table is slightly
-
setting to discuss filing oracle10g
Oracle Database 10g Enterprise Edition Release 10.2.0 .4.0 - Prod PL / SQL Release 10.2.0 .4.0 - Production IXDBA.NET Community Forums CORE 10.2.0 .4.0 Production TNS for Solaris: Version 10.2.0 .4.0 - Production NLSRTL Version 10.2.0 .4.0 - Producti ...
-
LISTENER and EZCONNECT
listener =========================== Listener should be noted that there are two methods Register: Dynamic and Static Registration Registration Registration <br /> dynamic, that is, when the listener configuration, Do not need to configure stat ...
-
RMAN created physical standby
Monitor in the standby host to create the necessary directory structure and parameter files. Hot COPY after the main library to the standby, and on standby to restore. +++++++++++++++++++++++++++++ Standby ++++++++++++++++++++++++++++++++++++++++++++ ...
-
Using SQL TRACE and TKPROF
Can type in the operating system to obtain tkprof all available options and output options to sort a list of note has Sort Option Description call analysis prscnt execnt fchcnt the implementation of the number of extraction Analysis of the implementa ...
-
An example of the use of TKPROF
First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE
Leave a Reply