Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_LOB , 15 of 26
When creating the table, you can specify the chunking factor, which can be a multiple of Oracle blocks. This corresponds to the chunk size used by the LOB
data layer when accessing or modifying the LOB
value. Part of the chunk is used to store system-related information, and the rest stores the LOB
value.
This function returns the amount of space used in the LOB
chunk to store the LOB
value.
DBMS_LOB.GETCHUNKSIZE ( lob_loc IN BLOB) RETURN INTEGER; DBMS_LOB.GETCHUNKSIZE ( lob_loc IN CLOB CHARACTER SET ANY_CS) RETURN INTEGER;
pragma restrict_references(GETCHUNKSIZE, WNDS, RNDS, WNPS, RNPS);
Parameter | Description |
---|---|
lob_loc |
|
The value returned for BLOBs
is in terms of bytes. The value returned for CLOBs
is in terms of characters.
Performance is improved if you enter read/write requests using a multiple of this chunk size. For writes, there is an added benefit, because LOB
chunks are versioned, and if all writes are done on a chunk basis, then no extra or excess versioning is done or duplicated. You could batch up the WRITE
until you have enough for a chunk, instead of issuing several WRITE
calls for the same chunk.
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|