Re: row size script

"Feldman Roger" <qrarofe_at_era.ericsson.se> wrote in message news:3A93C25A.C0835B3C_at_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.
>
> Q:
>
> 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
> ~
> ~
> ~
>
>

[Quoted] Just apply the vsize function to your babies and you will know how fat they are.
Why not use a BFILE instead, if I may ask so. At least doing so, they won't clutter up the database.

Regards,

[Quoted] Sybrand Bakker, Oracle DBA Received on Wed Feb 21 2001 - 16:04:54 CET