Posted: 20 Mar 2019 13:31 EDT Last activity: 22 Mar 2019 9:39 EDT
pc_data_workattach table and length(pzpvstream)
We are trying to work out how much data each application team is using on the pc_Data_Workattach table. We created the statement below, and would like to verify if the 'length(pzpvstream)' is in bits or bytes. Or is there some other calculation we should be using.
If we use bytes then 4456629939 would be 4.15 GIG. (4456629939/1024/1024/1024)
If we use bits then 4456629939 would be 0.518 GIG (4456629939/1024/1024/1024/8)
select substr(PXREFOBJECTKEY,1,locate(' ', PXREFOBJECTKEY)-1), sum(cast(length(pzpvstream) as bigint) ) from data.pc_data_workattach where locate(' ', PXREFOBJECTKEY) > 0 group by substr(PXREFOBJECTKEY,1,locate(' ', PXREFOBJECTKEY)-1)
Our total allocation on the database for pc_data_workattach is only 4G, and then by your calculation there are at least another 5G more in other applications that are stored on this table. How can this be?
Tabschema Tabname size in KB size in MB size in GB