Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: LOB's -- How Many Out of Line?
--
Mladen Gogala
Ext. 121
-----Original Message-----
From: Larry Elkins [mailto:elkinsl_at_flash.net]
Sent: Wednesday, January 26, 2005 1:25 PM
To: oracle-l_at_freelists.org
Subject: LOB's -- How Many Out of Line?
Listers,
Assuming a CLOB, for example, was defined with ENABLE STORAGE IN ROW. Is there an easy and *fast* way to determine how many of them are out of line?
[Mladen Gogala]
SELECT count(*) from TABLE_CONTAINING_LOB_COLUMNS WHERE
DBMS_LOB.getlength(LOB_COLUMN)>4000;
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 26 2005 - 14:30:49 CST
![]() |
![]() |