Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> where are all these hard parses coming from?

where are all these hard parses coming from?

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Wed, 02 Apr 2003 07:22:09 GMT
Message-ID: <3e8a872a.3160471647@nyc.news.speakeasy.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US