Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: space management for lob data type

Re: space management for lob data type

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 7 Oct 2000 13:24:22 +0100
Message-ID: <970921812.2305.1.nnrp-09.9e984b29@news.demon.co.uk>

LOBs are stored in CHUNKs, the CHUNKSIZE can be set only when you create the table holding the LOB.

All LOB blocks are 100% full, and pctused/pctfree do not apply. Instead there is a PCTVERSION defined at create time that specifies the percentage of the currently used volume of the lob segment that may be used for retaining out of date copies of LOB CHUNKS.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

tedchyn_at_yahoo.com wrote in message <8ribdf$c5n$1_at_nnrp1.deja.com>...

>sir, Is the oracle manage the space of lob data type in the same
>manner as regular varchar2 datatype if the lob column store in a
>different tablespace - it will be reused for inserting when the block
>is below pctused .
>
>thnx ted chyn
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sat Oct 07 2000 - 07:24:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US