Total Size of All embedded image files

Using the standard SQL function, SUM, you can determine the total space that is being used by all Optiva Embedded Attachments. Modify the original queries slightly.

SQL Server


SELECT SUM(DATALENGTH(OBJECT_DATA))

FROM FSEMBEDDEDOBJECTS

Oracle


SELECT SUM(DBMS_LOB.GETLENGTH(OBJECT_DATA))

FROM FSEMBEDDEDOBJECTS

Requires that the Oracle DBMS_LOB package is installed.