RE:

From: Aponte, Tony <AponteT_at_hsn.net>
Date: Fri, 29 Dec 2000 14:55:25 -0500
Message-Id: <10725.125470@fatcity.com>

Also, is this hard or soft parse? Hard parses would point to dynamic SQL as Dick suspects. Soft parsing would point you to Shared Pool sizing issues and/or other dynamic SQL issued against the database.

Good luck.

-----Original Message-----
From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com] Sent: Thursday, December 21, 2000 10:06 AM To: Multiple recipients of list ORACLE-L Subject: Re:

Ravi,

I would ask how you've put the statement into your program. I have developers who thought the same as you, but they were doing a dynamic statement
where the "where" part of the statement changed every time since they were not
using bind variables. Could you post the portion of the program that is "causing the problem" or sent it over privately?

Dick Goulet
A very old Pro*C hacker

____________________Reply Separator____________________
Author: "Ravi Vullanki" <rvullanki_at_hotmail.com>
Date:       12/20/2000 8:35 PM

Hello,
My name is Ravi. I am having a problem when i am executing a pro*c program.The Gist of the problem is, I want to tune the application, and in my application there are 17 unique sql select statements, and when i execute

it, for a single select statement it is taking approximately 1000 parsings(the stats are from TKPROF report),and i feel that a single select statement should be parsed only once when there is no change in my syntax. Can anybody help me with solution or possible website where i can find the relevant documentation apart from Metalink. Thanks in Advance for you time and help.

Thanks
Ravi Vaullanki

Get your FREE download of MSN Explorer at http://explorer.msn.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ravi Vullanki
INET: rvullanki_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------