RE: LOB's -- How Many Out of Line?

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_at_flash.net> 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_at_flash.net
214.954.1781

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Gogala, Mladen
> Sent: Wednesday, January 26, 2005 4:00 PM
> To: 'Larry Elkins'; Gogala, Mladen; oracle-l_at_freelists.org
> 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

--
http://www.freelists.org/webpage/oracle-l

		
---------------------------------
Do you Yahoo!?
 Yahoo! Search presents - Jib Jab's 'Second Term'

--
http://www.freelists.org/webpage/oracle-l