Re: 10046 trace - weird library misses

From: Jared Still <jkstill_at_cybcon.com>
Date: Fri, 14 Feb 2003 06:53:47 -0800
Message-ID: <F001.0054D8E1.20030214065347@fatcity.com>

Well, I wasn't actually correcting you.

Just thought you knew something about dynamic SQL that I wanted to see. :)

Jared

On Thursday 13 February 2003 10:29, Jamadagni, Rajendra wrote:
> hmmm...
>
> I shouldn't work on two emails at the same time anymore... Can't work in
> parallel.
>
> The statement should be ...
>
> There will be a parse, but it could be a soft if the SQL exists ... but a
> parse will happen so, my answer was absolutely irrelevant to the question.
>
> Please ignore, and thanks for correcting me Jared.
> (ps: The cut and paste was from an internal email showing reasons for hard
> parses ...)
>
> Raj
> ______________________________________________________
> Rajendra Jamadagni MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect that of ESPN
> Inc.
>
> QOTD: Any clod can have facts, but having an opinion is an art!
>
>
> -----Original Message-----
> Sent: Thursday, February 13, 2003 1:00 PM
> To: ORACLE-L_at_fatcity.com
> Cc: Jamadagni, Rajendra
> Importance: High
>
>
> Raj, where is it documented that EXEC IMMEDIATE always does a hard parse?
>
> Thanks,
>
> Jared

---

Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 
----------------------------------------

----------------------------------------
Content-Type: text/plain; charset="iso-8859-1"; name="ESPN_Disclaimer.txt"
Content-Transfer-Encoding: 7bit

Content-Description:

---

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Fri Feb 14 2003 - 08:53:47 CST