Soft parse or Hard parse

From: charlie cs <cs3526(no-spam)_at_yahoo.com>
Date: Sat, 15 Mar 2003 12:39:30 GMT
Message-ID: <6aFca.57801$gi1.41465@nwrdny02.gnilink.net>

John Weeg in his artical "are we parsing too much" provided a sql to identified the sql statements that went through too much parse.

It is something like:

select parse_calls, executions, sql_text from v$sqlarea where parse_calls >= executions

I found that in my database, there are quite some sql statement like that

parse_call     executions            sql_text
19900             19900                select * from A where col1=:x

...........

Because they are from v$sqlarea, so they are all soft parses, and I should not pay too much attention to it, am I right?

And they already use bind values, there is not too much I can do about it, am I right?

Thanks for your help. Received on Sat Mar 15 2003 - 06:39:30 CST