Determining the size of embedded images

The SQL queries demonstrate how to show the amount of space that each BLOB field is consuming. Both of these queries return the size of the field in bytes.

SQL Server


SELECT BLOB_ID, DESCRIPTION, FILE_NAME, 

DATALENGTH(OBJECT_DATA)

FROM FSEMBEDDEDOBJECTS

Oracle

Requires that the Oracle DBMS_LOB package is installed.


SELECT BLOB_ID, DESCRIPTION, FILE_NAME, 

DBMS_LOB.GETLENGTH(OBJECT_DATA)

FROM FSEMBEDDEDOBJECTS