Re: Can't find "hard parse elapsed time" value in sysstat view even exactly has "parse count (hard)" value
- From: "Leyi Zhang (Kamus)" <kamusis@xxxxxxxxx>
- To: oracle_l <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 7 May 2010 23:02:10 +0800
Sorry for disturb.
I've found these stats values have been moved to dba_hist_sys_time_model.
--
Kamus <kamusis@xxxxxxxxx>
Visit my blog for more : http://www.dbform.com
Join ACOUG: http://www.acoug.org
On Fri, May 7, 2010 at 7:31 PM, Leyi Zhang (Kamus) <kamusis@xxxxxxxxx> wrote:
> Hi, lists
>
> SQL> select stat_name from dba_hist_stat_name where stat_name like '%parse%'
> 2 minus
> 3 select distinct stat_name from dba_hist_sysstat where stat_name
> like '%parse%'
> 4 /
>
> STAT_NAME
> ----------------------------------------------------------------
> failed parse (out of shared memory) elapsed time
> failed parse elapsed time
> hard parse (bind mismatch) elapsed time
> hard parse (sharing criteria) elapsed time
> hard parse elapsed time
>
> All above 5 stats can't never be found in WRH$_SYSSTAT or
> DBA_HIST_SYSSTAT either in our product 10.2.0.3 database or in our
> test 11.2.0.1 database.
>
> SQL> select max(value) from dba_hist_sysstat where stat_name='parse
> count (hard)';
>
> MAX(VALUE)
> ----------
> 26013
>
> SQL> select max(value) from dba_hist_sysstat where stat_name='hard
> parse elapsed time';
>
> MAX(VALUE)
> ----------
>
>
> SQL>
>
> The question is: Why we can find "parse count (hard)" value but no
> "hard parse elapsed time" value? How about in your database?
>
> Any hint will be very appreciated.
>
> --
> Kamus <kamusis@xxxxxxxxx>
>
> Visit my blog for more : http://www.dbform.com
> Join ACOUG: http://www.acoug.org
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
