How to find LOBS and LOBS INDEX in Oracle Database

To find Lobs:

/* Formatted on 4/22/2015 10:53:30 AM (QP5 v5.149.1003.31008) */

  SELECT DBA_LOBS.OWNER,

         DBA_LOBS.TABLE_NAME,

         DBA_LOBS.TABLESPACE_NAME,

         DBA_LOBS.SEGMENT_NAME,

         DBA_SEGMENTS.BYTES / (1024 * 1024) AS MBYTES

    FROM DBA_LOBS, DBA_SEGMENTS

   WHERE DBA_LOBS.OWNER IN ('FLEXLIVE', 'FLEXBO')

         AND DBA_LOBS.SEGMENT_NAME = DBA_SEGMENTS.SEGMENT_NAME

ORDER BY 5 DESC

To find Lobs Index:

/* Formatted on 4/22/2015 10:53:30 AM (QP5 v5.149.1003.31008) */

  SELECT DBA_LOBS.OWNER,

         DBA_LOBS.TABLE_NAME,

         DBA_LOBS.TABLESPACE_NAME,

         DBA_SEGMENTS.SEGMENT_NAME,

         DBA_SEGMENTS.BYTES / (1024 * 1024) AS MBYTES

    FROM DBA_LOBS, DBA_SEGMENTS

   WHERE DBA_LOBS.OWNER IN ('FLEXLIVE', 'FLEXBO')

         AND DBA_LOBS.INDEX_NAME = DBA_SEGMENTS.SEGMENT_NAME

ORDER BY 5 DESC