RE: Update of Clobs *Performance*
- From: "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>
- To: "'mschmitt@xxxxxxxxxxxx'" <mschmitt@xxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 3 Nov 2004 14:42:30 -0500
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@xxxxxxxxxxxx]
> Sent: Wednesday, November 03, 2004 2:29 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
