Re: Can someone on 10.2.0.3 please post SQL for X_$ESTIMATED_MTTR?

Probably someone was reading Steve earlier in the life of the database

http://www.ixora.com.au/scripts/sql/create_xviews.sql

Niall

On 5/18/07, M Rafiq <rafiq9857_at_hotmail.com> wrote:
>
> I could not find this object/view either of 10g databases (10.1 or
> 10.2.0.3)
> databases. Those are all newly created databases and no migration was
> involved.
>
> Regards
> Rafiq
>
>
>
>
> From: "Jared Still" <jkstill_at_gmail.com>
> Reply-To: jkstill_at_gmail.com
> To: post.ethan_at_gmail.com
> CC: oracle-l <oracle-l_at_freelists.org>
> Subject: Re: Can someone on 10.2.0.3 please post SQL for
> X_$ESTIMATED_MTTR?
> Date: Thu, 17 May 2007 12:21:23 -0700
>
> On 5/15/07, Ethan Post <post.ethan_at_gmail.com> 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
>
> _________________________________________________________________
> More photos, more messages, more storage—get 2GB with Windows Live
> Hotmail.
>
> http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_2G_0507
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l