can you please provide the row counts and blocks occupied for the below tables in prod & dev?

CONTRACT_TRANS
CONTRACT_TRANS_GROUP

also, is the bind variables in the query passing the same value in both the environments?

Thanks,