What kind of work will you mainly be doing on it? Lots of water based liquids, building furniture, oils and/or fuels dripping, heavy impact forces, etc? Depending on what you will be using it for you might be better off just laying a thin sheet of masonite, plywood, etc. over the top and leaving it as is. Do whatever you want to the top without worry, because you just change out the surface sheet to a new one whenever it wears out, gets beaten up, cut up from a utility knife, covered in many layers of spray paint, etc.
In as far as oils, I just use regular mineral oil from the drug store for all my wood tool handles. It works great and it's cheap. That's the same oil most people use for wood cutting boards in the kitchen to give you an idea of what the surface would be like. I get that nice velvety feel without any smell, stickiness, etc. on my tool handles. Sometimes I warm up the wood handle first with a propane torch or a heat gun to help aid absorption and reduce the wet time, but it is usually absorbed pretty completely within a day or two.
Just don't put too much of any oil on the end grain of the lumber at one time or it might crack the ends a little bit from the oil absorbing and swelling the wood too fast.
I don't have any experience with oiling an actual workbench, so I don't know much about how well any oiled surface would hold up to something like gasoline drips or a spilled solvent for instance.