Perhaps the thinnest oil is kerosene. Ya, I know, it stinks!:)
The purpose of the oil is to keep the swarf from clogging up the hone. Some people use water for the same purpose