What is it?
Oral sedation will not put you to sleep during the procedure, but you will be significantly relaxed. Do not worry about being awake, most patients remember little to nothing from the procedure.
The sedative will leave you sleepy, so make sure that you have arranged to have someone drive you home after your appointment. By the next day, the effects of the sedative should have worn off.