SELECT AVG(DBMS_LOB.GETLENGTH(your_blob_column)) FROM <your_table>;

hth,
Regis

-----Original Message-----
From: John DeUnger [mailto:[Email Address Removed] Thursday, October 31, 2002 12:25 PM
To: LazyDBA.com Discussion
Subject: Length of LOBS



I am not great with programing procedures and hope that
you can help out. I am attempting to do some sizing
and need to record the sizes of LOBS using
the DBMS_LOB getlength procedure. I have
tried a function that returns the length of the lOBS
(acutually it's a BLOB) one at time when I enter the
record id, has anyone out there written a looping
procedure that will read a record, capture the length for
all of the records in the table ?

This is a production system I don't think I'd to add another table to it
to capture the information, but I'd like to do averages on the numbers
I get.

Examples would be appreciated.
Thanks.

Stephanie Gonos




--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.

This footnote also confirms that this message has been swept
for computer viruses.
**********************************************************************

Oracle LazyDBA home page