Row size script

From: Feldman Roger <qrarofe_at_era.ericsson.se>
Date: Wed, 21 Feb 2001 14:27:58 +0100
Message-ID: <3A93C25E.92ED04CC@era.ericsson.se>

Hello again:

I've got a table which is a BLOB table which contains lots of attachments for a program. Each attachment(Oh yes ! word docs and other garbage) are placed into a row.

When these babies get to big my buffers start to moan during imports.

How do I determine the size of each row ?

Anybody got a script ?

Here is how the table looks:

SQL> desc cq06.attachments_blob
Name
Null? Type

------------------------------------------------- ATTACHMENTS_DBID NUMBER(10) ENTITY_DBID NUMBER(10) ENTITY_FIELDDEF_ID NUMBER(10) DATA LONG RAW

THANX, Roger
~
~
~
Received on Wed Feb 21 2001 - 07:27:58 CST