RE: 8i CLOB data needs a labotomy

John

Its 816 db. Block size is 8K. We use out-of-line CLOBS so they go to a different tablespace. I'll check CHUNKSIZE and PCTVERSION. As for perl I dont know the internals of how it manages the inserts. If I get time I'll try SQL Loader and see how it handles them.

thanks for the pointers

John

At 02:32 PM 6/28/00 +0800, john.j.kanagaraj_at_shell.com.bn wrote:
>John,
>
>What are your very CLOB specific parameters such as PCTVERSION and
>CHUNKSIZE? Are they in-line / out-of-line CLOBS? What about your db
>block size? Does the problem have something to do with the way the Perl
>interface handles / sets default values for these? (and the internal
>Oracle ALTER - MOVE does a better job of it...) Last of all - how does
>it behave in 8.1.5 or 8.0.5 (if you have these databases around?)
>
>John Kanagaraj
>Brunei Shell Petroleum
>http://www.geocities.com/john_sharmila
>
>God so loved the world that He didn't send a committee! (See John 3:16
>for details)
>** Opinions expressed here are solely mine and not necessarily those of
>my employer **
>
>
>
>
>> -----Original Message-----
>> From: oracledba-digest-help
>> Sent: Wednesday, 28 June, 2000 4:17 AM
>> To: ORACLE-L; oracledba
>> Cc: jbarron
>> Subject: 8i CLOB data needs a labotomy
Received on Wed Jun 28 2000 - 13:05:40 CDT