RE: blobs used space in a database

Posted in 2014

Deillon Samuel — Wed, 16 Jul 2014 16:15:04 — source: IIUG Forums & Mailing Lists

Hi, If you are using blobspaces or smartblobspaces, you can check the global used space of dbspaces. If your blobs are in tables or if you want to calculate per-tables infos, you'll need to work with sql like select sum(length(<blob-column>)) from <table>. Regards, Sam -----Message d'origine----- De : ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] De la part de GILLES TCHAPPI Envoyé : mercredi 16 juillet 2014 17:51 À : ids@iiug.org Objet : blobs used space in a database [33404] Hi to all, Can someone tell me if there is a way to know space occupied by blobs in a database I'm running a dataserver version 9.40 on AIX Thanks in advance ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.