Oracle: Get the real size of a table with blobs

By | January 12, 2016

As we now in case of a table with BLOBs in the actual table row only a reference to the BLOB is stored.
In order to get the real table size of my table ‘MY_BLOB_TABLE’ including the refereed BLOBs the following query holds in Oracle: