How much blobspace is free?

-- blobfree.sql

select

name dbspace,

sum(chksize) Size_in_Pages, -- sum of all chuncks size pages

sum(nfree) Num_free_blob_page -- sum of all chunks free pages

from sysdbspaces d, syschunks c

where d.dbsnum = c.dbsnum

and d.is_blobspace = 1

group by 1

order by 1

Previous slide

Next slide

Back to first slide

View graphic version