Re: deleting many rows from a table
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 19 Jan 2010 20:19:12 +0100
Message-ID: <652c9$4b5605b1$524ba3af$10406_at_cache5.tilbu1.nb.home.nl>
UXDBA wrote:
> All,
>
> Oracle 9.2.0.8
> OS - HP Ux 11.23
>
> We have table T
> count(*) = 31414748
>
> table definition
>
> create table T (
> OBJID NUMBER,
> DEV NUMBER,
> NAME VARCHAR2(20 BYTE),
> VALUE CLOB,
> CONTEXT_INST2GROUP_INST NUMBER,
> CONTEXT_INST2PROC_INST NUMBER
> )
>
[snip!]
Date: Tue, 19 Jan 2010 20:19:12 +0100
Message-ID: <652c9$4b5605b1$524ba3af$10406_at_cache5.tilbu1.nb.home.nl>
UXDBA wrote:
> All,
>
> Oracle 9.2.0.8
> OS - HP Ux 11.23
>
> We have table T
> count(*) = 31414748
>
> table definition
>
> create table T (
> OBJID NUMBER,
> DEV NUMBER,
> NAME VARCHAR2(20 BYTE),
> VALUE CLOB,
> CONTEXT_INST2GROUP_INST NUMBER,
> CONTEXT_INST2PROC_INST NUMBER
> )
>
[snip!]
Did you specify DISABLE STORAGE IN ROW for the CLOB? I may help tremendously, if the average LOB size > 4000 byte
-- Regards, Frank van Bortel Topposting in Usenet groups I regard as offensive - I will not replyReceived on Tue Jan 19 2010 - 13:19:12 CST