Well, you don't have unnecessary parses, you are using the
primary key and it is still slow. The only advice that I can
give you is the one from the Taco Bell dog, during the commercial
referring to the 1998. movie "Godzilla". Taco Bell dog was trying
to bait the Godzilla under a standard grocery crate and when the
monster showed up, the little Chihuahua uttered something like:
"I need a bigger box". You too need a bigger box.
--
Mladen Gogala
A & E TV Network
Ext. 1216
> -----Original Message-----
> From: Mike Schmitt [mailto:mschmitt_at_uchicago.edu]
> Sent: Wednesday, November 03, 2004 2:29 PM
> To: oracle-l_at_freelists.org
> Subject: Update of Clobs *Performance*
>
>
> Hi all,
>
> I have a developer who is trying to use PL/SQL to update all
> of the CLOBS
> of a specific table (nightly basis). I am looking for advice
> on how to
> speed up the performance for this process. SQL tracing the
> process shows
> the following before I cancel out.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 03 2004 - 13:38:15 CST
