No (maybe you were dreaming about sex but didn't remember it?).
When I am tired and cannot sleep, I find that sex (any kind where you have an orgasm) puts me right out. It works better than psych or pain medications. I hardly ever nap, but sometimes I can make myself nap this way. Good sex with my partner sometimes gives me good dreams too.