|
Welcome
Seminars
Consultancy
Presentations
Diagnostics
Internals
Acknowledgements
|
Fixed View: X$ESTIMATED_MTTR
Versions
| Oracle Version |
X$ Version |
| 10.1.0.3.0 |
4 |
| 10.2.0.1.0 |
4 |
| 11.1.0.6.0 |
5 |
Columns
Version 4
| Column Name |
Data Type |
| ADDR |
RAW(4) |
| INDX |
NUMBER |
| INST_ID |
NUMBER |
| REQ_EST_MTTR |
NUMBER |
| INUSE_EST_MTTR_SEC |
NUMBER |
| CUR_EST_MTTR_SEC |
NUMBER |
| INUSE_EST_MTTR_MICROSEC |
VARCHAR2(22) |
| CUR_EST_MTTR_MICROSEC |
VARCHAR2(22) |
| INUSE_EST_MTTCA_SEC |
NUMBER |
| CUR_EST_MTTCA_SEC |
NUMBER |
| INUSE_EST_MTTCA_MICROSEC |
VARCHAR2(22) |
| CUR_EST_MTTCA_MICROSEC |
VARCHAR2(22) |
| FAST_START_DERIVED |
NUMBER |
| CKPT_ITVL_DERIVED |
NUMBER |
| FAST_START_PARAM |
NUMBER |
| CKPT_ITVL_PARAM |
NUMBER |
| ACTUAL_NUMBER_OF_CVS |
NUMBER |
| STAT_BASED_ON |
VARCHAR2(20) |
| INIT_TIME_AVG |
NUMBER |
| INIT_TIMES_MEASURED |
NUMBER |
| FOPEN_TIME_AVG |
NUMBER |
| FILES_MEASURED |
NUMBER |
| LOG_READ_TIME_AVG |
NUMBER |
| LOG_BLOCKS_MEASURED |
NUMBER |
| DATA_READ_TIME_AVG |
NUMBER |
| DATA_WRITE_TIME_AVG |
NUMBER |
| DATA_BLOCKS_MEASURED |
NUMBER |
| THOUSAND_CV_APPLY_TIME_AVG |
NUMBER |
| CVS_MEASURED |
NUMBER |
| LOG_BLOCKS_FOR_RATIO |
NUMBER |
| DATA_BLOCKS_FOR_RATIO |
NUMBER |
| CVS_FOR_RATIO |
NUMBER |
Version 5
| Column Name |
Data Type |
| ADDR |
RAW(4) |
| INDX |
NUMBER |
| INST_ID |
NUMBER |
| REQ_EST_MTTR |
NUMBER |
| INUSE_NONRAC_MTTR_SEC |
NUMBER |
| INUSE_NONRAC_MTTR_MICROSEC |
VARCHAR2(22) |
| CUR_EST_NONRAC_MTTR_SEC |
NUMBER |
| CUR_EST_NONRAC_MTTR_MICROSEC |
VARCHAR2(22) |
| INUSE_RAC_MTTR_SEC |
NUMBER |
| INUSE_RAC_MTTR_MICROSEC |
VARCHAR2(22) |
| CUR_EST_IR_SEC |
NUMBER |
| CUR_EST_IR_MICROSEC |
VARCHAR2(22) |
| CUR_EST_CA_SEC |
NUMBER |
| CUR_EST_CA_MICROSEC |
VARCHAR2(22) |
| FAST_START_DERIVED |
NUMBER |
| CKPT_ITVL_DERIVED |
NUMBER |
| FAST_START_PARAM |
NUMBER |
| CKPT_ITVL_PARAM |
NUMBER |
| ACTUAL_NUMBER_OF_CVS |
NUMBER |
| STAT_BASED_ON |
VARCHAR2(20) |
| INIT_TIME_AVG |
NUMBER |
| INIT_TIMES_MEASURED |
NUMBER |
| FOPEN_TIME_AVG |
NUMBER |
| FILES_MEASURED |
NUMBER |
| LOG_READ_TIME_AVG |
NUMBER |
| LOG_BLOCKS_MEASURED |
NUMBER |
| DATA_READ_TIME_AVG |
NUMBER |
| DATA_WRITE_TIME_AVG |
NUMBER |
| DATA_BLOCKS_MEASURED |
NUMBER |
| THOUSAND_CV_APPLY_TIME_AVG |
NUMBER |
| CVS_MEASURED |
NUMBER |
| LOG_BLOCKS_FOR_RATIO |
NUMBER |
| DATA_BLOCKS_FOR_RATIO |
NUMBER |
| CVS_FOR_RATIO |
NUMBER |
Indexes
Version 4
Version 4 of this fixed view does not have any indexes
Version 5
Version 5 of this fixed view does not have any indexes
|
