If you're looking for a rough estimate as to how many are out of line you can check the chained row count, assuming your rows aren't migrating due to other reasons. However, with in-line lobs you can easily migrate your rows if you're storing a ~3K lob so it's not really reliable but it's a lot faster than doing a count(*) on your table where dbms_lob.getlength > 3964. - Brian Larry Elkins <elkinsl@xxxxxxxxx> wrote: Ok, I see why you replied with the GETLENGTH response (I left it out for brevity in the original). But thanks for taking the time to mention it! I guess we will stick with the LENGTH approach on 9i and the DBMS_LOB.GETLENGTH approach on 8i. I haven't done much with LOB's and am learning a gazillion things about them each day (and a lot of things I'm not crazy about). Regards, Larry G. Elkins elkinsl@xxxxxxxxx 214.954.1781 > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Gogala, Mladen > Sent: Wednesday, January 26, 2005 4:00 PM > To: 'Larry Elkins'; Gogala, Mladen; oracle-l@xxxxxxxxxxxxx > Subject: RE: LOB's -- How Many Out of Line? > > > You specifically mentioned both 8i and 9i, which lead me to the DBMS_LOB > instead of length. That is the only way that I am aware of to > find out which > LOBs "oozed" to the LOB tablespace. I have no magic bullet. As a matter of > fact, I don't have any ammo whatsoever. I use sticks and stones to break > bones. > I would never say that it is the only way, I say that this is the > only way I > know of. There may be others with more thorough knowledge of Oracle and > firearms on this list. > -- > Mladen Gogala > Ext. 121 -- //www.freelists.org/webpage/oracle-l --------------------------------- Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term' -- //www.freelists.org/webpage/oracle-l