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

  • From: "Gogala, Mladen" <MGogala@xxxxxxxxxxxxxxxxxxxx>
  • To: 'Larry Elkins' <elkinsl@xxxxxxxxx>, "Gogala, Mladen" <MGogala@xxxxxxxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 26 Jan 2005 17:00:15 -0500

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
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

-----Original Message-----
From: Larry Elkins [mailto:elkinsl@xxxxxxxxx] 
Sent: Wednesday, January 26, 2005 4:26 PM
To: MGogala@xxxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: LOB's -- How Many Out of Line?

And in 9i, like in my example before, I can get by with LENGTH and not have
to use DBMS_LOG.GETLENGTH like I would in 8i. And use 3964 instead of 4K (at
least according to various Metalink documents). But I guess my question is
is this the only way? Is that what I'm supposed to assume from your reply?
Because I'm starting to think, after a couple of days of googling and
metalinking, that this really is the only way to know. So are you also
saying this is the only way?


Other related posts: