Re: Can someone on 10.2.0.3 please post SQL for X_$ESTIMATED_MTTR?
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: post.ethan@xxxxxxxxx
- Date: Thu, 17 May 2007 12:21:23 -0700
On 5/15/07, Ethan Post <post.ethan@xxxxxxxxx> wrote:
Just upgraded from 10.2.0.3 and this view won't compile. View references
columns that don't exist in X$ESTIMATE_MTTR. Not sure if is the view of X$.
It appears to just be a view of select * from x$estimate_mttr
select ADDR,INDX,INST_ID,REQ_EST_MTTR,INUSE_EST_MTTR_SEC
,CUR_EST_MTTR_SEC,INUSE_EST_MTTR_MICROSEC,CUR_EST_MTTR_MICROSEC
,INUSE_EST_MTTCA_SEC,CUR_EST_MTTCA_SEC,INUSE_EST_MTTCA_MICROSEC
,CUR_EST_MTTCA_MICROSEC,FAST_START_DERIVED,CKPT_ITVL_DERIVED
,FAST_START_PARAM,CKPT_ITVL_PARAM,ACTUAL_NUMBER_OF_CVS
,STAT_BASED_ON,INIT_TIME_AVG,INIT_TIMES_MEASURED,FOPEN_TIME_AVG
,FILES_MEASURED,LOG_READ_TIME_AVG,LOG_BLOCKS_MEASURED,DATA_READ_TIME_AVG
,DATA_WRITE_TIME_AVG,DATA_BLOCKS_MEASURED,THOUSAND_CV_APPLY_TIME_AVG
,CVS_MEASURED,LOG_BLOCKS_FOR_RATIO,DATA_BLOCKS_FOR_RATIO,CVS_FOR_RATIO
from X$ESTIMATED_MTTR
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
