Re: row size script

From: Feldman Roger <qrarofe_at_era.ericsson.se>
Date: Thu, 22 Feb 2001 09:45:47 +0100
Message-ID: <3A94D1BB.FB1A871F_at_era.ericsson.se>

Sybrand Bakker wrote:

>
> > ~
> >
> >
>
> 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,
>
> Sybrand Bakker, Oracle DBA

Sybrand:

Thanks for the tip ! Obviously I'm no SQL expert as I mostly use scripts that I've found on the net to monitor my databases. This seems to work well for me as I'm not a developer- just a unix admin who keeps the databases running.

I can't change how the data is stored as this is a commercial product and your forced to user their tables ....

Anyway-

I tried your "vsize" which is good, however it won't give info on the long raw data:

SQL> select vsize(DATA) from cq06.user_blob; select vsize(DATA) from cq06.user_blob

             *
ERROR at line 1:
ORA-00997: illegal use of LONG datatype

---

The vsize does spit out the size of the rowid- not that I need it but it shows how the function works.

Cheers,

Roger Received on Thu Feb 22 2001 - 09:45:47 CET