Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> where are all these hard parses coming from?
I've been fighting sql w/o bind vars for a couple of days now, and
most of it is gone, but the number of hard parses still stays very
high. v$sysstat data doesn't seem to be supported by v$sqlarea view
select value,to_char(sysdate,'yyyy-mm-dd/hh24:mi:ss')
from v$sysstat where name='parse count (hard)';
---------- -------------------
8341931 2003-04-02/01:10:38
select value,to_char(sysdate,'yyyy-mm-dd/hh24:mi:ss') from v$sysstat where name='parse count (hard)';
select sum(parse_calls)
from v$sql
where
to_date(first_load_time,'yyyy-mm-dd/hh24:mi:ss')>to_date('2003-04-02/01:10:38','yyyy-mm-dd/hh24:mi:ss');
SUM(PARSE_CALLS)
17
shouldnt' i see something like 2000 here?
I don't have an easy way of identifying hard parses due to invalidations, but I know very few objects change, we don't even run cbo stats on a regular basis on this db. How can I identify where hard parses are coming from? I also know that sql couldn't have aged out so quickly, we have sql sitting in there parsed few days ago and never used again.
.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes
remove NSPAM to email
Received on Wed Apr 02 2003 - 01:22:09 CST
![]() |
![]() |