SELECT
   /*+ READ_CONSISTENCY(WEAK) QUERY_TIMEOUT(50000000) */
   a.tenant_id,
   a.svr_ip   ,
   a.svr_port ,
   SUM(data_size) AS data_size
FROM
   cdb_ob_table_locations a
JOIN
   (
      SELECT
         tenant_id,
         tablet_id,
         svr_ip   ,
         svr_port ,
         data_size,
         required_size
      FROM
         __all_virtual_tablet_meta_table) b
ON
   a.tenant_id  = b.tenant_id
AND a.tablet_id = b.tablet_id
AND a.svr_ip    = b.svr_ip
AND a.svr_port  = b.svr_port
JOIN
   __all_virtual_table c
ON
   a.tenant_id   = c.tenant_id
AND c.table_type = 5
AND a.table_id   = c.table_id
GROUP BY
   a.tenant_id,
   a.svr_ip   ,
   a.svr_port